Are you saying that you actually have Excel loaded on your server? Excel (all Office products) are not supported on a server.

Since it is a PK (not just an index), you will have to drop it. Try this:

ALTER TABLE dbo.Vendors DROP CONSTRAINT PK_Vendors

Alan Armstrong-249094 (6/3/2010)

Thanks for...

It's fully explained in BOL under sys.database_files

I believe that you're looking for "^" (bitwise Exclusive OR) operator.

The syntax you're looking for is:

INSERT INTO STPWH.dbo.GPIV00101 (<column list, doesn't need to be qualified>)

SELECT (<column list, qualify with table alias ("i" in my example)>)

FROM A068.dbo.IV00101 i

...

Does your sql server NEED to run in mixed authentication mode? If not, change it to Windows Authentication only.

Of bigger concern... you are selecting, within a trigger, into a variable. This usually means that the trigger is not set up to properly handle multiple rows of data -...

Specifically, a LEFT OUTER JOIN.

Change the code to:

SELECT @szTitle = COALESCE( M.TITLE,'None')

FROM Meet_Master M

LEFT JOIN inserted i

...

I'd suggest replacing that c.u.r.s.o.r with:

UPDATE c

SET c.businessunit_name = t.BUSN_NM

FROM Card c

JOIN ##TEMP_CARD t

...

This looks like the error I get on my 64-bit laptop... there is no 64-bit version of the Jet engine. Is the sql running on a 64-bit OS?

Grant Fritchey (6/3/2010)

Like doing something stupid for a long time makes it...

TheSQLGuru (6/2/2010)

Almost every property in SSRS can be set through an expression as well as directly entering a value. Right-click the Name text-box, and select text-box properties. Select the "Font" tab....

Sorry, I don't do c.u.r.s.o.r.s.

(See??? I can't even type it!) :w00t:

..... what's wrong with the query? Why do you feel a cursor...