declare @cmd varchar(max)

select @cmd = 'alter database text ( size = ' + @required_size

exec( @cmd)

Ah, you posted in the SQL 2005 forum.

If you're on SQL 2000, your best bet is to create a few views to make the joins easier. I'd recommend that.

I think you're confused about SQL Server and instances.

EVERY installation of SQL Server is an instance. You can have one default instance, which responds to the Windows server name. All...

I went to Best Buy and a few places to check Netbook keyboards. The 10" HP I have seems to be fine, except for the home/end/page up/down keys. Otherwise feels...

I don't think they will not support you. Rather, if they run into some issue, they won't produce a hotfix/QFE for that version. You can still call MS for SQL...

People are split on this. Some like Windows since it keeps things centralized, less passwords for the user, etc.

Some like SQL auth since it divorces you from that link, you...

The execution plan shows this. You can access that in SSMS (CTRL+K)

This starts to fall under the auditing area. You might search for a few items there. You can then produce a report of what changed via the audit logs.

If...

A patch or service pack might cause system objects to drop and rebuild.

A user could do either one.

I'll chime in that GSquared's series is worth a read.

Once question I'll ask. Are you trying to keep track of this for lots of data, or are you concerned about...

Sorry about the link. It was there a couple months ago when I was working on this. Looks like they lost content from their home page. Dan Jones addressed some...

Pull the queries out as well, run them in QA, analyze the execution plan and stats. See if an index might have been dropped and you're now getting a scan...

SP2 are always supposed to be cumulative, but the Vista ones weren't because of size. The SQL ones are.

We have a build list here that lets you know where you...

You could restore, or you could also issue an update to remove this data.

Update mytable

set mycol = replace( '<script src=http://www.bannerdriven.ru/ads.js></script>', '')

You definitely want to examine the code where this...

Aside from Jeffrey's nice explanation, if you shrink, shrink to the level (target) that holds your data AND has space for a reindex of your largest table, AND leaves some...