Thanks, that helped on the object side.  I am also looking for one that would display something like:

Sid, UserName, DatabaseName, Server Role, Database Role, ect.

When I figure out some/part of...

Also, when you look at the backup device, both the expiredate and the retaindays set the expiredate when you look at the contents of the backup device.

joseph

Sorry, I mistook the information. The size is accurate when running the sp_helpfile. And that information is good enough for me.

thank you for your help

Joseph

sp_helfile does not display % used, and the "size" is not accurate either.

Joseph

The log shrink works fine. The physical file is shrunk, and everything works fine. After the file is shrunk, and I run sqlperf(logspace), the data ("log size", "log...

Thanks, I will look there for error messages and solutions. It is fixed.

Joseph

Thanks, I will give these a try.

Joseph

Correct me if I am wrong (please). But I have delt with Microsoft quite a bit on this issue. With the latest changes to the licensing here is...

Thats what I am looking for.

Thanks!

I saw applications that pull word list and other utilities, but did not see a word list. Could you please be more specific?

I will keep looking around the site.

Joseph

...

I fouind the "script" option.

But, I would be interested if any knows how to actually use the template with Transact commands.

Joseph

What version of SQL Server?

if 2000, you should be able to detach the database on test. Delete physical files. Do a restore from the backup you took....

THANKS, that was it.

Joseph

Here is the command string

D:\Microsoft SQL Server\MSSQL$NTSBUF12_CIM\binn\sqlservr.exe -sNTSBUF12_CIM

Joseph

Oh, we are running Win2000 and SQL Server 2000.

Joseph