The bug.[/url]

Yes, consider hiring someone who has setup DR/HA before to guide you through the process.

jamesl 88576 (3/11/2013)

---

I am trying to automate the move of data in .txt files to staging tables in Sql. I have been all over the internet and have read many...

Look for SQL Server:Memory Manager (as MSSQL$InstanceName:Memory Manager) counters:

- Target Server Memory (KB) is how much memory the instance would want to use if the demand was there from active...

Doing a SELECT * with no WHERE-clause will always do a scan, either a Table Scan in the case of a heap, or a Clustered Index Scan in the case...

This one made me research some command line utilities I had not used related to Named Pipes but deprecated, i.e. should not be used but is still supported != obsolete,...

Err, I want my point back. No infinite loop because nestlevel stops us at 32. Also, it does return some resultsets, 32 to be exact, before hitting the error. The...

Gail looked to be offline so I jumped in. Hopefully she'll drop by and help shed some additional light on the situation.

JC-3113 (3/11/2013)

---

Hi folks

came in today and found this error on one of my databases.

Would appreciate any assistance on this as I have not seen this type of error before

If you...

VARCHAR(MAX) was just one example. There is also a possibility that the OLE DB driver could not determine the shape of the resultset that should have been returned prior to...

I am doubtful that a CTE being present in a proc will cause this error. Check the driver you are using. A TDS error points to the possibility that the...

Check the Control Panel for the Services MMC.

It depends on how the Linked Server is configured. If you have the certificate working then it should be a trivial thing to test using a Linked Server from inside...

Not a problem. Thanks for the feedback.

No, not unless RECURSIVE_TRIGGERS is ON. It is...