I'm trying to deploy SQL Server 2005 in a hosted environment. I've looked at
this:
http://groups.google.dk/group/microsoft.public.sqlserver.programming/browse_thre
ad/thread/c25898c37cabd79b/10190ac4a993b51b?lnk=st&q=%22VIEW+ANY+DATABASE%22&rnu
m=1&hl=da#10190ac4a993b51b
and tried to ...

I am still naive to the security when it comes to keys and certificates.
Are there any valid articles with examples on how to set it and use it with
SQL 2005 ?
Thanks

Are the patches released for slammer rolled into service pack 4 or do you
need to apply the update to update the selected files selected by the
slammer worm?

I have some ASP.NET 2.0 code executing
SqlDependency.Start(connectionstring) to a SQL 2005 database and I am
getting the following error:
System.Data.SqlClient.SqlException: The specified schema name "dbo"

Came across the following on best practises as well
" Use the SQL Server service account to encrypt database files with EFS."
How do you set it up ?

After the command : " xp_sqlagent_proxy_account N'Del'"
I get the following errormessage :
The system cannot find the path specified.
Can anybody explain what is happening?

Our current backup process writes backup to a network drive and that is
transferred to a DVD on a daily basis.  How can we prevent people from
installing this backup on the DVD if the DVD is ever stolen?  Can the
backups be "password protected" or restricted to prevent ...

I have a sql box which is getting loads of login attempts from the sam ip
address. I cannot see where to block ip addresses, windows firewall does not
have usch an option -  any body know how.  or should i use some other host
based protection?

I was comparing two tables using a BINARY_CHECKSUM(*) function across the
rows when I ran into a problem. When one of my tables happened to have a
TEXT column in it, the query calculating the BINARY_CHECKSUM(*) pegged the
CPU at 100% and wouldn't let go, even when I killed Query ...

We have connection with sql server 2000 with front end visual foxpro 9 in
which we gave rights to user and install front end exe in client computer is
there any possibility that outsider can hack our server. how it possiblity
pls tell

I have users who currently query a SQL database using Access and an odbc
connection.  The database is being moved to a less secure server, and we are
looking for the best way for users to connect to this database so they can
do their own queries.  They like Access because they ...

To whom might be able to help me:
STORY:
I work in a stevedor terminal in the Autonomous port of Barcelona.  
Every time operations on a vessel are closed (instruction from software) an

Came across this on the checklist for best practises
     Enable security auditing
    . Enable security auditing of Sysadmin actions, fixed role membership
changes, all login related activity, and password changes.

Where can I get some basic info on what SSL is ? I have seen that one can
connect to SQL using SSL but dont know what SSL is to begin with

I need to start encrypting several fields in a database and have been doing
some testing with a test database first.  I've run into problems when
attempting to restore the database on either the same server (but different
database) or to a separate server.