The previous reply won't work as the TOP 1 statement will limit you to returning only one Company in the select statement, the options for returning multiple companies with one...

What kind of error message are you getting from the job?

Not sure on whether there is a setting for this or not but it only occurs when a row is not returned by the SELECT statement if a row is...

Another option is to use FSO within the SP to return the Size and Free Space on the disks, useful when you're after values from more than one server.

Another thing to look out for especially while looping (Obviously to be avoid whenever possible) but if you're using something along the lines of ...

SELECT @Variable = ColumnName FROM TABLE WHERE...

We occacionally get that when trying to connect to one of our small sites over an ADSL link, when the link is down it can't connect and returns that message.

If you post the SQL statement on here it should be quite easy to sort out, it sounds like you're joining the two tables but not specifying how they are...

Also check Remote Procedure Call (RPC) & Remote Procedure Call (RPC) Locator services are running and what user they are set to run as.

I've had this one a couple of times, it's to do with permissions of the account the debugging process service is running from, have a search on google for it,...

SELECT Column1, Column2 FROM OldTable

UNION ALL

SELECT Column1, Column2 FROM NewTable

Bugger, sorry about that, didn't notice the reply above

You can download the CTP version of SQL 2005 at the moment and the final version is being released in early November.

We've just enabled the /3G setting on our system here and it's made quite a difference. As long as your system is solely a SQL box and isn't used for...

Nice, will have to have a look into that

Mmm I like the idea of BCPing the tables off the server on a nightly basis, that would save quite a bit of time on the odd restore due to...