I would expect that the file name, "reporting agents" specifically is the problem.  To disprove this, try commenting out the long path name that you currently have and create a...

You could use dts and some programming to do this, or just some programming.

I would use log shipping if I could as the first choice.

Transactional replication sounds like it might...

Greg,

If I understand your question, you have a database with many sp's and you do not know which of them are active and which of them are older version that...

I started using the product about 3 years ago at another company when dbAssociates first started selling the product in the US.  The interface was nonexistant, but the backups and restores...

You can script your database from the enterprise manager, right click on the database and click on all tasks, script the database.  Go through this selection probram and create the...

Back up your transaction log first, then truncate your transaction log secondly.  Viewing the database size in the enterprise manager, you should have a normal sized log for the database...

As I understand your question, you want to know how to get rid of "orphaned connections" on a regular basis. You can look at the sp_who sp and see...

I have never seen VPN used for this. For the past several years at different job sites we have usually used FTP to transmit reports and or data files...

Looking up parsename in help doesn't look like it applies to this topic. It looks like it is more concerned with breaking up a multipart server object name i.e....

I just use the script to transfer the logins from a DEC ALPHA SQL 7 server to a new Intel SQL 2000 server with no problems. I was unable...

Here is a script from a job that I run as a step after I generate the report and bcp it to our ftp site, I also have to email...

Breaking the job down to reasonably small chunks is the key so that the transaction can be committed. When deleting records from out activity log on a monthly basis,...