check the tables involved you may have conrruption in one of them.

Jimmy, the index thing seemed like a good guess. If it's just the display, I'm not sure what's wrong there. If it's really bugging you perhaps you want to contact...

What does your sproc look like? Why are you passing in the query? I'd expect the sproc takes a parameter for the price and you only pass in the 10.

I received this as a post with a long explanation of why it didn't work. It seemed reasonable to me and honestly I didn't setup a test for 4200 Unicode...

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

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

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

Please keep the comments on topic and professional. What may be "nuts" to you, may solve a problem nicely for another.

Marshall, the PK is the unique set of values in...

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