audit trial

Hi ,
We can do audit trial through triggers in sql server , but oracle itself
having one feature for audit trialing with out using triggers, can any one
suggests me whether its possible in sql server with out using triggers.
With SQL Server tools, you can use Profiler.
There are some 3rd party tools, for example Entegra from Lumigent
(http://www.lumigent.com/).
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"sekhar" <sekhar@.discussions.microsoft.com> wrote in message
news:072C59CD-A1DF-4BF3-BC02-33FFFA0F15CF@.microsoft.com...
> Hi ,
> We can do audit trial through triggers in sql server , but oracle itself
> having one feature for audit trialing with out using triggers, can any one
> suggests me whether its possible in sql server with out using triggers.
|||Hi,
Also see .. C2 Auditing.
C2 Auditing option to review both successful and unsuccessful attempts to
access statements and objects. See books online for
more details.
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:eyNCQ41gEHA.4092@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> With SQL Server tools, you can use Profiler.
> There are some 3rd party tools, for example Entegra from Lumigent
> (http://www.lumigent.com/).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "sekhar" <sekhar@.discussions.microsoft.com> wrote in message
> news:072C59CD-A1DF-4BF3-BC02-33FFFA0F15CF@.microsoft.com...
one
>

audit trial

Hi ,
We can do audit trial through triggers in sql server , but oracle itself
having one feature for audit trialing with out using triggers, can any one
suggests me whether its possible in sql server with out using triggers.With SQL Server tools, you can use Profiler.
There are some 3rd party tools, for example Entegra from Lumigent
(http://www.lumigent.com/).
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"sekhar" <sekhar@.discussions.microsoft.com> wrote in message
news:072C59CD-A1DF-4BF3-BC02-33FFFA0F15CF@.microsoft.com...
> Hi ,
> We can do audit trial through triggers in sql server , but oracle itself
> having one feature for audit trialing with out using triggers, can any one
> suggests me whether its possible in sql server with out using triggers.|||Hi,
Also see .. C2 Auditing.
C2 Auditing option to review both successful and unsuccessful attempts to
access statements and objects. See books online for
more details.
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eyNCQ41gEHA.4092@.TK2MSFTNGP10.phx.gbl...
> With SQL Server tools, you can use Profiler.
> There are some 3rd party tools, for example Entegra from Lumigent
> (http://www.lumigent.com/).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "sekhar" <sekhar@.discussions.microsoft.com> wrote in message
> news:072C59CD-A1DF-4BF3-BC02-33FFFA0F15CF@.microsoft.com...
> > Hi ,
> > We can do audit trial through triggers in sql server , but oracle itself
> > having one feature for audit trialing with out using triggers, can any
one
> > suggests me whether its possible in sql server with out using triggers.
>

audit trial

Hi ,
We can do audit trial through triggers in sql server , but oracle itself
having one feature for audit trialing with out using triggers, can any one
suggests me whether its possible in sql server with out using triggers.With SQL Server tools, you can use Profiler.
There are some 3rd party tools, for example Entegra from Lumigent
(http://www.lumigent.com/).
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"sekhar" <sekhar@.discussions.microsoft.com> wrote in message
news:072C59CD-A1DF-4BF3-BC02-33FFFA0F15CF@.microsoft.com...
> Hi ,
> We can do audit trial through triggers in sql server , but oracle itself
> having one feature for audit trialing with out using triggers, can any one
> suggests me whether its possible in sql server with out using triggers.|||Hi,
Also see .. C2 Auditing.
C2 Auditing option to review both successful and unsuccessful attempts to
access statements and objects. See books online for
more details.
Thanks
Hari
MCDBA
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eyNCQ41gEHA.4092@.TK2MSFTNGP10.phx.gbl...
> With SQL Server tools, you can use Profiler.
> There are some 3rd party tools, for example Entegra from Lumigent
> (http://www.lumigent.com/).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "sekhar" <sekhar@.discussions.microsoft.com> wrote in message
> news:072C59CD-A1DF-4BF3-BC02-33FFFA0F15CF@.microsoft.com...
one[vbcol=seagreen]
>

Attaching Database 'AdventureWorks'

Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
Steve
IT Developer
You have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:290AD911-24FA-419B-8A26-636CC009B189@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>

Attaching Database 'AdventureWorks'

Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
Steve
IT Developer
You have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>

Attaching Database 'AdventureWorks'

Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following error.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
--
Steve
IT DeveloperYou have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>

Attaching Database 'AdventureWorks'

Hi,
I have installed SQL Server 2005 CTP/Trial Version.
When I try to attach the database 'AdventureWorks', I get the following erro
r.
Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
Run DBCC
CHECKTABLE on sysindexes
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
I also tried suggestions in BooksOnline but it didn't help.
Please advise how to attach the database.
Thanks a lot
--
Steve
IT DeveloperYou have asked this question in four different places that I have seen and
have already gotten a response. Please do not multipost.
Thanks!
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F507C579-89CA-40F4-BC9A-F0233C2B7F08@.microsoft.com...
> Hi,
> I have installed SQL Server 2005 CTP/Trial Version.
> When I try to attach the database 'AdventureWorks', I get the following
> error.
> Could not find row sysindexes for database ID 11, Object ID 1, index ID 1.
> Run DBCC
> CHECKTABLE on sysindexes
> Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
> I also tried suggestions in BooksOnline but it didn't help.
> Please advise how to attach the database.
> Thanks a lot
> --
> Steve
> IT Developer
>