We're still working on it and we've gone through a few revs, including a new one today, to try and make it less of a load on your systems.

Thanks for...

Thanks, rare to get a complement. Glad it helped.

I think this is an error on a blocking issue. The query was blocked by something else and timed out. Try increasing your query timeout and see if this helps.

Also,...

Maybe try a new sysadmin account as well.

Are you going through a firewall? I wouldn't expect it, but I wonder if DTS Designer uses some different port.

The forum search is a little flaky. Seems to sometimes show the last page, sometimes not.

Use the site search instead (http://www.sqlservercentral.com/search/turbo.asp).

From a few friends:

We do mostly Hardware Raid so I don’t believe that will show in the registry. You might want to look under HKLM\Hardware\Devicemap or HKLM\System\Currentcontrolset\mountedDevices

-----

We do mostly...

In HKLM/Microsoft/MSSQLServer/MSSQLServer/SuperSocketNetLib there's a TCP key and a TCPPort flag below that you can scan. That's W2K, not sure about other versions.

You can use some port scan tool, like nmap,...

Not sure I agree with the Open Source argument. It does allow you to choose when you upgrade, at least theoretically since you have the code, but if you don't...

The easy way to lock this is use a transaction around it.

Begin transaction

...

commit

Alter table 1 to make the length 25.

Not sure why you want them to be different. Especially with varchar, just put the smaller one at the length of the larger...

That should work. I'd look to move the full backups the day before, or before your window and let transaction logs catch you up from there.

So if you plan on...

The jacket might be optional, but you can't go wrong with it. Shirt and tie unless you've made inquiries already.

I always ask this in the telephone interview/pre-interview process to know....

It's out now. This was a reprint from late last year.

You can get the book here: http://www.sqlservercentral.com/books/books.asp?categoryid=12&categorynm=SQL+Server+2005

Your first one should work, but I'd be wary of stripping the alphas. They are your markers. Otherwise how do you know if "244" is 2 of 44 or 24...

http://msdn2.microsoft.com/en-us/library/ms189826.aspx