Viewing 15 posts - 31 through 45 (of 120 total)
How about wrapping the ALTER LOGIN in a TRY...CATCH? That would at least allow your policy update to continue on with the rest of the users.
April 17, 2017 at 11:55 am
Not sure why you need XML and STUFF use, but this alternative will at least get you what you asked for:
April 17, 2017 at 11:32 am
If the assembly does not exist, I create it. The I use ALTER ASSEMBLY to "upgrade" the existing assembly with the latest code. Is this not how it is done?
April 17, 2017 at 10:56 am
Most likely you were not trying to run the stored procedures from a DAC connection. Lookup DAC in SQL Server Books On Line for more information.
December 29, 2016 at 2:41 pm
I wonder if any change is needed to STRING_SPLIT for getting the order of values that are split. The following is an example of how I use the ROW_NUMBER...
August 31, 2016 at 2:04 pm
I adapted the following from this link (https://social.msdn.microsoft.com/Forums/en-US/20e92e10-a0ab-4a53-a766-76f84bfd4e8c/converting-hex-values-to-int?forum=transactsql).
It makes use of a "dummy" XML CAST so as to be able to use ".value".
I CAST the resulting hex from...
April 21, 2016 at 3:04 pm
See response to issue here: http://stackoverflow.com/questions/34770688/vs-sqlclr-function-x-has-unresolved-reference-to-schema-y
Essentially you add a CREATE SCHEMA object to your project, even if you know the target system will already have the schema.
February 16, 2016 at 9:22 am
Running into same problem, was there ever a workaround/fix for this?
February 11, 2016 at 9:48 am
Let me see if I have this straight...
It is safer to have each individual authenticate via AD (totally agree) and then be authorized via database access groups?
So instead of an...
December 22, 2015 at 5:33 pm
Currently verifying, but we believe that we've traced the issue to a particular version of the Oracle OLEDB software. WireShark revealed that data content of a packet appeared to...
May 3, 2012 at 2:02 pm
Can this be "fixed"? I was in 2012 forum and saw title on replication, so I searched the forum contents for replication and was informed that there were no...
April 26, 2012 at 1:50 pm
Sorry, wasn't directly answering your question on size. I was guessing that perhaps it was trying to write the file to a location with very little free space instead...
April 6, 2011 at 1:25 pm
.mdmp file is a dump file, and it by default is written under the LOG folder. This location can be changed by launching Configuration Manager, right-clicking on the service...
April 6, 2011 at 12:49 pm
Primary keys are indexed, so yes, defrag will help. If all you have are primary keys, I'm not sure if update stats will do much good.
April 6, 2011 at 12:38 pm
I think I've "fixed" the problem. I stopped and disabled a replication log reader job that I apparently "missed" the first go-round.
April 6, 2011 at 12:01 pm
Viewing 15 posts - 31 through 45 (of 120 total)