You might want to consider the use of roles and groups.

A role is a SQL Server level principle which can be assigned rights.

You then assign the role...

Peter,

The I think the reason your not getting the parameter back is because your stored procedure breaks at the line where the error is. I.e. the second insert.

As...

My usage of this site and community is largely concerned with SQL Server matters which do not refer to any third party tools at all. This to me...

PASS certification is definitely a good idea. As long as they covered a separate part of the skill-set, such as troubleshooting techniques.

I am now a certified...

Reasonably sure that some of our developers have had issues getting both to sit on the same box before. I'm think they had to recompile some 1.1 code...

Totally agree with this approach. You do not want to alter the original system sprocs. This would lead to maintainability issues for subsequent DBAs when these...

Thanks Guys for all your help over the last couple of years. I have gone from total SQL newbie to secret Guru in my little world (secret is...

Thanks Guys for all your help over the last couple of years. I have gone from total SQL newbie to secret Guru in my little world (secret is...

Enterprise Manager can be used to create scripts for publications through (I think) the replication monitor.

Right click on several nodes until you find the scripting option.

This scripts the publication and...

I would recommend looking at a book by Chris Date on FK stuff (or any basic Database design book) to help you get the normalisation of the tables correct.

Or, for...

You might want to consider breaking the queries down into chunks using temp tables(or permanent tables you later drop). you would then be able to do some actions in...

Don't forget to allow space for the OS. SQL can steal it all creating a whole host of problems.

Mostly I used BOL 2005 and SQL server Central.

Buying questions are a waste of time (I used measure-up) in my experience.

The free web courses (MS Learning) are good but probably...

ms_repl_tran_version is created in order for replication to track versions of rows so it can know which is the latest when using updateable subscriptions.

I don't think there is a work...

How did you create the duplicate?