Jeffrey Williams (11/25/2008)

Not sure where you...

Of course, that is exactly what my script does for you.

I believe that this can be made to work on SQL 2000, Jack. But I would need some time on one of the few SQL 2000 systems that I...

Oh, and "No Cursors"!

I think that this should do it:

declare @sql nvarchar(MAX);

Set @sql = N'

declare @sql nvarchar(MAX);

Set @sql = N'''';

';

Select

@sql = @sql

+ 'Select

@sql = Replace(

Replace(definition, N''search text'', N''replace...

Some of this (like password expiry) you could implement yourself. Other parts (like 3 fails & you're out) are more difficult.

Dang! So that's where they hid it!

Thanks, Matt, you da man!

What do you mean by "disable state"?

TRUNCATE TABLE will do it.

You are getting divide by Zero from your Horses with no Wins.

No way that I know of.

DMO was written for SQL Server 2000 and lower. The security scheme was significantly changed for SQL Server 2005. I do not think that a permission named "VIEW"...

Actually Jeff, the Owner of a SQL object can be different from it's Schema. Check out the ALTER AUTHORIZATION statement to see this..

Do you mean that it is stopped? If so, then you can restart it by right-clicking on the "SQL Server Agent" icon and selecting "Start"

I am...