Three road trips later and I'm back at the office, and this job still isn't working.

Windows updates were run, and the server was rebooted. We're back to the original...

Perry, thanks for your help.

Perry Whittle (7/30/2015)

---

Once you grant sysadmin to an account...

JoshDBGuy (7/29/2015)

---

From books online

If the database being restored does not exist, the user must have CREATE DATABASE permissions to be able to execute RESTORE. If the database exists, RESTORE permissions...

I've been working on something similar to this for a while. We wanted our database update utility to do an automatic backup before it started changing tables and stored...

Probably more likely that the one person...

I'm a fan of the index script from Michelle Ufford, aka SQLFool.

http://sqlfool.com/2010/04/index-defrag-script-v4-0/

Its well documented in the comments, and has a number of options for setting thresholds for when to rebuild,...

gbargsley (8/24/2010)

---

This solution worked great. With one exception. The Total columns it is concatenating the three fields instead of adding them together. I tried to fix, but...

It helps to give a simple create table script with some sample data....here is one with a non-pivot method of solving this. I know just enough about pivots to...

Lowell (5/7/2010)

---

Wayne what you are after is stored in the registry, and it depends on which verison of SSMS you are using for the exact key;

the lazy way is to...

Every year we plan to take a week off for Christmas, but there is always the disclaimer "if the situation allows"....

Somehow, the situation never allows.

The cleaning lady just...

Thanks for the advice...in the end, it turned out to be one of those hair pulling experiences that I don't understand, but I learned and I moved on.

I used sp_helpdb...

GilaMonster (12/21/2009)

---

One comment on the code.

USE [SAMPLE_DB]

GO

DBCC SHRINKFILE (N'SAMPLE_DB_Log2' , EMPTYFILE)

GO

use master

go

/* This next line works in the sample, fails in my actual database */

ALTER DATABASE [SAMPLE_DB]

REMOVE FILE...

SQL Server is going to return GetDate as a datetime - which includes the date and the time.

Since you are wanting this in a very specific format, you might want...

Thanks for the suggestions. Due to the interactive nature of the scripts I am trying to run, and the fact that it's one of the critical but infrequent projects,...

This is a fairly good Microsoft white paper on performance troubleshooting. I've used it more than once as a starting point.

http://technet.microsoft.com/en-us/library/cc966540.aspx