That's why the help_rev_login script includes the SID - should prevent users being orphaned.

sp_help_revlogin as mentioned above does the passwords correctly.

http://support.microsoft.com/kb/918992

Edit: Beat me to it George 🙂

Which error log? That sounds like a user error message rather than one you'd see in the sql error log.

Usual deadlock error 'Transaction (Process ID %d) was deadlocked on %.*ls resources with another process and has been chosen as the deadlock victim. Rerun the transaction.' is severity 13.

You can...

Typically that would indicate it's taking time to create and/or render the report. Are you getting an error or just the spinning wheel?

Leave it running until it times out &...

It's a good way to go about it. A fair bit of work to set up, but much easier after that!

ScottPletcher (3/6/2013)

---

To confirm, try writing the results returned by OBJECT_DEFINITION() to an nvarchar(max) column and checking the length of that column: I think you'll find that the entire code is...

george sibbald (3/6/2013)

---

the developers are asking a lot of you there, the code should be flexible enough to cope with changes in server names for DR and migration from test...

Approach is fine. The other way to do it if possible would be to give role membership(s) to AD group(s), and control user membership in AD.

That way you won't need...

QUOTENAME (@DB) is resulting in [USE MyDB] - needs to be USE [MyDB]

Note syscomments is due to be removed from SQL so this may not work in future versions.

There's a workaround here: http://social.msdn.microsoft.com/Forums/en/transactsql/thread/2e9b611f-0fe7-43ff-a420-5e96d14334d8

declare @name nvarchar(max)

set @name = 'proc_name'

declare @txt nvarchar(max)

declare @n int

declare @i int

select @i=1, @n=COUNT(*) from syscomments where id=OBJECT_ID(@name)

while @i<=@n

begin

select @i=@i+1, @txt=text from syscomments

where id=OBJECT_ID(@name)...

A find/replace isn't that much work now is it? 🙂

Presumably it's to maintain the difference between an empty string and NULL.

You need to implement Full-Text Indexing before freetext or contains will work.

I think Chris's solution is the way to go unless you find it's not what you need or that...

EXISTS might work. CONTAINS is used for querying full-text indexes.

But I think we need to understand what you need first. What do you mean by changing matched to partial?

Thanks