If you think it is that then keep and eye on next time would occurr. If same thing occurrs you might try reinstall SP2 and see if goes away, if...

How big is the transaction log on your machine compared to the remote one and how did you compare the two, total size or mdf size? Also, when the backup...

Not that I am aware of. However this should have been fixed from what I recall in SP2. Are you sure something installed afterwards did not break SP2 in some...

How are you implementing the CR ActiveX viewer and attaching the data? I would need to see the ASP code for the page that runs the viewer and attaches the...

Duplicate post, please see responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=8355&FORUM_ID=61&CAT_ID=5&Topic_Title=Crystal+Web+Reports+from+ASP&Forum_Title=Anything+that+is+NOT+about+SQL%21

Run sp_who and see what is happening on SPID 1-5. Awhile back I started getting a BACKUP LOG on temmpDB and my server screeched not to a halt but it...

Specifically why do you need to lower the priority of the Job? Usually there are better solutions taht doing this and I am just curious.

If the server they are on is unstable and has caused corruption then most likely you will not be able to do. However, stop SQL and copy databases over to...

This example is for Auditing logins and logouts

It is kind of ruff but you should be able to follow.

SQL 7

declare @P1 int

declare @P2 int

set @P1=32|64|512|1024|8192 --Column output selection list

/*

32 Microsoft...

Always try a reboot when somethin doesn't work just right, migh have replace an inuse file and this will not occurr until reboot.

Unfortunately when they designed OPENQUERY they did not allow for optional parameters to be passed. The only way is to build the query string and execute via EXECUTE or sp_executesql...

I think Veritas may have left file locked, do a search on the forums I do believe I saw some complaints on this before.

This will show you what SPID is running under what thread then you can look at the tool below for stats on that thread.

DBCC SQLPERF(THREADS)

If it gets run periodically you may could run yourself anyway without harm in a cmd prompt with the string you have, might have some details then in the cmd...

You shouldn't have to start Component Services to get to properties. When you open the Coponent Services in the Admin Tools of Control Panel if all you see if Computers...