Look at this article. I think it may help you.

http://www.sqlservercentral.com/columnists/pibison/alteringacolumnonareplicatedtable.asp

What version of SQL are the files from? If they are from 2000 and you are attaching to 7.0, you would get this message.

Maybe I'm being a little 'dim', but what can I, as the reader, do to make viewing the article easier? I found that the 'Print This' helps but not always....

If I understand correctly, you want to transfer users of a database with corresponding passwords. Passwords are stored with the login. The Transfer Logins task in DTS can be used and it...

The RK folder isn't in the path. The easy way around it is to copy srvinfo.exe to the Windows folder.

I have a stored procedure that executes a cmdshell and pulls in the data from srvinfo (from W2K Resource Kit). It parses it for just the drive info and stores...

100+ servers - no problems.

Do you need to produce a report on space usage for all servers periodically or a notification when a server reaches a configured threshold (i.e. drive E at 80 % of...

Don't feel bad - you're not alone.

I think there are some at MS that take absolute delight in confounding us.

Schedule backups - creating a maintenance plan in SSIS (SQL Server Business Intelligence Studio on the menu) might be the easiest way.

Since you are appending only the day of the week, yes, the file will be overwritten each time it is run on the same day.

Will you break the back...

You can speed it up a bit more by "striping" the backup. Break up the backup file into 4 files so that each one is approximately 1GB. SQL will create...

I'm getting an error :

Invalid column name 'columnname1'

Any idea?

thanks - I'll give this try a little later. I'm much more comfortable with QA than ActiveX

I have agree with J.T. In my experience with 3 major tape vendors, not one could provide the reliability I have needed to meet SLAs for recovery.