You could enable login auditing or use a DDL trigger

http://msdn.microsoft.com/en-us/library/ms190989%28v=SQL.105%29.aspx

http://msdn.microsoft.com/en-us/library/ms175850.aspx

skumar 5499 (5/9/2013)

---

Interesting example - but some time what we miss out is the fact - Model is not broken, its because we could not model it correctly due...

Mike Dougherty-384281 (5/9/2013)

---

Are you implying that old code is...

You're not setting the result of the select in the first part to a variable.

Went to Yankees/Rockies last night. First game in two years, and almost a rainout. It drizzled, and then came down hard almost the entire game. We only watched 2 innings,...

Note you still can't delete the primary file group.

Larry.Thompson 62346 (5/8/2013)

---

From an AI research project in college, I discovered that our distint advantage over machines isn't our ability to be precise, but our inability. Our minds often...

You can query sys.databases to see if the database exists.

If so, then you'd have to query sys.database_files in that database to get the file location. You can do that like...

Lynn is correct, use with Standby.

http://msdn.microsoft.com/en-us/library/ms188223.aspx

The default data path is stored in the registry. Here are some answers, but it's the one that reads the registry that you want

http://stackoverflow.com/questions/1883071/how-do-i-find-the-data-directory-for-a-sql-server-instance

You can't change the primary filegroup AFAIK. You can change the default filegroup. (http://msdn.microsoft.com/en-us/library/aa933074%28v=sql.80%29.aspx)

http://www.mssqltips.com/sqlservertip/2601/using-multiple-filegroups-for-a-database-and-changing-the-default-filegroup/

If you are trying to move to a new disk, detach the database, move the files, attach...

It very much depends on your business, but I can give you a few things I've seen people use.

1. AlwaysOn Availability Groups - Get some HA and offload reporting in...

It's not a simple thing to debug and trace down.

SQL Server can run fine under virtualization, but you have to understand that configuring xx resources for a VM doesn't mean...

Check this: http://msdn.microsoft.com/en-us/library/ms190673%28v=sql.105%29.aspx

I'd also make another backup of the source database, ASAP.