Karina

  Can you provide full details like ... what type of replication you are using and which agent gave you this error....

Frances

The prefix "dbo" (dbo.tablename) specifies the user who owns the table .

whether it is a database owner or a user

hope you got this...

Thank you Uddin for the suggestion..

hi

  did you try out this one

sp_dropuser 'username'

after executing this try to add the user again..

Thank You

Shekhar

You have transaction log and DB backups running daily..??

try backing up them and shrink..

Can u check the time zone setting in the operating system of the computer on which SQL Server is running...

this could help you

Thank You

Shekhar

No,

Only the members of the sysadmin fixed server role can add users to a database...

Thank You

Shekhar

and use the below script to move tempdb to other drives

alter database tempdb modify file

     (name='tempdev',filename= 'E:\MSSQL\data\TempDB\tempdb_data.mdf')

alter database tempdb modify file

     (name='templog',filename= 'C:\MSSQL\data\TempDB\tempdb_log.ldf')

This requires server restart to take...

Thanx jeff & mengus

the problem was with the IDENTITY property on JOB_ID column...

thank you

Shekhar

I have created a linked server with following credentials...

the following is the output from sp_helpLinkedSrvLogin

Linked server, Local Login, Is Self Mapping, Remote Login

MUS               ,    sa           ,       0                 , sa

i...

have u restored both Publisher and subscriber databases???

that might cause problem to start the transactional replication..

instead u restore only publisher database and create empty subscriber and then start off with...

check the security option which u have choosen

try using the last option

"be made using this security context"

and specify the remote login and password...

Use Execute function which evaluates the string to an SQL query

build a string fot the insert query and pass it to Execute fubnction

ex:

replace ur insert query with the following ..

Execute('insert into'+  @filename1+'...

Use this

For ex:..if u have got RID from trace

RID: 7:1:35443:0

DBCC PAGE ({db_id|dbname}, pagenum [,print option] [,cache] [,logical])

where:

db_id|dbname - Enter either the dbid or the name of...

Every five minutes, DBCC INDEXDEFRAG will report to the user an estimated percentage completed. DBCC INDEXDEFRAG can be terminated at any point in the process, and any completed work is...