What i mean by server & db login maping is, when we restore the DB from one server to another then all the login's under the db will be restored...

Can you please give the exact message id?

Yes, this should give you all the objects to the new server but you need to map the server & db logins.

Are you trying to restore from backup OR restoring from script?

oke, thanks for the info.

I know that all the backup info is stored in MSDB db, but i was looking for some specfic query if at all you know it.

did you got the tables in which this info is stored?

can you share that info with us as well?

Do you have the required sql login on the xp server?

Is their any specific table giving problem?

You can create a dsn for mySql server, then use DTS for transfer the data through that.

This should help you in getting latest backup taken from QA.

SELECT TOP 10 BS.backup_finish_date, BMF.physical_device_name

FROM msdb.dbo.backupmediafamily BMF

JOIN msdb.dbo.backupmediaset BMS

ON BMF.media_set_id = BMS.media_set_id

JOIN msdb.dbo.backupset BS

ON BS.media_set_id...

Alan,

As you said then INSERT INTO SELECT * is not a good option i agree with that, you need to write all the column names in your select & insert...

Detach the DB from main server, copy .mdf .ldf files to other server, then attach the main db & then new db as well, this is one way. The best way...

The following sp will solve your problem, but it is always recommended to drop replication, alter the table then reconfigure the replication.

exec sp_repladdcolumn  @source_object,@column,@typetext,@publication_to_add 

For which db you want query db2 or sql server?

You can change the services back to localsystem logon, this should not affect any of the other services.

Thanks for the reply Steve.

I got one more way through EM

Right click table in EM -> design table -> table property -> table filegroup.