How to maintain transaction between two databases?

Hi All,

Pandon me for asking such question, I am still a beginner to ASP.NET.

I have a project that require me to do single operation that is suppose to update two databases, wonder how do I maintain transaction between these two databases? Please advise, thank you!

Are these two different databases ?? Or two different tables in a database ?

If there are two tables inside one database, then you can keep a transaction object of ADO.NET

regards

|||

They are two different database. One database in each server sitting in a WAN. =(

|||

Hi,

To use transactions across database or servers, I suggest you use the TransactionScope class.

Here is an article for your reference.

http://msdn2.microsoft.com/en-us/library/ms973865.aspx

HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!

sql

How to look at "Set Up" options in somebody else's DB connctions?

Hello:
Is there a way that I can know what kind of DB Set up options are ON or
OFF in sombody else's connection? (Rather than asking him/her)
Options such as Concat_Null_Yields_Null, Ansi_Nulls, Ansi_Padding, etc.
Thank you.
CWIf you can run Profiler, then trace the 'existing connection' event and you
should see all the SET options for a given connection, uin the TextData
column.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Chai" <chai@.trs.state.il.us> wrote in message
news:uWvDh2U2DHA.1720@.TK2MSFTNGP10.phx.gbl...
Hello:
Is there a way that I can know what kind of DB Set up options are ON or
OFF in sombody else's connection? (Rather than asking him/her)
Options such as Concat_Null_Yields_Null, Ansi_Nulls, Ansi_Padding, etc.
Thank you.
CWsql

How to look at "Set Up" options in somebody else's DB connctions?

Hello:
Is there a way that I can know what kind of DB Set up options are ON or
OFF in sombody else's connection? (Rather than asking him/her) :)
Options such as Concat_Null_Yields_Null, Ansi_Nulls, Ansi_Padding, etc.
Thank you.
CWIf you can run Profiler, then trace the 'existing connection' event and you
should see all the SET options for a given connection, uin the TextData
column.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Chai" <chai@.trs.state.il.us> wrote in message
news:uWvDh2U2DHA.1720@.TK2MSFTNGP10.phx.gbl...
Hello:
Is there a way that I can know what kind of DB Set up options are ON or
OFF in sombody else's connection? (Rather than asking him/her) :)
Options such as Concat_Null_Yields_Null, Ansi_Nulls, Ansi_Padding, etc.
Thank you.
CW

How to limit number of connections for a user

Is there a way to limit a user's number of connections?
I'm asking because I have a user who keeps more than 50 query windows in
query analyzer.
Thanks!At the client side no...
on the server side you could write a scrip that periodically looks at
master..sysprocesses and issues KILL commands for connections that you want
to close.
But there is no way to set a threshold that say 'this user has 10
connections already so don't allow number 11'. You'd have to kill number 11
after it happens...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Michael" <michael.rodriguez@.loanperformance.com> wrote in message
news:u3OxQqlxDHA.3408@.tk2msftngp13.phx.gbl...
> Is there a way to limit a user's number of connections?
> I'm asking because I have a user who keeps more than 50 query windows in
> query analyzer.
> Thanks!
>|||Thanks for the reply Brian. I really appreciate it.
Unfortunately I'm looking for something better.
Maybe in future release of SQL server, they'll add that in there.
Thanks again!
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:OarcT%23lxDHA.3224@.tk2msftngp13.phx.gbl...
> At the client side no...
> on the server side you could write a scrip that periodically looks at
> master..sysprocesses and issues KILL commands for connections that you
want
> to close.
> But there is no way to set a threshold that say 'this user has 10
> connections already so don't allow number 11'. You'd have to kill number
11
> after it happens...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Michael" <michael.rodriguez@.loanperformance.com> wrote in message
> news:u3OxQqlxDHA.3408@.tk2msftngp13.phx.gbl...
> > Is there a way to limit a user's number of connections?
> >
> > I'm asking because I have a user who keeps more than 50 query windows in
> > query analyzer.
> >
> > Thanks!
> >
> >
>|||Hi Michael,
Thank you for using MSDN Newsgroup!
Thank you for your feedback! I am regret that there is not a easier way to
meet your request in SQL Server 2000. However, the products of Microsoft is
always keep up with the current application and forsee the new application
in different fields. There are many new exciting and powerful features in
our new generation SQL Server-Yukon, which are based on our study of the
new application of the Database systems. You can refer the information of
Yukon at:
http://www.microsoft.com/sql/yukon/productinfo/default.asp
You feedback is helpful for our developer to produce the best products and
satisfy our customers include you and others using products of Microsoft.
Thank you very much! Merry Christmas and Happy New Year!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.