I would use the link above. I don't have a procedure I've used. You can also search for FineBuild on Codeplex. Ed Vassie has built a great utility for slipping...

Yes, sorry, was providing the idea there.

The code should look like:

declare @cmd varchar(max)

select @cmd = 'alter database test modify file ( size = ' + @required_size + ' MB)'

exec(...

I've had good and bad experiences with Microsoft. By and large, however, I think that most of their software works well when it is released. There are bugs, but it's...

DRP is typically disaster recovery plan. Be ready in case you create your own disaster. Know what exact build number you have, and you may want to script out jobs/alerts/packages...

Make sure you have good backups.

The data files and log files will get attached to the new instance when it's upgraded, and they'll be migrated to the new formats as...

Thanks for the update and resolution.

Separate backup file for each backup.

The maintenance plans have a maintenance cleanup that does this well. We used to script something, but the maint plan item does it better. You...

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...