that's the only usefull information I found on oracle linked server in combinaison with the books online : http://www.sqlpass.org/Forums/messageview.cfm?catid=376&threadid=12178

near (provider='oraoledb';data source='oradbname', user id=scott;password=tiger)

I would help you further but I have...

Nice call cjensen... I missed that one.

This should do the trick (just removed First() and the having that didn't filter anything):

INSERT INTO Table1 ( [Application Field], CountOfApplication )

SELECT Software.Application AS [Application Field], Count(Software.Application) AS CountOfApplication

FROM Software

WHERE...

I don't understand what you are trying to accomplish, if you open notepad everytime the trigger fires it's gonna open notepad on the server (not the client's computer).

Why do you...

The only time you can use an aliased field name is in the order by clause... or if u are using it in a subquery

--order by

Select a*b-c as Calc1, SommeCol...

Maybe the length of one rows of the results goes over 8060 bytes (which is the maximum allowed by sqlserver). The data might be different from server to the...

This will do the trick (I posted this on another thread and that's exactly what you need since it's not dynamic SQL and it won't be limited by any number...

BOL = Books online (Microsoft help file for sql server).

If you can't use a linked server you can do something like this (this is for dbase IV but I'm sure...

I've been coding in asp with msaccess for quite a while and there's just no way of doing this task in SQL only with access. You really need the...

Do you mean that you want to open notepad everytime the trigger fires and write something in notepad?

Superfast set based query (0.093 sec for a table of 10000+ records of 40-50 characters):

CREATE TABLE [Numbers] (

[PkNumber] [int] IDENTITY (1, 1) NOT NULL ,

CONSTRAINT [Pk_Number] PRIMARY KEY...

I'm not sure I get your problem. Are you trying to use the same connection object to connect to another server or another DB and that isn't working or...

Query analyzer with a great DBA 🙂

You'll have to use the profiler. When starting a trace you can add filters (in trace properties / filters) such as user name, appname, events, database, objects...

Just ask if...

The only thing I can think off is that the statistic were updated and that the execution plan changed after the reindex because a better index was found.

I ran into...