I have a few refs:

BOL:Placing Tables on Filegroups

BOL:Using Files and Filegroups

Inside SQL Server - Doesn't really discuss, but recommends not too unless advanced DBA, knowedg of DB, etc. Does note...

I'd apply the KISS principle. Setup two tasks and let one grab records for TableA, ignoring other records. Let the 2nd grab records for TableB and ignore the others. Might...

One thing I have read, but not tested, is that mutliple filegroups improve IO as a separate thread is created for each file. This can have some benefits for splitting...

I agree with Brian. That's how we do it here to limit liabilities in production. Of course, our manager also does development and can be a maverick.

...

Even if it's a hash, since it can be duplicated, there has to be a way to decrypt it. Nobody has spent the time to do it, including myself, though...

Two things on the maintenance plan:

1. I have had problems with the integrity checks failing. I will try Brian's solution and see if this is the issue.

2. When it fails,...

Couple things:

BULK INSERT does work for native mode:

Run this on a server:

bcp Northwind.dbo.Customers out c:\NWTest.txt -n -T

Then create a copy of the Customers table on another server (or same). Should...

I am split here.

I think change control is critical and dev people (DBAs, programmers, etc) should not change production. I know someone has to wear both hats (I know I...

The best solution, IMHO, is to use one of the commercially available and readily known encrpytion algorithms. They biggest part of the encryption is the key. Keep in mind that...

I've had a sproc that will decrypt SPs, triggers, views, etc.

It is a deterrent, but not follproof. A good DBA and compentent Internet snooper will crack the code.

Steve Jones

steve@dkranch.net

Can you post some code?

Steve Jones

steve@dkranch.net

this is (theoretically) correct. The way backups work, is that once you start, you want a backup of every page in it's state when the backup STARTS. This way you...

Have you changed any security settings within SQL Server?

Do SQLServer and SQL Agent run under the same account?

Steve Jones

steve@dkranch.net

Can you use SMTP and have Exchange forward to Lotus? If you can get Exchange to forward, that is the best solution.

Check out this article:

http://support.microsoft.com/support/kb/articles/Q263/5/56.ASP?LN=EN-US&SD=gn&FR=0&qry=sqlmail&rnk=24&src=DHCS_MSPSS_gn_SRCH&SPR=SQL

You can use Lotus, but it...

Need to see some of the code for the sp.

Steve Jones

steve@dkranch.net