Programming SQL

Database Audit
How can you find out if a query has been run on a database? The reason is we would like to see if a database has been accessed in the last three months and if not, we will archive the database and remove it from the server to create space. Thanks. ... 24 May 2010 23:27

BUY FAKE PASSPORTS OF AUSTRALIA,FAKE AUSTRALIAN PASSPORTS FOR SALE
If you want to buy high quality fake faked forged fraudulent counterfeit duplicate false camouflage diplomatic passports and other identification documents of Australia, Austria, Belgium, Canada, Finland, France, Germany, Israel, Malaysia, Netherlands, New Zealand, South Africa, Switzerland, United Kingdom, Uni... 18 May 2010 10:22

Send Mail to Multiple recipients
This is my stored procedute to send an email to multiple recipients, Its working if there is only one recipient, But how can i send email to multiples? GO ALTER PROCEDURE aspdnsf_sendCouponCode AS BEGIN declare @bodyContent varchar(3000) declare @couponcode nvarchar(50) declare @email varchar(300) DECLARE... 19 May 2010 10:28

Remove characters in an ASCII decimal range: How To?
Hi Erland, I should have explained more thoroughly. The source is a commercial application that only allows users to enter ASCII 33 - 127 into the screen field that gets populated into the database column. However, the source application adds formatting characters for its own display format purposes that aren'... 17 May 2010 16:55

Remove characters in an ASCII decimal range: How To?
I have a table that has some prettty nasty strings in it. I would like to remove all characters outside the range of 33 - 127 decimal from the string Here is what I mean: CREATE TABLE test_row ( statement_nr INT NOT NULL ,statement_tx VARCHAR(200) NOT NULL ) ALTER TABLE test_row ADD PRIMARY KEY (statemen... 15 May 2010 00:50

Update order
Just want to make sure here. If you are updating multiple fields, it updates in the order that you specify, correct? For example: columnA= 100 columnB = 200 columnC = NULL I am going to move columnA to columnC, columnB to columnA, set columnB to NULL. This should end up with columnA = 200 colum... 21 May 2010 15:03

Cannot see SQL Server 2008 on other node!
I have visual studio 2008 installed on my home workstation and visual studio 2010 on my notebook computer issued to me by my employer. For some reason, my employer did not install sql server on the notebook. I have the developers version of SQL Server 2005 installed on my workstation and it seems to work fine ... 16 May 2010 19:03

Query for merge column
Dear Friends Please see it I want query Table name emp A B C D vivek vinod randhir Delhi vivek vinod randhir patna vivek vinod randhir Kolkata vivek vinod randhir Madras I want record like Vivek vinod randhir Delhi,patna,Kolkata,Madras ... 15 May 2010 10:26

Select a row in a group with a column that has the maximum value
Hi, I have the following recordset: 5F453674-DA64-4BB1-8947-19493439927B 1 CamCard Beta 1 5F453674-DA64-4BB1-8947-19493439927B 2 CamCard EB70E4BD-CC44-4AD0-A000-6DD92CD44740 3 Business Cards Column names are as follows: Column 1: ProductID Column 2: VersionNumber Column 3: ... 15 May 2010 22:27

Possible to select a sample rows based on a column value?
Hi I want to write a query to select columns from 3 tables (T1=120 million rows, t2=200 M and T3 = 9.5 M) grouped by a column in table T3. select count(*), T3.C1 from T1 <..> Join T2 <..> Join T3 <..> group by T3.C1 The question is it possible for me to select top 10 rows or a sample of rows from each... 12 May 2010 19:14