Something like this?

CREATE VIEW dbo.foo

AS

SELECT ... FROM otherdb.dbo.bar

Do not forget about ownership chaining though if that affects you.

I think you are out of luck, the file is gone.

It's been some time since I used VB6 and ADO, but as I remember there have never been any implicit transactions like you describe them. Executing two statements in one...

With Lumigent Log Explorer you can restore a single table.

But there is no need for the dev to have a san. You could run it on a USB disk if you wanted. The thing that is important is that...

How do you mean it doesn't work? And the new query would not always return the same result as the one using IN, are you aware of that?

That location should not contain the data files, it contains only a script to create the database (and places the files in the same location as master) and csv files...

What does your VB code look like? And the procedure that you are calling?

There is no built in method for it. Whether or not a CLR method is the best way to go is difficult to answer, it depends on a lot of...

But the production server is running SQL Server 2000 as well then I guess?

If you do not get a good answer from someone else who are using the JDBC 2005...

Are you sure that the login you are executing this with defaults to the schema that owns Employees?

There is not really anything out covering the product as a whole (will there ever be?). Kalen Delaney will of course have an Inside SQL Server 2005 (three volumes actually),...

The date does not need to 'look like' any special format. Use a command parameter with type specified to datetime when passing the date. That way you do not need...

Then you should be more than ok with Express Edition. You would of course have something larger for your development machine so you get all the tools.

You can download the latest version, the June CTP, from http://www.microsoft.com/sql/2005/productinfo/ctp.mspx.