I went down the rabbit hole pretty deep investgating this; kind of interesting.

this code project example compares teh first 10 bytes to determine the image file type.

if you can add...

untested, but syntax wise in vb.NET it looks like i can take any binary data, try to stick it in a "System.Drawing.Image", and if there's no error, do a Save...

Charlottecb (9/21/2011)

---

I'm probably being very simplistic \ ignorant in my outlook here, so please bare with me as I've never had to do anything like this before... Why can I...

i think you have to script the jobs out; as i remember it, the msdb rows refer to the server name, so if the "new" server is not named...

here's some .NET code i posted from a different post on the same issue;

you can use it as a model if you have the file name and binary data together,...

is the original file name saved in the row of data with the ID and the varbinary data? if you don't have the filename ,(which implies the image type),or at...

the constructor allows only literal strings, not a variable, so

ENCRYPTION BY PASSWORD =@var fails,

ENCRYPTION BY PASSWORD ='static string' is good

so i think you'll have to switch to dynamic...

I'm not sure i would even consider restoring master at all.

the only items of any importanceto me are the following:

1. Server Logins and their permissions.

2. Linked servers. definitions and...

is the data integer data type or strings?

so the value 24701 is 2:47:01 (am?)

152205 would be a valid value and 15:22:05 or 3:22:05 pm?

something like this may be...

a lot depends on your data; that cross join can have a cost.

if your data is anything like my copies of the US Census to 90% firstnames/lastnames, a cross...

try it yourself.

ALL transactions can...

hint # 1 the number of rows don't matter...testing it yourself goes a lot farther education-wise than asking and getting an answer....

hint # 2 when can you use or not...

you did everything right, thank you! excellent explanation, sample code of what you tried, gave me everything i needed to build a testable, working example.

good...

sounds like row number will give you exactly what you need:

SELECT

ACCT,

ROOM,

CUST,

REGION,

LASTUPDATEDATECORP

FROM

(SELECT

ROW_NUMBER() OVER(PARTITION BY...

you could get it from the execution plan, if it was in the cache.

it's not easy, as xQuery's a little difficult, but it's in there.