Thank you two (Jeff and ANT) very much - i really appreciate your time and effort!

ANT,

Are you saying that the update cmd actually works properly, and the data is correctly updated with the appropriate symbol? If so, if a user has permissions to query...

Your issue may lie with "port allocation".  One of two scenarios exist with a SQL Server installation - either the listening port is set to dynamic (the default), or one...

SA24/Steve

Thnaks for the reply and advice. I have used SQL profiler in the past, but not to a table.  I will attempt it - and include the columns Steve mentioned...

Steven_white40,

Thanks for takking the time to reply. I will look into your suggestion - it sounds like it would work. I haven't yet used that strored proc, so I'll...

I currently have log shipping setup and running in my production environment, and it is doing exactly what you are wanting to do. I used the procedure in the following...

I had same scenario of moving 8 databases from a SQL 7 server to a newly built SQL 7 server some time ago. I used the article Greg Larsen...

Stefan,

I agree with Greg Larsen. I have used the sp_help_revlogin procedure several times in the past and it works well. The link he posted from MS (article Q246133) is very...

Steve,

Thank you for taking the time to reply. I really appreciate it! Thanks for the info!