With re: to single user mode in running dbcc programs.  Is there a way to do this thru a maintenance plan without user intervention.

I want to run the integrity check...

Nicholas - Thank you so much -

Dan - Good luck!!

Karen

I too am having a problem with single-user mode.  Only the opposite of Dan - I can't run my Maintence program for Optimization or integrity checks because the system db...

Thats the funny thing - when I went into client network Util to add the alias - there were no protocols listed on the general tab. I addded tcpip

But by...

I ageee with shew01. I too have posted many a questions that might seem trivial to experts, but my questions have only been answered with great help and wonderful...

Brian:

1 The error occurred only once

2. Re other servers causing issue - I checked all of my jobs and none run on that day or...

Turning on the truncate log at check point in the properties of the database on the options tab will stop logging to the trans log. Also, which I think...

I guess no one has ever seen this - I got another one yesterday. I hope this isnt a arning tome re: a problem - I found no info...

As always - thank you one and all for your suggestions.

It is a nice feeling, when I am stumped, that I have somewhere to go to get great...

I want to thank you all for your suggestions and help - I will check out all of your leads

Karen

Thank you all for your comments and a few chuckles...I too will begin smocking crack!

I started playing with Visio, for the first time and I am...

The info I need is datatypes, description of fields and any other attributes/info we can get.

We re thinking about redesigning all of our DBs. IS EVERYONE...

Yes when I saw that contact tech support it threw me

Thanks Solart

I ran checkdb and there are no allocations or consistency errors. For all intents and purposes the DB comes back fine after the server shuts down and recovers the...

Thanks Brian - I just purchased your book. I'll use it to play on our test servers. And just think If I have any questions I can go...