Do you really need JPEG?

PDF is a very good and simple alternative with a lot of supporters

Just My 2 cents

quote:

---

CREATE TRIGGER t_ui_CustShippers

ON CustShippers

FOR INSERT, UPDATE AS

IF UPDATE([Default])

BEGIN

IF EXISTS (

SELECT *

FROM CustShippers ...

quote:

---

I think I have found that with sp's the default is that the users permissions in the target database are set...

check the account login that EM is using

HTH

HTTP 500 - Internal server error

I do speak spanish but can't access it.

Declare @varlist varchar(255)

Set @varList = ',1,2,3,5,' -- Commas before and after

Update tempSalesDetail

SET BTI = 1

WHERE CHARINDEX(',' + Convert(varchar, tempSalesDetailID) + ',', @varList) > 0

Note this is good for "small"...

I am still curious about your 75 Million rows

I would like to know the performance of the query posted using sp_excecutesql @str with the hard coded numbers in @str....

nope.

use separate files so you have total control on what stays and what goes away

and make sure the PASSWORD is STRONG enough because if that is a concern dictionaries attacks run very fast on sql server!

100% with brian the Default database for the login used to connect was dropped! as amtter of fact on my enviromet all logins are mapped by default to tempdb so...

I would add a unique constraint on

(Customer_Name, Ship_Location, Shipper, Default)

One thing though instead of real names you may want to use foreign keys to look up tables for ship_location...

quote:

---

quote:

--------------------------------------------------------------------------------

quote:

--------------------------------------------------------------------------------

Quick brainteaser for our beginning DBA's: what's the quickest method to strip out the time from a DATETIME field (returning...

thanks!

quote:

---

gljjr While using the "All" keyword will seem to do what you want a more reliable solution would be something...

quote:

---

Quick brainteaser for our beginning DBA's: what's the quickest method to strip out the time from a DATETIME field (returning only...