I can't say for certain, but I believe it only applies to the GUI in essence. It will have SOME generic other advantages since this data is ultimately being stored...

The intent isn't for the backup version to be executable. In fact, prior to making modifications it already is broken. I just "need", so to speak, a backup of the...

THANKS!!!!!!!!!!!

This was exactly what I was hoping to find! I got very lucky in that one of our new hires just happened to have that book. For everyone else, xp_setpriority...

That was the answer I basically expected. And I can't find what I was reading that I thought mentioned it being low priority. It may not have been BOL and...

Did you click the "Show step details" button and highlight the step that failed?

If you edit the job, edit the step that is failing, and switch to the Advanced tab,...

I might have missed something, but can't you just select all the stored procedures (CTRL-A) from within EM for a database, right click, Generate SQL Script, uncheck both the CREATE...

I am going to assume that ID_rec is the key for the MED_Progress table and that "ID_rec, RecordDate" is the key for the incPRE_Med_Progress table. If the link between the...

This is basically what I referred to in my earlier post. It can also accomodate other punctuation if you add replace statements for them. Basically, step one is to convert any...

There might be a better way, but I don't know of a SQL Server function to auto-detect numeric format type. In this situation (I'm no expert on international numbers) you...

If the stored procedures are working on the entire view results then you can't really do too much. If there is a WHERE clause then the following should work a...

SET ANSI_CAUTIONS OFF

Too bad that didn't work either.

The only thing I can come up with is to use OLE/ActiveX/COM+ to launch osql from within your script to execute the rename....

That may be your only decent option if your where clause is based on expressions in the view (forcing it to resolve the whole view prior to filtering rows), but...

Apparently there are no unique constraints (such as a primary key) on the table? Unless that is true, it seems to me based on what you said that the number...

Pulled from the following link: http://www.karaszi.com/SQLServer/info_generate_script.asp

The SQLDMO API (DDL only)

The scrip generation code used by Enterprise Manager and Query Analyzer is available for us to use in the...

I think I followed it. As a baseline, check out BOL. Go to the Index tab, look up "triggers" and then the "multirow" subcategory below that. Given that, I think...