If you have the mySQL ODBC Driver (I believe it comes with mySQL for Windows), you should be able to use DTS. The shortcut is labled "Import and Export...

mySQL is free (for the most part) and you can't get cheaper than that. However...

Developer licenses for SQL Server are real cheap these days, so there isn't much cost...

You should have a setup log. I don't remember exactly where it puts it, possibly in the Winnt or System32 directory. I believe it has a .log extension,...

Are you rebuilding indexes as part of your maintenance plan? That will cause the log to grow to about the size of the data.

http://sqldev.net/xp/sp_smtp_sendmail.htm

DavidB, this won't actually rename the instance will it? What about the registry keys, etc. which are still listed under the old name. Does it matter?

Try creating a temp table right before you declare your last cursor. Have your cursor select from the temp table.

I thought case might be faster despite the processor overhead if it could reduce the io.

I believe that select into is a non-logged operation. Of course if you do a select into or bcp, you're breaking the transaction chain, so you'll have to do...

How about something with case? Such as

Select the_month =

case

when convert(char(12), on_contract, 101) = '1/31/2003' then '01'

...

end

I realize that you have date ranges, so you'll have...

It could be the nic. It could be the cable. It could be a switch along the way.

Are any other servers that are physically connected to the same...

Obviously you report from your reports server. What kind of queries are the customers issuing? Mostly inserts and updates or a lot of selects?

If there are a lot...

quote:

---

Also, since I don't have SMS, so I took the -SMS off command line.

---

I'm...

You probably need to use dynamic sql with either the Exec() function or sp_executesql.

e.g.

Exec('Select * from ' + @dbname)

It may be easier to turn your script into a stored procedure...

Matching usernames and passwords won't work for Windows Authentication. If you have no trust, you'll have to use SQL Authentication.