Install everything on new server, putting the master.mdf in the exact same place, then stop service on both machines. Copy the mdf/ldfs to the same location on new machine that...

I agree that would be a very nice feature. I guess the plans cant be all things to all people, but a few more features would close the gap.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Havent had a use for TextCopy, didnt know it had that limitation. You can insert it into a working table as standard text, then move it to the final table,...

SQL 7 or 2k? If you have SQL2K I'd suggest looking at only changing the columns that matter, not the whole db.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Detach, copy to new server, attach, then reconcile the logins - you may have to add some that don't exist on the new server, or fix broken links using sp_change_users_login.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Parity is how it checks the data to insure its complete, or in the case of a missing drive, how it reverse engineers the missing piece of data. On a...

Well...there must be some!

Using a bitmap vs separate bit fields would make it hard to change later to a multi state indicator - pretty common to start out with yes/no,...

Was thinking that was the number for disk queuing..will have to check!

Andy

http://www.sqlservercentral.com/columnists/awarren/

I think you can change it using sp_configure, but I agree with Chris - the vendor isnt trying a bit to help you, either out of laziness or lack of...

Not that I know of. I usually grab the full text from the lower half of the display rather than trying to expand the column very much.

Andy

http://www.sqlservercentral.com/columnists/awarren/

I try not to use it, since in terms of space there isnt much difference and whether using separate bit columns or one consolidated column an index isnt likely to...

Interesting, I'll have to check that. I did some testing related to this recently, not sure I looked in both places or not. You'd think if the service account had...

Hosts might be faster in some cases regardless of the bug - but its a potential headache if the IP changes and no one remembers/knows to change it in hosts!

Andy

http://www.sqlservercentral.com/columnists/awarren/

No way that I know of, other than build a wrapper proc/app that would set the filegroup when it was used. Normally you dont have many users creating db's, much...

Have you enabled logging to a text file to see if you can capture any more detail? Usually the maint plan history has more/better info than sql agent, never seen...