Yelena's method is straight forward and manageble.

Just keep in mind you'll have to rebind the views when altering database object in your base-db.

 I'd...

- collect sqlserver version info.

- use sp_helpdb to get a first impression of the db-settings that are in use.

- perform sp_updatestats / dbcc updateusage for all db that use "autoupdate...

do all tables have a clustering index ?

I guess not. So for this maintenance time, you may want to create one (for each table ! ). If you just pick...

Check out : http://www.sqlservercentral.com/columnists/chedgate/fragmentation101.asp

search SSC for "fragmentation"

It was the featured article in the daily newsletter of 2006/04/21.

That's why I tought I just might add a path towards sql2005

Anyway, nice...

looking good overhere.

Only thing is to plan the reboot ! (who wouldn't )

It is a "strange" thing that  it does not recognize it's own need for reboot (sql native client...

I'm not that much into reporting server, but you can also have this solved in your select query

SELECT CONVERT(char(11), MAX(src_date)) AS LatestMonth

, CONVERT(char(11), dateadd(mm,-1, MAX(src_date)))...

converting to soon.

SELECT CONVERT(char(11), MAX(src_date)) AS LatestMonth

FROM tbl_src_date

FYI

in SQL2005 you have DMV's (e.g. sys.dm_os_memory_clerks) to followup this kind of info.

e.g. clr-info : http://blogs.msdn.com/sqlclr/archive/2006/03/24/560154.aspx

-- this one works on SQL7 and SQL2000

You may have to run this script a number of times, because of the reasons I mentioned in previous the post.

-- Shrink_TrxLog.SQL

--INF: How to...

thanks for the feedback.

I have altered the IPAll port, and even enabled the instance's own ipaddress with another port, but connecting using the latter ipaddress/port did not work !

Connecting using the ipaddress/"IPAll-port" worked...

altering the IPAll port, will have only that port active for connections when working with fixed ports.

(just done a quick test)

you databasesize has been shrunk.

it will try to shrink to it's original size, unless specified other size.

there is a procedure (which may need to be executed  a number of times)...

I cannot see your screenshot, but here's how it works with an active/active cluster (x64).

I just testted it today.

SQL server configuration manager \...