Set up all your servers as linked servers on a master server.  Then loop through each server with a query that inserts all logins with a null password into a...

We copy out our data and log files for master, msdb and model to somewhere safe.  That way, we can use them to start SQL Server quickly after a file...

Robert

UserID is an integer, so why are you using the FLOOR function on it anyway?

John

Please start a new thread.  Follow the link below, then choose the most appropriate forum and click on New thread.

http://www.sqlservercentral.com/forums/default.aspx

John

What makes you think those rights are not being taken over?  Can the user still connect to the database?  How are you trying to connect?

John

It sounds as if your instance of SQL Server isn't properly clustered.  However, without more specific information, it's difficult to help you.  What error messages are you getting?  Is this...

Robert

Please will you provide some DDL, sample data and expected results, since it's hard to see what you're trying to do.

Adding in that WHERE clause turns your OUTER JOIN into...

Yes, and he hasn't even had the courtesy to say thank you.  No doubt you've already added him to your mental list of users that you won't bother helping again......

Krishna

I notice you still haven't posted the (exact) error message.  However, from what you have said, I think I can help to point you in the right direction: you should...

Krishna

"Some prob" is too vague.  And I don't see "curren_area" anywhere in the query.  If there is an error message, please post it.  If the query is not returning the...

Krishna

Care to tell us what the problems are?

John

Jorge

I think you need to study the SQL Server 2005 security model - there's plenty of material in Books Online.  Good luck!

Also, I would try out sqldiag, which is part...

Jorge

Presumably this is the output of some health-checking tool that already exists?  Does sqldiag.exe provide this?

John

Something like this?

SELECT Word FROM #RestrictedWords

WHERE CHARINDEX(Word, @TestWord) > 0

John

Jorge

I don't understand exactly what you require, then.  Please will you give an example of how your report should look.

Thanks

John