> I ran select @@version and I have SP3 on where I believe this option was
> implented

"aaj" <a.b@c.com> wrote in message
news:40f3c990$0$641$afc38c87@news.easynet.co.uk...
> Hi all
>
> I had some info on setting db owners and chaining so I can execute a
dtsrun
> (many thanks to Dan for that)
>
> I have taken the comments on board and done some more research on the
> internet, but I'm still struggling.
>
> I am testing this on my personal edition, but when I run
>
> EXEC sp_dboption 'my dbname', 'db chaining', true
>
> it tells me that the SP doesn't accept the option db chaining.
>
> I ran select @@version and I have SP3 on where I believe this option was
> implented
>
> can anyone give me any further pointers.
>
> many thanks for any help
>
> Andy
>
>
>

"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:NwQIc.1043$mL5.1033@newsread1.news.pas.earthlink.net...
> > I ran select @@version and I have SP3 on where I believe this option was
> > implented
>
> Yes, cross-database chaining options were introduced in SQL Server SP3.
> These weren't configurable pre-SP3 and were always on in SQL 7 through SQL
> 2000 SP3.
>
> The info returned from @@VERSION is a bit encryptic and shows both the SQL
> Server version/build number as well as the OS version and service pack
> level. If you have SQL SP3 installed, the first line of the @@VERSION
> should contain 8.00.760 or higher. You might also check the results of
the
> following:
>
> SELECT SERVERPROPERTY('ProductLevel')
>
> This will report SP3 if you have that service pack installed.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "aaj" <a.b@c.com> wrote in message
> news:40f3c990$0$641$afc38c87@news.easynet.co.uk...
> > Hi all
> >
> > I had some info on setting db owners and chaining so I can execute a
> dtsrun
> > (many thanks to Dan for that)
> >
> > I have taken the comments on board and done some more research on the
> > internet, but I'm still struggling.
> >
> > I am testing this on my personal edition, but when I run
> >
> > EXEC sp_dboption 'my dbname', 'db chaining', true
> >
> > it tells me that the SP doesn't accept the option db chaining.
> >
> > I ran select @@version and I have SP3 on where I believe this option was
> > implented
> >
> > can anyone give me any further pointers.
> >
> > many thanks for any help
> >
> > Andy
> >
> >
> >
>
>