I've done something exactly like this...based on the rows in a table, a view with dynamic pivots gets altered.

in my case, i write to an events table from within the...

The Alais is just what the linked server...

i seem to remember that the msdbora driver was valid only up to oracle version 9; with 10 and above, the blob type fields cause issues.

if your select statement did...

the rule of thumb is each object in a statement must be uniquely identifyable, whether by object name or by alias;

in your example, each sql is standalone and following the...

well first lets get rid of the cursor.

there is nothing a cursor does that a set based operation cannot do, and the set based would be a couple of orders...

statistics most like is the culprit.

if your SSIS package is insertint/deleting/updating rows, and then calling the procedure, the statistics are probably very different than when the stored procedure was created.

update...

there was a thread alst week on how performance can be poor when you try to drop a temp table , where you created a temp table, and then...

cvandevoorde (12/6/2010)

---

Huh... The 2 columns I noticed the problem with, the PREFIX and SUFFIX, are char(8). The others are varchar.

I still don't understand why, if the columns...

I'm not sure the return code will help; it signifies whether the procedure executed without errors or not...not whether the email was sent successfully. the email gets sent asynchronously, when...

i think you'll just have to wrap a section of the query into a subquery, since the data has to be filtered on the LIKE statement first;

because the second part...

also you said "online database"...maybe you meant you are using a web server and a database together?

in that case, the web server can return the IP Address and mac address...

are you familiar with connections to the database?

every connection is assigned a uniqueID..the @spid...they are typically an integer starting at 51, and goes up.

in any of your database code, you...

one of the DMV's has the IP address in 2205 and above:

select host_name(),app_name(),client_net_address from sys.dm_exec_connections where session_id = @@spid

i tend to use this snippet for auditing:

SELECT

getdate() as...

here's what i use.

note you have to download the command line version of 7zip. like all other zip files i know of, you cannot use the GUI, it's always a...

if you are importing data, i think BULK INSERT can do anything that BCP was going to do;

writing to a file is a different matter.