The DBCC SHRINKFILE(file,EMPTYFILE) is an essential step. You cannot remove a file unless you do this because this is what tells SQL to deallocate the pages in the file.

It...

[I'm obsessing on this because I have exactly the same problem.]

After using my script (see above) to list the tables on the filegroup I want to drop, I still get...

Add "WHERE xtype='U'" to the cursor for user tables only.

Try this one...

set nocount on

create table #id (ndx int primary key identity,ob int)

create table #fg (ndx int primary key identity,fg varchar(255))

declare id_cursor cursor local read_only for

...

Actually, maybe the trigger should be on syscomments?

quote:

---

Hi,

We are having some issues with people changing database objects (such as stored procs) and thus breaking the front-end application. What I...

One "problem" with MSCS is that Microsoft will not support a "non-certified" configuration and that means that you're going to have to buy the vendor's "cluster package" if you want...

VERITAS Backup Exec sells an add-on product called "RAIDirector" which allows you to use multiple drives as a tape RAID array. You could try this to improve your througput.

I've never...