for my personal CLR collection, the UNSAFE/EXTERNAL/SAFE designation is assigned at the project (dll) level, and not against individual procedures/functions.

So all my CLR's are under a single project. that project...

Eirikur Eiriksson (5/1/2014)

Lowell, you where almost there! Changed the code to modify and store the encrypted secret, then decrypt in the select. This code has everything needed for either storing...

i found this interesting, and am about 90% there with an example solution.

my problem is if there is a text representation of a binary string in the xml, how do...

there's probably more to the question, but the charindex function finds the starting position of a string within another string.

DECLARE @FindPharase varchar(max) =' I would like to thank whomever<span style=\""font-family:courier\">...

my first guess: the table is a heap, and does not have a clustered index.

in the case of a heap, if you update data, or delete and reinsert individual rows...

there's an exisitng option for the COPYTO='\\jons-laptop\SharedFolder\SQLBackups\' that is already a part of Native Sql backups,as well as litespeed and redgate backups.

can't you just add that to your backup command,...

as long as you bullet proofed the code to make sure all tables already exist, your trigger is pretty close to working, but it must be a FOR TRIGGER, not...

in the SSMS grid, in order to force visibility of the data , for display purposes only,Carriage Returns and Line Feeds are turned into spaces; however the data truly still...

without more details, all we can do is guess.

the most likely culprit is you have databases that have the recovery model set to FULL, but are failing to take regular...

you'd probably be much better off using BULK INSERT over bcp + xp_cmdshell anyway:

--in via bulk insert

BULK INSERT INV_StageTable FROM 'c:\Test\Aut_2014-04-22.csv'

...

you cannot pass a windows username and password. it's just not allowed.

you can pass a SQL username and password, or use the -T for trusted connection, which uses...

there are quite a few script contributions here on SSC; some are detailed, some script out as commands, some are more overview/report like, so it really depends on what you...

a4apple nailed it: your inner quote needs to be double single quoted to work, or remove the single quotes to allow comparison to an integer.

:

use msdb

if exists

(select sysjobs.name as...

well, as you can see from my example code, i generated my best guess from the existing data.

you can do the same, obviously; i would assume that somewhere, someone has...

the best way is to create a view, which would calculate that information on demand.

Best practice is to never add a column containing agregates in a table row, since...