The account that SQL Server is running as (the SQL Server service account) needs to have permission to access that folder.

Check what accounts have permissions on that folder

Check what account...

Attach the database read-write, let it recover properly. Detach it again and then you should be able to attach it read-only without problems.

Are there any other indexes?

Your problem may also be poor indexing or poorly written queries. Both of those can easily cause SQL to have to read far more data than it should have to....

Does this help?

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx

Basically, in my experience:

1) Log files on a separate RAID array

2) Data files (if there are multiple) on separate raid arrays

3) TempDB on its own set of dedicated...

Can you post the table and index definitions please? Also the output of sp_spaceused for that table

The only way that a SQL data or log file will decrease in size is if you explicitly shrink it or if you have autoshrink enabled (which is a bad...

DBA (10/13/2008)

---

thank you, so i put my logic now how you put it. I could put the logic into a stored procedure, and then make the trigger execute the...

David Lester (10/13/2008)

---

It seems to me such a question would be somewhat common, that is knowing when and how often various select statements occur. Of course, I have been...

I'll add to that

7) Set up some performance monitoring so that you can establish a baseline of what's normal and what's not

8) Schedule index rebuilds/defrags as necessary

9) If in full...

Usually before that point people will start splitting up, for recovery purposes....

That still only allows for a single row in inserted.

If multiple rows have been inserted, then your variable assignment (below) is going to assign values of one of those...

Looking at that, unless you're seeing IO bottlenecks (are you?) I doubt you'll see much if any improvement from the split. If you decide to split, then just add a...

Are you sure there's no one else with sufficient rights? Nothing got accidentally scheduled or run? The DTS package didn't perhaps have the wrong connection on a drop table task?

It...

thomas.lemesurier (10/13/2008)

---

This kind of works, except that in some cases there is more than one row in the Album table per album. For example, for a given album, the Album...