Database Encryption

What version of SQL Server, 2000 or 2005..?
HTH. Ryan
"Imran Aziz" <imran@.tb2.net> wrote in message
news:Omk%23c3gjGHA.1552@.TK2MSFTNGP03.phx.gbl...
> Hello All,
> Is there a built-in way that one can encrypt and decrypt data in SQL
> Server tables. My client wants all data in the database encrypted so that
> even the system admins doing backups cannot view the sensitive data.
> Any suggestions or solutions will be greatly appreciated.
> Thanks a lot,
> Imran.
>
>Hello Ryan thanks for your response. I will be using SQL Server 2005,
googling around I can see that SQL Server 2005 has this option , but I
cannot seem to see how to work with it in our install of SQL Server 2005.
In addition the current database is in SQL Server 2000 which I will
transfer to SQL Server 2005 and then would like to encrypt all existing data
in the database.
Of some info that I have found till now, it seems that one has to set the
encryption up for a database table on creation (although could not find it
in my SQL server 2005)
but will SQL Server 2005 encrypt existing data in tables ?
Thanks a lot,
Imran.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eZmEVchjGHA.1600@.TK2MSFTNGP04.phx.gbl...
> What version of SQL Server, 2000 or 2005..?
> --
> HTH. Ryan
>
> "Imran Aziz" <imran@.tb2.net> wrote in message
> news:Omk%23c3gjGHA.1552@.TK2MSFTNGP03.phx.gbl...
>|||Hello All,
Is there a built-in way that one can encrypt and decrypt data in SQL
Server tables. My client wants all data in the database encrypted so that
even the system admins doing backups cannot view the sensitive data.
Any suggestions or solutions will be greatly appreciated.
Thanks a lot,
Imran.|||What version of SQL Server, 2000 or 2005..?
HTH. Ryan
"Imran Aziz" <imran@.tb2.net> wrote in message
news:Omk%23c3gjGHA.1552@.TK2MSFTNGP03.phx.gbl...
> Hello All,
> Is there a built-in way that one can encrypt and decrypt data in SQL
> Server tables. My client wants all data in the database encrypted so that
> even the system admins doing backups cannot view the sensitive data.
> Any suggestions or solutions will be greatly appreciated.
> Thanks a lot,
> Imran.
>
>|||Hello Ryan thanks for your response. I will be using SQL Server 2005,
googling around I can see that SQL Server 2005 has this option , but I
cannot seem to see how to work with it in our install of SQL Server 2005.
In addition the current database is in SQL Server 2000 which I will
transfer to SQL Server 2005 and then would like to encrypt all existing data
in the database.
Of some info that I have found till now, it seems that one has to set the
encryption up for a database table on creation (although could not find it
in my SQL server 2005)
but will SQL Server 2005 encrypt existing data in tables ?
Thanks a lot,
Imran.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eZmEVchjGHA.1600@.TK2MSFTNGP04.phx.gbl...
> What version of SQL Server, 2000 or 2005..?
> --
> HTH. Ryan
>
> "Imran Aziz" <imran@.tb2.net> wrote in message
> news:Omk%23c3gjGHA.1552@.TK2MSFTNGP03.phx.gbl...
>

Database Diagram in VS 2005 for SQL Express 2005

I have installed VS 2005 (Beta 2.050215-4400) and SQL Server 2005 CTP (File Version 9.00.1187.07).

I can connect to the SQLEXPRESS database and created tables from the VS 2005. But when I try to click the + to expand the database diagram folder I get the following window:
Microsoft Visual Studio

This server does not have one or more of the database objects required to use database diagramming. Do you wish to create them?

Yes No Help
After I select yes, I get the following error message:

Microsoft Visual Studio

Could not obtain information about windows NT group/user 'xxxx/xxxx', error code 0x5.

OK

The + next to the database diagrams folder disappears. I select the "Add new diagram" menu item from the database diagram folder. I able to add tables to the database diagram. But when I try to save the database diagram, I get the following error message:

Microsoft Visual Studio

(Exception from HRESULT: 0x80131904)

OK
Does any one know why?

This is a pretty old build of VS (Feb) and I believe we still had some issues back then.

Database Corrupted, Need help recovering data from LDF file

A friend of mine called and said that his database was suspect and he detached it and was unable to attach it. The SQL Server Version is 2000 with the latest service packs installed. When I checked it the database (MDF) size was 1MB and the LDF size was 3.8 GB. I was not able to attach the two together and I was not able to attach the database using sp_attach_single_file_db. I did find an old backup of his database and attached that so he can work off of it but it is 1 yr old and he needs recent data. Since the MDF seemed to be blank we cant do much with that, but there seems to be data in the LDF. Is it possible to extract any data from the LDF file?

SunnyThe log file contains low level physical changes that are almost impossible to correlate with user objects without the metadata in the data files.

Database Corrupted, Need help recovering data from LDF file

A friend of mine called and said that his database was suspect and he detached it and was unable to attach it. The SQL Server Version is 2000 with the latest service packs installed. When I checked it the database (MDF) size was 1MB and the LDF size was 3.8 GB. I was not able to attach the two together and I was not able to attach the database using sp_attach_single_file_db. I did find an old backup of his database and attached that so he can work off of it but it is 1 yr old and he needs recent data. Since the MDF seemed to be blank we cant do much with that, but there seems to be data in the LDF. Is it possible to extract any data from the LDF file?

SunnyThe log file contains low level physical changes that are almost impossible to correlate with user objects without the metadata in the data files.