Viewing 10 posts - 76 through 85 (of 85 total)
Are your table scripts under source control? Most (all?) source control systems can be set to email certain people when file changes are checked in.
Do you have a formal...
May 22, 2014 at 5:54 pm
Anything in the default trace? If the 'modify date' in sys.objects is accurate you could use that as a start to search the default trace.
May 18, 2014 at 5:32 am
Do your source table and destination table have the same definition?
You are trying to get a field with value 'false' -that's in VoucherParticipant for the first row -...
May 16, 2014 at 6:45 pm
I don't really have a answer for you but I've seen this sort of thing on the forum before. The consensus seems to be that it's not a pure...
May 6, 2014 at 1:53 pm
Are there any DENY permissions set on the user for the other schemas?
If they try a SELECT query on one of the other schema tables (even though they can't 'see'...
April 24, 2014 at 6:23 pm
Shouldn't the desired results be as follows?
Purchase,South,3
Liquidate,East, 4
Purchase,West,1
Liquidate,West,4
Liquidate,West, 5
Liquidate,West, 6
April 23, 2014 at 7:06 pm
I haven't tried it but this might be the solution
April 23, 2014 at 1:03 pm
I think you want to Edit the TextData column in profiler and set a filter on the text using the 'like' field
Right-click on the TextData column in profiler (Events Selection)...
April 23, 2014 at 9:50 am
Seems to be a bug in Italian version of SQL.
There is a workaround posted on google groups to do with replacing this file.'sqlagent.rll'. Don't know if it is fixed in a...
September 29, 2004 at 3:20 am
Hi Grasshopper,
I'd use a combination of profiler, sp_lock and trace flags 1204, 1205. The last two will write you some history to the sql log. Remember to turn them...
September 24, 2004 at 3:27 am
Viewing 10 posts - 76 through 85 (of 85 total)