when you do import export from database to other and table is having identity column then a step where you select source and destination table there you have edit mapping...

when you do import export from database to other and table is having identity column then a step where you select source and destination table there you have edit mapping...

is that poosible to have 10 publisher and one subcriber.

i guess u have 1 publisher and 10 subscriber.

publisher is one which is the primary data which publish data to...

hey,

try this command on the server where you are shipping the log that is target server

use master

restore database databasename with recovery

it might bring your restoring state db in online.

i have...

no database will not come online even if the service are restarted...

when ever u go for migration you should fix all comptability issues for download this tool

http://www.microsoft.com/downloads/details.aspx?familyid=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

and go for migration

it will tell you all compilance and noncompilance issue that...

select 'DROP LOGIN [ '+name+'] GO ' from master..syslogins

where name not in ('domain\raj','raju')

this Tsql will give drop login script for all user except which you will filter out.

copy it and...

use the below query to get all desired logins

select 'DROP LOGIN [ '+name+'] GO ' from master..syslogins

where name not in ('','',,,)

in where caluse specify user which you dont want.

when u...

ya u r right..

suggested it becuase it the simplest way to copy the desired tables with less efforts and overhead like full database restores and on which is time consuming...

See the snapshot will have read only data of the database for which it has been taken at a particluar time.

Suppose a snapshot is generated at 10:00 am today so...

SQL agent services may have some windows login id to start or log on you check the in SQL Agnet Service property window. Check what type what right it has...

yes i actually i mean that prepare snap shot of the database and from the snapshot copy all the required tables. it would simple and without using any third part...

try creating database snapshots and import or restore the tables you want

please check id which sql server agent is configured for has full rights

if your using 2005

then

select 'drop table '+table_schema+'.'+table_name from information_schema

select 'drop procedure '+routine_schema+'.'+routine_name from information_schema.ROUTINES

where ROUTINE_TYPE ='procedure'

this will generate drop script.

or open SSMS open database and select tables folder and press...