Viewing 15 posts - 9,271 through 9,285 (of 9,399 total)
The only way I know of to accomplish this is to change the notification of the job to send the email when the job fails instead of when the job...
May 24, 2013 at 6:03 am
From the syntax, I'm going to assume that this code is part of a trigger where you're referencing OLD AS OLD and NEW AS NEW and that it's a FOR...
May 24, 2013 at 5:39 am
Sorry to hear that. Just like the public debt, there is a price to be paid for this technical debt eventually. One thing about debt is that if...
May 24, 2013 at 5:18 am
Eugene Elutin (5/23/2013)
1. SSIS - use XMLSource2. SQLXMLBulkLoad:
I don't have experience with SSIS, but I've seen bulk load do some amazing things. The throughput is simply amazing. ...
May 23, 2013 at 1:21 pm
Kenneth: Glad you got the mystery solved and thank you for posting the solution.
May 23, 2013 at 1:15 pm
Definitely talk to the applications manager and inform them of the situation. I would approach this from the stance that the accounts hard-coded into the applications need to change...
May 23, 2013 at 1:08 pm
OPC: Thank you for the link to the sp_foreachdb replacement. I've encountered problems with the MS version myself and found Aaron's approach very insightful. Thanks again.
May 23, 2013 at 12:37 pm
With your answers, I think you answered your own question.
May 23, 2013 at 12:28 pm
Alas, if only we had "START WITH...CONNECT BY" in our SELECT statement.
May 13, 2013 at 5:51 am
If you want everything (data, types, users, security settings, etc.), I found the best way to do it is to take a full backup of the source database and then...
May 13, 2013 at 5:48 am
This has been done quite a few times at my company by people who prototype in Access and then move to SQL Server. The Data Import is the most...
May 10, 2013 at 4:58 am
The semicolons are required in Oracle PL/SQL, but only in specific cases in T-SQL. Personally, I think it's just good coding practice. I've always done it and never...
May 10, 2013 at 4:49 am
Vegard Hagen (4/26/2013)
April 26, 2013 at 6:19 am
Testing in a test environment is key. You just can't know which one will be best without testing them.
When I test, I like to run the number of rows...
April 26, 2013 at 6:13 am
I'm afraid I'm just not sure what you're after from the post above. If you post a create table statement and some inserts to populate it, then describe what...
April 18, 2013 at 9:00 pm
Viewing 15 posts - 9,271 through 9,285 (of 9,399 total)