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

In v6.5, sysobjects in tempdb would get locked and cause problems. This is les problematic in v7/2000, but you should still avoid this if there is another way to rewrite...

BE sure you have the proper spacing included in your strings. Looks like you are missing a space. Try a response.write(strCriteria) and see what is returned. Be sure this is...

Can you post more information and sample code?

Steve Jones

steve@dkranch.net

I work like Brian. One backup only locally and then 2 days remotely.

The remote backups are on tape within 20 minutes of being copied.

I use FTP because it is the...

One more things:

Keep the Server patched, but test the patches elsewhere. Most downtime will come from poor QA and poor change control.

Steve Jones

steve@dkranch.net