Brian

Yes the following messages were found in SQL Server Event Log

1. Server is listening on [ 'any' <ipv4> 1433].

2. Server local connection provider is ready to accept connection...

Brian

Yes I restarted the SQL Server as well as restarted the server.

How can I check whether it is bind to various libraries ?

Sathish

Create the above as a UDF to make your life easy

Sathish

Thanks Joseph & Mark

This will really help me to proceed further.

Joel

I am running on  MDAC 2.8 SP1 on Windows XP SP2

The ASP.Net Applicaion and the Database are hosted on different servers inside my intranet. The servers reside in our US office, and I am trying to access the DB from...

Hi

Try this suggestion. Maintain the additional views and tables in a seperate DB and access the data like dbname.user.table / views. Since you were accessing the data in the restored...

Its working. Thanks a lot David.

But I can't understand the functinality of this Script, can u pls explain me.

Sathish

Simple solution, use undocumented SP sp_MSforeachtable

Example: EXEC sp_MSforeachtable "Delete from ?"

Where '?' is the place holder for the table name

Try this ...

SELECT

 t1.id,

 t1.name [Child],

 t2.name [Parent]

FROM

 category t1,

 category t2

WHERE

 t1.parentid = t2.id

Sathish

Hi Phill

Sorry. The "parameters and other details" i mention is the Access Db path and the SQL Server DB name. Since I will deploy this tool in various locations, i...

Hi guys

Thanks a lot for ur efforts. This is what exactly I needed.

Sathish

Hi Chris Moix,

Thanks a lot. I got the script.

Sathish ...