Why do you need to reclaim the space? If you do, the DB is just going to grow again next time you rebuild indexes.

Is it the data or the log...

You don't need to do another fetch in the middle of the cursor loop. Fetch can't have a condition on it. It fetches values from a cursor row. All you...

Yes. SQL needs space to rebuild the index. Don't...

Are you sure that's coming from the maintenance plan? If you start the maint plan's job manually, do you get the same error? How ofte is it scheduled, what does...

Please post SQL 2000 related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, people are going to assume you are using 2005...

No easy way I know of on SQL 2000 or 2008. 2008...

When you find out, please let me know.

Try changing the foreign key to ON DELETE SET NULL. You should then be able to delete via the trigger. The reason you can't now is because the trigger fires...

Duplicate post. Replies to the following thread please:

http://www.sqlservercentral.com/Forums/Topic584368-5-1.aspx

Please don't post multiple threads with the same topic. It just wastes people's timeas they answer posts already answered. It also fragments replies and makes things harder to find

No replies...

Try dropping all three procs, recreate the inner one and then recreate the two outer ones.

If you create the dependant object before the object that it depends on (allowed in...

Have a look at this blog post, see if it applies.

http://blogs.msdn.com/bartd/archive/2008/09/24/today-s-annoyingly-unwieldy-term-intra-query-parallel-thread-deadlocks.aspx

The changes will be logged...

The first thing that I will recommend is that you go and explain to your boss what has happened. Hiding mistakes makes them worse, and there's a good chance that...

In that case, the proc should look like this

CREATE PROCEDURE dbo.sp_Chop_Status

@Chop_ID nVarChar(6) = NULL,

...