In order to add components to an exisiting installation go open add/remove software in control panel. When select SQL Server 2005 and the installion wizard will start. It will ask...

It would help a lot if you would post the exact error you got before.

Without that it we are guessing.

Antonio,

while I agree it's not 100% safe to rely on db_id, the problem with you're attempt is that it will only...

Not sure what exactly you want but I usually use WHERE database_id > 4.

If you want to execute a query on all user databases you can use this:

EXEC master..sp_MSForeachdb 'USE...

There are several solutions, but I think the main question is how do you authenticate in your datasource? Do you use Windows authentification, then your users...

Did you read about sp_send_dbmail in BOL?

You can adjust the merge agent profile for slow connections. For example selecting a smaller batch size or higher timeout values. If I remember right there's also a build in...

No, a replication snapshot is totally different from a database snapshot. Basically what applying the snapshot means is that all objects which are part of your publication are (re)created in...

The list of reports is stored in a XML file which you can find under

C:\Documents and Settings\UserName\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\Reports.xml

These are orphaned sessions and you should kill them. Unfortunately you can't kill them the easy way by running Kill -2 ,but you need to find the Unit of Work...

You can upgrade you're existing cluster as long as you use Enterprise edition of SQL2005. Microsoft has a very detailed whitepaper about upgrading in all kind of scenarios. Check it...

In SQL 2000 maintenance plans the backup is taken first and then the old files are dteleted. You cannot change this behaviour within SQL 2000 maintenance plan, you need to...

In a SQL 2005 maintenance plan you can define the removal of old backups as a separate task. If you want to remove your old backup files before creating a...

If it's in a stored procedure you could use the EXECUTE AS option to run the procedure in the security context of anther login. I'm not sure it will work...

You have to use CASE to achieve this.

Something like this

create table t1(c1 int Identity(1,1),

c2 datetime,

c3 datetime)

go

Insert into t1(c2,c3)

Select Getdate()-3, Getdate()-5

Union all

Select Getdate()-3, Getdate()-2

go

select c1,

Case

When c2 > c3 THEN...