Viewing 15 posts - 61 through 75 (of 140 total)
Are you looking only for third party tool? Have you tried in built DDL Trigger and Policy Based Management?
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 15, 2011 at 8:01 am
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...
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 14, 2011 at 9:21 am
As sturner said, this is only for cosmetic. For that, recreating table is unnecessary. Thanks to you both :-).
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 14, 2011 at 9:00 am
Hi Dave, The link is exactly what we were looking for. Thanks.
So, Our solutions are TRICKS 😀 your link is REALITY :cool:.
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 12, 2011 at 7:16 am
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...
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 12, 2011 at 6:07 am
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...
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 12, 2011 at 5:58 am
The ArticleType column will contain either "StepByStep" or "Regular" values only. It will not have the value "All"
Thanks
Ok. But you are passing 'All' as parameter.. right? Actually the below...
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 12, 2011 at 5:19 am
Try this.
SELECT *
FROM Articles
WHERE (( ArticleType = @ArticleType)
OR (@ArticleType = 'All'))
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 12, 2011 at 5:00 am
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...
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 12, 2011 at 3:02 am
No, a filtered index does not purge (delete) the data. I want to remove the data from the data mart after 6 months.
If you are not required the old...
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 11, 2011 at 7:37 am
The below link saying something different. Have a look.
http://social.msdn.microsoft.com/Forums/nl-BE/sqlsearch/thread/847a4729-126f-4324-ad31-9c7ada88c87b
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 11, 2011 at 7:28 am
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...
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 11, 2011 at 7:06 am
Do you want to make a connection string?
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 11, 2011 at 4:02 am
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...
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 11, 2011 at 3:09 am
Thank you very much 🙂
_____________________________________________
One ounce of practice is more important than tonnes of dreams
April 8, 2011 at 9:56 am
Viewing 15 posts - 61 through 75 (of 140 total)