Thanks Gail. One of...

http://www.ureader.com/msg/11464933.aspx

You could look at the sqlcmd utility. The end user could call a batch file which then calls sqlcmd. This is the simplest 'interface' for a user to execute sql.

There...

Have you seen this: http://support.microsoft.com/kb/918760

I use xp_cmdshell, others may use robocopy, etc. This script may help. Understand the security implications of xp_cmdshell if you need to activate this.

Also see http://www.sqlservercentral.com/scripts/Administration/62729/ for a...

Backing up to a network drive can be problematic. Better to backup locally and then copy the file to a network location. You can do this in the same job.

This is all 32 bit....

You can also use BIDS-Business Intelligence Development Studio a custom version of Visual Studio that is shipped with SQL Server 2005.

This is resolved. I had to reset the service accounts through enterprise manager, not sure what caused this. thanks all.

Thanks Steve!

Yes agent is dependent on server so I am focused on server.

The security log is clean.

2 notable entries in System

http://support.microsoft.com/kb/938449

We can log on to the domain so...

This is all untested air code since you didn't provide data in a format that is easy to work with.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

1)

SELECT COALESCE(NULLIF(Format,'')'unknown' )FROM Orders

2) Maybe something like...

SELECT

Field1,

100...

Any time you have a manual process that you want to script, you can use the profiler. The profiler will capture the commands you are passing to the server as...

Hello and welcome,

Some code would help here but I'll take a wild guess.

Are you concatenating variables? A NULL value combined with another value will often produce NULL depending on...

I believe this only only works on local drives, not UNC paths.

EXEC xp_cmdshell 'FORFILES /p F:\Backup /s /m *.bak /d -3 /c "CMD /C del /Q /F @FILE"'

Also see...

The Foreach loop will look at a folder, optionally subfolders, and files of a certain pattern if you are using wildcarding.

If only one file meets the criteria then yes the...