Viewing 7 posts - 1 through 7 (of 7 total)
Yes DB name is prefixed : Here's the code:
(pls. note linked server is defined in proc1 and procedure works fine when logged in as a SQL authentication account or SQL...
September 9, 2008 at 7:15 am
Thanks. So I have to create triggers on all tables if I want to capture when and how it was last updated and what login was used to update the...
August 5, 2004 at 8:53 am
Sorry for the delay in replying.
Here is the result:
6 0 0 0x0000 14437 RESOURCE_QUEUE 1 1 47 1 0 2004-03-23 21:33:00.980 2004-03-23 21:33:00.980 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0x0000000000000000000000000000000000000000 0 0
4 0 0 0x0000 2375 RESOURCE_QUEUE 0 1 11047 0 0 2004-03-23 21:33:00.980 2004-03-23 21:33:00.980 0 0 background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 ...
March 26, 2004 at 11:46 am
All the queries and SP's are same as before as no chnage has been done to these. Regarding Caching we have read ahead caching at 0% on the controller and...
February 19, 2004 at 11:56 am
Yes John we have that switch in boot.ini and also awe is enabled on the SQL server.
February 18, 2004 at 9:09 am
We have 12 GB of RAM on the server and we have fixed the SQL server memory at 5.5GB as it is a Active/Active cluster , so in case of...
February 18, 2004 at 4:50 am
Viewing 7 posts - 1 through 7 (of 7 total)