Ganesh,

Allen is correct.  I apologize if I misunderstood.  IF you change the name of an index that is explicitly called then you need to change your code.

It is just...

umm..  The correct answer is typo'd BIG TIME.  I cheated before answering by using RegEdit and ensuring that the answer I selected (as far as the registry path goes) is...

Can you post a snippet of the code that is failing with the global variables so we can attempt to help you.  It sounds like a data-type conversion issue but...

Roger,

No you don't need to recompile your code like Ganesh stated.  However, more than likely the server will recompile all of the needed code by itslef due to the...

Have you tried doing the CAST/CONVERT in BOTH the SELECT and GROUP BY?? 

I have had to do this before for various other reasons and it should work (I think)...

try the following

1.  Build the ##temptable information or real table with data inside the 1st sp

2.  Call the 2nd sp that uses the table from sp 1

EXEC sp1

EXEC sp2

If you are going to have another SP use the data from this SP's temp table then you need to use ##tablename and not #tablename.  The ## is available for...

1. Bring the data into a single column SQL table and PARSE away
2. Use VB to crawl through the text file and PARSE away and send the data into SQL via a...

Have you thought about doing a CAST or CONVERT of the TEXT field to be a NVARCHAR or VARCHAR that you would then be able to GROUP BY??  These fields...

what are you using to develop the SQL query?????

Try changing the "Insert tblMMStateStandards" to

"INSERT INTO tblMMStateStandards"

UPDATE DI SET manufacturer = DTS_MRP_DRAWING.NO_CODE_IDENT

  FROM DTSinvvendor DI

    INNER JOIN DTS_ubmf01_part_master DM ON DI.itemnum    = DM.PART_NO_001

    LEFT JOIN DTS_MRP_DRAWING         DD ON DM.DBKEY_8000 = DD.DBKEY

The problem was the WHERE...

This should work

SELECT CAST(S1.[name] AS VARCHAR(30)) SystemGeneratedName, CAST(S2.[name] AS VARCHAR(50)) ObjectName

  FROM sysobjects         S1

    LEFT JOIN sysobjects S2

      ON S1.parent_obj = S2.[id]

WHERE

  LEFT(S1.[name], 4) IN ('CK__', 'DF__', 'PK__', 'FK__')

Form what I have read it depends on the BRAND.  If you are running AMD Opteron then you should not experience any speed difference either way.  INTEL has a performance degradation...

Set-up NT groups and make the groups READ-ONLY with EXEC to stored-procedures ONLY if you want to lock down the system completely.  This way the stored-procedures which are reviewed (by...