What are the data types of the columns being transferred? I'm wondering if an implicit conversion is happening when the data hits Oracle and throws that error. I've...

sp_denylogin did the trick. I've been trying revoke, but that just removes the account entirely from the server. Thanks!

Use xp_cmdshell

As an example:

EXEC xp_cmdshell 'del C:\test.jpg'

Check BOL for any restrictions on using this sp.

I'm assuming your "system" is an application sitting on top of SQL. If this is correct, the quickest solution would be to parse the string within the app while...

Every job has an initial start off point, otherwise it wouldn't be a scheduled job, but an infinite loop of execution. The SSIS or DTS package would act as...

Effectively, there is a "job suite" as you put it, but not in the traditional sense. Because DTS and SSIS can call other DTS and SSIS packages and they...

They do, there just isn't something as simple as a disable checkbox on the step. To go about disabling job steps do the following:

1. Open the job
2. Open the Step before...

No, it's not using any table variables. Complex joins, sub-queries, simple-parameters, yes, but no table variables or anything outside the normal bounds of a SP.

Well, I still don't know why the SQL 2005 upgrade caused such a drastic switch in execution plan generation, but to solve the problem (so we can again utilize automatic...

Roger, thanks for the reply, but in my situation I do not believe this is the case as my stored procedure isn't called a great deal. Your issue may...

Append ORDER BY [COLUMN NAME 1] DESC, [COLUMN NAME2] DESC, etc.

Your code isn't best practice, but it won't execute because it's formatted wrong, not because of context.

Change SELECT @sql =...

I've ran the query through DTA and it gave me an estimated performance increase of 27% when my query was running around 1:18 (which puts the estimated time of completion...

You don't necessarily have to make a new field to make an index. Put the select statement into a .sql file then run it through Database Engine Tuning Advisor....

What permissions does the account have on the machine that you're running the installer under? If it's a power user or something with more restrictive settings, you may not...