Why I like the site: it's made by people that care not only about technological issues.

The fact that calls for help on non-technological issues have a place also adds...

Hello Ellis,

thanks for the answer.

I tried again to run the service pack, and this time I could choose the named instance.

I think the service pack was installed BEFORE the named...

Hello Peter,

Here is the create table statement:

CREATE TABLE [dbo].[tblFamily](

[ChildID] [int] IDENTITY(1,1) NOT NULL

,[ParentID] [int] NOT NULL CONSTRAINT [DF_tblFamily_ParentID] DEFAULT ((0))

,[Name] [varchar](255) NOT NULL

,CONSTRAINT [PK_tblFamiliy] PRIMARY KEY CLUSTERED ([ChildID] ASC)

WITH...

I saw that the layout of the output list was not preserved; what I mean is:

-Parent1

---Child1

------Child2

---Child3

------Child4

Hans

Yes,

executing the stored procedure from asp and taking the resultset is the way to go.

But is there any easy way to preserve the order in which the stored procedure...

Thanks for the reply homebrew; I feel more confident now to do the upgrade.

regards,

Hans

Hello Michael,

We have a couple of hardware servers on which we run Vmware ESX.

These servers host a couple of vmware guests; those guests have SQL2005 installed.

I can connect to...

BTW: in the error log the ipv4 shows up; as I just did a copy/paste it did not show in the previous post (because of the brackets it is...

Yelena,

I tried the telnet; in both cases I get a blank screen, and a blinking cursor. When I type and press enter, no reply.

The part of the log you mentioned...

Hello Yelena,

I was not aware of the need for that.

Following your advice I created an alias on my client machine, pointing to the server that I want to access, via...

Thank you for the reply Yelena.

I used Configuration Manager to enable Named Pies, and restarted the service, but it did not help.

I checked the Application log on the server, and...

Thank you for the help Trigger,

we will have another look to see how we can get around this issue, indeed perhaps choosing for another solution to copy the data.

regards,

Hans

One issue is that the referential integrity of the database on the publisher is arranged via code (originally, the application used a propriety database; only later it has been...

The situation is as follows:

We have a database (database A) with about thousand tables (it is a financial database).

We are developing an application that uses five tables out of these...

Trigger,

The option would be used for the foreign keys. But the thing is: there are no referential integrity relationships set on the published tables, while the subscriber tables would have...