Re: encrypting stored procedure
- From: "Ant Zucaro" <azucaro@xxxxxxxxx>
- Date: 17 Aug 2006 17:18:00 -0700
Never used DBCC? You should!
That's the be-all end-all command for managing the integrity of your
Sybase databases. All sorts of stuff is checked, depending on which
"flavor" of DBCC you choose to run. I would venture to guess that most
DBAs go for "dbcc checkstorage," but it requires a small amount of
setup. If you don't like that, probably "dbcc checkdb" could do well
too. If you have a fairly active database, do a DBCC on it often. As
your DB gets bigger and the checks get longer, you may want to make
them less frequent.
DBCC mainly makes sure that your indexes and pages are in proper order.
That's a lifesaver!
-Ant
Simon wrote:
Rob Verschoor wrote:
Those 'columns' are not accessbile through SQL. You'd have to extract the
hex stuff manually with dbcc page, and first figure out where to find it...
HTH,
Ive hunted through master.dat (from a test database) with a
hexeditor....
Never having used dbcc, what will it do for me?
Thanks
.
- References:
- encrypting stored procedure
- From: r . randhawa
- Re: encrypting stored procedure
- From: julien Touche
- Re: encrypting stored procedure
- From: Mikhail Teterin
- Re: encrypting stored procedure
- From: Simon
- Re: encrypting stored procedure
- From: Rob Verschoor
- Re: encrypting stored procedure
- From: Simon
- encrypting stored procedure
- Prev by Date: Re: problem with accented characters in a UTF8 ASA database
- Next by Date: Re: problem with accented characters in a UTF8 ASA database
- Previous by thread: Re: encrypting stored procedure
- Next by thread: BCp issue with ignore_dup_key
- Index(es):
Relevant Pages
|
|
