Jack,

I made some changes to get this to run on 2000.

CREATE TABLE #logins

(

sid VARBINARY(4000),

login_name NVARCHAR(100),

...

Most of my support is for canned applications. I will fight vendors that insist on using the 'sa' account for everything. My stance is not to give that to anyone,...

A little more information...

This appears to be the query running in the background...for each database

SELECT u.name AS [Name],

CAST(u.hasdbaccess AS bit) AS [HasDBAccess]

FROM dbo.sysusers AS u

WHERE (((u.issqlrole != 1 and u.isapprole...

You are preaching to the choir...I would prefer to not give it out. The Express version is almost perfect...all it needs is the import/export option and it would be the...

How do you do that through the GUI? The options that I see to install the Management tools includes unwanted things, such as SQL Profiler and SQL Server Configuration Manager....

I have done a search for only extended SP's. However this only shows 60 items. There are 171 objects listed in the master database. I am guessing that this is...

This is a great start for what I have to do. Our security group wants a report showing that the public role doesn't have access to certain XSP's. This appears...

OK...I think I see how this is working. Correct me if I am wrong

This does: 1 - DAY(getdate()) which will return the current day, which would be 26 today. This...

Awesome. Both of these work as needed. The question that I have is how they return the date as of the 1st of each month. I looked at BOL and...

I am the admin and DBA. I have about 30 servers to check. Since I can't block the local Admin group on most servers I need to validate the modes...

Great. This is a good start. I will work with some of the scripts I already have and see what I can come up with. When I get it done...

Well, here is the simplest way I found. I hope there is a more straight foward way.

Remove MSDE.

Reinstall MSDE.

Restore master, msdb, model then the user DB's. Somewhat of a hassle,...

Thanks alot!! That looks like what I needed. I will have to save this as a script so that I can look it up when I forget!