Adam i think you just want to do wrap your query as a cte/subselect to get distinct logins with weak passwords, since your new logic allows multiple matches.

if '0001' and...

change your datatype to varchar(max).

http://technet.microsoft.com/en-us/library/ms176089.aspx

max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size is the actual length of the data entered + 2...

i have this saved in my snippets for auditing weak passwords;

basically i have a dictionary of known weak passwords to compare against, and also check if the password = loginname.

hope...

you are talking about the default trace?

if that's true, there's no way to modify that built in default trace.

however, you can script out that same trace,and create a duplicate of...

ok, in that case, the idea is kind of the same...minimize the data you are selecting from the remote server.

a join to a local tablre, like this:

FROM Customers T1

INNER JOIN...

can you try explicitly saving the document as excel 2003-2007?

i've had a similar situation where a csv or html file was saved with an xls extension, so it was not...

i deprecated my oldstyle maintenance plans in favor of TSQL scripts for the same steps. for example, i really liked Gianluca Sartori's version of capturing only relevant errors from DBCC...

Greg Edwards-268690 (1/29/2014)[hr

Wouldn't an Exception Join (NOT EXSISTS) actually be better?

Although a real gap could also be record updated.

Or maybe that never happens. 😀

Bottom line - spend the time...

balasach82 (1/29/2014)

---

We run a delete query which deletes 500-1000 records. But this takes more than 2hours to run.

We use Linked server between 2 SQL 2008 servers.

We delete rows...

column level encryption has been a part of 2005 and above and in all version including express versions, but it's up to your to implement it.

here's a linky to just...

why not just create a procedure that finds what has not been migrated yet?

either via a join so that it is a perfect match, but probably resource intensive, or by...

the key lookup, just by itself, is not a bad thing.

the query is using the unique index, but has to lookup the other values (due to the SELECT *)

to do...

great job posting sample data! post slike this make me want to help!

here's an example of a set based operation using a well know technique with FOR XML;

the STUFF simply...

looks like bad logic to me.

your procedure finds the max id that has a matching criteria, so it assumes a single record was ever inserted.

if i insert multiple records into...

can you show details, and not any pseudo code?

if you can show us the exact code you are using to send the emails, we can help you track down the...