Sheldon , I am facing the same issue while converting text column to datetime. Did you got any solution.

execute this query. It gives you all the detail about the tables in the database

declare @id int

declare @type char(2)

declare @pages int

declare @dbname sysname

declare @bytesperpage dec(15,0)

declare @pagespermb dec(15,0)

create table #spt_space

  (objid...

You can use MS Visio for the documentation. Its very easy to use and can be always used for storing and understanding replication structure. Here we can create a diagram with all...

Thankyou. My publication is on sql2k and the subscriber is on sql2k5. I wish to insert column through scripts and sp_repladdcolumn might not work on different version of sql server. And before inserting...

Do you mean scripting publications?

Oh thats what i am thinking. Yes the database was restored from production to testing environment. So users with blank logins are void and we can delete those users from...

Chuck What tool your company is using to push script to set password once at a time. The whole idea behind this is saving the time in transferring a list of...

Thanks you all for quick help. Yelena we are going to send notification for the individual NTlogins having different type of access on server. Thanks for pointing that applying same...

Thanks Kathy.  Can a windows authentication login or sql login can access server via group membership . If so how to give windows authentication login  or sql login  via group membership .

Thanks Chris. I got my answer from you. Its a memory leak only.

Shekhar,

Thanks for your reply. Its a transactional replication and the error message is from distribution agent.