somewhere in the report, it is referencing a column that does not exist in the SQL statement returned into the recordset. a valid  recordset was returned, and has rows, otherwise...

you typically use ORDER BY new_id() to randomize results:

SELECT top 5 CATEGORY_NAME ,ASSETS_NEEDED_FOR_ASSIGNMENT FROM MYTABLE ORDER BY NEW_ID()

run it multiple times, and you'll see the data is random.

you should be able to use the object_name function without translating to decimal:

select object_name(0x4319E038)

select object_name(0x60FC61CA)

ok how about this: can you do this to the linked server? using the SELECT ...INTO feature, but make sure the where statement returns no rows, so it creates the...

I think that's my next step.... I was looking for an easy sleazy way to get results from any old DLL, but I think I'll have to slap together an...

you didn't post any changes, so I'm assuming you are still not checking for nulls.

add this function to the page:

Private Function tnull(s) As String

    If IsNull(s) Or IsEmpty(s)...

in that case, here's an example from vb6: create a form, slap a button on it, and have the button call this function.change the SQL statement to your table, and...

Also you've got to watch for the problem where if an error is level 16 or above, execution stops PERIOD... so it would never go to the log stuff.

so if...

Man you've already covered the basics, I see;

Ok, i'd look at file attributes , file locking, and finally folder security... gotta cover the basics.

any chance that the folder or the...

i'm guessing that the username that is used to run SQLJobs doesn't have rights to the F:\ScriptedFiles\Oracle\DownloadedFiles folder;

is this a mapped drive? try changing it to a uncpath: ie

i know for SQL 2000, there's an applet in the control panel: Start>>Control Panel>> SQL Server Licensing Setup;

mine says Processor License for 2 Processors, and doesn't have the ability to...

not natively in SQL server; there's no implicit conversion funcitons in SQL for images.

you have to farm it out to a .NET object for example, convert it, and then put...

there are a lot of script contributions that do decimal to hex and hex to decimal for example, but non of them have the exact format you are looking for;

take...

I agree with Colin; Server does not exist or Access Denied.  is typically the application cannot connect, and has nothing to do witht he number of allowed connections.  A different...

because spids that are below 50 are system processes, i usually use this for the rough guestimate:

select count(*) from master.dbo.sysprocesses where spid >=50