was the password recently changed for the user PPSCENTRAL\mrcluster , and the job not updated withthe updated password, maybe?

row_number() is your friend in this case.

that will allow you to rank/assign a value to each row:

SELECT ROW_NUMBER() OVER (PARTITION BY tblContactID ORDER BY tblContactID,TotalDue) AS RW,* FROM #TEST

then with...

how about dynamic SQL?

execute ('use Perfect1012;drop procedure dbo.pr_fake')

works for me.

aww,at 1000+ lines of code, without the underlying base tables and linked server(EDWGEARS),

that one is a little bigger scope than i can help with as a volunteer;

it...

well there you go!

i see a couple of things;

the plan shows two cursors doing stuff to at least 580 rows;

those cursors can be eliminated and replaced witha set...

chriskellerx10 (8/2/2012)

---

What is the best way to give you this information? As far as the schema and clustering? I have never created and clusters before.

Sorry for my limited knowledge...

something missing from your post is the state

with the state, you know what the actual problem is:

http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

ERROR STATE ERROR DESCRIPTION

2 and 5 ...

try this: adding SET FMTONLY OFF works for me:

i tested from a 2005 to a 2008 openrowset:

SELECT *

FROM OPENROWSET ('SQLOLEDB','SERVER=DEV223;UID=sa;PWD=NotTheRealpassword;','Set FmtOnly OFF;exec master..xp_cmdshell ''dir c:\'' '

) t

nzhang6666 (8/2/2012)

---

I can use the sa...

jeff.mason (8/2/2012)

---

opc.three (8/2/2012)

---

This is exactly what Microsoft is up against. They...

well, you could use a view on dbo.Incidents to automatically generate your calculation as a new column, or you could add a calculated, persisted column to the base tabe; both...

without the details my friend anthony is asking for, i'd WAG and say to update statistics on the underlying tables the procedure uses.

out of date statistics are associated witht eh...

well, based on your post, you said the users cannot select, and i'm guessing that is because you did not assign db_datareader.

you'd have to report the specific error message they...

an example of what Sean is asking you for: a CTE or CREATE TABLE with his first post:

With MyCTE (PRNT,CHLD,POS)

AS

(

SELECT '1050000','1000000','1' UNION ALL

SELECT '1050000','5000000','2' UNION ALL

SELECT...

this warning is for the least common denominator thing:

the Object Explorer warned you if you are not in the db_owner role, but if you test my role, you will...