ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ERRORS when trying to run alter in SQL Query Analyzer session:===> Server: Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the...

Three Questions before I take the dive in the deep end of hte pool:

1.  In the an Analyzer session when I do what you recommend do I immediately run this in...

A script would be nice.  If I run it wide open will get everything from the beginning of time?

By the way ... you are an angel.

Thanks

This looks nice but we load massive data warehouses here so I wouldn't want to add overhead.  It is hard for me to believe that the metadata does not exist...

I knew about this but he process ... when you have hundreds of DTS ... is very tedious.  If the data were in flat files or the database (where I...

Thanks for taking the time to reply.  We had oracle installed.  The issues was fyi ... we changed owners of the DTS packages because of a bug in wind 2003...

I've been fortunate enough to work with tools like informatica and SAPBW where the driving meta data for their DTS solution is stored in tables so impact analysis can be...

Is there a way to see what character exists (which I can't see) before the first character of what I think is the table name?

I see it now with '%...' .. I had tried '...%'.  Why?

DBCC results for 'current database'.

DBCC execution completed.

Yes Sir ... Good Question. I'm the only one who asks dumb questions in this forum : )

Slow Running:  Can you give me the Query analyzer code?  I have not done this before.

Duty Roster: 

Quoting Sgt Schultz I must say that 'I know notttthing' ... new to this stuff.   Any links you could give me to learn would get you in my prayers and close...

Thanks!  Some in ohio loves you. : )

You are wonderful! Would you mind giving me sampe backup and restore command line code using the MOVE clause in directory H:\A in from system and in D:\X in the...