Viewing 15 posts - 1,666 through 1,680 (of 7,164 total)
Yes, consider hiring someone who has setup DR/HA before to guide you through the process.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 5:27 am
jamesl 88576 (3/11/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 5:25 am
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 5:15 am
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 5:03 am
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,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 3:07 am
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 12, 2013 at 2:51 am
Gail looked to be offline so I jumped in. Hopefully she'll drop by and help shed some additional light on the situation.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 11, 2013 at 4:13 pm
JC-3113 (3/11/2013)
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 11, 2013 at 1:52 pm
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 11, 2013 at 11:27 am
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 11, 2013 at 10:02 am
Check the Control Panel for the Services MMC.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 11, 2013 at 9:56 am
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 10, 2013 at 6:53 pm
Not a problem. Thanks for the feedback.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 9, 2013 at 9:30 am
btio_3000 (3/8/2013)
But wouldn't it create a recursive call on that trigger? Updating the same table that the UPDATE trigger is defined on?Thank you
No, not unless RECURSIVE_TRIGGERS is ON. It is...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 8, 2013 at 7:59 pm
I saw "clustered" and breezed right past "primary." Constraints have to be dropped and re-added, which brings FKs and NC indexes into it as well. Messy.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 8, 2013 at 4:26 pm
Viewing 15 posts - 1,666 through 1,680 (of 7,164 total)