Viewing 15 posts - 121 through 135 (of 484 total)
To run a remote stored procedure use
exec server.database.dbo.sp_name @param1, @param2 etc
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 25, 2002 at 2:59 am
Yep thats it
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 24, 2002 at 10:18 am
I believe the flag is -m check out
http://dbforums.com/archives/t215896.html
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 23, 2002 at 4:55 pm
A bit of history that I am not 100% on is that CURSOR support was only put maintained in SQL to keep ANSI compliance. But was not the biggest priority...
November 23, 2002 at 4:50 pm
The only situation I am aware that SQL does not detect this is when you have distributed transactions across spids. This was not detected in SQL 7 (big probelm with...
November 23, 2002 at 4:49 pm
Sorry I haven't got SQL on this machine. You have to set a startup flag that puts the server in single user mode.
It should be in BOL.
Sorry I can't be...
November 23, 2002 at 4:45 pm
Well OPENXML is my chapter in the book below. I have done some research into this and like chrhedga created a fucntion to do teh same as OPENXML. What is...
November 23, 2002 at 4:10 am
FYI this is the script
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=589
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 23, 2002 at 4:03 am
you would need to check for spids that are blocking each other in query analyser and also for spids that have are in the same distributed transaction.
Lock timeout is irrelevant...
November 23, 2002 at 3:59 am
what are you trying to achieve?
Did you set it in the options of Query analyser and if so what did you set it to
Simon Sabin
Co-author of SQL Server 2000 XML...
November 23, 2002 at 3:56 am
You can use triggers but the insert that caused the trigger to fire will have to wait for your app to finish before the insert will complete.
If in your trigger...
November 23, 2002 at 3:54 am
A set based process process all data in a set at once.
i.e
UPDATE MyTABLE
SET guid = MyMainTable.NewGuid
, othercolumn = MyMainTable.otherColumn
FROM mYTable
LEFT JOIN...
November 23, 2002 at 3:50 am
As expected look at the query plan, you will see a remote rowset element that costs 3.36 (or something like that)
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 22, 2002 at 4:36 pm
What about OPENXML?
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 22, 2002 at 4:35 pm
You only get one row affected as this is the first message that is sent back to the client. You may also find that not all the inserts are performed...
November 22, 2002 at 4:34 pm
Viewing 15 posts - 121 through 135 (of 484 total)