Thanks for all the replies.  I think I now have a better idea of what to do. 

Well…I was thinking along the same idea that John Rowan suggested but I also wanted to take SQL Oracle’s suggestion into consideration.  However, I do want to make it...

Alright…here is some more detail and a correction to my original post.

The correction is that the database actually has 1 filegroup which is spread over 2 disks. ...

alright I figured it out.  I was missing the field name parameter in filegroup defination in create table script.

Thanks.

Raj,

I assume you want to see the encrypted data.  You can simply run select query...

Thanks everyone.  It will help.

My SQL Server is pretty secure but I have heard from...

Thanks Raj, that helps.

So, if I remove BUILTIN\Administrators, I do not have to worry about this right?  Also, what is xstatus 64?

Thanks Raj, that helps.

So, if I remove BUILTIN\Administrators, I do not have to worry about this right?  Also, what is xstatus 64?

I have used LiteSpeed from Imceda in the past and it works great

Do select @@version.  Compare the result to the following list

8.00.194 - Microsoft SQL Server 2000

8.00.384 - Microsoft SQL Server 2000 SP1

8.00.532 - Microsoft SQL Server 2000 SP2

8.00.760...

I was able to use sp_trace_create and sp_trace_setevent to collect the user login and logout information.  The trace runs fine when windows authentication is used. ...

Being the "low on attention to detail" person I am, I would have certainly missed this one if 11 was one of the choices.  Good...I get 21 points

Thanks...seems like I will have to do the same thing you did.  Does anyone know if SQL Server 2005 has something to audit logins?

Well...I blindly clicked on SQLServerCentral.com as an answer a few days ago when asked which is the best source of news for SQL Server.  Guess what...I got it wrong.  When...

Thats not it.  I created the package and I am the one importing it.  The SQL Server uses windows authentication so I don't see a permissions issue.