In principle, there is no reason why a sp would deadlock but QA would not.  Also, although the query processes a lot of rows, it...

I’ve done a couple of tests with cursors using a query based on your template.  For the time that the open cursor is executing(which could be...

Hi,

The important word here is "deadlock".  These can be tricky to track down and eliminate but there is lots of help in Books Online particularly the article on "mimimizing deadlocks"...

It seems to suggest that the db is not suspect (?)

Close Enterprise manager and then restart it to double check the status.

If it is still suspect try

update sysdatabases set...

Just noticed teh thread it not quire right

update sysdatabases set status = 32768

should have

where name = 'yourdbname'

added to it or it will set all databases so emergency

Looks like the DB is damaged.

See this thread

http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=99258

Read the whole thread, but I think you shoiuld start at the line:

"If you haven't a recent backup then you can do...

Sorry but it doesn't look good.  This usually requires the database to be restored from backup.

The only other 'easy' fix assumes that the database file has been renamed or inacessable...

SQL Profiler can do this quite easily.  Start-> SQL Server -> Profiler

If can look a bit daunting at first but it isn't so bad once you play with it for...

Is your disk drive full?

If so then try the procedure described in Books Online

Look for "Resetting the Suspect Status" in the index.

If the disk is not full then you...

Try this in queryanalyser when the delays occur:

select * from master..sysprocesses    

This will list the current connections and show the status.

Look for tasks with "blocked" <> 0

Then check the...

EM just executes the dbcc shrinkdatabase or shrinkfile procedures so it is just a matter of preference.  Personally,  I alway use the scripts i.e. DBCC because then I can run them in...

A few thoughts:

If you are deleting more than you are keeping then the temp table option above and / or dropping and rebuilding indexes is probably the best bet. Rebuilding the...

SQL Server dynamically adjusts the amount of memory it uses.  It will automatically take as much memory as it needs up the total amount installed on the server!  It then...

Hi,

This sounds like a 'report' style query which proceses a reasonable number of rows.  If the joins are used primarily to 'look up' descriptions then a significant improvement can be acheived...

 Hi,  I know you have a work arround but I thought you might like to see this anyway.  I'm not clear on what you wand but I think this might...