SQL 2000 SP 3a. - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL 2000 SP 3a.

Author

Topic

admin001
Posting Yak Master

166 Posts

Posted - 2003-08-30 : 01:14:21

Hi ,

I was just installing SQL 2000 SP 3a on my test SQL server before deploying it on a production servers . During the service pack installation , i came across a message whether if i would like have database cross-check enabled or let SP 3a rebuild the system catalogs .

I am not sure what does this message means and would like to have your suggestions if anyone has come across this message .

Will it affect any databases which are working on SP 2 currently ?
Will it have any other impact if i just select to rebuild system catalogs ? Which option should i select ? I did not find anything on this in BOL .

Thanks .

nr
SQLTeam MVY

12543 Posts

Posted - 2003-08-30 : 01:35:01

Is it cross database ownership chaining?

It means that permissions allocated in one database can be used for permissions in another e.g. an SP accessing a table in another database.
Sounds like you had this option on and it is asking whther you still want it.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

admin001
Posting Yak Master

166 Posts

Posted - 2003-08-30 : 01:54:12

Thanks NR ,

Yes precisely it is cross database ownership chaining .

Then it that case it is better to select that option during the SP3a upgrade rather than going for rebuilding the entire catalogs .

Where can i see that option set ? Is there any way to check that ?

Thanks once again .

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2003-08-30 : 11:09:19

cross database chaining is a new security feature w/SP3. It has nothing to do with rebuilding text catalogs. SP3 installation requires all full text catalogs be rebuilt. there are several technet articles on this http://support.microsoft.com/default.aspx?scid=kb;en-us;327217 and http://support.microsoft.com/default.aspx?scid=kb;en-us;811064

Another quick search of technet finds this article on cross database chaining http://support.microsoft.com/default.aspx?scid=kb;EN-US;810474

-ec

admin001
Posting Yak Master

166 Posts

Posted - 2003-08-31 : 21:32:06

Thanks Eyechart . The links will be very useful to me . I will go through the docs before i implement it on Prod.servers .

Thanks to all for your help.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources