Apologise for the miswording. I changed Jonathan's wording slghtly because it wasn't clear to me. Apparently, my choice wasn't much clearer. It's been reworded to be (I hope) more clear.

good catch, it's corrected.

CREATE PROCEDURE ListMyTable( @Op As Integer, @ParamValue As Integer)

AS

IF @Op = 1

select table_id from mytable WHERE COL1 = @ParamValue

ELSE IF @Op = 2

select table_id from mytable WHERE COL2...

Select the public role, right click, properties, then permissions button.

When you say the job window shows step id completely out of order, is this the history window? Also, when you create a job, you can specify it to start...

This forum is for assistance to others and we appreciate everyone remaining poite and professional towards one another.

The comments above from Mr. Celko are not appropriate nor necessary to...

Good luck. Be sure to visit here for help

http://www.sqlservercentral.com/columnists/sjones/killthattarget.asp

http://www.sqlservercentral.com/columnists/sjones/batching.asp

Good catch, administration is a pain. We typically setup servers into 3 groups. First group is lower impact, less people where we test patches and hotfixes. Sometimes we could script...

You can run Profiler to see what the most common SQL is. Make notes and keep track of what tables/fields are used for. Be sure that the db is being...

I have been involved in two cases where the cert mattered. One, I applied for a position with JD Edwards. The ad stated that MCDBA required and pretty much every...

Check your connection settings. Might be different in ISQL from defaults. Are you sure the data sets are the same? Default db, etc. the same?

Wow, that's some code

Haven't read all through it, but the left joins always make me worry about non-matches. That could be the issue....

Generate the scripts for replication and run them on the next server.