Probably worth considering not hardcoding the SubId into the package either, but rather using the DDS name/description:

SELECT @SubId=SubscriptionID FROM dbo.Subscriptions WHERE Description='DDS_Name'

EXEC dbo.AddEvent @EventType = N'TimedSubscription', , @EventData = @SubId

I tend to simply add Windows AD groups as logins and don't bother with any associated role.

I'm curious what value a role adds?

(I'm aware the main thrust of your editorial...

Hi Steve,

Aren't the release problems you descibe what proper source control systems and processes are there to address?

Source control branching, coupled with a high level database management system, such as...

JediSQL (9/12/2014)

---

A SYNONYM can be to any object, including stored procedures and functions. I don't think...

I played around with synonyms for a while, then came to the conclusion that they really offer no advantages over views.

So can someone explain how a synonym is superior to...

Excellent article. Very comprehensive and informative.

Will be very useful in future to have comprehensive comparison data side by side in one place.

How about using this for a TSQL based solution?:

SELECT DISTINCT(local_tcp_port) FROM sys.dm_exec_connections

WHERE net_transport='TCP'

arsinfor (5/25/2011)

---

Thanks very much Lawrence.

I am using sql 2005 and I find in this address a possible solution.....

http://weblogs.asp.net/jgalloway/archive/2008/01/27/adding-simple-trigger-based-auditing-to-your-sql-server-database.aspx%5B/quote%5D

This looks like a nice automated solution, based on triggers....

arsinfor (5/24/2011)

---

I'm looking for the most eficcient way to audit the changes on a particular table. Generaly you need to know which table, row and column where changed. I mean...

Yes I believe you are right, but this raises the question of what value the CHECKSUM_AGG()...

HansB,

BTW I was thinking more about your post, and it also occurs to me that if you have a datetime column maintained by triggers, then you could simply use the...

Hi virtualjosh,

I'd be very careful using the sys.tables.modify_date field.

In my experience, it is not always kept up to date in realtime.

For example, try the following:

CREATE TABLE test1 (i INT, vc1...

Thanks HansB,

It's a very good point you raise. Of course you are correct. However, I think it's still worthwhile highlighting the shortcomings of the CHECKSUM functions to further encourage the...

Hi Eric,

Many thanks for your post.

It is true that DMVs offer lots of useful information, some of which could be applied for requirements discussed in my article.

However, DMVs typically require...

Hi fmendes,

That would cover inserted rows only, but not cater for updates on the row, nor row deletions.

Regards,

Lawrence.