Search results for query: *

Anyway you can provide me with an example. I do not know how to do what you described.

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...

Thanks so much for the help. One other question. Here is what I have now, <form method="post" "<% = Request.ServerVariables("SCRIPT_NAME") %>"> How do I add this to what I have above? action="login.asp?urlRedirect=<%= Request("urlRedirect")%>" How do you have to action statements?

Thanks so much for the help. Here is what I have now, <form method="post" "<% = Request.ServerVariables("SCRIPT_NAME") %>"> How do I add this and do I need both? action="login.asp?urlRedirect=<%= Request("urlRedirect")%>" What is the best way to pass url parameters through a couple of...

Thanks for the quick responses! This is exactly what I am doing : if urlRedirect=1 then response.redirect "page1.asp" else response.redirect "page2.asp" end if It does not recognize the urlRedirect when the user clicks login (runs that code). If I place this above: if...

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 understand but my code does not work with the begin distributed transaction...i think it has to do with the linked server or something. can you show me how to structure it?

thanks for the responses. I am using the set --SET xact_abort ON and when the middle server goes down it affects the main servers speed of inserts on the table with the trigger. i am not sure why it slows down but I want to disable the trigger if the linked server goes down. data integrity is...

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?

can anyone help, sqldennis please???

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...

I think I got it... Would I just change: FROM dbo.AA_STABLE s to FROM inserted s and call it a day???

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...

Let me get back to this after we explore this question: Please see this thread... thread183-1323079 I am very confused and could really use your advise... In my linked server set up, I can execute a INSERT INTO linkedserver.dbname.dbo.test from query analyizer with no problem from server a...

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...

mrdenny: Thanks, the NOLOCKS eliminated the locking/blocking issues but affected some other database processess on the SQL server. My trigger is firing 100K times and appending data each time to a linked sql server. Other software running on the sql server that i have no control over was...

Ok, how do you do this when you are joining three tables one of which uses FROM OPENQUERY? Also, the reason I can to this conclusion was databases locks and blocks that kept occuring. Will the No Locks resolve all database blocks resulting from this transaction?

Thanks for the feedback. Paul, I saw the example you posted, but it does not let you save it as a view. The nolock hint is the way I will have to go however my initial view is rather complex or at least with my knowledge of sql it seems to be. Not comparing myself you all the sql wizes on...

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!