SELECT batch_execution_id,

other_column_padding

FROM #TableX

WHERE batch_execution_id = '99641F25-0FA8-4651-819B-E2DEC05D5113'

GO

-- Same SELECT, but using a variable

DECLARE @execid NVARCHAR(50)

SET ...

if possible, required ORDER can be set in physical table and then avoid "order by" clause in derived query

May be you can do/schedule the reindexing in OFF peak hours.

try this

select * from

(Select 'BEGDOC' as BEGDOC

UNION ALL

SELECT 'BEGDOC' FROM table ) t

ORDER BY CASE WHEN t.BEGDOC...

you can keep prid column with datatype uniqueidentifier.

for definition http://msdn.microsoft.com/en-us/library/ms190215.aspx

for index size

select

i.name as index_name,

i.[object_id],

i.index_id,

p.partition_number,

p.rows as [#Records],

a.total_pages * 8 as...

Could you create a new table

with the same definition, and see how it that works?

and I found a post somewhere that suggested uninstalling the

workstation components, repairing the .NET 2.0...

How ? is somebody resetting it without intimating you ?

See this

http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html

then create login

and i guess you need to map that login to new server

Create a new user on that DB and

use GRANT EXECUTE on dbo.up_SP TO New_USer

Above lines causing the issue as you can use temp variable under a dynamic Sql.

@importRegisteredData doesnt have scope under...

How you executing SP at Linked Server.?

Dont forget to read SQL_Server_Execution_Plans by Grant Fritchey, Amazing Book

thanks i will read it this weekend