SQL Server 2000 SP3.
Is it possible to send a "net send" message to more than 1 operator in SQL
Server job Notifications ?. If not, is there a work-around ?.
We need to send a "Net Send" message when a job fails to more than 1
operator. How this can be possible ? I have defined multiple operators in
"SQL Server Agent--> Operators" but it is one or the other in the job's
Notifications.
T.I.A
Net Send is not an effective way to communicate/alert people. IMHO, it
shouldn't even have been included in the product. You'd be better off to send
an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
job failure to log an error in the app eventlog, and let your monitoring
system pick it up and alert you.
Linchi
"DXC" wrote:
> SQL Server 2000 SP3.
> Is it possible to send a "net send" message to more than 1 operator in SQL
> Server job Notifications ?. If not, is there a work-around ?.
> We need to send a "Net Send" message when a job fails to more than 1
> operator. How this can be possible ? I have defined multiple operators in
> "SQL Server Agent--> Operators" but it is one or the other in the job's
> Notifications.
> T.I.A
|||Thanks.................The problem is, server is in one domain (A secure
domain) and the monitoring will be done on another domain where 2 domains
don't see each other........
"Linchi Shea" wrote:
[vbcol=seagreen]
> Net Send is not an effective way to communicate/alert people. IMHO, it
> shouldn't even have been included in the product. You'd be better off to send
> an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
> job failure to log an error in the app eventlog, and let your monitoring
> system pick it up and alert you.
> Linchi
> "DXC" wrote:
Showing posts with label sqlserver. Show all posts
Showing posts with label sqlserver. Show all posts
Monday, March 26, 2012
Net send message
SQL Server 2000 SP3.
Is it possible to send a "net send" message to more than 1 operator in SQL
Server job Notifications ?. If not, is there a work-around ?.
We need to send a "Net Send" message when a job fails to more than 1
operator. How this can be possible ? I have defined multiple operators in
"SQL Server Agent--> Operators" but it is one or the other in the job's
Notifications.
T.I.ANet Send is not an effective way to communicate/alert people. IMHO, it
shouldn't even have been included in the product. You'd be better off to sen
d
an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
job failure to log an error in the app eventlog, and let your monitoring
system pick it up and alert you.
Linchi
"DXC" wrote:
> SQL Server 2000 SP3.
> Is it possible to send a "net send" message to more than 1 operator in SQL
> Server job Notifications ?. If not, is there a work-around ?.
> We need to send a "Net Send" message when a job fails to more than 1
> operator. How this can be possible ? I have defined multiple operators in
> "SQL Server Agent--> Operators" but it is one or the other in the job's
> Notifications.
> T.I.A|||Thanks.................The problem is, server is in one domain (A secur
e
domain) and the monitoring will be done on another domain where 2 domains
don't see each other........
"Linchi Shea" wrote:
[vbcol=seagreen]
> Net Send is not an effective way to communicate/alert people. IMHO, it
> shouldn't even have been included in the product. You'd be better off to s
end
> an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
> job failure to log an error in the app eventlog, and let your monitoring
> system pick it up and alert you.
> Linchi
> "DXC" wrote:
>sql
Is it possible to send a "net send" message to more than 1 operator in SQL
Server job Notifications ?. If not, is there a work-around ?.
We need to send a "Net Send" message when a job fails to more than 1
operator. How this can be possible ? I have defined multiple operators in
"SQL Server Agent--> Operators" but it is one or the other in the job's
Notifications.
T.I.ANet Send is not an effective way to communicate/alert people. IMHO, it
shouldn't even have been included in the product. You'd be better off to sen
d
an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
job failure to log an error in the app eventlog, and let your monitoring
system pick it up and alert you.
Linchi
"DXC" wrote:
> SQL Server 2000 SP3.
> Is it possible to send a "net send" message to more than 1 operator in SQL
> Server job Notifications ?. If not, is there a work-around ?.
> We need to send a "Net Send" message when a job fails to more than 1
> operator. How this can be possible ? I have defined multiple operators in
> "SQL Server Agent--> Operators" but it is one or the other in the job's
> Notifications.
> T.I.A|||Thanks.................The problem is, server is in one domain (A secur
e
domain) and the monitoring will be done on another domain where 2 domains
don't see each other........
"Linchi Shea" wrote:
[vbcol=seagreen]
> Net Send is not an effective way to communicate/alert people. IMHO, it
> shouldn't even have been included in the product. You'd be better off to s
end
> an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
> job failure to log an error in the app eventlog, and let your monitoring
> system pick it up and alert you.
> Linchi
> "DXC" wrote:
>sql
Net 1.1 and 2.0 and SQLServer 2000 and 2005 at one machine
Hi,
we have a VServer with Server 2003.
I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
2005 on it.
Does anybody knows if that's possible without problems. I have a consultant
here (from cognos) who tells me it's not possible. Can't believe that.
Please help.
Thanks,
Uli
Wer nicht fragt, stirbt dumm.
If you don''t ask, you''ll die as a dumba**.
Hello Uli,
I've certainly done 2000 and 2005 on the same physical host before without
implications (other than competing for memory, cpu, etc.) I'm not sure about
Virtual Server, but I can't tell you why it would be any different. Is the
consultant offering any specifics?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
|||No.
Only not to run 2000 and 2005 on one system.
But we will go on and try with both on one system.
Thanks a lot.
Uli
Wer nicht fragt, stirbt dumm.
If you don''''t ask, you''''ll die as a dumba**.
"Kent Tegels" wrote:
> Hello Uli,
> I've certainly done 2000 and 2005 on the same physical host before without
> implications (other than competing for memory, cpu, etc.) I'm not sure about
> Virtual Server, but I can't tell you why it would be any different. Is the
> consultant offering any specifics?
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>
|||Uli formulated the question :
> Hi,
> we have a VServer with Server 2003.
> I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
> 2005 on it.
> Does anybody knows if that's possible without problems. I have a consultant
> here (from cognos) who tells me it's not possible. Can't believe that.
> Please help.
> Thanks,
> Uli
funny you should ask
I am doing exactly what you want to do
be it that I use VirtualPC cause I am still in test
so far everything is working fine
grtz
|||Hi Uli
By requiring .NET Framework 1.1 implies the server is doing more than just
run SQL Server. As Kent says running SQL 2000 and SQL 2005 on a single system
works if you have enough resources, also having both frameworks is possible
see http://msdn.microsoft.com/msdnmag/is.../default.aspx,
which implies that if this can't be done the problem is elsewhere or does not
exist!
John
"Uli" wrote:
[vbcol=seagreen]
> No.
> Only not to run 2000 and 2005 on one system.
> But we will go on and try with both on one system.
> Thanks a lot.
> Uli
> --
> Wer nicht fragt, stirbt dumm.
> If you don''''t ask, you''''ll die as a dumba**.
>
> "Kent Tegels" wrote:
we have a VServer with Server 2003.
I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
2005 on it.
Does anybody knows if that's possible without problems. I have a consultant
here (from cognos) who tells me it's not possible. Can't believe that.
Please help.
Thanks,
Uli
Wer nicht fragt, stirbt dumm.
If you don''t ask, you''ll die as a dumba**.
Hello Uli,
I've certainly done 2000 and 2005 on the same physical host before without
implications (other than competing for memory, cpu, etc.) I'm not sure about
Virtual Server, but I can't tell you why it would be any different. Is the
consultant offering any specifics?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/
|||No.
Only not to run 2000 and 2005 on one system.
But we will go on and try with both on one system.
Thanks a lot.
Uli
Wer nicht fragt, stirbt dumm.
If you don''''t ask, you''''ll die as a dumba**.
"Kent Tegels" wrote:
> Hello Uli,
> I've certainly done 2000 and 2005 on the same physical host before without
> implications (other than competing for memory, cpu, etc.) I'm not sure about
> Virtual Server, but I can't tell you why it would be any different. Is the
> consultant offering any specifics?
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>
|||Uli formulated the question :
> Hi,
> we have a VServer with Server 2003.
> I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
> 2005 on it.
> Does anybody knows if that's possible without problems. I have a consultant
> here (from cognos) who tells me it's not possible. Can't believe that.
> Please help.
> Thanks,
> Uli
funny you should ask
I am doing exactly what you want to do
be it that I use VirtualPC cause I am still in test
so far everything is working fine
grtz
|||Hi Uli
By requiring .NET Framework 1.1 implies the server is doing more than just
run SQL Server. As Kent says running SQL 2000 and SQL 2005 on a single system
works if you have enough resources, also having both frameworks is possible
see http://msdn.microsoft.com/msdnmag/is.../default.aspx,
which implies that if this can't be done the problem is elsewhere or does not
exist!
John
"Uli" wrote:
[vbcol=seagreen]
> No.
> Only not to run 2000 and 2005 on one system.
> But we will go on and try with both on one system.
> Thanks a lot.
> Uli
> --
> Wer nicht fragt, stirbt dumm.
> If you don''''t ask, you''''ll die as a dumba**.
>
> "Kent Tegels" wrote:
Friday, March 23, 2012
Net 1.1 and 2.0 and SQLServer 2000 and 2005 at one machine
Hi,
we have a VServer with Server 2003.
I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
2005 on it.
Does anybody knows if that's possible without problems. I have a consultant
here (from cognos) who tells me it's not possible. Can't believe that.
Please help.
Thanks,
Uli
--
Wer nicht fragt, stirbt dumm.
If you don''t ask, you''ll die as a dumba**.Hello Uli,
I've certainly done 2000 and 2005 on the same physical host before without
implications (other than competing for memory, cpu, etc.) I'm not sure about
Virtual Server, but I can't tell you why it would be any different. Is the
consultant offering any specifics?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||No.
Only not to run 2000 and 2005 on one system.
But we will go on and try with both on one system.
Thanks a lot.
Uli
--
Wer nicht fragt, stirbt dumm.
If you don''''t ask, you''''ll die as a dumba**.
"Kent Tegels" wrote:
> Hello Uli,
> I've certainly done 2000 and 2005 on the same physical host before without
> implications (other than competing for memory, cpu, etc.) I'm not sure abo
ut
> Virtual Server, but I can't tell you why it would be any different. Is the
> consultant offering any specifics?
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>|||Uli formulated the question :
> Hi,
> we have a VServer with Server 2003.
> I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
> 2005 on it.
> Does anybody knows if that's possible without problems. I have a consultan
t
> here (from cognos) who tells me it's not possible. Can't believe that.
> Please help.
> Thanks,
> Uli
funny you should ask
I am doing exactly what you want to do
be it that I use VirtualPC cause I am still in test
so far everything is working fine
grtz|||Hi Uli
By requiring .NET Framework 1.1 implies the server is doing more than just
run SQL Server. As Kent says running SQL 2000 and SQL 2005 on a single syste
m
works if you have enough resources, also having both frameworks is possible
see [url]http://msdn.microsoft.com/msdnmag/issues/06/03/CLRInsideOut/default.aspx,[/url
]
which implies that if this can't be done the problem is elsewhere or does no
t
exist!
John
"Uli" wrote:
[vbcol=seagreen]
> No.
> Only not to run 2000 and 2005 on one system.
> But we will go on and try with both on one system.
> Thanks a lot.
> Uli
> --
> Wer nicht fragt, stirbt dumm.
> If you don''''t ask, you''''ll die as a dumba**.
>
> "Kent Tegels" wrote:
>sql
we have a VServer with Server 2003.
I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
2005 on it.
Does anybody knows if that's possible without problems. I have a consultant
here (from cognos) who tells me it's not possible. Can't believe that.
Please help.
Thanks,
Uli
--
Wer nicht fragt, stirbt dumm.
If you don''t ask, you''ll die as a dumba**.Hello Uli,
I've certainly done 2000 and 2005 on the same physical host before without
implications (other than competing for memory, cpu, etc.) I'm not sure about
Virtual Server, but I can't tell you why it would be any different. Is the
consultant offering any specifics?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||No.
Only not to run 2000 and 2005 on one system.
But we will go on and try with both on one system.
Thanks a lot.
Uli
--
Wer nicht fragt, stirbt dumm.
If you don''''t ask, you''''ll die as a dumba**.
"Kent Tegels" wrote:
> Hello Uli,
> I've certainly done 2000 and 2005 on the same physical host before without
> implications (other than competing for memory, cpu, etc.) I'm not sure abo
ut
> Virtual Server, but I can't tell you why it would be any different. Is the
> consultant offering any specifics?
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>|||Uli formulated the question :
> Hi,
> we have a VServer with Server 2003.
> I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
> 2005 on it.
> Does anybody knows if that's possible without problems. I have a consultan
t
> here (from cognos) who tells me it's not possible. Can't believe that.
> Please help.
> Thanks,
> Uli
funny you should ask
I am doing exactly what you want to do
be it that I use VirtualPC cause I am still in test
so far everything is working fine
grtz|||Hi Uli
By requiring .NET Framework 1.1 implies the server is doing more than just
run SQL Server. As Kent says running SQL 2000 and SQL 2005 on a single syste
m
works if you have enough resources, also having both frameworks is possible
see [url]http://msdn.microsoft.com/msdnmag/issues/06/03/CLRInsideOut/default.aspx,[/url
]
which implies that if this can't be done the problem is elsewhere or does no
t
exist!
John
"Uli" wrote:
[vbcol=seagreen]
> No.
> Only not to run 2000 and 2005 on one system.
> But we will go on and try with both on one system.
> Thanks a lot.
> Uli
> --
> Wer nicht fragt, stirbt dumm.
> If you don''''t ask, you''''ll die as a dumba**.
>
> "Kent Tegels" wrote:
>sql
Net 1.1 and 2.0 and SQLServer 2000 and 2005 at one machine
Hi,
we have a VServer with Server 2003.
I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
2005 on it.
Does anybody knows if that's possible without problems. I have a consultant
here (from cognos) who tells me it's not possible. Can't believe that.
Please help.
Thanks,
Uli
--
Wer nicht fragt, stirbt dumm.
If you don''t ask, you''ll die as a dumba**.Hello Uli,
I've certainly done 2000 and 2005 on the same physical host before without
implications (other than competing for memory, cpu, etc.) I'm not sure about
Virtual Server, but I can't tell you why it would be any different. Is the
consultant offering any specifics?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||No.
Only not to run 2000 and 2005 on one system.
But we will go on and try with both on one system.
Thanks a lot.
Uli
--
Wer nicht fragt, stirbt dumm.
If you don''''t ask, you''''ll die as a dumba**.
"Kent Tegels" wrote:
> Hello Uli,
> I've certainly done 2000 and 2005 on the same physical host before without
> implications (other than competing for memory, cpu, etc.) I'm not sure about
> Virtual Server, but I can't tell you why it would be any different. Is the
> consultant offering any specifics?
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>|||Uli formulated the question :
> Hi,
> we have a VServer with Server 2003.
> I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
> 2005 on it.
> Does anybody knows if that's possible without problems. I have a consultant
> here (from cognos) who tells me it's not possible. Can't believe that.
> Please help.
> Thanks,
> Uli
funny you should ask
I am doing exactly what you want to do
be it that I use VirtualPC cause I am still in test
so far everything is working fine
grtz|||Hi Uli
By requiring .NET Framework 1.1 implies the server is doing more than just
run SQL Server. As Kent says running SQL 2000 and SQL 2005 on a single system
works if you have enough resources, also having both frameworks is possible
see http://msdn.microsoft.com/msdnmag/issues/06/03/CLRInsideOut/default.aspx,
which implies that if this can't be done the problem is elsewhere or does not
exist!
John
"Uli" wrote:
> No.
> Only not to run 2000 and 2005 on one system.
> But we will go on and try with both on one system.
> Thanks a lot.
> Uli
> --
> Wer nicht fragt, stirbt dumm.
> If you don''''t ask, you''''ll die as a dumba**.
>
> "Kent Tegels" wrote:
> > Hello Uli,
> >
> > I've certainly done 2000 and 2005 on the same physical host before without
> > implications (other than competing for memory, cpu, etc.) I'm not sure about
> > Virtual Server, but I can't tell you why it would be any different. Is the
> > consultant offering any specifics?
> >
> > Thanks,
> > Kent Tegels
> > http://staff.develop.com/ktegels/
> >
> >
> >
we have a VServer with Server 2003.
I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
2005 on it.
Does anybody knows if that's possible without problems. I have a consultant
here (from cognos) who tells me it's not possible. Can't believe that.
Please help.
Thanks,
Uli
--
Wer nicht fragt, stirbt dumm.
If you don''t ask, you''ll die as a dumba**.Hello Uli,
I've certainly done 2000 and 2005 on the same physical host before without
implications (other than competing for memory, cpu, etc.) I'm not sure about
Virtual Server, but I can't tell you why it would be any different. Is the
consultant offering any specifics?
Thanks,
Kent Tegels
http://staff.develop.com/ktegels/|||No.
Only not to run 2000 and 2005 on one system.
But we will go on and try with both on one system.
Thanks a lot.
Uli
--
Wer nicht fragt, stirbt dumm.
If you don''''t ask, you''''ll die as a dumba**.
"Kent Tegels" wrote:
> Hello Uli,
> I've certainly done 2000 and 2005 on the same physical host before without
> implications (other than competing for memory, cpu, etc.) I'm not sure about
> Virtual Server, but I can't tell you why it would be any different. Is the
> consultant offering any specifics?
> Thanks,
> Kent Tegels
> http://staff.develop.com/ktegels/
>
>|||Uli formulated the question :
> Hi,
> we have a VServer with Server 2003.
> I'd like to install Software for net 1.1, 2.0 and also SQLServer 2000 and
> 2005 on it.
> Does anybody knows if that's possible without problems. I have a consultant
> here (from cognos) who tells me it's not possible. Can't believe that.
> Please help.
> Thanks,
> Uli
funny you should ask
I am doing exactly what you want to do
be it that I use VirtualPC cause I am still in test
so far everything is working fine
grtz|||Hi Uli
By requiring .NET Framework 1.1 implies the server is doing more than just
run SQL Server. As Kent says running SQL 2000 and SQL 2005 on a single system
works if you have enough resources, also having both frameworks is possible
see http://msdn.microsoft.com/msdnmag/issues/06/03/CLRInsideOut/default.aspx,
which implies that if this can't be done the problem is elsewhere or does not
exist!
John
"Uli" wrote:
> No.
> Only not to run 2000 and 2005 on one system.
> But we will go on and try with both on one system.
> Thanks a lot.
> Uli
> --
> Wer nicht fragt, stirbt dumm.
> If you don''''t ask, you''''ll die as a dumba**.
>
> "Kent Tegels" wrote:
> > Hello Uli,
> >
> > I've certainly done 2000 and 2005 on the same physical host before without
> > implications (other than competing for memory, cpu, etc.) I'm not sure about
> > Virtual Server, but I can't tell you why it would be any different. Is the
> > consultant offering any specifics?
> >
> > Thanks,
> > Kent Tegels
> > http://staff.develop.com/ktegels/
> >
> >
> >
Friday, March 9, 2012
Nest transactions in SQLServer
hi guys:
i am doing a hard work of migrating programs from Oracle to SQL-Server.
i encounte a problem about transaction which hardly hurt my heart (forgive
my poor english first ... :-) )
you know,there is such a usage in oracle:
SAVEPOINT xxx
doing things1...
doing things2...
if error in doing things2 then
ROLLBACKTOSAVEPOINT xx
end if;
so, if things 2 failed, the data altered by things1 is guaranteed to be
rollback.
but when i change it to fit sql-server, i was happily wrote such codes:
BEGIN TRANS... //must
...
...
BEGIN TRANS... //SAVEPOINT xxx
doing things1...
doing things2...
if error in doing things2 then
ROLLBACK TRANS... //ROLLBACKTOSAVEPOINT xx
end if;
..
...
COMMIT TRANS.
yes, i got a error: 'Cannot start more transactions on this session' (oh,
these codes are under ado in delphi)
i find the answer in msdn
CAUSE
By design, OLE DB Provider for SQL Server does not allow nested
transactions.
http://support.microsoft.com/defaul...kb;en-us;316872
but,i think, such nest transcations (or same other trick equal to oracle
save point) is very needed in general business process.
how to solve this problem?
my best wishes.Hi
Have you looked up SAVE TRANSACTION in BOL?
John
"MaHahaXixi" wrote:
> hi guys:
> i am doing a hard work of migrating programs from Oracle to SQL-Server.
> i encounte a problem about transaction which hardly hurt my heart (forgi
ve
> my poor english first ... :-) )
> you know,there is such a usage in oracle:
> SAVEPOINT xxx
> doing things1...
> doing things2...
> if error in doing things2 then
> ROLLBACKTOSAVEPOINT xx
> end if;
> so, if things 2 failed, the data altered by things1 is guaranteed to be
> rollback.
> but when i change it to fit sql-server, i was happily wrote such codes:
> BEGIN TRANS... //must
> ...
> ...
> BEGIN TRANS... //SAVEPOINT xxx
> doing things1...
> doing things2...
> if error in doing things2 then
> ROLLBACK TRANS... //ROLLBACKTOSAVEPOINT xx
> end if;
> ...
> ...
>
> COMMIT TRANS.
> yes, i got a error: 'Cannot start more transactions on this session' (oh,
> these codes are under ado in delphi)
> i find the answer in msdn
> CAUSE
> By design, OLE DB Provider for SQL Server does not allow nested
> transactions.
> http://support.microsoft.com/defaul...kb;en-us;316872
>
> but,i think, such nest transcations (or same other trick equal to oracle
> save point) is very needed in general business process.
> how to solve this problem?
> my best wishes.
>
>|||hi john:
thank u for ur response.
what do u mean by BOL' sorroy, i am just a greenhand.
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:E702B8AB-3AD4-4AE9-BA9A-95D6AE336046@.microsoft.com...
> Hi
> Have you looked up SAVE TRANSACTION in BOL?
> John
> "MaHahaXixi" wrote:
>
SQL-Server.
(forgive
be
codes:
(oh,|||oh... yes i got the answer
there are
save trans {savepoint}
rollack trans {savepoint}
in t-sql too.
thanks all the same
"MaHahaXixi" <enjoy_linux@.hotmail.com> wrote in message
news:d3fh2p$vuo$1@.mail.cn99.com...
> hi guys:
> i am doing a hard work of migrating programs from Oracle to SQL-Server.
> i encounte a problem about transaction which hardly hurt my heart
(forgive
> my poor english first ... :-) )
> you know,there is such a usage in oracle:
> SAVEPOINT xxx
> doing things1...
> doing things2...
> if error in doing things2 then
> ROLLBACKTOSAVEPOINT xx
> end if;
> so, if things 2 failed, the data altered by things1 is guaranteed to be
> rollback.
> but when i change it to fit sql-server, i was happily wrote such codes:
> BEGIN TRANS... //must
> ...
> ...
> BEGIN TRANS... //SAVEPOINT xxx
> doing things1...
> doing things2...
> if error in doing things2 then
> ROLLBACK TRANS... //ROLLBACKTOSAVEPOINT xx
> end if;
> ...
> ...
>
> COMMIT TRANS.
> yes, i got a error: 'Cannot start more transactions on this session' (oh,
> these codes are under ado in delphi)
> i find the answer in msdn
> CAUSE
> By design, OLE DB Provider for SQL Server does not allow nested
> transactions.
> http://support.microsoft.com/defaul...kb;en-us;316872
>
> but,i think, such nest transcations (or same other trick equal to oracle
> save point) is very needed in general business process.
> how to solve this problem?
> my best wishes.
>
>|||thank you john, i got it .yes, save transactions
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:E702B8AB-3AD4-4AE9-BA9A-95D6AE336046@.microsoft.com...
> Hi
> Have you looked up SAVE TRANSACTION in BOL?
> John
> "MaHahaXixi" wrote:
>
SQL-Server.
(forgive
be
codes:
(oh,|||BOL = SQL Server Books Online, found in the SQL Server program group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"MaHahaXixi" <enjoy_linux@.hotmail.com> wrote in message news:d3ftsf$137e$1@.mail.cn99.com...
> hi john:
> thank u for ur response.
> what do u mean by BOL' sorroy, i am just a greenhand.
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:E702B8AB-3AD4-4AE9-BA9A-95D6AE336046@.microsoft.com...
> SQL-Server.
> (forgive
> be
> codes:
> (oh,
>|||Hi
You may find these articles useful:
http://www.microsoft.com/resources/...r />
0761.mspx
http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
John
MaHahaXixi wrote:
> oh... yes i got the answer
> there are
> save trans {savepoint}
> rollack trans {savepoint}
> in t-sql too.
> thanks all the same
> "MaHahaXixi" <enjoy_linux@.hotmail.com> wrote in message
> news:d3fh2p$vuo$1@.mail.cn99.com...
SQL-Server.
> (forgive
to be
codes:
session' (oh,
oracle|||thanks a lot :-)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uTmv2zPFHA.3928@.TK2MSFTNGP09.phx.gbl...
> BOL = SQL Server Books Online, found in the SQL Server program group.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "MaHahaXixi" <enjoy_linux@.hotmail.com> wrote in message
news:d3ftsf$137e$1@.mail.cn99.com...
to
oracle
>|||thank you! very useful to me!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1113307105.002786.136380@.f14g2000cwb.googlegroups.com...
> Hi
> You may find these articles useful:
>
http://www.microsoft.com/resources/...art2/c0761.mspx
> http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
> John
> MaHahaXixi wrote:
> SQL-Server.
> to be
> codes:
> session' (oh,
> oracle
>
i am doing a hard work of migrating programs from Oracle to SQL-Server.
i encounte a problem about transaction which hardly hurt my heart (forgive
my poor english first ... :-) )
you know,there is such a usage in oracle:
SAVEPOINT xxx
doing things1...
doing things2...
if error in doing things2 then
ROLLBACKTOSAVEPOINT xx
end if;
so, if things 2 failed, the data altered by things1 is guaranteed to be
rollback.
but when i change it to fit sql-server, i was happily wrote such codes:
BEGIN TRANS... //must
...
...
BEGIN TRANS... //SAVEPOINT xxx
doing things1...
doing things2...
if error in doing things2 then
ROLLBACK TRANS... //ROLLBACKTOSAVEPOINT xx
end if;
..
...
COMMIT TRANS.
yes, i got a error: 'Cannot start more transactions on this session' (oh,
these codes are under ado in delphi)
i find the answer in msdn
CAUSE
By design, OLE DB Provider for SQL Server does not allow nested
transactions.
http://support.microsoft.com/defaul...kb;en-us;316872
but,i think, such nest transcations (or same other trick equal to oracle
save point) is very needed in general business process.
how to solve this problem?
my best wishes.Hi
Have you looked up SAVE TRANSACTION in BOL?
John
"MaHahaXixi" wrote:
> hi guys:
> i am doing a hard work of migrating programs from Oracle to SQL-Server.
> i encounte a problem about transaction which hardly hurt my heart (forgi
ve
> my poor english first ... :-) )
> you know,there is such a usage in oracle:
> SAVEPOINT xxx
> doing things1...
> doing things2...
> if error in doing things2 then
> ROLLBACKTOSAVEPOINT xx
> end if;
> so, if things 2 failed, the data altered by things1 is guaranteed to be
> rollback.
> but when i change it to fit sql-server, i was happily wrote such codes:
> BEGIN TRANS... //must
> ...
> ...
> BEGIN TRANS... //SAVEPOINT xxx
> doing things1...
> doing things2...
> if error in doing things2 then
> ROLLBACK TRANS... //ROLLBACKTOSAVEPOINT xx
> end if;
> ...
> ...
>
> COMMIT TRANS.
> yes, i got a error: 'Cannot start more transactions on this session' (oh,
> these codes are under ado in delphi)
> i find the answer in msdn
> CAUSE
> By design, OLE DB Provider for SQL Server does not allow nested
> transactions.
> http://support.microsoft.com/defaul...kb;en-us;316872
>
> but,i think, such nest transcations (or same other trick equal to oracle
> save point) is very needed in general business process.
> how to solve this problem?
> my best wishes.
>
>|||hi john:
thank u for ur response.
what do u mean by BOL' sorroy, i am just a greenhand.
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:E702B8AB-3AD4-4AE9-BA9A-95D6AE336046@.microsoft.com...
> Hi
> Have you looked up SAVE TRANSACTION in BOL?
> John
> "MaHahaXixi" wrote:
>
SQL-Server.
(forgive
be
codes:
(oh,|||oh... yes i got the answer
there are
save trans {savepoint}
rollack trans {savepoint}
in t-sql too.
thanks all the same
"MaHahaXixi" <enjoy_linux@.hotmail.com> wrote in message
news:d3fh2p$vuo$1@.mail.cn99.com...
> hi guys:
> i am doing a hard work of migrating programs from Oracle to SQL-Server.
> i encounte a problem about transaction which hardly hurt my heart
(forgive
> my poor english first ... :-) )
> you know,there is such a usage in oracle:
> SAVEPOINT xxx
> doing things1...
> doing things2...
> if error in doing things2 then
> ROLLBACKTOSAVEPOINT xx
> end if;
> so, if things 2 failed, the data altered by things1 is guaranteed to be
> rollback.
> but when i change it to fit sql-server, i was happily wrote such codes:
> BEGIN TRANS... //must
> ...
> ...
> BEGIN TRANS... //SAVEPOINT xxx
> doing things1...
> doing things2...
> if error in doing things2 then
> ROLLBACK TRANS... //ROLLBACKTOSAVEPOINT xx
> end if;
> ...
> ...
>
> COMMIT TRANS.
> yes, i got a error: 'Cannot start more transactions on this session' (oh,
> these codes are under ado in delphi)
> i find the answer in msdn
> CAUSE
> By design, OLE DB Provider for SQL Server does not allow nested
> transactions.
> http://support.microsoft.com/defaul...kb;en-us;316872
>
> but,i think, such nest transcations (or same other trick equal to oracle
> save point) is very needed in general business process.
> how to solve this problem?
> my best wishes.
>
>|||thank you john, i got it .yes, save transactions
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:E702B8AB-3AD4-4AE9-BA9A-95D6AE336046@.microsoft.com...
> Hi
> Have you looked up SAVE TRANSACTION in BOL?
> John
> "MaHahaXixi" wrote:
>
SQL-Server.
(forgive
be
codes:
(oh,|||BOL = SQL Server Books Online, found in the SQL Server program group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"MaHahaXixi" <enjoy_linux@.hotmail.com> wrote in message news:d3ftsf$137e$1@.mail.cn99.com...
> hi john:
> thank u for ur response.
> what do u mean by BOL' sorroy, i am just a greenhand.
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:E702B8AB-3AD4-4AE9-BA9A-95D6AE336046@.microsoft.com...
> SQL-Server.
> (forgive
> be
> codes:
> (oh,
>|||Hi
You may find these articles useful:
http://www.microsoft.com/resources/...r />
0761.mspx
http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
John
MaHahaXixi wrote:
> oh... yes i got the answer
> there are
> save trans {savepoint}
> rollack trans {savepoint}
> in t-sql too.
> thanks all the same
> "MaHahaXixi" <enjoy_linux@.hotmail.com> wrote in message
> news:d3fh2p$vuo$1@.mail.cn99.com...
SQL-Server.
> (forgive
to be
codes:
session' (oh,
oracle|||thanks a lot :-)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23uTmv2zPFHA.3928@.TK2MSFTNGP09.phx.gbl...
> BOL = SQL Server Books Online, found in the SQL Server program group.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "MaHahaXixi" <enjoy_linux@.hotmail.com> wrote in message
news:d3ftsf$137e$1@.mail.cn99.com...
to
oracle
>|||thank you! very useful to me!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:1113307105.002786.136380@.f14g2000cwb.googlegroups.com...
> Hi
> You may find these articles useful:
>
http://www.microsoft.com/resources/...art2/c0761.mspx
> http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
> John
> MaHahaXixi wrote:
> SQL-Server.
> to be
> codes:
> session' (oh,
> oracle
>
Neet to know the sqlserver reporting news group
Neet to know the sqlserver reporting news group
microsoft.public.sqlserver.reportingsvcs
Jacco Schalkwijk
SQL Server MVP
"Atul Bahl" <atulbahl@.nospam.com> wrote in message
news:0AE210A3-5104-485F-A34F-F20A1165FC65@.microsoft.com...
> Neet to know the sqlserver reporting news group
microsoft.public.sqlserver.reportingsvcs
Jacco Schalkwijk
SQL Server MVP
"Atul Bahl" <atulbahl@.nospam.com> wrote in message
news:0AE210A3-5104-485F-A34F-F20A1165FC65@.microsoft.com...
> Neet to know the sqlserver reporting news group
Neet to know the sqlserver reporting news group
Neet to know the sqlserver reporting news groupmicrosoft.public.sqlserver.reportingsvcs
Jacco Schalkwijk
SQL Server MVP
"Atul Bahl" <atulbahl@.nospam.com> wrote in message
news:0AE210A3-5104-485F-A34F-F20A1165FC65@.microsoft.com...
> Neet to know the sqlserver reporting news group
Jacco Schalkwijk
SQL Server MVP
"Atul Bahl" <atulbahl@.nospam.com> wrote in message
news:0AE210A3-5104-485F-A34F-F20A1165FC65@.microsoft.com...
> Neet to know the sqlserver reporting news group
Neet to know the sqlserver reporting news group
Neet to know the sqlserver reporting news groupmicrosoft.public.sqlserver.reportingsvcs
--
Jacco Schalkwijk
SQL Server MVP
"Atul Bahl" <atulbahl@.nospam.com> wrote in message
news:0AE210A3-5104-485F-A34F-F20A1165FC65@.microsoft.com...
> Neet to know the sqlserver reporting news group
--
Jacco Schalkwijk
SQL Server MVP
"Atul Bahl" <atulbahl@.nospam.com> wrote in message
news:0AE210A3-5104-485F-A34F-F20A1165FC65@.microsoft.com...
> Neet to know the sqlserver reporting news group
Wednesday, March 7, 2012
NEEDED: SQL Server Express 2005 Setup Walkthrough
Someone please help me, Im trying to set up SQLServer on my website(IIS v4.0) and I cant seem to get any web apps that use SQL to intall correctly, I get errors like, SQL does not recieve remote connections by default, or just 'Server Not Found'.
This is what I need to know
- How to set SQL to accept incomming remote connections
- Where to find the Name of the SQL instance
- Is it a good idea to have a password on the db, and how do I add one
- A walkthrough on how to set up SQL Express 2005(what to do after the istall is complete)
As you can see Im very new to SQL. So any information you could give to help would be greatly appreciated.
Thanks
Admin @. Something-to-do.com
1. Here is a KB Article that goes through setting up remote connections. http://support.microsoft.com/kb/914277
2. With SQL Server 2005 Express the server install defaults to ".\SQLEXPRESS" for the instance. To find the name though you can check the windows service list in the Services mmc inside the administration folder under the control panel. The name will be inside brackets beside the SQL Server Service.
3. You should try and stay with Windows Logons for the security.. if you do need to use sql logons you should try a strong password on the database accounts.
Subscribe to:
Posts (Atom)