If all you are trying to do is change the structure of the...

We maintain seperate fields for our Property Addresses and then assemble them when we wish to use them. It probably doesn't help for your situation but it helps us...

Thanks Irosales for the links. I will pass it on to our IT department. They currently have committed to moving off of the mainframe but it will probaly...

I doubt if it can be done. You might look into moving the application to PCs by using a PC based COBOL compiler. I'm sure this will take...

What is the actual name of the database you are trying to restore? Is it master?

Steve

In what format are you getting the data and how is it inserted into Sql Server? Since there is no guaranteed order of the data, the time to assign...

If this is trully an accounting system, what do you do with adjusting entries? You always have entries that are posted that will reverse or adjust the original amounts...

Is there no one around that has worked on the tables and maybe has a clue?

Is the application written in house and the people that wrote it available...

Also, if you do any ORDER BYs on the column, you will get a different result for the varchar than you will for the int.

i.e.: ...

If this were a one time event, I would use the search and replace capabilities of Query Analyzer but it sounds like you want to do this on a regular...

Perhaps a correlary script to disable contraints and triggers when copying large amounts of data from one database to another is

sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"

go

sp_msforeachtable "ALTER TABLE ?...

If you are using a field to determine what type of data is being stored in a row, I suspect that your data is not normalized. If it is...

A side question. I know that when you reboot, tempdb is rebuilt based upon the model database (privileges, etc.). Is the initial size of tempdb based upon the...

Just a couple of thoughts.

Could these people be a member of SysAdmin or db_owner? No matter what permissions are disallowed, they would still be able to update.

Is the field...

When you create databases for ESRI's ArcSDE, it always uses the logical names of sde_dat & sde_log, no matter what the database name is. Knowing how ESRI has a...