Just FYI I am testing two SQL Encryption packages, once called NetLIB and the other SecureData (by Protegrity). Both promise do do column-level encryption.

From the limited response to this...

Same question about system tables.

DBCC SHOWCONTIG scanning 'sysindexes' table...

Table: 'sysindexes' (2); index ID: 1, database ID: 21

TABLE level scan performed.

- Pages Scanned................................: 54

- Extents Scanned..............................: 13

- Extent Switches..............................: 43

- Avg....

Keneth,

Thanks for the reply but I thought the date of '01/23/12' will INSERT into a table as January 1, 2012. That is definitely not my date: "01/23/1234".

TIA,

Bill 

Good thoughts, Rockmoose and Steve.

We have a team of developers that use views and stored procs in the same DB. I don't understand, and I will ask them tomorrow, why they...

"Using Named Pipes depending on the configuration can be slower...."

Can anyone elaborate on the statement "depending on the configuration"? What types of configs can slow down named pipes?

TIA,

Bill

Thanks Douglas, I'll "take a look".

Bill

Antares686,

If you will, please post your SQL-DMO for the tables and indexes. May save me a lot of work and if I expand upon it in any significant way I'll...

Thanks to everyone for your great replies!

Bill

Thanks to everyone for their replies.

I'm embarassed to tell you what I found out!  The sql agent runs under a domain "service account" and, given that auditors visit us often,...

Believe it or not -- it's a file device!

Bill

Thank you for all the great replies. Obviously, I thought the original problem was simply a "use DTS" one so I put it in the forum. I didn't realize that there were...

Peter,

Thanks. I am not that familar with Access. I ran the upsizing wizard as you suggested and it seemed to go well but the Sql dataabse is only 25MB in size,...

I haven't yet found the source of the problem but thank everyone for their thoughts!

Bill

Ray,

They will provide us will all needed text files (may include CSV, fixed field, XML). The problem is not getting the files but handling all the different formats once we...

Unfortunately, I don't know the exact answer BUT as I said in my earlier posting, my experience matches yours. I believe that Win 2003 has certain RPC functionality disabled that is...