Obviously there will be some sort of hit, but if things are indexed properly, the hit will be small.

If you add a child record, SQL server has to make sure...

ISQL/W is actually Query Analyzer.

ISQL is the earlier command line interface for doing the same thing as Query Analyser (i.e running queries and getting back results)

Try this (note, credit to Gert Drapers - it was his script initially)

declare @dir nvarchar(4000)

exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',N'Software\Microsoft\MSSQLServer\MSSQLServer',N'SQLArg1', @dir output, 'no_output'

if @dir is null

begin

...

The primary key doesn't have to be clustered, and in many cases that's...

RESTORE [font="Comic Sans MS"]HEADERONLY[/font] FROM DISK='C:\MyDisk\MyDBLogBackup.dmp'

Natural keys have one big disadvantage... they can change.

If your natural key to identify a person is the National Insurance No (UK equivalent of the Social Security Number in the...

Check BOL... it tells you that CREATE SCHEMA must be run in its own batch.

Therefore you aren't going to be able to put any other statements (e.g. if exists...) in...

That's the bit I'm worried about... moving the data to the new filegroup.

It took 2 weeks in development with no users...

It sounds as though your REXX/SQLConnect is automatically starting a transaction. If you can't stop it from doing this, try adding this to the beginning of your stored procedure

if @@trancount...

You don't have snapshot isolation in SQL 2000, but you do have "READ UNCOMMITTED".

That...

Still not ideal, but you could save yourself a bit of scripting...

Assuming you have a test copy of the database, do the change using Enterprise Manager, and capture the queries...

The script below will list all the full backups restored:-

select physical_device_name

from msdb.dbo.backupset b

inner join msdb.dbo.restorehistory r

...

The last one probably timed out because it took longer than the others to back up.

You will need to specify an infinite timeout (0) when you connect to the server,...

A few thoughts:-

Performance aside, does the tenant_id need to be part of the primary key?

You might have...

Are you sure it isn't already installed?

Have a look in the services applet and see if you can find a service called "SQL Server Browser".