How the hell do you show the contents of a system stored procedure? I know sp_helptext but there MUST be a better way than...

Besides of the above, the rules that were posted are pretty incomplete. Can you clarify a bit more the rules?

ORDER BY -->  ?, TableSort , Level, LastChildDescription

if the column where you defined the Foreign Key Constraint was defined as not required (meaning can accept nulls) then NULL is perfectly legal. If you want to prevent that,...

Can you explain why inserting in a temp table does not works for you?

Have a look at the troubleshooting Part!!!

http://support.microsoft.com/default.aspx?scid=kb;en-us;280101

I'd go a bit further:

select

ltrim(rtrim(t.last_name) )+ ', ' + ltrim(rtrim(t.first_name)) as name

from table t

and even further:

DO ALL TRIMING Client side before it gets into the DB!!

declare @group varchar(128)

set @group = 'mygroup'

select 'Grant '+ Case when xtype = 'U' then 'INSERT, UPDATE, DELETE'

                 else 'EXECUTE' end + ' ON ' + name + ' TO...

is the fast linked server the same as the one you setup in production?

is the load i production too heavy?

In my opinion you are performing the join locally. I would...

You will have to query sysusers for all the databases and use some unconventional features  :

declare @cmd varchar(300)

select  @cmd = 'select  ''?'' as...

Sorry but I can't reproduce your results.

Are you taking those values from a column or you just typed them in QA?

when you call an SP and it is not the first line in the batch you need to use exec

...

CREATE PROCEDURE sp_TriggerOrder

AS

 exec...

Change this line:

...

 set @cmd1 = N'select @retVal = db_logical_dbname from BackupFileData where dbname = ''' + @userdb + ''''

Actually updatetext does just that "exactly"

declare @startIndex int, @patlength int, @prtval varbinary(16)

set @patLength = 3 --len('fgh')

SELECT @prtval  = TEXTPTR(case_Details) , @startIndex  = PATINDEX('%fgh%', case_Details)

FROM yourtable

WHERE pk_id = 1234  -- Use...

try:

DBCC UPDATEUSAGE(0)

it will put them in synch

Cheers,

I can guess there is integer division involved.

Try:

...

convert(money,count(Answer)*1.0/count(QuestionID))  as PercentOfQuestions

...

Cheers,