thanks!

exactly what i needed, thank you!

this worked perfectly , thank uu

thank you!

can you send the link to the sql 2005 version?

hi i am having the same issue , i killed the spid but it remains as "restoring" is there anyway to change that without running another restore?

thank you!

thanks!

exactly what i needed it! thank you all of you 🙂

that is what it was, the user's role had a view definition, thank you all of you!!!! 😀

thanks for your reply, i executed this in both environment.

in one db(A) he has

databaseCONNECT

databaseSELECT

databaseVIEW DEFINITION

in the other (B) only

databaseCONNECT

databaseSELECT

for the first one i went to...

to be more specific, when the user runs this in one enviroment (A)

select count(1) from sys.procedures (nolock)

in Database Server A he gets around 400

in Server B...

in both environments , he is only a member of the role db_datareader for the DB.

thank you guys.

so if the immediate_sync was already set to false and i have transactional replication if i execute this

Exec sys.sp_startpublication_snapshot 'publication'

it will only do snapshot of new articles?