Thanks for reply,

Certificate and master key already created on the server.

We have around 150 user dbs on server.In that 50 dbs are need to be encrypted,i want a script so...

Thanks for reply,

1)I am doing side by side upgradtion.I request you to clarify whether i need to run the upgrade advisor tool on the Source server ( i am not...

Thanks for reply,

1) i will ensure that we have good backups before starting the change.

2)can you clarify whether we need to take entire SQL group OFFLINE or only sql services...

Can any one reply this...plz

THanks for reply,

update stastics has been updated upto date.

i have checked fragmentation and are fine...

Can you tell me how to find the missing indexes for high usage tables....

THanks you so much for helping me with the Query...

we want to delete the duplcate record from a table (DAT_DES--which i mentinon above).

Can you please help me how to wright...

Hi Richard Warr,

Thanks Fo reply,

Can you please help me how to wright that Query using Merge........

Many Thanks...............

There are no duplicate values in the staging table ....

SSIS job is created in such a way that after inserting the Values to DAT_DES form DAT_STAGE we will delete the...

we have an ssis packa created in such a way that

Data will loaded into the DAT_STAGE from Flat file and then we need to insert that values from Dat_stage to...

i Have just uninstalled sql server through Add\remove program...

and after i have observered that ..

sql services(cluadmin-SQL GRoup-services(sqlip adress(online),sql network name-offline,sql server-online) are still existing on cluadmin....

I have not tried...

Thanks for reply,

I have installed Sql server 2005 and

i could not find this option "Remove Node from a SQL Server Failover Cluster" Using the SQL Installation media.

Hi,

Many thanks for reply,

I have used this command

select REPLACE(LTRIM(REPLACE(A_H, 'D', ' ')), ' ', ' ') from tableA

It is working .But is displaying space before the numric.

IS ther any...

Tabe-A

A-d-int,pk,notnull

A_H--nvarchar(10),null

A_dn-navrchar

A-S-int,null

A_c-date(smalldatetime,null

Table-B,

B_d --int(PK,not null)

B_H---int,notnull,

B_Dn---nvarchar(14),notnull)

B_c_date--(smalldatetime,null)

B-si--(int,null)

B_DT--(smalldatetime,null)

when we are using the below insert into query we are got the error as "Msg 245, Level 16, State 1, Line 1

Conversion failed when converting the nvarchar...

Your problem basically is that you have some values in your column that can be converted to integers. You need to get rid of those before you attempt to write...

Many Thanks for reply,

I have tried using a Derived Column transformation between Flatfie and destination components?

IN derived column i hvae added the a row with a command similar to: (DT_I4)[Column...