Viewing 15 posts - 4,996 through 5,010 (of 7,187 total)
I think there are compliance issues here, as well. In the UK, the Data Protection Act covers data that can be used to identify a living individual. As...
October 19, 2011 at 3:46 am
One way of doing it is put a DISTINCT in, thus:
...
LEFT OUTER JOIN (SELECT DISTINCT ServiceOrder FROM ServiceOrders) SO ON I.ServiceOrder = SO.ServiceOrder
...
John
October 18, 2011 at 8:43 am
If you only want one Work Order, how will you choose which one will be returned? Also, your WHERE clause includes conditions on your outer tables. This will...
October 18, 2011 at 8:31 am
I like the trigger theory best.
SELECT [name]
FROM sys.triggers
WHERE OBJECT_NAME(parent_id) = 'Person'
John
October 18, 2011 at 6:58 am
Try one of these links and let us know how you get on.
John
October 18, 2011 at 6:55 am
trarunprasanna (10/18/2011)
if we enable the trace in server side It will affect the performance
Will it? How do you know that whatever other solution that may exist doesn't affect performance...
October 18, 2011 at 6:44 am
Yes, there are stored procedures you can use to set up a server-side trace.
John
October 18, 2011 at 6:36 am
Whoaa! This is far more complicated than it needs to be. All you need to do is user parameters in your Execute SQL task - something like this:
SELECT...
October 18, 2011 at 5:46 am
You would need to configure your package so that it does a specific thing on task failure. I think by default, the package will fail if only one task...
October 18, 2011 at 5:39 am
I'm not an expert on how server discovery works, but I'd imagine that it interrogates SQL Server Browser and looks for anything listening on 1433. That would explain why...
October 18, 2011 at 5:35 am
Sounds like you need an event handler on your event handler! Seriously, though - I would start by having it not do anything except write the error to a...
October 18, 2011 at 4:52 am
OK, and during execution, what colour are the two data handlers when your data flow gets stuck on yellow?
John
October 18, 2011 at 4:33 am
What does the event handler do? Is it possible that the task is still yellow because the event handler is stuck doing something? You may wish to experiment...
October 18, 2011 at 4:27 am
Another thing that's worth trying is backing up the database and restoring to the new location. This should obviate the need to delete the subscription. Vultar's advice still...
October 18, 2011 at 4:09 am
Is Google broken today? Do your own research, and post back if there's anything in particular that you don't understand.
John
October 18, 2011 at 3:53 am
Viewing 15 posts - 4,996 through 5,010 (of 7,187 total)