Thanks..............

BUT

what else information we can have .? ....like who exected it ?

plz provide the dummy script...:cool:

add following code in ur script

declare @db as nvarchar(50)

set @db='Employee'

declare @lstr varchar(100)

set @lstr ='select max(empId) as lastEmloyee from ' + @db + ' ..Employee'

exec (@lstr)

hope this will work...

I dont know what exaclty u want but if u want to incorporate

ur SELECT command into Procedure then

see this................

DECLARE @LSTR NVARCHAR(300)

DECLARE @projectId INT

--SET @projectId = 90

SET @LSTR =...

On what basis you want to update targetid in T2 from T1

there shud be some criteria or condition 😉

Dear SSC Veteran,

On production that guy wants to avoid UNION and you are executiing it CURSOR

dont u think it will increase network traffic and degrade server performance:D

Thanks ...but have u run this ..it only giviing system relevant information..

But buddy i want user databasee specific information

Thanks .i 'll try this ...

Can anybody tell me which dynamic managemant view or function will be used to get information ??

Thanks :):)

i want result as sql query:)

Can't we use OPENXML queries without using it ??

Thanks for ur response..but i need someone who can put light on it with his views.....

I have read thta BOL but i couldnt get it:)

try this out

select * ,op_bal + quantity from #Temps

see linked server is not a physical machine ...when we want to execute a query from server A to server B...then Server B act as Linked server

Linked...