Hello,

You can install SQL 2005 without un-installing SQL 2000 but you need to install SQL 2005 as a named instance.

Hope this helps.

Hello Vamsi,

It would be better if you study the information provided in Books Online

Clustured indexes, architecture

nonclustered indexes, architecture

Thanks

Hello Miller,

The compatibility level for 2K5 is 9 and not 7. Please check the compatibility level of other databases which were showing up in the maintenance plan.

Thanks

Hello Thomas,

I haven't seen any problem in viewing any of the presentations. I have been to the site "n" number of times logging in from different machines.

Might be a problem...

Hello Venkat,

You can go ahead with the following steps:

1. First create a user

2. Now, create a role and see that the user created in step 1 is a part of this role.

3....

Hello Nali,

You can save it as a .dts file and copy it over to the destination server. First right mouse click on the DTS designer window and select save as...

Hello Tim,

Do you mean 2 SQL instances on each of the cluster nodes?

If so, can you check for the physical files of each instance "msdb" database on the second node...

Hello Hans,

Can you check this query:

select

* from sys.systypes where uid !=...

Hi Steve,

As you said in your post, you need to select "schedule" option in the DTS and select the time for execution of your package. It will automatically create a...

Hello Ninel,

You can query the system table "sysdatabases".

Thanks

Hello,

Can you post the table structures which you are using in your query? It might give an insight for anybody to help you out.

Thanks

Hello,

Do you mean that the multi-valued parameter is a varchar with a comma(,) delimited values? if so, then you can go ahead as

@parameter1 datetime = '', @parameter2 datetime =...

Hello,

Where is the "From" clause in your query???

Thanks

Hello,

Try this one

update hdtd

 set hdtd.TechnicalDescription = stg.TechnicalDescription

 from stg_HelpDetailsTechDesc stg,

  HelpDetailsTechDesc hdtd

 Left join HelpDetails hd on stg.EventName = hd.title

 where hd.HelpDetailsID = hdtd.HelpDetailsID and

  hd.HelpTypeID = hdtd.HelpTypeID and

  hd.HelpTypeID = 1

Thanks

Hello,

Click on "Execute SQL Task" icon and place it on the designer window in DTS. Here you need to have the existing connection selected and give the required SQL statement...