Setting one up myself currently, Edwin Sarmiento has a great 4 part article.

http://www.mssqltips.com/tip.asp?tip=1687

as far as calculations you could try a linear growth

which is just a projected amount of...

That is a very good point, of the databases that i have encrypted not only does it nix compression, but it increases the size of the database as well. ...

Thanks all for the replies. I really appriceate it!

Anybody, is this news to you, have you known it forever? please just looking for some info

I don't dispute that for a second, however unless you are in a small shop most places have a network team that would prepare the out defenses and would establish...

Agreed.

If someone has access where they can query the database TDE does nothing, you could encrypt columns within the tables themselves and that would obscure the view. then you...

I have a SQL 2K SP 3a cluster I just inherited, for business reasons i have to put off the upgrade to SP 4 until this weekend. (yeah i know...

I added the MySQL ODBC drive 5.1, then I created a Linked server using the Microsoft OLE DB Provider for OdBC Drivers.

I didn't use BIDS to make this...

Okay so I figured this one out but have a new question, I should have done this sooner, but I ran profiler, and executed the job and watched. And...

The error I get when i try to impersonate or execute as in the stored procedure is that I do not have permissions to use that account on the remote...

it was actually around 1600 - 65500

I figured out how to conenct using an ODBC connection, but now I cannot figure out how to get a datasource to use that odbc connection.

Has anyone ever...

you've got several options, depending on the version you've got and what tools you can install on your local desktop.

Activity Monitor, but it doesn't auto refresh in 2000, you set...

Forcing users to set strong passwords is determined (in and Active Directory Domain) at the Domain Controller. If you have access to your Domain Controller then you can set...

Agreed.

I remember in SQL 2000 that you could detach or take offline a db, and when you reattached it or brought it back online if you moved the log file...