Something that might be useful is the app at this link: http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx

It can show you which process is using a particular file.

No. SQL doesn't do that. The reason is that tables really aren't supposed to be designed that way. The values should be in rows, not columns.

Since you're...

talltop (6/12/2009)

---

GSquared,

The problem is not to identify Files in use,it is to provide a QUICK list of ALL detached database files ONLY in a directory. MS Process Explorer does not...

Log shipping can actually become your key backup strategy in those cases. Combine that with file backups (and split the database into multiple files, either through splitting tables and...

No. Nothing wrong. Just confused me for a minute. Felt like deja vu.

First I had to download the driver. That's here.

Then, I had to change "Excel 8.0" to "Excel 12.0", as per the directions on that page.

Then I had to turn...

Isn't this the same thing you asked a couple of weeks ago? Or was that someone else?

The best way is to build and use a calendar table. It's just a table with a list of dates, and pertinent facts about them, like day of week,...

Similarly, I'd use xp_cmdshell to get the dir, with a /b tag to eliminate the overhead on that, then I'd query the files in use.

In SQL 2005, I'd use...

Career-wise, I kind of wish I'd taken this one job opportunity. Didn't take it because I didn't want to move long-distance at that time. Six months later, the...

Not sure about changing the template. But as far as enforcing standards in layout, etc., you can usually just kick stuff back from the QA server till they get...

Leon Orlov (6/11/2009)

---

In my previous place.

RedGate SQL Compare and Data Compare top of the list.

Currently Toad for SQL and Oracle. Sucks for both... so I am getting...

GDI Lord (6/11/2009)

---

GSquared (6/11/2009)

---

I dislike the whole concept of fault. I prefer responsibility. It's the responsibility of those who can repair the problem. Fault and blame are...

cy (6/11/2009)

---

I sometimes think trying to find out "who" is to blame just adds fuel to the fire. The goal should be to find out "what" is to blame and...

Jeff Moden (6/11/2009)

---

GSquared (6/11/2009)

---

Don't disagree with you about the need for human involvement in the process. I just think a system that can do things like track average national and...