ErrLog,

That's a good script that I'll make sure I use. Thank you for pointing it out.

Lowell

Thank you for the link, I'll take a look. The easy fix would be to apply the SP1 and bring the server to that level. The easy fix......

Thank you Erin, will do, I tell myself test, test, and test again 🙂

I ran the script:

SELECT DISTINCT

( [vs].[logical_volume_name] ) AS 'Drive' ,

[vs].[available_bytes] / 1048576 AS 'MBFree'

FROM...

Thank you, I had in mind link servers and ssis packages. I'm leaning towards SSIS packages because it seems to give more control and more options. Thank you...

Good article, it will definitely point me in the right direction, I'm a very new DBA and I'm learning all the tricks and what to watch for.

One question, how can...

wakanni,

If you're getting an error it might be due to having a space in the database name. Add some brackets in the code below around the database parameter value....

I will definitely check it out. Thank you.

Thanks for the question, some people tend to forget the basics and waste time chasing their tales. Whether you use system tables, depricated or user tables you proved your...

Jeff,

I totally agree with on the exposure of the database to the public. The team I formed part with now it's very concious about this issue. We're...

Shaz I made a small change to your script to work with my databases. I have a couple that have a space in the file name. No major...

Very nice script, I was in fact looking for a way to pull this information together. I found a few scripts that gave me too much and some too...

The user that I'm trying to change is in fact the owner of the database. Would the best practice be change the owner of the database to the sa...

USE YourDatabaseName;

GO

SELECT sp.name

FROM sys.database_principals dp

JOIN sys.server_principals sp ON dp.principal_id = sp.principal_id

WHERE dp.name = 'dbo';

GO

The script above...

Thank you I will definitely do. Although it not may occurrences when this happens I'd like to know if there's anything else I need to look into. The...