You could use an EXECUTE to drop and create the table via another connection to simulate the GO.

Do you really need to drop the table? Perhaps you can truncate it if you are using the simple recovery model. Is the blpu_rcords table changing structure between...

This refers to v7 but should work,

"To mark a provider as in-process, use one of the following two processes:

Create a linked server in SQL Server 7.0 which specifies...

I don't know what account it would use. Perhaps the security event log will have entries that will indicate what account is having access problems. It might...

I just found a QOD that relates.

http://www.sqlservercentral.com/testcenter/QOD.asp

The date for the question is 9/24/3003.

The answer links to http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/aghtconfig_15bm.asp which indicates that Allow InProcess should be checked. ...

Maybe the "Allow InProcess" needs enabled. See "Configuring OLE DB Providers for Distributed Queries" in BOL.

From Q280106 - "You can set the Allow InProcess option directly through...

You could try running MSDE using the domain admin account (or your account since it worked when you ran it logged in) just to see if it would work. ...

My shot in the dark.... Perhaps MSDE is unable to access a required file. Can it access both the local Jet dlls (not part of MDAC 2.8) and...

If case sensitivity is required and the collation of the db or column is not case sensitive, a cast can be used to change it without db redesign. Changing...

quote:

---

If you use certain types of software, like Great Plains for example, you must use the sa password to set it up,...

The default BUILTIN\Administrators works fine most of the time. However, you might have a policy change (error) or other failure that would prevent authentication (been there). The sa...

Just a note of caution: Using the ON clause to reduce the records while using an outer join does not always produce obvious results. If the record is...

Also, if there is any chance of a trigger being required on a table, I want an identity column. I do not know of any better way to match...

I did not read all the responses - so many! However, I don't think concurrency was mentioned. Placing a clustered index on an identity column places new inserts...

In the update trigger, use the inserted and updated "tables" to compare the record values before and after - they might not actually change. An identity id is handy...