I like jwiners solution in that the batch file ftp process is probably the way to go. I would then use a xp_cmdshell t-sql solution to rename the files. Example...

Good place to start is

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/default.asp

David

I didn't really look at the ddl so, this is an off the cuff reply however, did you rebuild the index as part of the troubleshooting or is it being...

The web site to download is http://www.microsoft.com/data/download.htm#CCinfo

I wanted it too so, while I was there I thought I would make it easy for others to find.

Hope this...

There is an OLE DB Provider for Exchange that is documented in BOL that is supposed to allow for connectivity and querying from SQL Server however, I have not tried...

Start by bringing the Excel file into a temp table and then use T-SQL to pass it into the other tables. DTS will do a great job of bringing the...

Hence the problem with 3rd party backups. Another link in the chain that can break. SQL to disk is the way to go.

As Steven mentioned, he does not have...

Anti-Virus on a server running SQL Server. Not here. Maybe I am a bit picky but, too much background munching by the AV software and really no benefit. I allow...

"Wouldn't even say its a bad idea, but the opinions of most DBAs that have been working with SQL Server for some time is to backup to tape"

You mean disk...

Yes, you should be able to use a Full Database backup from Veritas to restore and restore subsequent SQL Log backups to it.

Two problems that I have seen really...

You may also want to download the system table map - Books On Line - from the following;

http://www.microsoft.com/SQL/techinfo/productdoc/2000/systables.asp

I find this really useful in understanding how much of...

Um, Er, Well, after digging around a tiny bit during my 2 minute lunch, I did not find that you could do this within EM in 7.0. May be best...

Unfortunately no, you will have to restore the whole backup. However, you can restore to another place or another name and then copy the specific table back using DTS or...

I script everything. If I don't write the script initially (i.e someone else is developing) then I script following review. That way when I migrate to production I have everything...

In the EM Design View the Identity Col drop down select has "Yes (Not for replication)".

Hope this helps.

David