here's a tested, working model you could use;

it takes multipel inserts into consideration,and sends the email from within the trigger.

so if say, 5 rows were isnerted in a single INSERT...

a CTE is just a subquery to get sample data out so people can see and test it themselves(since you did not provide the CREATE TABLE...INSERT INTO we need)

it's...

sp_database isn't a built in procedure, it must be one that your group added;

i'm guessing that 8704 is the number of pages but i'm not sure without seeing the...

does this work for you?

based ont he sample data you posted, this works:

;With emp (empid,createddate,job)

AS

(

SELECT '1','2011-01-01','db' UNION ALL

SELECT '1','2011-01-01','db' UNION ALL

SELECT '1','2011-02-01','db' UNION ALL

SELECT '2','2011-01-01','db' UNION ALL

SELECT '3','2011-01-01','db')

select empid

from emp

where...

create a new login, for example "WebAccess", then add a user to the database the web pages will access.

create a role for the appropriate rights,a nd finallly , put WebAccess...

ok check this out please.

this has worked correctly on all 5 of my tables which happen to have picutres/images in either image datatypes or varbinary(max) datatypes.

i could correctly guess the...

forsqlserver (9/22/2011)

---

Hi,

The developers have sa priviledge on 1 server , they usually stop the sqlserveragent service and due to which the nightly backup jobs fail.

Can it be possible to stop...

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