SQL Server 2008 and Security

[Steffi1013]

Has anyone started working with the CTP version of SQL Server 2008?? What are the security benefits? Anything really great in the security area ??

I have been trying to find some good info on the security features/"bells and whistles" about 2008

 

[mrdenny]

So far the security appears to be mostly the same as SQL Server 2005. However I haven't dug into it that much ... yet.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[paskuda]

I have SQL Server 2008 CTP installed but haven't tested any of the new features yet.Some of them are, or at least seem to be, pretty interesting. Transparent data encryption is one of them, MS states that it will be possible to encrypt whole database, data files or log files transparently to users - which also means no applications' modifications. I agree with mrdenny though - so far it doesn't seem so much different from SQL Server 2005.