this means that the user is trying to access the server via windows authentication and on the server itself...

or help us, he's using the "builtin\administrators" as user in the login...

the question is if you need point in time restoration

if no, then just set the recovery model to simple so that you don't have to shrink the log file, it'll...

backtrack a bit

why do you need xp_cmdshell? you may find that you don't actually need it afterall

you could log the errors in txt file, a rollback will not roll this back...

i think... give it a try

due to the "unplugging", replication transactions could have been rolled back

i had experienced it before, 5 hours of getting to commit transactions, when suddenly aborted due to n-number of reasons,...

what sql version and sp do you have?

pretty straightforward:

dbcc checkident('tablename',reseed,1)

if the table is still in development and you have no other table using that identity value for constraints or referential integrity, I guess it will ok to...

did you check the full syntax in Books Online?

This is  a help file for sql2000,

otherwise go to msdn

dbcc checkident, check out the entire syntax in BOL and read the implications

HTH

can you post the steps? there might be something missing...

by right you should be able to modify this

is the script grayed out? does your account have SA privilege?

have you re-run the snapshot?

you can modify the existing stored procedure, rename it and use that instead incorporating what you need to monitor the status

HTH

modify the publication using enterprise manager, go to each articles and modify the owner there for snapshot, then reinitialize the subscriptions so you can reflect the changes by generating a...

a job maybe? (aside from the obvious that someone is doing it manually), you may want to enable profiler on this server perhaps

renaming a table is not recommended as this will cause some codes to break especially those that don't use SPs to address them

but it's probably your requirement, just check for...