Thanks all for the reply. I will mostly likely end up un-installing the default instance since no other application is using it at the moment.

I have one more question...

Thanks for your reply Kenneth.

Yes, named instance is running on the same local machine and both named and default instance are running.

How can we set up to run the...

The connection string is below

connectionString="Database= ;Server=.\SQLHES;Integrated Security=SSPI;"

providerName="System.Data.SqlClient

We never have any issue when we were using default instance with the same connection string (Server =...

%DATABASEFOLDER% is pointing the original location (C:\My Documents\Databases)

All the application databases are residing in C:\My Documents\Databases folder. Below is how I am de-attaching one of the database: (%STRING% has a value "C:\My Documents\Databases")

SET DATABASEFOLDER=%STRING%

SET DATABASETEMP=%DATABASEFOLDER%

"C:\Program Files\Microsoft SQL...

When we install a new instance (SQLHES), it should have all system databases available include Master right??

Below is my script:

@echo off

REM - Set the DATAABSETEMP variable to the

SET DATABASEFOLDER=C:\My Documents\TIMS\Databases

SET DATABASETEMP=%DATABASEFOLDER%

echo Restoring EZSalesOrder Database

echo Restoring EZSalesOrder Database >> ezso_db_restore_output.txt

"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\osql" -E -Q -S...

Greg,

That is exactly I am trying to do. Below is my sample script:

@echo off

REM - Set the DATAABSETEMP variable to the

SET DATABASEFOLDER=C:\My Documents\TIMS\Databases

SET DATABASETEMP=%DATABASEFOLDER%

echo Restoring EZSalesOrder Database

echo Restoring EZSalesOrder...

I want to do it inside T-SQL script and then this script will run on user's machine. We have various users uses the application and every user have its own...

Thanks for your quick reply Prasad.

How can I connect to Named instance using T-SQL. Is there any parameter I will have to use inside T-SQL that will connect SQL...

Thansk for your reply Greg. Yes, Data.DAT is a SQL back up file. Acutally, I used to have only default instance but due to business requirement, I will be creating...

Thanks guys for all your help. Your help is greatly appreciated!!!

Regards,

Syed

Thanks Lynn for your reply. Yep, that is something happening because of the dd/mm/yyyy in UK. I tried earlier to change the variable to yyyy-mm-dd but I couldn’t do it. There...