fully consumable, copy and paste example:

CREATE TABLE [dbo].[tbl_Purchase] (

[Purchase_id] bigint ...

that's not sample data....

what we need is "consumable" data...copy and paste into SSMS, run it, so we have a setup that mimicks the...

Since this is your first post, let me try and give you an example of what we really need to help you, just like Gianluca suggested

i ran this thru...

you can get the last modified date if...

we use compound IF EXISTS commands to make sure that a table we KNOW exists....well exists...

(if it's our version of a database)...

it eliminates issues where the IF NOT EXISTS...CREATE TABLE...

techzone12 (9/22/2011)

---

Thanks for the code. I am looking at it. One of the requirments is to have one email for each event.

There probably needs to be some sort of...

Elliot that is a really nice project, and was...

well, "instance" is a keyword for SQL server, do you mean two installations of SQl server on the same physical machine, or do you mean two separate servers, both with...

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