Grant Fritchey (12/2/2010)

Writing to file is much, much faster than writing to a database, so yes, it does make a difference. Also, is that database on the same server you're...

Thanks for the great article. I create a baseline performance measure every so often on my servers, and this will simplify the process. I'm currently placing the output...

I have two suggestions:

1) Format the data in Excel as to how you want it imported into the table. This function will give you the first 30 characters:...

Thanks for confirming what I suspected... I guess I'll be creating my own document. Thanks, Lowell, for helping with a starting point for it.

Cindy

I guess I'll bop in as well.

ALDS winners:

Minnesota Twins

Tampa Bay Rays

NLDS winners:

Philadephia Phillies

San Francisco Giants

ALCS: Rays

NLCS: Phillies

World Series: Phillies

So does winner get an extra SSC point or...

Are you running 32-bit or 64-bit? What is value of select @@version?

Does your account running the SQL Agent have the following access to these folders? Is the SQL...

If I understand your problem correctly, when your agent job fails, nothing it being inserted into the msdb.dbo.sysmail_allitems table? Correct? So whatever is failing is preventing the notification...

You can try checking the sysmail items table. Maybe the sent_status will be useful.

select * from msdb.dbo.sysmail_allitems

I don't think this will help, but will mention it anyway. I...

Yup - I figured this out after I tried it and actually "read" the command 🙂 So far, so good. I'm just about ready to start the SQL...

Thanks. I didn't know that. Apparently quite a bit has changed - like "move groups" moving from the gui to command line. Just gotta love the "enhancements".

I'll...

FYI - Issue resolved - we needed to disable the cluster service which had started on both nodes.

Cindy

Anyone else dreaming of a "white World Series". Twins are the first...

http://sports.espn.go.com/mlb/recap?gameId=300921109

Cindy

If I understand your question correctly, you want the code to execute with the two lines commented-out, correct? The syntax error is because you have a comma after "insumpo"...

Thanks. No doubt I'll discover those other million things one at time.

Cindy

Lowell,

Thanks for the query. I was hoping it would give me more ammunition to make my case, but alas, it did not. I was able to run the...