Lowell,

Exactly! Most of the other changes requested were easy - revoking access to extended procs that we aren't using. I'm not at all comfortable with this change and...

I think there may be more to the story than builtin\administrators not working at all in SP3. There are several SQL Server 2005 servers installed here running SP3 that...

In the past, I had wanted to do the same thing as well. To the best of my knowledge, this cannot be done in SQL 2000. If I'm...

FYI - this is a duplicate post to this one - http://www.sqlservercentral.com/Forums/Topic964052-391-1.aspx

If you're interested in query-tuning performance, check-out this link. The book is available for free download, but I like paperbacks better, so I actually purchased it. I'm up...

Check out this post. I modified the code extensively to fit my custom requirements, but it's a great starting point.

http://www.sqlservercentral.com/Forums/Topic869519-2627-1.aspx

Cindy

Is this what you're looking for? I like to see the space in MB, thus the first computed field.

select (size *8)/1024 as MB, * from <dbname>.sys.database_files

Cindy

You can start with the installation of SP3. Sometimes you do need to install the earlier ones first, so you should always check, but in the case, you don't.

HTH,

Cindy

Like ronmoses, I, too, knew the answer because I learned the hard way. It's tough to figure-out the first time, but then the second, third, etc, it finally sinks...

Thanks, Gail. That was the link I was trying to find and just couldn't locate it! It's in my briefcase now.

I really appreciate you steering me...

IMHO, your bigger problem is why your log file keeps growing to an unmanageable size and not the shrink running concurrently with the backup.

The log backup is going to "empty"...

There are lots of posts on this forum as to why shrinking the log file is not advised. What is your reason for wanting to shrink it?

Cindy

Thanks for the question. I've done a lot work with schemas, so I was confident in my selection of the answer. The interesting part of this QoD for...

Thanks. Just wanted to make sure I wasn't trying to write/learn something that couldn't be done. PowerShell - here I come!

Cindy

I had never heard of endpoints, but apparently my BOL reference was better than Michael's 🙂 I did get it correct.

http://blogs.msdn.com/b/sql_protocols/archive/2005/10/14/480842.aspx

Thanks for question - learned something new today.

Cindy