can sql maintenance plan be script out?

as title. any tips would be appreciated. thank you
You can script the scheduled job it creates but not the entire maintenance
plan.
Andrew J. Kelly SQL MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:edVFcoXLEHA.556@.tk2msftngp13.phx.gbl...
> as title. any tips would be appreciated. thank you
>

can sql maintenance plan be script out?

as title. any tips would be appreciated. thank youYou can script the scheduled job it creates but not the entire maintenance
plan.
--
Andrew J. Kelly SQL MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:edVFcoXLEHA.556@.tk2msftngp13.phx.gbl...
> as title. any tips would be appreciated. thank you
>

can sql maintenance plan be script out?

as title. any tips would be appreciated. thank youYou can script the scheduled job it creates but not the entire maintenance
plan.
Andrew J. Kelly SQL MVP
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:edVFcoXLEHA.556@.tk2msftngp13.phx.gbl...
> as title. any tips would be appreciated. thank you
>

Can not update from view of linked server

Hi, All,
I got a problem with linked server, I cannot fix it, if anyone can help will
be appreciated.
The problem is two instance of sql server in one machine, A and B, in A made
a linked server to B. and a view in A. actually I can view the data from
view, but I can not update from view. I get error message:
7395, "42000", [microsoft][odbc sql server driver] unable to start a nested
transation for ole db provider 'sqloledb'. A nested transaction was required
because the xact_abort option was set to off.
7312, "01000" [microsoft][odbc sql server driver] [sql server] [ole/db
provider"] 'sqloledb' ITransationlocal::starttransaction returned
0x8004d013:isolevel=1048576
Thanks
Yifei
On the client where you are trying to update the view, try
executing: SET XACT_ABORT ON
before doing the update.
-Sue
On Mon, 31 Oct 2005 14:59:54 +1100, "Yifei"
<yjiang@.sdg.aust.com> wrote:

>Hi, All,
>I got a problem with linked server, I cannot fix it, if anyone can help will
>be appreciated.
>The problem is two instance of sql server in one machine, A and B, in A made
>a linked server to B. and a view in A. actually I can view the data from
>view, but I can not update from view. I get error message:
>7395, "42000", [microsoft][odbc sql server driver] unable to start a nested
>transation for ole db provider 'sqloledb'. A nested transaction was required
>because the xact_abort option was set to off.
>7312, "01000" [microsoft][odbc sql server driver] [sql server] [ole/db
>provider"] 'sqloledb' ITransationlocal::starttransaction returned
>0x8004d013:isolevel=1048576
>Thanks
>Yifei
>
|||It works, thanks Sue
Yifei
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:g5pem19r6401plkh1741bbt1at0bkvhi71@.4ax.com... [vbcol=seagreen]
> On the client where you are trying to update the view, try
> executing: SET XACT_ABORT ON
> before doing the update.
> -Sue
> On Mon, 31 Oct 2005 14:59:54 +1100, "Yifei"
> <yjiang@.sdg.aust.com> wrote:
will[vbcol=seagreen]
made[vbcol=seagreen]
nested[vbcol=seagreen]
required
>

Can not update from view of linked server

Hi, All,
I got a problem with linked server, I cannot fix it, if anyone can help will
be appreciated.
The problem is two instance of sql server in one machine, A and B, in A made
a linked server to B. and a view in A. actually I can view the data from
view, but I can not update from view. I get error message:
7395, "42000", [microsoft][odbc sql server driver] unable to start a
nested
transation for ole db provider 'sqloledb'. A nested transaction was required
because the xact_abort option was set to off.
7312, "01000" [microsoft][odbc sql server driver] [sql server] &
#91;ole/db
provider"] 'sqloledb' ITransationlocal::starttransaction returned
0x8004d013:isolevel=1048576
Thanks
YifeiOn the client where you are trying to update the view, try
executing: SET XACT_ABORT ON
before doing the update.
-Sue
On Mon, 31 Oct 2005 14:59:54 +1100, "Yifei"
<yjiang@.sdg.aust.com> wrote:

>Hi, All,
>I got a problem with linked server, I cannot fix it, if anyone can help wil
l
>be appreciated.
>The problem is two instance of sql server in one machine, A and B, in A mad
e
>a linked server to B. and a view in A. actually I can view the data from
>view, but I can not update from view. I get error message:
>7395, "42000", [microsoft][odbc sql server driver] unable to start
a nested
>transation for ole db provider 'sqloledb'. A nested transaction was require
d
>because the xact_abort option was set to off.
>7312, "01000" [microsoft][odbc sql server driver] [sql server]
[ole/db
>provider"] 'sqloledb' ITransationlocal::starttransaction returned
>0x8004d013:isolevel=1048576
>Thanks
>Yifei
>|||It works, thanks Sue
Yifei
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:g5pem19r6401plkh1741bbt1at0bkvhi71@.
4ax.com...
> On the client where you are trying to update the view, try
> executing: SET XACT_ABORT ON
> before doing the update.
> -Sue
> On Mon, 31 Oct 2005 14:59:54 +1100, "Yifei"
> <yjiang@.sdg.aust.com> wrote:
>
will[vbcol=seagreen]
made[vbcol=seagreen]
nested[vbcol=seagreen]
required[vbcol=seagreen]
>