Try saving manually with some of the compatibility options. I think the Jet driver saves in a compatibility mode and it may be different than your default save options.

You cannot have an ALTER PROC within a stored procedure (except perhaps with dynamic SQL). Are you looking at the definition of the procedures by right-clicking on them in...

No, the "GO" batch separator is actually part of the client tool. It cuts the batch into pieces.

You would have to cut the batches up yourself. However, that...

Nope.

You would have to deal with it using batch separators. Using a semi-colon after the point in which you create the database may solve your issue. Depending on...

Ideally, you would have a clustered index that is either in the order data will be inserted (to speed up inserts and reduce fragmentation) or using columns you very frequently...

I would guess you do not have KERBEROS configured correctly. Typically, when you cannot authenticate with KERBEROS, security will try NTLM and give you the error you are seeing....

Please don't cross-post

http://www.sqlservercentral.com/Forums/Topic521867-148-1.aspx

There are arguments on both sizes. I would suggest you search google for some information and make your own decision.

The main points will be data integrity and backups handle...

I don't know about best buddy.

I would ask the plan cache to help me move a couch, but I don't think I would ask it to take me to the...

Yes. Sometimes, I group some of the checks together - checking for NULL in any columns, for example. You lose the detail of which columns are a problem,...

RECOMPILE does not remove the plan from the CACHE, it just does not use the cached plan when the procedure runs.

Again I will ask, why would you want to continuously...

I would love to help, but I don't feel like typing in test data today since right in the newsletter is an article on how to post. Please read...

proc(@arg1 bit)

select * from table where x=y

and (a=b or @arg1=0)

No

It will depend on the types of errors you are looking for. Here is what I like to do:

Define an Error Description table that includes some kind of error...