Hello,

RTO? ... RTP?

OK, this is all a bit new to me, so I apologise for my ignorance. I am studying SQL and trying to get to grips with its...

Perfect! Thanks 🙂

GilaMonster (7/11/2012)

---

Sorry, sys.dm_exec_sessions (not requests). Shouldn't answer questions before 2nd cup of coffee.

That will show you other connections present, filter for is_user_session = 1 (or something like that, can't recall...

GilaMonster (7/11/2012)

---

Now there aren't....

OK, I ran the query you kindly provided and it yielded no rows. This suggests that there are no other resources/connections using the database in question.

Interestingly, prior to receiving...

There were no message returned as a result of performing the DBCC CHECKDB command with the options you specified other than telling me that the command was successful.

If I understand...

Ran the DBCC CHECKDB command you supplied and re-tried, but the result was the same.

With regards to querying sys.dm_exec_requests, I get 34 rows returned. However, I am not sure how...

OK, I am not familiar with the table you suggested, but I'm guessing that it was the "open_transaction_count" column that should be of key interest? If so, then none of...

Thanks John, that's just...

Well, I have an SSIS package that loads a series of CSV files from a directory...

Hello,

Thank you for responding and my apologies for cross-posting. Some sites I've seen appear to recommend this approach when not having any luck in a particular forum - apparently not...

I'm using the standard DBCC SHRINKDATABASE but the same result happens if I use the more selective DBCC SHRINKFILE version.

I know...

None of my DB's use auto-shrink, so there's no issues...

Thank you so much for all your help and advice.

Hmmm .. quite a bit of food for thought there, thank you.

So, just to clarify for me (apologies for labouring this point) if in my example I had to import...