I know when I have added reporting services to 2005 I have patched again and the patch knows to update reporting services only, but fulltext is installed as a service...

What version of SQL are you using, I have noticed that on 2005 maintenance plans the backup will run without error but will not backup db's set to lower compatability?

Open up the toolbox in the left side of the data flow tab, there you can locate the data conversion tool from the data flow transformations section, drag this to...

Check this series of articles out, he shows how to dynamically connect to N number of servers, you simple populate a servername table to be used by an ADO connection...

You need to use the data conversion in ssis.

Both of the ten minute books are good as well as the old 24 hr books. For a good understanding of the SQL language and plenty of practical excersizes check...

Maybe there is not a way to stop the restore, but for auditing purposes it would be better that you where alerted if and when this happens, you could collect...

You can have a job that polls the sysdatabases table on whatever box you are interested, pop this into a table and the next time you poll see if there...

I am assuming you are looking for running jobs, I use

execute master.dbo.xp_sqlagent_enum_jobs 1,

'garbage'...

Sometimes the logs get very large and MS just times out, don't know if this is your issue, but either way I prefer to use a script to get the...

I had this setup for a few procs in SQL 2000 and just moved these over to 2005 when upgrading, but the procs where not firing on start up, I...

Give it a reboot, can't hurt.

Was the lock pages in memory set on both nodes? I have set this up on many VERITAS clusters and have followed http://www.sqlservercentral.com/articles/Administering/aweadventures/960/ to do the steps, just...

You can use execute master.dbo.xp_sqlagent_enum_jobs 1,

'garbage' -- doesn't seem to matter what...

Where are the system databases on this cluster, are they on a shared drive that both sets of SQL services are set to use, or are they residing locally. I...