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

... our ethics code requires us to prevent you from seeing what we are doing ...

the fix is to group the data by day to get daily totals when more than one shipement exists per day, then get the max per week or month, depending...

based on your data, and some substantial cleanup of what you pasted,(year 2104) i get a max of 60 shipped for week 2:

;WITH MyCTE([Invtid],[Case_ship],[Trandate],[FiscYr],[PerPost],[week_period],[day_period])

AS

(

SELECT 'A',CONVERT(int,'10'),convert(date,' 1/1/2014'),'2014',' 1',' 1',' 1'...

wrapping your current query and using a CTE or subquery works;

here's a simple case statemetn example:

SELECT

CASE WHEN avg_read_disk_latency_ms < 20 THEN 'fast'

WHEN avg_read_disk_latency_ms < 50...

a scheduled job could check each database, and if it finds the right role or user, perform the same script we are recommending above.

if a table was dropped, you might be able to find out who/ when it was dropped by looking at the default trace.

if you need the DDL to recreate the...

is there a DDL trigger on the database that is designed to protect specific tables?

that sounds like a custom error message to me.

select * from sys.server_triggers

apparently, the stored procedure finds the data...

I'm not sure myself, which is why i was asking;

the examples i put out are what is wierd for me. If a query takes ten seconds, i'd kind of expect...