Everything I've seen says the index rebuild causes a heavy use of the transaction log. It needs to do that in case the job is interrupted and rolls back. Rebuilding...

How big is the database? I've had a problem with queries locking up my database (182+ GB) and things being really slow. I couldn't run DBCC SHOWCONFIG at all. Finally...

What datatype is this set for:

@pnExchRate

It should be declared as NUMERIC(18,8) if it isn't, that's what's causing your problem.

-SQLBill

It's just what it says it is...something else is using that file. Are you backing up the backup file to tape? If so, is the tape backup running at that...

Here's an update:

Ran DBCC DBREINDEX on my 182+ GB database. Reindexed one table (116,331,780 rows, 36.795 GB). I stopped all connections prior to running the command. The reindex took 2...

NONE of your data meets the requirements from your query. You want to SELECT everything FROM table Item2 WHERE the Regdate is Greater Than or Equal to '2004/09/18 11:15:00'  AND...

Sorry about my typo....it should have been SP2. XP SP2 turns on the Windows Firewall and blocks several ports of which two are TCP 1433 and UDP 1434.

Are you getting...

You have to CONVERT it to a string. Refer to BOL for more information on CONVERT.

SELECT CONVERT(VARCHAR(8), GETDATE(), 1)

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP

Installed as part of the Client Tools

Found at...

When you install the eval edition it makes a registry entry. So unless you track down that registry entry and remove it - your computer knows that it already had...

Have you recently installed XP SP3? If so, it 'turns on' the internal firewall and blocks TCP 1433 which is the default for SQL Server.

-SQLBill

You CAN'T have that happen with your SELECT. You are asking for everything where the date and time EXACTLY match '2004/09/18 11:15:00'. And none of your values match that.

Based on...

I just (9/21) ran DBCC DBREINDEX on one of my databases. I only did the indexes on two tables.

DBCC DBREINDEX (dbname, tablename)

The database was 32 GB before the two...

Ahh, more information...they migrated your SQL Server to the AD. That means they changed domains - correct?

As for the 'path', in Security, click on Logins. There will be a...

Enterprise Manager sometimes has trouble keeping up it's information. Sometimes running DBCC UPDATEUSAGE works. Might also run sp_updatestats.

-SQLBill

One other thing....are you deleting the databases before restoring?

You say you have a database on Server 1, let's say it's 10GB. You backed it up and restored it to another...