if not already done so in EM properties\security set audit level to failed logins only. This will give you more info on the error in the errorlog and the application...

Barry,

should the default database file locations have been set via the database settings in SSMS properties, your query would not be guaranteed to return the default locations for database files.

If...

...another thing, is execute as owner really necessary?

mike.fleming (6/12/2009)

---

Hi John,

This is the error I get when I execute the SP from my script

C:\GetLocation.vbs(24, 1) Microsoft OLE DB Provider for SQL Server: Could not obtain information about Windows...

If the default database file locations have been changed the values are stored in the registry so use xp_regread for

HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MICROSOFT SQL SERVER\MSSQL.1\MSSQLSERVER

and check the values of defaultdata and defaultlog.

If these...

Now you're just being silly. 🙂

start checking fragmentation in your databases at points in time furthest from when they are rebuilt, see if you can identify any tables that become fragmented quickly and would benefit...

OK. there is some weird people out there! 🙂

dump database comes from sybase and was used in earlier versions of MSSQL, it has been deprecated but still works. Just replace word 'backup' with 'dump'

However there is no good...

problem with this sort of system is it is just as likely to be used to identify who is NOT likely to leave and therefore you can get away without...

Hey Gail, I'm finally typing faster than you 🙂

heres a thread might interest you and the gang:

http://www.sqlservercentral.com/Forums/Topic731195-1291-1.aspx

Backup and restore is a big subject, your best bet (honest) is to refer to backup database and restore database in books online and do some practicing on a test...

I might as well be first to ask, WHY do you want to use cursors as opposed to set based.?

The heavy hitters should be descending en masse on this at...

SQL Noob (6/8/2009)

---

there is a constant tape/disk battle here and i've used both. i'll take tape any day over disk.

in the last 9 years i've seen less than 5 tapes...

If I may jump in and deprive Gail of a point...............(She's got plenty)

If your database data file is obviously way over sized and you you know you will never need...