Just to clarify, I said that I never give or display customer data to another customer. But re-creating a relational dataset from scratch is not a trivial task for a...

During my search for obfuscation methods, I ran across this article written by an Oracle person, you might find it interesting:

http://www.jaredstill.com/downloads/Data_Obfuscation_and_Encryption.doc

One of the topics covered is how to present data...

Thanks to everybody who responded, especially Adrian - very clever idea using the placeholders. I had no idea how to approach selectively replacing 1, 2 or 3 letter combinations without...

Steve,

Last week you suggested that we all vote for SP3, so I visited the web site. I already have a Windows Live ID and I am even a registered MS...

Here is one method to locate the bad record - using Access, open the table and loop thru all the records & print all the fields to the Immediate window....

If you have a corrupted memo field, compact & repair cannot fix that.

The usual fix is to locate the bad record, copy all fields from that record except the...

Hello Igor,

I routinely take backups from production & restore to up to four dev servers with different hardware & OS. I created this script in master on each of the...

Whitey,

Are you talking about using sp_addumpdevice to create a logical backup device? For example, in SS2000 you might use

EXEC sp_addumpdevice 'disk', 'par_pos_1', 'C:\Program Files\Microsoft SQL Server\MSSQL$STATION9\BACKUP\wm_par_pos.bak'

...and then you would backup...

Here are two short articles that might help.

This link describes a very simple Access crosstab and how to re-create in either SQL 2000 or 2005:

http://wvmitchell.blogspot.com/2007_03_01_archive.html

This link describes a simple 2005...

So what types of things don't work at level 9.0?

I don't have access to the vendor's technical staff, so I'm just guessing what could be wrong. I'm surprised that it...

Proving compliance can be extremely difficult for large companies, especially those that have grown thru mergers and acquisitions. The companies being acquired may not have adequate documentation for their software...

Thank you Andrew, that is exactly the kind of data I was looking for.

Bill

Steve, thanks for the quick reply.

I did some more digging, and the answer is: human error. I suppose I give people more credit than they deserve (no pun intended).

One member...

Unfortunately, 3rd-party apps will only get worse, and MS has to share the blame. Check out this article "SQL Server '08 Adds Dev Perks" from the December 1, 2007 issue...

Matt, as far as Access 2007, you can still create a table with a Yes/No field that does not have a default value, but as you said when you create...