Hello!

I guess changing a couple of INNER JOINS to LEFT JOINS (or making them subqueries) and removing the WHERE     (dbo.analgroup.sys_analgroup IS NOT NULL) or moving it into a ON clause on...

Hehe. I'll be heading down to the pub to get my ice Seeing that it is end of the working week now

I guess it is a point of view. Not many things are security issues unless you explicitly make them to be security issues. Defining a Linked Server where all users are using 'sa' on the...

I'd say yes and no

If you increase the timeout it will probably succeed (but it will still take a long time) since the query...

Agree. Not possible.

You could go for the other approach, select from a view (or many) inside a Stored Procedure...

I agree with Remi Gregoire, your solution is great. Easy to make, quick to implement and if performance is not an issue...

Well, just to assess your timeout problem, it is very unlikely that it is because of sql server. I think it is your calling enviroment that is timing out... Try...

Why not make boring things easier?

Create a linked server and.. Tadaa! Do a  EXEC YourServer.Master.dbo.sp_addrole 'MyRole'

You're welcome

Maybe I am bing abit of a party pooper but maybe Microsoft are not so happy about passing around unrelased and not for public use hotfixes...

//Hanslindgren

Right...

I'll do some testing... Thanx again!

P.S And if someone else have tried it and found any issues with changing this system table, please let us know! 

Hello!

I would say one 'big' would do it ( though maybe that could internally call other SP to get modularization ) so you gain performance in eliminating unneeded server round...

Do you mean inside Enterprise Manager?

I havn't seen this problem before but maybe she does not have any SQL SPs installed and it helps if she applies SP4?

//Hanslindgren

Thanx Shawn C!

But you know of no way of actually changing the Server name?

I guess you could write your own?

Insert the result of sp_helprole into a tmptable and just do sp_addrole for every record (execpt the standard roles) on the new server...

//Hanslindgren

No, there is no easy way of doing that.

But if you want to do it more times you could consider doing it in a cursor loop then doing cut &...