Job skips certain queries?

Has this happened to anyone else?

I have a large job and all the queries run fine when used
individually, but in the job, SQL says completed with success but in
two cases the queries did not run. One of them is even ridiculously
simple: DROP TABLE tblMyTable, etc.Steve (go2toa@.hotmail.com) writes:
> Has this happened to anyone else?
> I have a large job and all the queries run fine when used
> individually, but in the job, SQL says completed with success but in
> two cases the queries did not run. One of them is even ridiculously
> simple: DROP TABLE tblMyTable, etc.

Are these individual job steps, or are the part of a larger batch?
It is quite difficult to give any assistance with that minimum of
information.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

JDBC drivers and SQL Server 2005

(1) Will Microsoft provide a JDBC driver for SQL Server 2005?

(2) If it does, will the driver allow a person to perform SQL queries on the XML datatype and/or XQuery types of queries?

Thank you!Hi,
(1) Microsoft is working on a driver, I read in a thread some days before.|||I found the thread, here read this:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=14948|||re: (1) yes, will have more to announce about Betas and release dates shortly

re: (2) yes, SQL Server 2005 XML data type work is planned, but it's not finished yet so I don't want to comment too much on specific functionality.

-shelby