Steve i know you can easily get the data with the reserved characters escaped out wiht ampersand amp semicolon, would that be an alternative?

it depends on your data, but this...

I have this old snippet form a post from years ago.

both this and your example are non-sargable, meaning it's going to table scan for the values, which is what full...

I've used the answer below to get the Active Directory password policy via powershell:

https://blogs.technet.microsoft.com/heyscriptingguy/2014/01/09/use-powershell-to-get-account-lockout-and-password-policy/

import-module ActiveDirectory

Get-ADDefaultDomainPasswordPolicy

PS H:\> Get-ADDefaultDomainPasswordPolicy

ComplexityEnabled : True

DistinguishedName ...

also, does the table inside follow some sort of naming convention, but is dynamic?

for example a table named [Invoices_2016-02_14] from yesterday, but it's [Invoices_2016-02_15] from today?

if you can determine...

it's in...

I went deep, deep down this rabbit hole, and built a procedure that i can call from tsql .

tin the long run, you have to use the sys. schemas and...

not suspicious; it sounds like a missing GO statement between drop create procedure and drop/create function in someones script.

it happens to us all at some point

IF OBJECT_ID('[dbo].[sp_Bad]') IS NOT NULL...

if not too much time has passed, the default trace would have the DROP FUNCTION event, complete with whodunnit information; you might have an automated process, or someone may just...

easy fix.

if the function has no parameters, you still need the parenthesis for the parameter list.

alter FUNCTION [dbo].[fnPressGaneyDownload] ()

your function could easily be converted to an inline table value function,...

I'm on the SQL cruise with limited internet, but i'll put together an article;

I tend to shy away from articles, hate getting criticism.

At my job, we just joined two AD...

in my case, I remove the users and logins from SQL Servers, but they stay forever in Active Directory.

I've got a nifty powershell i wrote that imports Active directory data...

there is a neat opportunity here to use the OUTPUT clause;

it allows you to capture things like new guids or identities into a table, and then consume it on a...

hlrx (1/25/2016)

---

GilaMonster (1/23/2016)

---

Yes...

vsamantha35 (1/25/2016)

---

Hi All,

Today came across an issue. Database mail alerts on job failures was not been sent. Checked the dbo.sysmail_faileditems and found that it was failing with authentication error.

Basically,...

if you added a table named Customer_Invoice, you would get the error

Luis hit the nail on the head: you...