List of SQL Server Proprietary Data Types?

Could someone point me to a list of SQL Server proprietary data types? Tried
searching this forum and the web but couldn't find a full published list.
Thanks.
NaveenTry,
select [name]
from master.dbo.systypes
go
AMB
"Naveen" wrote:

> Could someone point me to a list of SQL Server proprietary data types? Tri
ed
> searching this forum and the web but couldn't find a full published list.
> Thanks.
> Naveen|||That seems to be a list of all data types in SQL Server. I should have been
more clear. I meant non-ANSI compliant datatypes in SQL Server.
"Alejandro Mesa" wrote:
> Try,
> select [name]
> from master.dbo.systypes
> go
>
> AMB
> "Naveen" wrote:
>|||So, get a list of ANSI data types, and say:
SELECT [name] FROM master.dbo.systypes
WHERE [name] NOT IN ('type1', 'type2', etc)
Obviously, SQL Server doesn't have a flag called ANSI_COMPLIANT...
A
"Naveen" <Naveen@.discussions.microsoft.com> wrote in message
news:67059C80-35BA-4251-AB3F-0E442E582F2A@.microsoft.com...
> That seems to be a list of all data types in SQL Server. I should have
> been
> more clear. I meant non-ANSI compliant datatypes in SQL Server.
> "Alejandro Mesa" wrote:
>|||Some info here:
http://www.karaszi.com/SQLServer/in...i_datatypes.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Naveen" <Naveen@.discussions.microsoft.com> wrote in message
news:498D2709-8186-4F4D-88E1-9B5CAACA3D65@.microsoft.com...
> Could someone point me to a list of SQL Server proprietary data types? Tri
ed
> searching this forum and the web but couldn't find a full published list.
> Thanks.
> Naveen

List of Packaged XP's

Hi All
Can somebody point me to where i can find a list (including what they do
with parameters) of all the Sp's and XP's that come with SQL 2000
Thanks
RegIn Books Online, look in the index for "system stored procedures, listed".
There are more SPs and XPs shipped with SQL Server than are listed there,
but these undocumented procedures can change without warning with a new
version, service pack or hotfix and use is at your own risk.
--
Jacco Schalkwijk
SQL Server MVP
"Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
news:JO-dnQYtM7TTyhyiU-KYhw@.is.co.za...
> Hi All
> Can somebody point me to where i can find a list (including what they do
> with parameters) of all the Sp's and XP's that come with SQL 2000
> Thanks
> Reg
>|||Probably the best reference for this is SQL Server Books
Online. Just go through the help file's index reviewing
sp_xxx and xp_xxxx.
-Sue
On Mon, 6 Oct 2003 13:53:49 +0200, "Reg Besseling"
<reg.usenet.nospam@.epic-sc.com> wrote:
>Hi All
>Can somebody point me to where i can find a list (including what they do
>with parameters) of all the Sp's and XP's that come with SQL 2000
>Thanks
>Reg
>|||Thanks - I was searching for xp_qv
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:elkk$cAjDHA.1956@.TK2MSFTNGP12.phx.gbl...
> In Books Online, look in the index for "system stored procedures, listed".
> There are more SPs and XPs shipped with SQL Server than are listed there,
> but these undocumented procedures can change without warning with a new
> version, service pack or hotfix and use is at your own risk.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
> news:JO-dnQYtM7TTyhyiU-KYhw@.is.co.za...
> > Hi All
> >
> > Can somebody point me to where i can find a list (including what they do
> > with parameters) of all the Sp's and XP's that come with SQL 2000
> >
> > Thanks
> >
> > Reg
> >
> >
>|||Some information about xp_qv courtesy of Microsoft employee Gert Drapers:
"xp_qv, hosted in xpsqlbot.dll is a wrapper around functionality in
sqlboot.dll, which returns information about the SKU type, licensing etc
It is not documented that is why you can not find a reference.
I should be getting called very infrequently and as far as I know it only
visits the Registry"
Jacco Schalkwijk
SQL Server MVP
"Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
news:_cudnaOFzsXY5ByiU-KYiQ@.is.co.za...
> Thanks - I was searching for xp_qv
> "Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
> news:elkk$cAjDHA.1956@.TK2MSFTNGP12.phx.gbl...
> > In Books Online, look in the index for "system stored procedures,
listed".
> >
> > There are more SPs and XPs shipped with SQL Server than are listed
there,
> > but these undocumented procedures can change without warning with a new
> > version, service pack or hotfix and use is at your own risk.
> >
> > --
> > Jacco Schalkwijk
> > SQL Server MVP
> >
> >
> > "Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
> > news:JO-dnQYtM7TTyhyiU-KYhw@.is.co.za...
> > > Hi All
> > >
> > > Can somebody point me to where i can find a list (including what they
do
> > > with parameters) of all the Sp's and XP's that come with SQL 2000
> > >
> > > Thanks
> > >
> > > Reg
> > >
> > >
> >
> >
>|||Thanks for the prompt help
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:ux78ncBjDHA.2336@.TK2MSFTNGP11.phx.gbl...
> Some information about xp_qv courtesy of Microsoft employee Gert Drapers:
> "xp_qv, hosted in xpsqlbot.dll is a wrapper around functionality in
> sqlboot.dll, which returns information about the SKU type, licensing etc
> It is not documented that is why you can not find a reference.
> I should be getting called very infrequently and as far as I know it only
> visits the Registry"
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
> news:_cudnaOFzsXY5ByiU-KYiQ@.is.co.za...
> > Thanks - I was searching for xp_qv
> > "Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
> > news:elkk$cAjDHA.1956@.TK2MSFTNGP12.phx.gbl...
> > > In Books Online, look in the index for "system stored procedures,
> listed".
> > >
> > > There are more SPs and XPs shipped with SQL Server than are listed
> there,
> > > but these undocumented procedures can change without warning with a
new
> > > version, service pack or hotfix and use is at your own risk.
> > >
> > > --
> > > Jacco Schalkwijk
> > > SQL Server MVP
> > >
> > >
> > > "Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
> > > news:JO-dnQYtM7TTyhyiU-KYhw@.is.co.za...
> > > > Hi All
> > > >
> > > > Can somebody point me to where i can find a list (including what
they
> do
> > > > with parameters) of all the Sp's and XP's that come with SQL 2000
> > > >
> > > > Thanks
> > > >
> > > > Reg
> > > >
> > > >
> > >
> > >
> >
> >
>

List of Audit Events for SQLServer

The documentation on SQLServer (both books and online) seems to have treated this as a need-to-know item.

Can someone point me where I should be looking for a complete list of the audit events that SQLServer would spit out.

The list for Sybase is easily found when you do a search for "audit" but nothing comes up for SQLServer.

Thanks in advance!1 If you are looking for additional information on error messages (1 - 21999)?? browse the BOL Contents as follows:

BOL Contents:
Troubleshooting:
Error Message Descriptions:
Resolving System Error Messages:
Errors 1 - 999
...
Errors 21000 - 21999

2 If interested in c2 audit mode there are MS white papers pertaining to the subject.

3 If interested in auditing using profiler or traces there is some information on both in BOL and there are MS resources pertaining to both subjects, (however not all trace flags or results are documented to users).

(Unfortunatly, reference links for 2 & 3 have been moved.)