Frank,

Your answers sound logical. But I need a little more clearification. Please see my original questions at the begining of this thread. I will appretiate your time.

1. I do not...

I was suspecting that storeage is always in integer multiple of byte. Even so, would it take CPU longer to test a bit field than testing a tinyint? (Performance issue)

Thanks a lot to Kathi and Vidas.

Now, I will try to do it using trigger and SP on our own.

Thanks a lot.

it works now.

I had to create the stored procedure from query analyzer, had GO statement after ANSI_NULLS ON and ANSI_WARNINGS ON but before create statement and I did not have GO keyword at the...

same error message.

I check in SQL server book online about ANSI settings. It says for all distributed query ANSI_NULLS and ASNI_WARNINGS must be set to ON. Default setting is OFF.

What...

Yes. All Lined servers are SQL server 2000 and tested works fine in distributed quiery enviornment, except that when try to pass parameter.

It gave me the following run time error. I also tried SET ANSI_NULLS ON, SET ANSI_WARNINGS On inside the stored procedure. Still it did not work.

Now the question is where...

Antatres686,

Why basic replication to several sql servers (in a single LAN) via broadcasting is not supported?

Is it because of

1) technical/logical impossibility OR

2) Technological difficulties OR

3) oversight in Microsoft's...

Antares686:

 I have another question.

Is it possible to update or replicate by means of broadcasting in sql server 2000? My servers are in the same LAN. Objective is to reduce the network...

Antares686:

I want to thank you for the excellent and quick response. I think, you are correct. I was already leaning toward what you wrote.

I guess problem with data bases is...

SQL server 2000 linked server problem

S2 is added in S1 as Linked server. I am trying to run SP1 in Server1 that in turn calls Sp2 in server2. there is...

In S1 I added s2 as linked server. There is no third machine involved.

I tried:

i) Mixed mode authentication

             Error: sql doesn't exist or accessd denied.

ii) Windows authentication.

     I checked (radio button) in Linked...