Viewing 15 posts - 2,191 through 2,205 (of 9,641 total)
Jim Murphy (9/21/2011)
My mother in law just died last night. Been a rough few weeks. She was old and in a nursing home for a while, so it was expected....
September 21, 2011 at 9:48 am
GilaMonster (9/16/2011)
Another request:
I'm bunking tonight and starting the rewrite of my rather old (and second-ever) article Managing Transaction...
September 16, 2011 at 7:44 am
I believe the default settings are 1000 and 100 for SQL Agent History so it sounds to me like someone else is upping the values.
September 15, 2011 at 2:35 pm
bitbucket-25253 (9/15/2011)
A suggestion .. read this article by Jeff Moden, it just may be what you are looking for:
+1 for this as you have a somewhat classic gaps & islands...
September 15, 2011 at 2:27 pm
Can you try the query omitting the BLOB data types (ntext, image)? BLOB data types really slow down queries when you return them. I don't know if that...
September 15, 2011 at 10:35 am
I don't have any experience with BizTalk, but I'd be interested in seeing the resource that says you need to backup the database special way for BizTalk in order for...
September 15, 2011 at 10:15 am
You would have to do something in the batch file that continually checks the status of the specific job until it gets a Success or Failure message for it. ...
September 15, 2011 at 10:11 am
Yes it will only work with one row because of:
@CountDel = 1 and @CountIn = 0
and
@CountDel = 1 and @CountIn = 1
If you changed that those to:
@CountDel > 0...
September 15, 2011 at 9:58 am
Just a note on your solution. If you do hit the ROLLBACK TRANSACTION then the entire transaction, including the "Outer" or source transaction is rolled back, not just the...
September 15, 2011 at 9:50 am
Hey, I exhausted my expertise on connectivity on this thread, http://www.sqlservercentral.com/Forums/Topic1175071-5-1.aspx, so if someone else could take a look I'm sure the OP would appreciate it.
September 15, 2011 at 9:43 am
Sounds like firewall to me, but I've exhausted my expertise.
September 15, 2011 at 9:41 am
If there is no relation how do you know what rows to put together? Do you want a Cartesian product where every row from one input is merged with...
September 15, 2011 at 9:05 am
Check out this article[/url] as it may apply to your situation. The issue with using an event handler to log the error in a Data Flow is that the...
September 15, 2011 at 8:57 am
I'm not an expert, but it sounds like the change has not replicated to the DC that the SQL Server is querying. I could be wrong though.
September 15, 2011 at 8:48 am
The default port is 1433. Otherwise if it is dynamic or changed to another port you'll need to look on the SQL Server for configuration.
September 15, 2011 at 8:46 am
Viewing 15 posts - 2,191 through 2,205 (of 9,641 total)