Tables are all contained in the .mdf file. You'll need to either export it to a different db so you can zip THAT .mdf, or export the data to a...

Wow. I am SO against XML in blobs! Until the tools progress some, it's just a royal pain to work with (Leon - come on, lets argue!).

How are you accessing...

Host_Name()? Or App_Name()?

Andy

Truncate is excellent if you want to remove ALL the data. One thing to remember - if you're using an identity column it will reset the seed!

Andy

Jody - not bad, staging tables are always handy, although depending on your data source I'd be concerned about the dropping the constraint part. I understand why you do it,...

Ana - have you tried running the same query in Query Analyzer, taken a look at the query plan?

Andy

You could do it with an insert trigger. You could either rollback any transaction that would cause the row limit to exceeded, or you could delete the oldest/inactive records to...

Is backing them up taking a lot of time? I avoid filegroups (just a personal preference) but if you can afford to back them up, why not? Another option would...

Basically - according to Inside SQL Server 2000, each data row has some version info as well (if you have it, try page 252). The amount of space this info...

Here is a starting point for you. See what you can do with this:

On Error Resume Next

Set oServer = New SQLDMO.SQLServer

With oServer

.LoginSecure = True

...

Did they give you a Q article on it? The problem only happens when you shrink - why would you need to? They don't have any kind of hotfix available?

Andy

...

One thing handy to have is a list of your SQL logins and the associated passwords. There's a puzzle for you!

Andy

Ran the following:

create table testtablesize (col1 varchar(8000), col2 varchar(60))

Generated this:

Warning: The table 'testtablesize' has been created but its maximum row size (8085) exceeds the maximum number of bytes per row...

I have not seen this. What version of SQL? What service pack? Setting auto shrink to off is a good idea anyway.

Andy

Yes, I'd expect performance to be the same or better. It is SO worth upgrading. Just be done with junk like devices is worth the move.

Andy