You can go to the report manager and browse to the folder with the particular report in and add yourdomain\Domain Users as a browser, then everyone in the domain can...

I am assuming these are san drive, if so, you will also need to confirm that each drive has separate spindles, if it is just a logical separation of a...

here is the link Dohh!!

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

Do you have a large log file with lots of vlf's as described here, if so this can cause long restore times, we ran into it and had a restore...

you can use xp_servicecontrol, you can punt the output to a table and then figure if the service is running, you should be able to find a script on here...

I have used logparser to do this, takes some time to get all the file details but you can insert into a table and use a while loop to get...

Have you checked the MSDTC is set up so each box can run distributed transactions?

Jeff,

Let me rephrase, at the smaller shops I have worked in or had dealing with, the DBA role was not considered as a chargeable resource to clients. I know there...

One other thing about smaller shops is that the DBA is generally not chargeable to the client, I worked at a shop where anyone who touched the databases was called...

You can also use the below code, we use it to figure out group membership without having to engage domain admins.

EXEC xp_logininfo 'whateverdomain\whatevergroup', 'members'

Andrew

be aware that the temp table will not simple be called #whatevernameyougive but in the form of

##whatevernameyougive_______________________________________________________________________________________________________________00000000957C

in sys.objects so you will need to use a like statement

Andrew

I am only interested in failures, I have a job collect any failures every 15 minutes, the where clause is so I don't miss any failures if there is a...

I use this script, think I may of got it here or just profiled it on replication monitor, can't remember, I am concerned with failures, don't like having the client...

This isn't April the 1st again:-)

Other than curiosity why would you want to know this, just curious myself?

Andrew