I understand that in order to shrink transaction log backups in SQL 2000
that you run the following scripts:
BACKUP LOG TestDB with TRUNCATE_ONLY
DBCC SHRINKFILE (<FileName>, <TargetSize>) )

I wonder if anyone can help me.
I have a table (tbl_nonWkgDays) which temporarily holds a (unique) employee
ID (empID) and a field for each day of the month for that employee (day1 to
day31) within each empID record. Each day field holds an integer that

Gurus,
Running SQL Server 2005 SP2.  Does the SQL Server Profiler tool tell you how
many transactions are occurring per second anywhere?

Hi
I have installed a sql server 2000 using "local  system account". SQL mail
does not work with local system account so i need to change it to domain user
account...

Greetings all,
We are using SQL Server 2005 Express and SQL Server 2005 Developers
Edition in developing our new product.
We are attempting to spec out what version we are going to use in our

If I have setup a database mirror, will transactions associated with
Reindexing and Reorganizing be copied over to the Mirror?  or do only actual
data changes (Inserts, Updates,Deletes) get copied over?  I'm wondering
because my transaction log gets very big during reindexing and ...

I need to write a select statement for a table that looks like this (it has
MANY more columns, but these are the ones that count)
RowID    (int - Identity)
StartDateTime    datetime

Both of my machines run Windows2003 R2 server.
At present this box has SQL2000 standard edition and is also a web-
server.
Question1:

I'm trying to connect to my SQL 2000 db server through enterprise manager
using a SQL ID and password, but I keep getting 'Login Failed'. I have the
ID and password setup on the server but I can't connect using that ID and
password. What would cause enterprise manager to fail and ...

We have a client running SQL2005 with a 5 CAL license. They are now looking
at substantially changing their use of SQL, and wish to change to
per-processor licensing.
Is this possible without a reinstall, and if so, how is it done?

i've SQL server installed on a customer site, i want to make a new
Maintenance Clean up task, through maintainance plane wizard
I don't find the Clean up task, SP2 is installed.. is there any thing to
make it available ?

I  have a .NET Windows 1.1 based application which uses SQL Server 2005. The
Executables are loaded in each of the 30 client PCs in the network. Every
now and then some of the client PC's slow down and then crash. They wake up
if we reboot the SQL Server machine.

Recently upgraded a 2-node Windows 2003 Cluster running SQL 2005
Enterprise Edition (single instance) from SP1 to SP2 as well as
Cumulative Update 6 (CU6).
Everything appears to be running just fine, except Database Mail does

All,
I have to create a temp table, insert records into the temp table, return
the records from the temp table and drop the temp table.
Becuase the temp table structure is not before hand I have to create it

I just renamed my physical database name like so:
alter database "tom2 database" modify file (name = "toms
database",filename="\\devsql2005\SQLData\tom2.mdf")
And got the message: