Into "all" tables. Does this include the system tables?

I would do this with two logins.

One login would have DDLAdmin, datareader, datawriter and this login would exist only...

The security vulnerability footprint is much higher when using dynamic sql over a properly written parametrized stored procedure.

I apologize to the original poster for getting off the "thread" topic.

... but also opens you up to SQL Injection attacks.

Steve, you hit the nail right on the head. I totally agree with you.

No, it doesn't make sense. Adam has provided good guidance.

I cannot think of a reason why you would want to perform such actions.

Without seeing code, who knows?

Here's a guess: If it's an OLTP database maybe new records are being added or modified in between runs of the sproc and that's why...

SQLCompare

SQLDataCompare

Ultraedit

SSMS

SQLServerProfiler

Maybe referring to Lehman Brother's who filed for bankruptcy. Try talking to those guys!

Well, you're not disabling your "admin" login; just the user logins. Anyway, the OP doesn't think my suggestion will work.

Did the resource databse ever get updated?

SELECT SERVERPROPERTY('ResourceVersion');

select @@version

Both versions should be identical.

river1 (3/30/2010)

---

The procedure that Lowel gave me is very usefull but i think that you are right , it's better to put all the databases in to single user mode...

You say you really want to be a DBA, but it seems as though you're just looking to pass an interview. If you study hard using all sources (many...

Make sure the ResourceDb got upgraded. I had an issue where the install completing successfully but the ResourceDb never was upgraded. Totally weird because the install showed success....

You should start a server side profile trace prior to running the job. This will provide more information (ie: blocking, deadlocks). Currently, your post is too vague.

Some questions...

To check for the indexing:

You could always execute "sp_who2" into a temp table and check to see if there is an input_buffer with "DBCC DBREINDEX 'tablename'" for the tables that...