Viewing 15 posts - 46 through 60 (of 222 total)
That's a good idea. Will give it a shot.
August 24, 2012 at 5:37 am
Same error here... very odd
OLE DB Source [11]] Error: SSIS Error Code DTS_E_OLEDBERROR.
An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available.
Source:...
August 23, 2012 at 6:26 pm
I read it through, figured out the right answer, then parsed visually against what was there and based on what the right answer was, I "thought" I selected the right...
July 9, 2012 at 7:14 pm
Nice to test and show answer as absolute.
March 31, 2012 at 2:27 pm
It takes someone with a good knowledge of a question to ask it in a way that is illuminating
March 31, 2012 at 2:24 pm
There is no room for work-around here. You must allocate more disk space by hook or by crook or your server will remain down.
March 9, 2012 at 12:32 pm
The reason it isn't found in the collection is because it is not in the collection. Go to the data sources listed in the Solution Explorer that point to...
March 1, 2012 at 2:34 pm
http://support.microsoft.com/kb/314546
Step 4: How to move jobs, alerts, and operators
Step 4 is optional. You can generate scripts for all jobs, alerts and operators on the source server, and then...
November 28, 2011 at 6:43 am
So that if you accidently have the wrong server up and you delete records from that server and not the one intended, there is still a path to recovery. ...
October 13, 2011 at 11:37 am
RUN THIS:
EXEC master.dbo.sp_addlinkedserver @server = N'myserver', @srvproduct=N'SQL Server'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'myserver',@useself=N'False',@locallogin=NULL,@rmtuser=N'mySqlAuthAcctOnTargetSvr',@rmtpassword='mySqlAuthAcctOnTargetSvrPassword'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'myserver',@useself=N'False',@locallogin=N'NT AUTHORITY\SYSTEM',@rmtuser=N'domain\svcAcct',@rmtpassword='DomainsvcAcctPassword'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'myserver',@useself=N'True',@locallogin=N'domain\svcAcct',@rmtuser=NULL,@rmtpassword=NULL
GO
EXEC master.dbo.sp_serveroption @server=N'myserver', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'myserver', @optname=N'data access',...
September 10, 2011 at 5:32 am
This question reminds me of the way a DB person thinks... instead of saying which question is false, the question asks which one is not true.
September 5, 2011 at 4:49 am
Interesting and somewhat horrifying - up to now, 43% said delete was not logged, which is amazing considering how much discussion of that there has been on SQLServerCentral.com; and more...
September 5, 2011 at 4:43 am
Not that losing a point is fun, but the image I garnered from the guy throwing the brick through his screen sure caught my attention.
September 5, 2011 at 4:06 am
I would suspect this inability to get to the registry is a service account being denied access by the OS. If your service account is just a user and...
July 25, 2011 at 5:56 am
Viewing 15 posts - 46 through 60 (of 222 total)