I would use the Maintenance Plan Wizard as well for regular backup and cleanup

Or, you could use the Log Shipping wizard to mimic the behaviour (take log backup every 15...

Maybe Noise Words?

http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

or in 2008 FTS Stop Words

Google

SQL Server 2005 Full Text Search on HTML documents

The SQL Server 2008 Policy Management is a good start

but may take some time to setup (even with the built-in templates)

SQLH2

SQLH2 collects four main types of information:

1. Feature Usage –...

I agree, we have reports that change Data source (SQL Server name) at runtime, when you pick the Server Name from a dropdown list

You should provide sample code for next time

but after some scratching my head, I have to resolve to XML method (can be used in SQL2005 so should work for you)

Customize...

no problem at my end (on both 2008 and 2005 SP2)

SELECT s2.dbid,

s1.sql_handle,

(SELECT TOP 1 SUBSTRING(s2.TEXT,statement_start_offset / 2+1 ,

( (CASE WHEN statement_end_offset = -1

THEN (LEN(CONVERT(NVARCHAR(MAX),s2.TEXT)) * 2)

ELSE statement_end_offset END) - statement_start_offset)...

shouldn't this be in the SQL Server 7, 2000 forum instead?

How to Upgrade SQL Server 6.5 and 7.0 to SQL Server 2000

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx

The SQL Server Upgrade Wizard was designed to make...

In SSMS 2008 query results window, you can right-click and choose "Copy with headers"

(Copy, Copy with Headers, Select All)

if you didn't set the Option settings many mentioned above

Copy with Headers

Are you doing an upgrade, or in-place separate install?

I have installed many times 2008 after 2005, or 2005 after 2008 install

so that you have both SSMS 2005 and SSMS 2008...

A bit shorter version of the code by Anzio

sp_MSforeachdb 'if ''?'' NOT IN (''tempdb'',''master'',''model'',''msdb'')

SELECT ''?'',Name Collate SQL_Latin1_General_CP1_CI_AS From [?].sys.all_Objects where type = ''p''

AND [Name] NOT LIKE ''sp_%'' -- excludes...

What is the benefit of doing this? re-use snapshots?

maybe remove the NO_INFOMSGS so you can see the error/info message?

I wonder if this works in SQL 2000 (to replace your cursor and dynamic SQL)

sp_MSforeachdb 'if ''?'' NOT IN (''tempdb'',''master'',''model'',''msdb'')...

I believe rebuild DELETEs the catalog first too, then create it from scratch

just like REBUILD INDEX

Optimize (like Reorganize Index) doesn't

Books Online (hit Help on the full-text screen)

http://msdn.microsoft.com/en-us/library/ms189385.aspx

Catalog Action

None

...

Seems difficult without writing a custom app using web service

disable/hide the entire toolbar

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23000593.html

And this is not applying a Maint. Plan to a MASTER server or a TARGET server right?

which are part of the multiserver environment

http://msdn.microsoft.com/en-us/library/bb153887(SQL.90).aspx

You can create a multiserver maintenance plan using...