I'll give it a try, but I'm not sure a GUI is necessary. As a design tool, I'd agree, but for making changes, I think I'll stick with my scripts.

Steve...

probably beginner's luck . I'm sure it works, but if it fails, you are stuck holding pieces and may end up manually doing it instead. I like...

This is dangerous to do in a trigger. The insert will not complete until the write does and that could be an issue from the OS.

From a trigger, you could...

Can you just post all the column names? or generate a script for the creation of the table.

Steve Jones

steve@dkranch.net

can you post the script that is giving this error?

Steve Jones

steve@dkranch.net

like

alter table MyTable drop column [MyColumn]

Steve Jones

steve@dkranch.net

I agree. EM usually works, but if you need something specific like point in time, you'd be better off with QA.

Steve Jones

steve@dkranch.net

Thanks for the update. Yes, terminal services causes some problems, becuase it is not the "console", but a virtual console that does not get all console messages.

Steve Jones

steve@dkranch.net

Another alternative. In sysindexes, the # of rows is stored. Accurate for clustered indexes. You can guessimate (or calculate if there are no varchar columns) the size of the table...

Good luck and you are welcome. Hope it helps. Personally, I'd avoid triggers if the system is loaded. Actually, I'd rather have something run every minute and snag the latest...

You'd want the textdata data column, but the T-SQL event stmt starting or completed. These will include other items, but you can filter the result with textdata like 'SELECT%' or...

Not being too familiar with PL/SQL, can you give an example? I've heard it is a more powerful languange, but not any specifics.

Steve Jones

steve@dkranch.net

I will admit that the GUI is easier to use, but that is often the problem. People mistake ease for right or the best way.

If you use the scripts from...

You should be able to run Nigel's code without an issue. I agree with Nigel and hate to use cursors, but if I have to, I'd rather decide how it...

Is everything exactly the same? There is an ADO bug that causes text problems if the text fields are not at the end of the table.

Steve Jones

steve@dkranch.net