Nice work! do you have a link to download the toolbox?

Right! that would be a bad idea for sure! And it's easy to say ok it works now, and move on to the next problem/issue

Adam Haines (3/21/2008)

Check the rights on the machine for the new account.

Might need to give it more rights. Quick check is to add it to the local admin group...

Check the rights on the machine for the new account.

Might need to give it more rights. Quick check is to add it to the local admin group on the...

If the database was using replication in production you may have to also mark the transactions as complete in order to be able to shrink the logfile.

Probably not access rights if you can connect some of the time.

Maybe the query is taking too long to execute? Or network congestion?

You can look at...

Are you sure the problem is disk? I would recommend running perfmon and looking at disk queue length along w/ memory and processor. I know it sounds basic,...

I ran into the same thing. There were some odd characters in the listing, might be from the web.

At any rate here's my copy

drop view vw_index_usage

go

create view vw_index_usage as

select...

Pretty good idea. One thing that might make it a bit more useful though, is to turn it into a sproc and allow the dbid to be passed in.

Paul,

Exactly! I wasn't aware they were using netlib to encrtypt the data on the drive until I dug a little deeper.

Thanks so much for your help! This one...

Nope. No adding of drives or messing with the files.

TLog backup wouldn't do any good, recovery model is simple.

The odd thing is if I put the DB in single-user...

Andy,

What a great post! It pretty much outlines how I spend my day when working as a DBA....

Mark

I actually used this one in conjunction with xp_SMTP_sendmail can't remember the xact SProc name, but it's an add-in sproc, and it was quick and didn't add much load to...

Thank you Haidong!

I know I've used this one, or some variation of it before in the past, it's very useful!

Steve,

Wow!  Surprised you opened this can of worms!

There are a ton of debates over Certifications vs. Degrees vs. Job Experience.

What I've found is it all plays into the overall picture...