Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
usenetreader
Starting Member
2 Posts |
 Posted - 2007-12-05 : 02:27:34
|
| Hi there,I am using SQL Server 2000 and 2005 and need to do something.Now here is my questions:1 - Is it possible to capture the active transaction with its ID in stored procedure? How?2 - Is it possible to join another database in stored procedure? How?3 - Is it possible to capture the active connection from another database (orcale, db2 or again sql server) in stored procedure? How?4 - 2 - Is it possible to create and commit or rollback transaction in stored procedure? How?Thank you for your interests. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-05 : 02:33:38
|
These look very much like homework questions.anyways - all of these can be found in BOL (Books OnLine)Duane.  |
 |
|
|
usenetreader
Starting Member
2 Posts |
Posted - 2007-12-05 : 02:56:47
|
| Are there anybody who can answer those question and write some example lines friends?If I am not in trouble at this moment, or have much time of course I investigates my thousands of books...Please write and help or do not write anything... |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-05 : 03:06:41
|
| Here is some helpBOOKS ON LINE I've just typed in search criteria for your questions in BOL and have come up with lots of articles.You have not got a specific problem here, if you had a specific problem and gave an example of your tables and existing code - then you will receive and endless supply of help here, but because you are asking such vague questions - the only advice we can give - is READ BOOKS ON LINEDuane. |
|
|
|
|
|
|
Need help... [StoredProcedures]