Using MS SQL Server

How to implement Audit/Alert for Row level access?
On May 6, 5:54 pm, --CELKO-- <jcelko...(a)earthlink.net> wrote: The management would like to know if anyone else is trying or successfully accessed the flagged customers. << This is a HIPAA requirement and it is best done with third party software that has been certified. Conventional tools based off the ... 6 May 2008 21:27

MSSQL - MySQL
Hi there, i need some help I got a software to backend is MSSQL 2005, but a provider software requires an UPDATE on his table with MySQL 5.0.56a backend, so i made the next: download and install ODBC MySQL 3.51 configuring system DSN add a linked server on MSSQL 2005 then i made a stored procedure with a d... 24 Apr 2008 18:15

Brand Watches TAG Heuer Women's Formula 1 Maria Sharapova Diamond Watch #WAC1215.BC0840 Discount, Swiss, Fake
Brand Watches TAG Heuer Women's Formula 1 Maria Sharapova Diamond Watch #WAC1215.BC0840 Discount, Swiss, Fake Browse our TAG Heuer Women's Formula 1 Maria Sharapova Diamond Watch #WAC1215.BC0840 Swiss watches, which is sure the watch you are looking for at low price. There are more high quality designer watch Swi... 24 Apr 2008 12:39

Brand Watches Seiko Arctura Kinetic Men's Black Dial Date Rubber Strap Watch SKA207 Discount, Swiss, Fake
Brand Watches Seiko Arctura Kinetic Men's Black Dial Date Rubber Strap Watch SKA207 Discount, Swiss, Fake Browse our Seiko Arctura Kinetic Men's Black Dial Date Rubber Strap Watch SKA207 Swiss watches, which is sure the watch you are looking for at low price. There are more high quality designer watch Swiss for ... 24 Apr 2008 12:39

back up jobs, re-index question
We have a db that is accessed by users on the web 24/7. Problem is when our maintenace job runs users are getting killed with this error: Database Error: SQL Error #-2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction manager has canceled the distributed transaction. (Source: Microsoft OLE DB Pro... 24 Apr 2008 19:03

capture and save running sql query to database table (for logging)
Hey, This may sound odd, but is there anyway to catch the current or just run query from inside a trigger? Kinda like how profiler displays the query just as you've run it, along with all the statistical data... But I'm just looking to capture the query itself and save it in a logging table. I just need to s... 24 Apr 2008 23:01

How to recover deleted records?
Hello I accidentaly ran a DELETE command against a table with a wrong WHERE clause. My database had no backup, but the recovery model was Full. I am using SQL Server 2005. Is there a way, or any utility software that could help me recover the lost data? The .ldf file is twice as big than the .mdf file, so I ... 24 Apr 2008 11:02

file crawler
I have just started learning SQL. I would like to write a program that crawls the hard drive and collects file names (with full path), size of files and directories, date of last modification, etc. (I know Google Desktop Search offers more.) I am already stuck with the path, how should i handle that? It is a goo... 23 Apr 2008 20:32

design question - type heirarchy with supertype queries
Is there a convient way to do a supertype/subtype heirarchy in mysql and do queries on the supertype to return sets of subtypes? For example, suppose I have a table with several types of military hardware: Table: Id----Type--------Price 1.....Mig-15.....$20 1.....Mig-17.....$32 1.....Su-27......$80 1.....T... 23 Apr 2008 20:32

OEM Wireless Mics - Chinese Wireless Mics Manufacturer
OEM Wireless Mics - Chinese Wireless Mics Manufacturer Wireless Microphone WebSite Link: http://www.chinese-microphone.com/Wireless-Microphones.html China GuangZhou TianTuo Microphone Manufacturing Co., Ltd WebSite: http://www.chinese-microphone.com/ Microphone Products are: Wireless Microphones, Conferenc... 23 Apr 2008 16:32