Are you looking only for third party tool? Have you tried in built DDL Trigger and Policy Based Management?

Ben, While adding a new field in the designing tool, we can add it in a position wherever we want. But later when we create the field, I need the...

As sturner said, this is only for cosmetic. For that, recreating table is unnecessary. Thanks to you both :-).

Hi Dave, The link is exactly what we were looking for. Thanks.

So, Our solutions are TRICKS 😀 your link is REALITY :cool:.

Srikant's solution also will work for this scenario. He is using "CASE" and in my code it is "OR". You need to check performance of the both solution and have...

Hi Parthi / Lowell, Thank you very much for your replies.

Space for Growth.

my rule of [currentsize] * [Planned years of Support]

For example, someone comes to me with an existing...

Ok. But you are passing 'All' as parameter.. right? Actually the below...

Try this.

SELECT *

FROM Articles

WHERE (( ArticleType = @ArticleType)

OR (@ArticleType = 'All'))

How did you create the connection string? Using by any control? If you used any control there will be a "Test Connection" button. Did you test that to check the...

If you are not required the old...

The below link saying something different. Have a look.

http://social.msdn.microsoft.com/Forums/nl-BE/sqlsearch/thread/847a4729-126f-4324-ad31-9c7ada88c87b

Is there a mechanism in SQL to purge the data once it no longer meets the filter statement and if so is there documentation available so I can verify my...

Do you want to make a connection string?

Another way is, keep all addresses in one table. Add the Address Id in the Customer table and Broker table. In that case person type is not required in the...

Thank you very much 🙂