Thanks

Hi Steve

all my databases are on a Windows 2003 servere running SQl Server 2005 though

Jim

Thanks GregoryF

can you expand on the Compliant change ?

Thanks

jim

Hi Folks

I guess nobody has ever nstalled Sql Server 2008 on a WIndows 2008 Server then ?

Jim

Hi

Still no luck

when i try to install 3.5 manually all i get is

"Setup Error"

nothing else

i look in event viewer and i see:

Windows Installer installed the product. Product Name: Microsoft...

Thanks Shawn

I will take a look at what is and what isn't installed

Jim

Here is one quick way:

sqlcmd -Q "exec spAuditUsersPermissions" -o c:\temp\SecurityReport.html

Jim

Thanks Paul

Jim

okay thanks

Jim

Thanks Paul

I will try it out

Jim

on Paul's i get an error

the linked one works

how do i save it to a file ?

Thanks

Jim

question:

is there a way to spool the output to a file so i do not have to copy and paste it into a file ?

Thanks

Jim

Hi Paul

i am getting this error when trying to exeute the code

1> DECLARE @command VARCHAR(MAX),

2> @script ...

will take a look

thanks

jim

Thanks Paul

will check it out

jim