Sorry for the late response, Thank you very much. I will use the blow fish implementation.

c++ is bad. But good at c#

Thank you for all the information...I think I need to use the extended proc

hey thansk for the replies

It worked for us

Hurry it was 75 gb of data

Thanks a lot

Hi Karl,

Does this mean we Alter the database giving a new Transaction file path.

Will this allow us to move the Old transaction log file

thanks , Sorry for the delay in reply.

I have got the exact solution from sqlserver performance.

Thanks for Your all great efforts

Sorry a bit mistake total number of records are 60,000.

Thanks a lot both the queries are of great help

Hi,

The query looks good and fantastic but i m not able to understand this query,let me know where i can pass the user name of the database.

Hey guys i have a solution for the above problem

There is a utility called as Client Network Utility

Go to Run->cliconfg.exe

In the cliconfg.exe there is an Alias Tab where

In...

Hey guys i have a solution for the above problem

There is a utility called as Client Network Utility

Go to Run->cliconfg.exe

In the cliconfg.exe there is an Alias Tab where

In...

Hey guys i have a solution for the above problem

There is a utility called as Client Network Utility

Go to Run->cliconfg.exe

In the cliconfg.exe there is an Alias Tab where

In...

Let me check this ...

Both the servers have same MDAC Level.

All the servers are same SQL Server 2000

Service pack is also same ,

This is an exising project and they are using the connection string...

This works !

with back slash \\

thanks