not sure how much help this would be.

the CTE below is just so I have a table that represents the data you provided.

only the select is the part you'd want...

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...