data encryption standards

Is there any organization with standards for SQL Server database encryption
software? Does anyone have any warnings/advice about evaluating 3rd party en
cryption products?Rule #1: Alway evaluate on a test box.
Other than that, I don't believe there is an organization with standards
specifically for SQL Server. You would most likely want to check out
www.nist.gov for general encryption standards. You will probably also want
to
get confirmation from the vendors you interview what standards their product
s
adhere to.
Here are several of the third party product usually mentioned:
Whamware.Crypt from www.whamware.com
ActiveCrypt from www.activecrypt.com
dbEncrypt from www.appsecinc.com
Enjoy!
Tom
"Dan P."
> Is there any organization with standards for SQL Server database encryption[/color
]
software? Does anyone have any warnings/advice about evaluating 3rd party
encryption products?

Data Dictionary

Is there any software available (preferably freeware but commercial an
option) to help me create a data dictionary for my database to help document
it?
Thanks
Keith,
I'm not aware of any free ones, but I like Embarcadero's ER/Studio to do
this work. However, it is quite expensive, but worth the money in my opinion
if you do a lot of database design work.
www.embarcadero.com
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Keith" <@..> wrote in message news:OanwEQpLEHA.340@.TK2MSFTNGP11.phx.gbl...
> Is there any software available (preferably freeware but commercial an
> option) to help me create a data dictionary for my database to help
document
> it?
> Thanks
>

Data Dictionary

Is there any software available (preferably freeware but commercial an
option) to help me create a data dictionary for my database to help document
it?
ThanksKeith,
I'm not aware of any free ones, but I like Embarcadero's ER/Studio to do
this work. However, it is quite expensive, but worth the money in my opinion
if you do a lot of database design work.
www.embarcadero.com
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Keith" <@..> wrote in message news:OanwEQpLEHA.340@.TK2MSFTNGP11.phx.gbl...
> Is there any software available (preferably freeware but commercial an
> option) to help me create a data dictionary for my database to help
document
> it?
> Thanks
>

Data Dictionary

Is there any software available (preferably freeware but commercial an
option) to help me create a data dictionary for my database to help document
it?
ThanksKeith,
I'm not aware of any free ones, but I like Embarcadero's ER/Studio to do
this work. However, it is quite expensive, but worth the money in my opinion
if you do a lot of database design work.
www.embarcadero.com
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Keith" <@..> wrote in message news:OanwEQpLEHA.340@.TK2MSFTNGP11.phx.gbl...
> Is there any software available (preferably freeware but commercial an
> option) to help me create a data dictionary for my database to help
document
> it?
> Thanks
>

Data Diagram Software

Hi SQL Gurus,
I have a database that has 250 tables. I need to a 3rd party software that
will generate data diagram for me. I used data diagram from sql but it is
useless with a huge amount of tables.
I would be nice if that 3rd party software can do other things more than
just generate data diagram.
Your suggestions are always highly regarded.
Vito Corleone
My personal choice is Visio for Enterprise Architects. It will do forward
and reverse database engineering as well as excellent diagramming. It also
is included in several MSDN products so you may already have a license for
it.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Vito Corleone" <VitoCorleone@.discussions.microsoft.com> wrote in message
news:7A80466D-2948-4775-94A8-70EC75C76AB5@.microsoft.com...
> Hi SQL Gurus,
> I have a database that has 250 tables. I need to a 3rd party software
> that
> will generate data diagram for me. I used data diagram from sql but it is
> useless with a huge amount of tables.
> I would be nice if that 3rd party software can do other things more than
> just generate data diagram.
> Your suggestions are always highly regarded.
> Vito Corleone

Data connection error - Please help

Thanks in advance to anyone that can help me with this.

We have software in a production environment that uses a DSN-Less connection to access an Access Database. The software was written in VB6 and uses MDAC 2.8

99% of customers have no issues with the software connecting the the database however once in while we encounter a customer that get's the following error:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Except for the DB path the rest of the connection string is hardcoded in the app so there is no difference in the name of the driver used on 99% of the working installations and the 1% that fail. The debug log returned by the customer shows that the following connection string is being used:

Driver={Microsoft Access Driver (*.mdb)};Uid=xxxx;Pwd=xxx;Dbq=C:\Windows\SomeSubDir\ourAccessDB;

We have verfied the following:

1. Our Access DB must be placed under a subdirectory of the main Windows directory. There is special reason for this but it would take too long to explain. However, I have confirmed that the database can be accessed and the user has full permissions on these folders. The can create new files in the same directory, etc.

2. Customer is running Windows XP SP2. Has MDAC 2.8 installed as well as the MS Jet SP8

3. Customer confirms that the entry "Microsoft Access Drive (*.mdb)" shows up in the driver tab of the ODBC panel.

4. I have discovered that I can only reproduce that error on our development systems if I change the connection string to use a driver that doesn't exist (e.g. Driver={Mosoft Access Driver (*.mdb)}

5. Latest users states that this is a "clean" system that is fairly new.

Any ideas would be greatly appreciated.

Take a look at this support article

http://support.microsoft.com/default.aspx/kb/271908

Hope this helps

Data Compare

I have and use Red Gate software for comparison. However; I'm at a loss on
this data compare scenario:
I have two tables I want to compare, but the PK-ID field is seeded
differenly between the 2 tables. So when I do a comparison - every row is
considered different. I looked at a couple other tools to see if I could
compare and exclude columns - but havent' found any. I remember once seeing
a T-SQL solution - but I cannot find that either.
One thought I had was that this particular table, the PK-ID field is not
used anywhere else - so maybe I could just reseed the one table to match the
other.
Can anyone offer some suggestions?It is hard to understand your narrative without an example. Can you post
your table structures, sample data & expected results? For details refer to:
www.aspfaq.com/5006
Anith|||I found the perfect solution just now a SP called sp_compare:
http://www.databasejournal.com/scri...cle.php/1579951
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:%23eTMaogHGHA.3624@.TK2MSFTNGP09.phx.gbl...
> It is hard to understand your narrative without an example. Can you post
> your table structures, sample data & expected results? For details refer
> to: www.aspfaq.com/5006
> --
> Anith
>

Data Compare

I have and use Red Gate software for comparison. However; I'm at a loss on
this data compare scenario:
I have two tables I want to compare, but the PK-ID field is seeded
differenly between the 2 tables. So when I do a comparison - every row is
considered different. I looked at a couple other tools to see if I could
compare and exclude columns - but havent' found any. I remember once seeing
a T-SQL solution - but I cannot find that either.
One thought I had was that this particular table, the PK-ID field is not
used anywhere else - so maybe I could just reseed the one table to match the
other.
Can anyone offer some suggestions?
That would sort of defeat the purpose. The PK is supposed to uniquely
identify a row. If there is no way to uniquely identify a row, then how can
any comparison tool compare any row to any other row?
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Joe" <bill@.msn.com> wrote in message
news:OgjKPRgHGHA.216@.TK2MSFTNGP15.phx.gbl...
>I have and use Red Gate software for comparison. However; I'm at a loss on
>this data compare scenario:
> I have two tables I want to compare, but the PK-ID field is seeded
> differenly between the 2 tables. So when I do a comparison - every row is
> considered different. I looked at a couple other tools to see if I could
> compare and exclude columns - but havent' found any. I remember once
> seeing a T-SQL solution - but I cannot find that either.
> One thought I had was that this particular table, the PK-ID field is not
> used anywhere else - so maybe I could just reseed the one table to match
> the other.
> Can anyone offer some suggestions?
>

Data Backup to CDROM

Is there any software that can make backup of data from MSSQL Server, LIVE - during work - to another machine on CDROM?
Anybody has the experience - good or bad with the CD solution?You mean that you want to buy something to do what SQL Server itself does?

-PatP