I am a little confused about what to do after I fail over to the mirrored
server. I am running mirroring in high protection without a witness server.
What is the best way to manually failover to the mirrored database. And then
how do you set the primary to take back over.

Is it possible (using T-SQL) to delete a row from one table and insert
it into another? e.g. I have a table dbo.employee, an employee leaves,
so I delete their record, but want to place it into dbo.employee_old

Here is my scenario.
I have a source server (SRV1) with the database (BaseLineDB) that has
about 20 tables.  I have to create a package (or a stored procedure)
that can copy data from those 20 tables into a destination server.

Here is the cursor that I am writing to loop through the users tables
on one database and insert the data into the existing database on a
linked server.  That linked server database already has empty tables
with the same names.

Whenever I select the "New Query" option or attempt to open any saved query
in SQL Server Management Studio, I get the following error:
Attempted to read or write protected memory.  This is often an indication
that other memory is corrupt.

I am using SSMS to create a linked server to a VFP free tables
directory, and I keep getting this error after clicking 'Tables' in
the SSMS GUIr:
The OLE DB provider "VFPOLEDB" for linked server "T1" reported an

I am seeking some assistance on the following:
1) Assisting someone with Win XP SP2 with following relevant apps installed
to his PC through Group Policy (SQL 2005 Mgmt Tools, Visual Studio 2005,
Oracle 9i Admin Client) and 1 manual install of MS SQL Server (2000 ed).

When you change the database recovery model (from full to simple or from
simple to full) does this get recorded in the transaction log?

we are making changes in local company
We have a windows 2000 server with IIS and SQL 2000 with SP3a everything ok,
but slow... due many sites and traffic and SQL use of resources, until we did
some changes few days ago.

I have a below query.
Select * from Employees(NOLOCK) Where HomeCountry = 'USA' AND
HostCountry = 'JAPAN'
In some places i want to use 'OR' in place of 'AND' in the WHERE

I have a maintenance plan that has a step which rebuilds indexes.
While doing this the transaction log bloats to a huge size - 20gb.
As a result, available disk space is used up and the job fails.
Is this expected behaviour? (the log growth I mean).

We are running a test scenario with the purpose of "filling up" our
database. The client application that drives the test has 4 threads
which simply create rows in a particular table in the database. The
load on the server is constant at about 20 transactions/sec and each

I have a function written below:  I think what the tables are is
irrelevant but if you need to hear an explanation Ill be more than
happy to provide you with an explanation:
ALTER FUNCTION fn_v33_IsGroupApproved(@GRP_nID as int)

I'm going to install SP4 on SQL SERVER 2000 ENT SP3 but I'd like to know how
much disk space is needed in order to make this operation.
I tried the same operation on a test server (SQL 2000 STD SP3) and I wonder
why before and after installation the free space is the same......so ...

Has anyone ever renamed a clustered SQL 2005 Server and also change the IP
address of the instance?  Do I just change the parameters in the respective
cluster resources to reflect the new name and Ip address? Do I need to run
the sp_dropserver/sp_addserver command?