Manie you script looks pretty good without testing it myself;

Here's a something similar I built for some unknown forum post here; the basic differences are i'm also capturing changes to...

how does the data actually come? is it a real csv file, and not an excel doc?

I've imported millions of rows via bulk insert or SSIS with delimited files,...

Yes, but that trace only captures changes realted to DDL operations, ie CREATE TABLE/ALTER TABLE etc.

B. Is it possible to capture all...

weird, i haven't seen that issue before specifically; you clearly have dba rights to take it offline and online, so that's not the issue, especially since it's available afterwards.

I have...

take a look at the script contributions on the site:

the second link from this results explicitly says jobs for SQL 2000/05/08,

http://www.sqlservercentral.com/search/?q=script+jobs&t=s

I think another search for the other items you...

ok great!

the trick here is you really need two queries, adn compare them agaisnt each otehr;

you already have the cheapest supplier, but now you wnat to know which regular supplier...

jralston88 (3/14/2013)

---

Lowell,

Thanks for responding. I should have clarified that in my posting - the email account has the full domain. And the mapping you mentioned was done. ...

r-276086 (3/14/2013)

---

Hi I have the following table (created from a view):

BaseSupplierID__SupplierID___ProductID__Price

3_______________3___________1________11

3_______________4___________1________11

3_______________5___________1________15

3_______________6___________1________10

4_______________3___________2________16

4_______________4___________2________10

5_______________5___________3________16

5_______________8___________3________14

5_______________9___________3________10

Basically each product can be supplied from multiple supplies yet there is a base supplier (which in theory should be...

now that you have...

some context is missing; what project are...

sp_send_dbmail can only send to an address that conforms to an actual email address format, ie mygroup@mydomain.com; you cannot send to just "MyGroup"

a group account is handled special by an...

ok if it's a user who exists in a windows group, and doesn't have an individual login in SQL, then it's the issue Gazareth identified;

I assume the user are...

google update service is one of the things the google toolbar adds when installed on internet explorer or firefox.

if this is on a server, consider either updating to the latest...

check the default database for that login;

if the database was deleted, then you'll see that error, and need to reassign the default login, probably to master.

so as an example,...

glad i could give you a push in a different direction!