Good question. Thanks 🙂

yes VARCHAR(MAX) is not allowed, but you can use VARCHAR(8000).

Try executing the code below:

declare @STR varchar(8000)

select @STR = 'create table #test

(ind int primary key not...

Just as a thumb rule (that I follow), use CHAR only when you are sure of the character length. For example - SSN number is always of fixed length. For...

+1

Also, as pointed out by Hugo yesterday, the link is also correct - latest version of BOL 🙂

In order to change connections dynamically, you need to program them using script task in SSIS.

This sometimes happens to me as well 🙂

Using merge (as pointed out by demonfox) you can easily user INSERTED.* and DELETED.* (as mentionded by Dwain) after MERGE in order to capture, columns and values which are being...

As rightly pointed about Anthony, this is bit tricky as there is no identifier on the rows. Here is another way of deleting duplicate records using CTE:

WITH DelDup

...

Easy question for the day!

I agree with the explanation by "demonfox", here is the BOL link for BIT datatype:

http://msdn.microsoft.com/en-us/library/ms177603.aspx

It clearly says "any non-zero value will be converted to 1". I...

Wonderful! Glad to know that.

All glories to Jason as well for optimizing my code 🙂

Cool! This works well. Here is the modified (few compilation issues rectified) and tested version.

;WITH Cte_Src AS (

SELECT

Db_name(database_id) databasename

,Max(x.Last_Date) Last_Access_time

,Getdate() curr_time

FROM

sys.dm_db_index_usage_stats

CROSS...

Hey Jason, thanks for your valuable inputs. I shall have these incorporated and tested soon.

Thanks 🙂

OP here is how I have set-up custom auditing on the Server. The script given here will create an Audit Table and try to record DB access information. I use...

demonfox (1/28/2013)

:hehe: yes , it is ..

when I hear the word audit , I think of security 😛

and with CDC , Change data Capture , I think of it as...

demonfox (1/27/2013)

CDC is more like versioning than audit ; what does it mean by audit trail on daioy transactions ?

does it more related to logging of transaction by a login...