Gila,

where can i check the review for 441 , Amazon.com or amazon.co.[something]? else that might be some £££ down the drain

Thanks

Sergiy,

>Then linked server is not your solution.

That's what I thought as well.

>Each time I try to create a stored proc I get the following error.

What type of trigger are you trying to create. i.e. DDL or DML, when you get the...

can you post your script

I have just bought the ms press self paced study book for 70-442. I am using the sybex book for the 70-441 exam by Isakov and the is nice to...

Glenn,

It seems you need 'permanent' linked servers, why are you bothering with dynamic creation? I thought your requirement was to centrally drive stored procs!!!

Ta

i must have my eye checked

on your remote server can you check if the DisallowAdhocAccess registry option is explicitly set to 0

and the Ad Hoc Distributed Queries advanced configuration option is enabled.

can u use stored procs?

Jeff,

seeing that there has been a couple of similar requests,based on this response why don't you do an article about it.

Ta

sorry i missed the part about the linked servers

did you look at the query execution path to see where time is being spent, before changing your code. and also use statistics on

you could consider using linked servers if its an option.

i am failing to understand where they are [all the three are coming in a single column]

where are you running this script, in QA??

i think your requirement is similar to these

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=376899

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=379131

please let us know, if that is not the case so that we can get a crack on it