We have 150 SQL Servers & 3000+ databases. Autogrow is the standard & we reindex weekly at minimum. We use home grown code & batch jobs to retrieve...

Good article. Reminds me of a gripe I have about MS, though. In Enterprise Manager, using external tools, you could open explorer on the server where you had...

Was this ever resolved?  We are missing ODBC drivers (including ORACLE) on our 64 bit SQL Server 2005 environments.  Server operations group installed the Oracle client, but the drivers are still...

I'm a guy, my daughter is in college and yes, I've encouraged her to pursue a career in IT. That's entirely her decision, but I wouldn't think of discouraging her...

I agree with SAM, sort order/collation should be a major consideration, if you're in anything but a tiny shop - we have 5 different flavors here.  Putting a user database on...

Worked good, after figuring out not to use quotes for the input variables, and then a problem encountered when the sqlcmd couldn't log on:

Moving files...

Restarting service with /f and trace...

Yes, you'd need to do the same with those.  Make sure the drive letters & folders are the same on source & target servers. 

This method is rather easy, and a...

Is the new server going to be renamed the same as the old one?

Here's what we do in a nutshell - if the drives are the same & this is...

Nothing in the event logs anything like that.

Oops, I meant to say he suspects the MAXTRANSFERSIZE default is hardware dependent, not memory dependent.

Passed this on to our server guy, he said we use NIC Teaming, but only in a smart failover configuration, not load balancing.  No drive failures.

8 SAN attached servers are...

Couldn't say for sure, but I doubt it.  I notice that MS article 224071 (How to move SQL Server databases to a new location by using Detach and Attach functions...

External tools also don't work the same in sql2k5.  We manage 100+ sql server environments, so using the [SRV] parameter in sql2k EM external tools is handy for executing explorer,...

Nice article.

External tools also don't work the same in sql2k5.  Managing 100+ sql server environments, using the [SRV] parameter in enterprise manager's external tools is handy for accessing explorer, server...

We're having the same issue on a production server here.  Applied SP4 & then the 2162 hotfix due to trying to fix strange problems. 

Ended up bad data being bulk-copied...