Viewing 15 posts - 31 through 45 (of 54 total)
February 13, 2017 at 9:50 am
goher2000 - Monday, February 13, 2017 9:18 AMdid you compare the transaction log file sizes?, I suspect it would be log file
Good...
February 13, 2017 at 9:37 am
Thom A (11/22/2016)
planetmatt (11/22/2016)
Thom A (11/22/2016)
What are the permissions of the account you are viewing this dialogue box from? Do you have permission to impersonate?
As I said, no explicit permissions....
November 22, 2016 at 8:25 am
Thom A (11/22/2016)
What are the permissions of the account you are viewing this dialogue box from? Do you have permission to impersonate?
As I said, no explicit permissions. The user...
November 22, 2016 at 7:59 am
Phil Parkin (11/18/2016)
planetmatt (11/18/2016)
Phil Parkin (11/18/2016)
This code snippet shows that ?+ is no...
November 18, 2016 at 9:21 am
Phil Parkin (11/18/2016)
This code snippet shows that ?+ is no problem:
IF OBJECT_ID('tempdb..#test', 'U')...
November 18, 2016 at 8:30 am
Another weird thing to throw in the mix.
When examining the raw data in SQL, SELECTing the row in question with a SELECT * does not show the "?". Only...
November 18, 2016 at 8:21 am
Phil Parkin (11/18/2016)
planetmatt (11/18/2016)
Until today, it ran without issue.
The error it's now throwing...
November 18, 2016 at 8:18 am
Is this account separate from the one used as the SQL Agent Service "Log On As" Account?
May 5, 2016 at 7:30 am
So you have one Windows Account, One Credential,and One Proxy.
This account then has read/write on any external file locations as needed by any SSIS package.
Is this Windows account then used...
May 5, 2016 at 6:39 am
Jez-448386 (5/5/2016)
If you are...
May 5, 2016 at 4:45 am
Alan.B (3/11/2016)
TryWHERE Item LIKE '%S' OR Item LIKE '%B'
WHERE Item like '%[S,B]'
March 14, 2016 at 6:11 am
Bill Talada (4/29/2015)
April 29, 2015 at 10:07 am
Lynn Pettis (4/29/2015)
And can you have some down time to complete the deletion of data?
There are 737million rows total. I need to delete all records related to a master...
April 29, 2015 at 10:02 am
Clever stuff, might give that a try. Comments about performance taken on board. Thanks chaps.
January 22, 2009 at 10:03 am
Viewing 15 posts - 31 through 45 (of 54 total)