Cluster solution certification

Hi All,
We are currently working on setting up a 2-Node cluster using SQL Server
2005.
Hardware :
HP Blade servers : BL 460c (c7000 enclosure)
SAN from Compellent Technologies
Fiber channel network.
OS : Windows Server 2003.
My understanding is that this cluster solution (as a whole not individual
components)needs to be certified by Microsoft in order to get support from
them in the future.
I checked the microsoft site www.windowsservercatalog.com but couldn;t find
the entire system as a whole for the above combination. There were other
combinations of SAN from Compellent and Proliant servers from HP.
I spoke to Compellent, and they directed me to the "wondowsservercatalog"
site.
I'm trying to get hold of someone from HP who can help me with this ,so far
no success.
Does anyone of you use the above platform for Clustering without any issues.
If so, for how long?
I appreciate your input.
SJ
Blade cluster = Low Availability Cluster, regardless of the certification.
Blades share too many critical components (Power Supplies, inbuilt network
switches, etc.) for me to count them as truly redundant solutions. Some
blade systems are less "interdependent" than others, but when you are trying
for both hardware redundancy (Clustering) AND lower cost through combined
hardware (blade platform), something has to give.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"SJ" <SJ@.discussions.microsoft.com> wrote in message
news:C314632E-B342-45E7-86F8-CB0F8F1DD230@.microsoft.com...
> Hi All,
> We are currently working on setting up a 2-Node cluster using SQL Server
> 2005.
> Hardware :
> HP Blade servers : BL 460c (c7000 enclosure)
> SAN from Compellent Technologies
> Fiber channel network.
> OS : Windows Server 2003.
> My understanding is that this cluster solution (as a whole not individual
> components)needs to be certified by Microsoft in order to get support from
> them in the future.
> I checked the microsoft site www.windowsservercatalog.com but couldn;t
> find
> the entire system as a whole for the above combination. There were other
> combinations of SAN from Compellent and Proliant servers from HP.
> I spoke to Compellent, and they directed me to the "wondowsservercatalog"
> site.
> I'm trying to get hold of someone from HP who can help me with this ,so
> far
> no success.
> Does anyone of you use the above platform for Clustering without any
> issues.
> If so, for how long?
> I appreciate your input.
>
> --
> SJ

Cluster and Mirroring with 2005

I am looking for some advice on the following problem.
I need a redundant SQL solution at our main location and a warm site in
a different, off site location. The warm site would only become a hot
site if we had a complete failure at the main location.
What I was thinking was to create a failover cluster at our main
location incase of simple hardware failure, the other server could take
over. At the warm site I would have a witness server and have the
database mirrored to a sql server there. I am going to be using sql
server 2005.
Is this a possible solution? If not, can you please point me in the
right direction. $$$ is not really an issue.
That is certainly a possible scenario. Remember that mirroring works at the
database level, not at the server level. You will have to do some
customization if you want to make it work for multiple databases. There are
also performance, latency, and network bandwidth costs for mirroring. The
lower your tolerance for data loss and outage time, the higher those costs.
If money really isn't an issue, you may want to look at SAN-level data
replication technologies. Since you will have a SAN for the cluster anyway,
this may be a better option. Make sure the SAN vendor can keep multiple
LUNS in synch or you may end up with mismatched data and log partitions,
causing a corrupt and unusable database.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<dwclark@.gmail.com> wrote in message
news:1130250702.646778.85520@.g47g2000cwa.googlegro ups.com...
>I am looking for some advice on the following problem.
> I need a redundant SQL solution at our main location and a warm site in
> a different, off site location. The warm site would only become a hot
> site if we had a complete failure at the main location.
> What I was thinking was to create a failover cluster at our main
> location incase of simple hardware failure, the other server could take
> over. At the warm site I would have a witness server and have the
> database mirrored to a sql server there. I am going to be using sql
> server 2005.
> Is this a possible solution? If not, can you please point me in the
> right direction. $$$ is not really an issue.
>
|||I noticed that you said 'warm site'. By 'warm', I assume you can afford
losing some data during a site failover. If you can afford data loss of up
to 15 minutes or so, the plain old log shipping may be the simplest and
cheapest solution to consider. I'd keep it simple if a simple solution is
enough.
Linchi
<dwclark@.gmail.com> wrote in message
news:1130250702.646778.85520@.g47g2000cwa.googlegro ups.com...
>I am looking for some advice on the following problem.
> I need a redundant SQL solution at our main location and a warm site in
> a different, off site location. The warm site would only become a hot
> site if we had a complete failure at the main location.
> What I was thinking was to create a failover cluster at our main
> location incase of simple hardware failure, the other server could take
> over. At the warm site I would have a witness server and have the
> database mirrored to a sql server there. I am going to be using sql
> server 2005.
> Is this a possible solution? If not, can you please point me in the
> right direction. $$$ is not really an issue.
>
|||Database mirroring is certainly an option, but so would be log shipping,
remote mirroring, or stretch clustering.
You might want to check out the following. Although for SS2K, most of the
information still applies, with the exception of DB mirroring.
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
SQL Server 2000 High Availability Series
Implementing Remote Mirroring and Stretch Clustering
http://www.microsoft.com/technet/pro...y/hasog05.mspx
SQL Server 2005 Mission Critical High Availability
http://www.microsoft.com/technet/pro...s/default.mspx
Sincerely,
Anthony Thomas

<dwclark@.gmail.com> wrote in message
news:1130250702.646778.85520@.g47g2000cwa.googlegro ups.com...
> I am looking for some advice on the following problem.
> I need a redundant SQL solution at our main location and a warm site in
> a different, off site location. The warm site would only become a hot
> site if we had a complete failure at the main location.
> What I was thinking was to create a failover cluster at our main
> location incase of simple hardware failure, the other server could take
> over. At the warm site I would have a witness server and have the
> database mirrored to a sql server there. I am going to be using sql
> server 2005.
> Is this a possible solution? If not, can you please point me in the
> right direction. $$$ is not really an issue.
>

closer, but not quite

Hello, thank you Raymond and Paul, please bear with me a little longer:
It really seems like running sp_addscriptexec is the solution for me,
Thank you again.
So I have run:
exec sp_addscriptexec 'myPublication'
, '\\myDataBase\shared\udt_script.sql'
, 0
I know that myPublication is correct because this database only
contains one publication, and if I type in garbage it gives me the
following error:
"Failed to retrieve information about the publication : garbage. Check
the name again."
udt_script.sql contains repeats of user types I am trying to define.
Maybe the problem is there? I wrote:
CREATE TYPE u_members
FROM varchar(30) NULL
CREATE TYPE u_fees
FROM decimal(9,2) NULL
and the list is then saved as .sql
If I have to create the assembly and then register the assembly as per
instructions here
(http://msdn2.microsoft.com/en-us/library/ms131120.aspx) then I am in a
world of trouble, unless anyone can point me towards a step by step
instructions on how to do that. I know C# and VB.net, but have never
written assemblies before, let alone one in the correct format for this
purpose.
After that has run successfully I went to Replication Monitor -->
myDatabase --> myPublication and started the snapshot agent, which went
fine.
And then I attempted to Start Synchronizing the subscription agents,
and the agent failed with the message "cannot find data type u_members"
again
At this point I am thinking that the script file is written
incorrectly. Can anyone give me an example of how it should look like
when i'm trying to create user defined data types in that script file?
Any more help with regards to what to try next would be greatly
appreciated, Thank you very much
-Dorothy Yip
Is this a merge or transactional publication? I would be a bit surprise if
this happens for transactional publication (would be great if you can post
the snapshot history output) although I don't know exactly what will happen
for merge. Just to resolve the issue at hand, you should simply run the UDT
script directly against the subscriber database using sqlcmd.exe or SSMS.
-Raymond
"DorothyY" <dorothyy@.eyi.us> wrote in message
news:1159388445.536683.237310@.e3g2000cwe.googlegro ups.com...
> Hello, thank you Raymond and Paul, please bear with me a little longer:
> It really seems like running sp_addscriptexec is the solution for me,
> Thank you again.
> So I have run:
> exec sp_addscriptexec 'myPublication'
> , '\\myDataBase\shared\udt_script.sql'
> , 0
> I know that myPublication is correct because this database only
> contains one publication, and if I type in garbage it gives me the
> following error:
> "Failed to retrieve information about the publication : garbage. Check
> the name again."
> udt_script.sql contains repeats of user types I am trying to define.
> Maybe the problem is there? I wrote:
> CREATE TYPE u_members
> FROM varchar(30) NULL
> CREATE TYPE u_fees
> FROM decimal(9,2) NULL
> and the list is then saved as .sql
> If I have to create the assembly and then register the assembly as per
> instructions here
> (http://msdn2.microsoft.com/en-us/library/ms131120.aspx) then I am in a
> world of trouble, unless anyone can point me towards a step by step
> instructions on how to do that. I know C# and VB.net, but have never
> written assemblies before, let alone one in the correct format for this
> purpose.
> After that has run successfully I went to Replication Monitor -->
> myDatabase --> myPublication and started the snapshot agent, which went
> fine.
> And then I attempted to Start Synchronizing the subscription agents,
> and the agent failed with the message "cannot find data type u_members"
> again
> At this point I am thinking that the script file is written
> incorrectly. Can anyone give me an example of how it should look like
> when i'm trying to create user defined data types in that script file?
>
> Any more help with regards to what to try next would be greatly
> appreciated, Thank you very much
> -Dorothy Yip
>
|||Hello,
this is a transactional publication. The snapshot history output looks
normal, (and I can't find a way to copy/paste the history details)
Could you please give me more details regarding your suggestion?
How do I run the script against the subscriber database? would I have
to connect to their database through query analyzer, and if so I'm not
sure how. Because the subscription database is located in a different
country (we are in canada ie:not directly on the same network) and any
suggestions on how to connect to the other guys would be nice...
would it work if I ask the subscription company to run the script's
text in their sql query analyzer directly? (if I understand correctly
asking them to run sp_addscriptexec like I did would put the script
onto their publication which isn't going to solve the problem for them,
right?)
I don't think we have Sql Server Management Studio here, unless I am
mistaken about what SSMS is.
Thanks for the speedy reply, Raymond, much appreciated (and sorry about
starting a new thread -- somehow posting reply to the other one messed
up and viola, new thread.)
-dorothy
Raymond Mak [MSFT] wrote:[vbcol=seagreen]
> Is this a merge or transactional publication? I would be a bit surprise if
> this happens for transactional publication (would be great if you can post
> the snapshot history output) although I don't know exactly what will happen
> for merge. Just to resolve the issue at hand, you should simply run the UDT
> script directly against the subscriber database using sqlcmd.exe or SSMS.
> -Raymond
> "DorothyY" <dorothyy@.eyi.us> wrote in message
> news:1159388445.536683.237310@.e3g2000cwe.googlegro ups.com...
|||This sounds really strange (bug?), I am actually looking for hints in the
snapshot agent history as to whether the user defined data type was included
with the snapshot. Is this a pure SQL2005 environment
(publisher\distributor\subscriber)? As for creating the type manually, you
should ask the subcribing company to create it for if you cannot do it
directly using any query tool of your choice (Query Analyzer, SQL Server
Management Studio, osql.exe, or sqlcmd.exe).
-Raymond
"DorothyY" <dorothyy@.eyi.us> wrote in message
news:1159456819.811473.262010@.d34g2000cwd.googlegr oups.com...
> Hello,
> this is a transactional publication. The snapshot history output looks
> normal, (and I can't find a way to copy/paste the history details)
> Could you please give me more details regarding your suggestion?
> How do I run the script against the subscriber database? would I have
> to connect to their database through query analyzer, and if so I'm not
> sure how. Because the subscription database is located in a different
> country (we are in canada ie:not directly on the same network) and any
> suggestions on how to connect to the other guys would be nice...
> would it work if I ask the subscription company to run the script's
> text in their sql query analyzer directly? (if I understand correctly
> asking them to run sp_addscriptexec like I did would put the script
> onto their publication which isn't going to solve the problem for them,
> right?)
> I don't think we have Sql Server Management Studio here, unless I am
> mistaken about what SSMS is.
> Thanks for the speedy reply, Raymond, much appreciated (and sorry about
> starting a new thread -- somehow posting reply to the other one messed
> up and viola, new thread.)
> -dorothy
>
>
> Raymond Mak [MSFT] wrote:
>
|||Hello,
yes this is a transactional publication. The snapshot seems to be
running fine, and I haven't found a way to effectively capture the
output yet, but I could do that if running the UDT script on their
database doesn't work. Which bring me to my question,
could you please go into a little more detail on how I can run the
script on their end? They are located in the States and we are here in
Canada. (ie: not on the same network that Query Analyzer can connect
to) If I ask them to run the script's text directly in SQL Query
Analyzer to add the UDTs would that be just as good? I don't think I
can ask them to run to run sp_addscriptexec because that'll just add
script to their publication, which isnt what we are trying to do I
guess.
As for using sqlcmd.exe or SSMS, I don't think we have SqlServer
Management Studio, and I don't know how to use sqlcmd.exe. Hopefully
we won't have to do and that asking them to run the script will do
it...
Thank you again,
Dorothy
Raymond Mak [MSFT] wrote:[vbcol=seagreen]
> Is this a merge or transactional publication? I would be a bit surprise if
> this happens for transactional publication (would be great if you can post
> the snapshot history output) although I don't know exactly what will happen
> for merge. Just to resolve the issue at hand, you should simply run the UDT
> script directly against the subscriber database using sqlcmd.exe or SSMS.
> -Raymond
> "DorothyY" <dorothyy@.eyi.us> wrote in message
> news:1159388445.536683.237310@.e3g2000cwe.googlegro ups.com...
|||Hello,
yes this is a transactional publication. The snapshot seems to be
running fine, and I haven't found a way to effectively capture the
output yet, but I could do that if running the UDT script on their
database doesn't work. Which bring me to my question,
could you please go into a little more detail on how I can run the
script on their end? They are located in the States and we are here in
Canada. (ie: not on the same network that Query Analyzer can connect
to) If I ask them to run the script's text directly in SQL Query
Analyzer to add the UDTs would that be just as good? I don't think I
can ask them to run to run sp_addscriptexec because that'll just add
script to their publication, which isnt what we are trying to do I
guess.
As for using sqlcmd.exe or SSMS, I don't think we have SqlServer
Management Studio, and I don't know how to use sqlcmd.exe. Hopefully
we won't have to do and that asking them to run the script will do
it...
Thank you again,
Dorothy
Raymond Mak [MSFT] wrote:[vbcol=seagreen]
> Is this a merge or transactional publication? I would be a bit surprise if
> this happens for transactional publication (would be great if you can post
> the snapshot history output) although I don't know exactly what will happen
> for merge. Just to resolve the issue at hand, you should simply run the UDT
> script directly against the subscriber database using sqlcmd.exe or SSMS.
> -Raymond
> "DorothyY" <dorothyy@.eyi.us> wrote in message
> news:1159388445.536683.237310@.e3g2000cwe.googlegro ups.com...
|||Asking them to run the script in SQL in Query Analyzer should work just fine
although I am curious how you folks managed to get replication without some
kind of connection going. In fact, it would be great if you can confirm
whether the subcriber is using pull subscription on a SQL2000 server
(otherwise things don't make much sense to me at the moment).
-Raymond
"DorothyY" <dorothyy@.eyi.us> wrote in message
news:1159473908.516526.219320@.i3g2000cwc.googlegro ups.com...
> Hello,
> yes this is a transactional publication. The snapshot seems to be
> running fine, and I haven't found a way to effectively capture the
> output yet, but I could do that if running the UDT script on their
> database doesn't work. Which bring me to my question,
> could you please go into a little more detail on how I can run the
> script on their end? They are located in the States and we are here in
> Canada. (ie: not on the same network that Query Analyzer can connect
> to) If I ask them to run the script's text directly in SQL Query
> Analyzer to add the UDTs would that be just as good? I don't think I
> can ask them to run to run sp_addscriptexec because that'll just add
> script to their publication, which isnt what we are trying to do I
> guess.
> As for using sqlcmd.exe or SSMS, I don't think we have SqlServer
> Management Studio, and I don't know how to use sqlcmd.exe. Hopefully
> we won't have to do and that asking them to run the script will do
> it...
> Thank you again,
> Dorothy
> Raymond Mak [MSFT] wrote:
>
|||Hello,
sorry abou the triple posting before, apparently google groups was
having a bit of problems.
And I am completely stumped. I tried running the script on their end,
it says they already have the types in question (!)
I don't think I've mentioned:
we are using SQL server 2000, the publication is is Transactional, and
the subscription type having problems is Push. The really curious thing
I've found is that the UDT that raises the error should not be a new
type at all: it is used by a column in an article that already existed
as part of the publication before I tried adding the other articles in.
Would you mind if i sent you snapshot history via email?
Thanks so much!
-dorothy
Raymond Mak [MSFT] wrote:[vbcol=seagreen]
> Asking them to run the script in SQL in Query Analyzer should work just fine
> although I am curious how you folks managed to get replication without some
> kind of connection going. In fact, it would be great if you can confirm
> whether the subcriber is using pull subscription on a SQL2000 server
> (otherwise things don't make much sense to me at the moment).
> -Raymond
> "DorothyY" <dorothyy@.eyi.us> wrote in message
> news:1159473908.516526.219320@.i3g2000cwc.googlegro ups.com...
|||For SQL2000 pull\anonymous subscribers, you would need to somehow bring over
the UDT manually and the snapshot agent history would not be of much use if
this is the case except it would be interesting to me (well, not really) if
the UDT is not mentioned when the snapshot agent is analyzing dependencies.
Is there any (indeirect) way you can check whether the required data type
exists at the subscriber?
-Raymond
"DorothyY" <dorothyy@.eyi.us> wrote in message
news:1160496410.497244.209740@.m7g2000cwm.googlegro ups.com...
> Hello,
> sorry abou the triple posting before, apparently google groups was
> having a bit of problems.
> And I am completely stumped. I tried running the script on their end,
> it says they already have the types in question (!)
> I don't think I've mentioned:
> we are using SQL server 2000, the publication is is Transactional, and
> the subscription type having problems is Push. The really curious thing
> I've found is that the UDT that raises the error should not be a new
> type at all: it is used by a column in an article that already existed
> as part of the publication before I tried adding the other articles in.
>
> Would you mind if i sent you snapshot history via email?
> Thanks so much!
> -dorothy
>
> Raymond Mak [MSFT] wrote:
>

Close all open connections

Before I can drop an mdf file form the server, all connections needs to be closed. how can I force to close this connection. The solution explained on this blog don't seems to work in my case http://sqlserver2005.de/SQLServer2005/MyBlog/tabid/56/EntryID/9/Default.aspx

I'm using SQL express, with visual studio pro 2005.

Thx for you quick responses

best regards

Luc N

please verify the code I've used

Dim svr As Server

svr = Nothing

svr = New Server(".\SQLEXPRESS")

'attach database

Dim con As New SqlConnection(svr.ConnectionContext.ConnectionString)

Dim com As New SqlCommand("sp_detach_db", con)

Dim d As Database

con.Open()

For Each d In svr.Databases

If Not d.IsSystemObject Then

'com.CommandType = Data.CommandType.StoredProcedure

'com.Parameters.Add(New SqlParameter("@.dbname", d.Name))

'com.ExecuteNonQuery()

'MsgBox(d.UserName.ToString())

d.DatabaseOptions.UserAccess = DatabaseUserAccess.Restricted

SqlConnection.ClearAllPools()

d.Drop()

'com.CommandText = "DROP DATABASE " & d.Name.ToString

'com.CommandType = CommandType.Text

'com.ExecuteNonQuery()

'End If

End If

Next

com.Connection.Close()

Why do you think that the information form the blog is not working for you ?

Jens K. Suessmeyer

http://www.sqlserver2005.de
|||

I've still got the message 'cannot drop the database because.......................'

I've modified my code , which seems to be working,

please reply your comments on this code

thx Luc

Try

Dim svr As Server

svr = Nothing

svr = New Server(".\SQLEXPRESS")

'attach database

Dim con As New SqlConnection(svr.ConnectionContext.ConnectionString)

Dim d As Database

con.Open()

For Each d In svr.Databases

If Not d.IsSystemObject Then

Exit For

End If

Next

If InStr(d.Name, "exp", CompareMethod.Text) <> 0 Then

svr.KillAllProcesses(d.Name)

d.DatabaseOptions.UserAccess = DatabaseUserAccess.Restricted

SqlConnection.ClearAllPools()

d.Drop()

con.Close()

End If

Catch ex As Exception

' MsgBox(ex.Message)

End Try

|||As I pointed out in the comment, they fixed the behaviour in the Service Pack, so KillDatabase should work for you.

Client Side Sequential Guid Generation

Is it possible to generate a Guid on the client side similar to
NEWSEQUENTIALGUID()?
I need a solution to PK generation that benefits from Guid so i can create
an object graph on the client side without the performance problems of
standard Guids.
Master-Detail data will be inserted into a Dataset and posted to the
database in one transaction to save round trips in a web service
application.here is from an old post:
http://groups.google.co.uk/groups/s...ql+oj+dllimport
-oj
"Anthony" <aa@.noreply.com> wrote in message
news:%233QzigLeGHA.3888@.TK2MSFTNGP04.phx.gbl...
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>|||Hi Anthony
If you want to identify the individual client then you a GUID would not give
you that information, therefore you would probably end up storing that as a
separate column which is part of a composite key. For SQL Server the other
column could be an Identity which would give you incrementing numbers and if
you needed these to be contiguous then they could be ranked. The other
alternative would be to maintain a counter for each client that you incremen
t.
John
"Anthony" wrote:

> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>
>|||It depends on the application. If it's a .net app, then it's very easy to
generate the guid by using the Guid.NewGuid() method. (It sounds like it
from the use of DataSet, which is a .net class.)
There should be a way from other languages to generate a guid.
"Anthony" <aa@.noreply.com> wrote in message
news:%233QzigLeGHA.3888@.TK2MSFTNGP04.phx.gbl...
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>|||Sorry, I mean I NEWSEQUENTIALGUID() was introduced to counter the
performance problems of the standard Guid. BUt I would like my Id
generated within my .NET app.
Anthony wrote:
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.

Client Side Sequential Guid Generation

Is it possible to generate a Guid on the client side similar to
NEWSEQUENTIALGUID()?
I need a solution to PK generation that benefits from Guid so i can create
an object graph on the client side without the performance problems of
standard Guids.
Master-Detail data will be inserted into a Dataset and posted to the
database in one transaction to save round trips in a web service
application.here is from an old post:
http://groups.google.co.uk/groups/search?hl=en&q=sql+oj+dllimport
-oj
"Anthony" <aa@.noreply.com> wrote in message
news:%233QzigLeGHA.3888@.TK2MSFTNGP04.phx.gbl...
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>|||Hi Anthony
If you want to identify the individual client then you a GUID would not give
you that information, therefore you would probably end up storing that as a
separate column which is part of a composite key. For SQL Server the other
column could be an Identity which would give you incrementing numbers and if
you needed these to be contiguous then they could be ranked. The other
alternative would be to maintain a counter for each client that you increment.
John
"Anthony" wrote:
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>
>|||It depends on the application. If it's a .net app, then it's very easy to
generate the guid by using the Guid.NewGuid() method. (It sounds like it
from the use of DataSet, which is a .net class.)
There should be a way from other languages to generate a guid.
"Anthony" <aa@.noreply.com> wrote in message
news:%233QzigLeGHA.3888@.TK2MSFTNGP04.phx.gbl...
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.
>|||Sorry, I mean I NEWSEQUENTIALGUID() was introduced to counter the
performance problems of the standard Guid. BUt I would like my Id
generated within my .NET app.
Anthony wrote:
> Is it possible to generate a Guid on the client side similar to
> NEWSEQUENTIALGUID()?
> I need a solution to PK generation that benefits from Guid so i can create
> an object graph on the client side without the performance problems of
> standard Guids.
> Master-Detail data will be inserted into a Dataset and posted to the
> database in one transaction to save round trips in a web service
> application.

Client can not connect to SQL Express - The Solution

Hi,

When I try to connect to SQL Express from another computer I get error 26.

The setup is as follows:

Server is Windows XP Pro, Firewall turned off.

Client is Windows XP Pro, Firewall turned off.

Both computers are on the same workgroup, no domain or other servers on the network.

The server is configured for network: protocols enabled, browser running.

The client has MS SQL Server Management Studio Express installed. When I try to connect the SSMSE finds the SQL Express on the server (using the Browse for more – Network server option), but the connection fails with error 26.

When I try to connect from MS Access 2003 I get the same error.

Thank for any help

Amihy

I found this link http://www.datamasker.com/SSE2005_NetworkCfg.htm maybe this will help you out.|||

Thanks for the link, it helped me understand that all my SQL settings are OK.

So I started to think about the network and at last found that NetBios over TCP\IT was disabled. It did not bother me before since the local network works with NetBEUI protocol.

Once I enabled TCP\IP over NetBios in Local Area Connection-Properties-TCP\IP properties-General-advanced-wins, The client immediatly connected to the server.

|||good to hear your ok now