It depends what sp_HostProcess does. For example, if it creates a permanent table (or a global temp table) then you're likely to get an error in one of the...

I don't know anything about AS/400, but when using linked servers you have to use the four-part naming convention, specifying (I think) the server, the catalog, the library and the...

Yes. You have to change MyDatabase for the actual name of the database on the remote server.

John

DELETE FROM DB2400_WRITEPROD.MyDatabase.PALTEMP.CNTUPDR

John

In which case, can I borrow your car, please? It doesn't appear to have used any fuel on any of its journeys!

John

Please will you check - is TableNameT1 actually a table, or is it a view?

SELECT type_desc FROM sys.objects

WHERE SCHEMA_NAME(schema_id) = 'dbo'

AND OBJECT_NAME(object_id) = 'TableNameT1'

John

Are you saying that when you work with BusinessDate on its own, you don't get the error, but you do when you include other columns in your query? That...

Yes, the process is different from that for user databases. Search for "moving system databases sql server" and you'll soon find how to do it. I can't see...

Sergiy (4/28/2016)

---

There is nothing wrong with objects or columns named Number, Version, Join, etc.

The names don't affect performance or quality of the code anyway.

It's not a bad coding practice either.

The...

Well, yes - since you've tested in the WHERE clause that that condition is true, you don't need to test again with a CASE expression. But there's no syntax...

Good - does that work now, then? By the way, don't use TOP without an ORDER BY clause, since there's no guarantee which row you'll get.

John

Probably Zip4 is an invalid column, then. Do you get a similar error for this?

SELECT TOP 1 Zip4

FROM TimCIS.dbo.Legis_Districts

John

Thanks Drew. I didn't know that. It doesn't seem to make a difference to the execution plan in this particular case, but I'll certainly bear it in mind...

Well, you did mention SSMS! But anyway, that's easy. Use sqlcmd to call the stored procedure, and wrap that in a batch file.

John

Presumably the collation of the database you're creating the view on isn't Latin1_General_BIN? I think the easiest way to solve this would just be to put the same COLLATE...