I don't think that there is a function for that, I think you must use a cursor unless anyone else knows a way.

What do you mean by 'as our main db.' Are you saying to use the db for the subscriber as a production server?

Replication shouldn't interfiere with your backups. But to keep replication consistency in case of a server crash, you should check the option 'Sync with Backup' in the sp sp_replicationdboption. This...

Are you having troubles?

are you letting checkdb to fix the errors?

Did you reboot your server?

I think that for update triggers is easy but for the others you will have to use a cursor.

Unless the transacction is a massive transacction, (10000 inserts for expample), the...

run killl [SPID] WITH STATUSONLY

If it show time remaining 0, then the process won't die, so you will have to reboot sql server

I didn't know this dbcc command. Can you post the parameters?

DBCC IND doesn't seems to work either.

to change a column for a published article (table) you must drop the publication, change the table and then recreate and syncronize the publication.

If your publication is too big, to...

Also a god way to learn is create a publication with EM, script it, and then check with BOL all the stored procedures used to create the publication.

Also if you explain what does the job do would help us find the problem...

Try this:

DECLARE @Lastname VARCHAR(25)

SELECT @LastName = 'O'+''''+'Malley'

SELECT * FROM PERSONS WHERE LASTNAME = @LastName

DID you create the identity field with the option NOT FOR REPLICATION or not?