I think this broke when we converted teh site. I'll mark it as a bug to work on. In the meantime, here are a couple links:

DTS: http://www.sqlservercentral.com/columnists/sjones/sqlserverdtsresources.asp

DMO: http://www.sqlservercentral.com/columnists/sjones/sqlserverdmoresources.asp

Licensing:...

Sorry, can't dig too deep right now, but this occurs for me. I suspect that more of these parameters are  not optional and must be included.

It shouldn't grow that big if you are committing as Antares suggested. You can always make the batch smaller, like 100, and add a small delay, like a second, between...

It sounds like the setup path you are entering is incorrect. Can you verify the UNC path from explorer?

Agree with Wes. Should work, but you need to be sure you add some horsepower, or live with the short performance hit.

In Windows, fragmentation is more of an issue. For SQL Server, I wouldn't recommend defragmenting the data files or log files unless the server is at low load, but it...

Probably some scripts on the site here.

Could you not run a backup transaciton with no_log? Can't remember if that works in 7. If not, killing the spid should have started...

For the backups, which I didn't address. The backup process is finicky. Any network delays will cause failures and they need to be rerun. Backup to local disk and then...

Slightly different take than Manny.

1. SQL Server doesn't have to be configured. Your code is what calls dynamic SQL. This is SQL that is built on the fly and submitted...

1: yes

2: if you get a script of the schema, you could import that without data. Kind of a broad question.

3. Profiler can help find/filter queries taking longer than xx....

I looked at this a couple years ago along with MySQL. It's been a few versions and the PostGres/MySQL versions have advanced quite a bit.

My 2cents:

SQL Server is not unstable....

FilesystemObject can do the rename.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vtoriVBScript.asp

Include this in an active X script.

For the email, I use ASPEmail from persits (http://www.aspemail.com/) with this code:

Function Main()

Set Mail = CreateObject("Persits.MailSender")

Mail.Host = "mail.mydomain.com"

'put...

You should be able to log in as the SQL Server account (the one running mssqlserver) and log into mail. If this doesn't work, you might have the pwd or...

How many do you need? If it's more than 1024, I suggest you revist your design.

Also keep in mind the max byte size for a row is 8060, so...

Check that autoclose is not set.

http://www.sqlservercentral.com/columnists/sjones/autoclosefordatabases.asp