Search results for query: *

I thought this would be easy but I can't find anything on it anywhere. I am try to build a web form in asp using sql 2000 as the back end. i have two tables: tblContest QID Q 1 Who won the game? 2 Who has the most points? 3 What was the high score? tblContest_DropDowns QID Choice 1...

I just can't figure this one out. I have a basic asp page with a link www.something.com/login.asp?urlRedirect=1 It takes you to the login page in which the user logins into the website username and password. At the end of the login code (setting session variables etc) I want to redirect my...

I need to have my replication agent retry after a failure occurs. I set the rety interval on a 1 minute setting but the agent never tries to start again? Am I missing something here? I am pushing a subscription to another PC running all processes at the distributor.

i run a job that does a simple select count(*) command to test if I have connectivity between my linked server. could i issue a disable trigger command if i get an error on the select statement above during my job, if so how?

I am syncing up data between three server using MSDTC via SQL server 2000. My triggers are appending data from one linked server to another to another. What I have noticed is when an issue arises on one of the three servers, speed and performance is degraded drastically. Is there a piece of...

Can some help me convert the below select statement into an FOR INSERT TRIGGER: SELECT s.ID, c.IsD FROM dbo.AA_STABLE s INNER JOIN dbo.VTABLE v ON s.PTC COLLATE SQL_Latin1_General_CP1_CI_AS = v.PTC LEFT OUTER JOIN dbo.CCTABLE c ON s.ID COLLATE SQL_Latin1_General_CP1_CI_AS = c.ID I...

I am looking to add the following logic to the trigger below but I could use a little help. I have a table where I am assigning criteria that I want to select on in the below trigger to reduce the amount of records the trigger returns. I am not sure of the best and most efficient way to do...

Is it possible to SET TRANSACTION ISOLATION LEVEL in a view or only a stored procedure? If so, please show me the CREATE VIEW AS statement with isoloation level to read UNCOMMITTED. Thanks!

Is it possible to run a stored procedure from an Access Project form in VBA with out showing the output to the screen??? I simply want to execute a stored procedure that has no results but can't seem to do this without it displaying to the user... Any help?

What is the best way to do the following: tblLive code 1 2 3 4 I need to copy and append tblLive to tblSaved. tblLive will keep incrementing data with unique keys in which I have to also added to the tblSaved table. I was thinking I need to mark the records I get initially and only go after...

Is it possible to set a trigger on a sql server table and have it append results to another sql database on another server (I have access to all servers). If so, does it put more strain on the trigger? Is this done through linked server? I want to avoid a DTS if possible. Please let me know...

I am running SQL server 2000 and have sqlmail configured to my outlook 2002 MAPI profile. I am able to use xpsendmail fine; however, I always need to have my mail client open or it will not send the email until I open it. Is this how sql mail works or is their a way to make it send mail when...

I have setup a report that users a odbc connection to a access database on another server. when running the crystal report localy using the odbc connection, it returns data fine. When i upload the report to enterprise it asks users for a username and password. I tried every combination you...

How can I update the top 2 records of every group in a table to the number 1. GroupID Rec 1 1 1 1 1 2 1 2 1 2 etc. Seems simple, but i can't seem to write it. i tried all sorts of subqueries but i doubt that is the route to go? any help would be greatly...

Below is a set of data in my sql table. I need to create an asp report that displays the info sort of like a cross tab would (see below). There are multiple ids but for space I am only showing one. What is the best way to do this? Sql data ID Week GID Selection HID...

All I want to do is add a column to my view called counter. qty counter 11 1 5 2 4 3 2 4 I am ordering by qty desc. I just want to add a count that counts in order 1 - whatever. Is this possible in a view?

I need to close access automatically via VBA and re open it one time after, is that possible?

I created a very very simple form in Dreamweaver MX using ASP VB Script. I have 6 drop down select list that have the same static lists. I have a update button that updates a record in my database. All I want to do is add a piece of code that checks to see if the user picked the same choice...

What would the equivalent to the following function be in sql server 2000. USE AdventureWorks; GO SELECT i.ProductID, p.Name, i.LocationID, i.Quantity, RANK() OVER (PARTITION BY i.LocationID order by i.Quantity DESC) as RANK FROM Production.ProductInventory i JOIN Production.Product p ON...

I have the following data in a table: name wins diff pct pts admin14 10 0 41 77 admin11 10 1 42 777 admin12 10 24 41 4443 administrator 10 24 62 50 I have the following view (check out the sorting). Select * from tbltest order by wins desc, diff, pct desc, pts desc The diff column...