Column Descriptions are extended properties. If you make the change in EM, then script it out, you see the code that you need to run in QA.  It's a good...

Your original post just mentioned the amount of time it took. At this point you probably won't get any new readers to this thread, so if you want to get...

I assume you meant  " ... that i CAN always ... "

There's no "best" answer.  I do a full backup every night of my 280 G database (takes 1/2 hour), and...

I'm no expert, don't really know much about split-mirroring.  Does it require more hardware ?   A cheap way to improve might be to get SQLSafe (or a competitor). Then your...

One instance would be my vote, unless you have a compelling reason for multiple instances. The only case where we have multiple instances on 1 server is to allow a...

What's a LVL0 backup ??

4-5 hours to backup a 100 G database ?!?!  

My 280 G database backup with backupexec takes about 1 hour to tape, and if I use...

You can use  DBCC INPUTBUFFER (59) to get a bit more information about what a spid is doing.

I don't remember exactly.  But I think it was a combination of table schema changes, and triggers put on tables based on the old schema, not the new schema that...

Yeah yeah ... I know .... smartass !!

Got it !!      Detach & re-attach.   Some DBs were moved to new storage recently ...   Too bad that it wipes out the real creation date 🙁

Thanks for helping

No. These databases have creation dates within the last week or so, and I haven't done anything with them in months.

I found I was able to get Idera's Diagnostic Manager to connect to the remote server - I had been only using it locally. It  gives me much more information,...

Maybe Noel's method would be better, as long as replication will be unaffected.  

Is your database a publisher or a subscriber ??    Mine's a subscriber, so I will just dis-able...

I'm doing the same thing this weekend. I'm planning on stopping replication, unmarking the DB as used for replication by setting  CATEGORY = 0 is sysdatabases, detaching the DB, moving...

Thanks.   I just started running a trace, and although I selected database name to display, that column is blank, although there is what looks like a good value in Database...