Thanks ! What would be a good way to ensure the month field has a zero in front of it if it is a singled digit month, so I get...

is that usually a problem? what does a big negative value like that in the cpu column indicate? Thanks.

Thanks Noel ! That's perfect.

-Pat

Thanks Brian. The data is accessed via stored procedures, so I think I'll go with your suggestion and map the user groups to database roles and give the roles execute permissions on...

Also, I'm assuming the same principle could be used for large INSERTS as well, right?

Woops ! I read your reply to quickly and misread it. sorry. yes, you're right, and thanks for the tip.

-Pat

I think that's meant to give the log time to truncate, but I guess it probably truncates after the COMMIT anyway, so maybe you're right.

Good discussion guys ! Thanks for all the replies. So, I guess I found what I'm looking for, and I needed to explicitly commit the tran.

DECLARE @x INT

SET @x = 1

SET...

Thanks for the help Remi !

-Pat

Thanks Remi. I'm new to writing vbscript. Does the way I'm checking for the existence of the log file look correct (it seems to work), or should it be placed...

Thanks for all the great responses. I love the SQL community! Here's how my script looks now. It's basically checking for files older than a month that begin with "qury"...

Thanks Remi. Found a link right here on this site too for anyone else.

http://www.sqlservercentral.com/columnists/hji/usingvbscripttoautomatetasks.asp

Pat

Thanks for the reply. I found this other solution to my problem in case anyone else needs it.

Pat

http://www.sqldts.com/default.aspx?293,1

Thanks for all the quick replies! I just started at a new place and this is a 3rd party app they have, so I'll have to see whether or not I...

Thanks guys. I know about the dSQLSRVD tool, but I just started a new job, and don't yet have rights to install apps on my machine, that's why I looked...