There's no Oracle-equivalent ROWNUM in SQL Server unfortunately. However, either of the follow methods can be used if you have column/s that uniquely identify each row.

If no...

You can use the WITH MOVE option when restoring user databases onto the clone, directing database data and log files to new paths.

I'm sure about whether you can do so...

I'm a big fan of Inside SQL Server 2000

Cheers,

- Mark

No, you put the index on the column in the underlying table.

You CAN create indexed views (which materialises the view), but you need Enterprise Edition and a number of ANSI...

Chris,

Is the trigger being fired? Does the view meet the requirements for INSTEAD OF triggers?

From the looks of your code, it doesn't cater for multi-row updates, so any update...

'fraid not Steve. Trigger on system tables aren't supported.

However, I do have plans to write a (customisable) auditing procedure. If I pull my finger out I might get...

There's built-in C2 Auditing, which I suppose is a bit over the top for your purposes, or the alternative is writing and scheduling a continuous server-side Profiler trace with customer...

The file name "dbClient_Log" appears to be wrong. Are you sure you're not suppressing file extensions for known types in Explorer? The log file would, under normal circumstances,...

I understand your problem of working with legacy systems. Sometimes there's a few warts that one just has to live with.

One final suggestion... that all of the update code...

Backup the database. Copy the backup file to the CD. Restore the database on the other machine.

Cheers,

- Mark

You can shrink the database manually (from EM right-click on the DB, choose All Tasks, Shrink Database) or set it for autoshrink (from EM right-click choose Properties, options).

The former is...

The attempt to cast a non-numeric to integer is what kills it with severity 16. You can't get around this other than avoiding the CAST. So, you should...

Are you sure it's running?

Cheers,

- Mark

I take heart from being part of the 50+% who got it wrong.

Cheers,

- Mark

Are you getting the error message from EM? If so, have you tried restarting EM?

Cheers,

- Mark