Great, thanks a lot for the link.

Steps:-

Change the Default Port to XXXX to the Default SQL Server Instance

Restart the Default SQL Server Instance

Change the Port to 1433 to the Named SQL Server Instance

Restart the Named SQL...

lax.rawat07 (11/10/2010)

---

i have a result set

LedgerId, ProfitAndLoss

46 -3000.00

49 -7000.00

45 ...

Jeetendra (11/10/2010)

---

Hi,

We have a Default SQL Server 2005 & several other named SQL Server Instances on the same box.

Now One of the application requires us to configure the SQL Named...

Microsoft Active/Active is purely 2 nodes acting as Active nodes and using each other as failover.

You will host different databases on each node.

Not the same as Oracle Active/Active...

make sense?

add a cleanup task and define your retention period.

http://lmgtfy.com/?q=.Net+to+SQL+connection+strings

select DATEDIFF(hour,'2010-10-08 23:59:59','2010-10-09 03:00:00')

??

Fair enough, but you only mention

...

confirm if...

check the account permissions...?

Get your application Vendor to provide support on their tables.

Vendors usually provide scripts to modify their own tables and structures, they should be able to assist.

do you have any indexes on ams_fin_link??

Map \\Sasi as a drive letter and use it as N'f:\Testing.txt', F being the drive letter or whatever you assigned.

Do you have any indexes on order by c.CATEGORY_NAME ?

http://tinyurl.com/3xazmvy