Hi, All experts:
I first built sql2000 and restored database from one server to this new
server Win2K3.
Now I installed sql 2005 in a different folder but the old database of sql

I have an existing server running SQL 2005.  I want to know the correct
process to replace this box.  Right now the server name is ATCSQL and I want
the new server to be called ATCSQL when the process is finished.
Should I build the new server up under a different name, install ...

tblStudents
 StdCode Int
 Year       Int
 Class      VarChar(2)

In the old versions of SSMS and EM, the activity monitor would show idle
but connected clients; you could tell who was connected to which
database, i.e., you needed to restore a test/dev DB and had to know
which users to 'kick off' to make it happen.

When I upgrade from SQL server 2005 to SQL Server 2008 (Standard Edition), I
see 2 folders in the start menu, one related to Microsoft SQL Server 2005 and
other related to Microsoft SQL Server 2008. And none of the menu items under
Microsoft SQL Server 2005 are working. Only SQL ...

We have an application which runs as windows service, has dependency on
MS SQL Server (MSSQLSERVER). Somehow when the machine is restarted, our
service is trying to start before MS SQL Service is fully started and our
service is failed to start.

MSSQL backups are odd in that the data and transaction logs are two different
backup operations it seems.  Normally, when a backup is performed, the data
and log file can be archived at exactly the same time, and the data file in
the live area is the same as the archived one ...

I have this trigger that I want to create:
CREATE TRIGGER trig_Activate_Account
-- Set Activated to 1, set Acct_Status to Active
ON Acct_Profile

I'm having problems with searches via a classic ASP front-end of terms
including foreign characters.  For example, Profiler indicates that a
search for: все ок, юзай на здоровье
is actually executed as:

We just migrated from an XP server to a 2003 server.  From 2000 to 2005.
Everything on the new hardware is supposed to be far superior to what we had
on the 2000 sql box but performance is down in the dumps.  I mean its BAD.
I can dig up the specs on everything but I figure ...

I feel like I'm banging my head against the wall
I created a function
CREATE FUNCTION [dbo].[fn_Check_Digit](@ID varchar(10))
RETURNS varchar(12)AS

This is a question about the TSQL generated by linq to entities but you guys
will be able to answer it. I have a simple where clause, which uses a
varchar field called CustomerKey. The actual TSQL looks like this:
WHERE N'LAN56' = [Extent1].[CustomerKey]

i'm midly interesting, in perhaps finding out about what might be required
to use version control on SQL Server objects - should i decide to look into
thinking about version controlling them.
(Is that enough of a disclaimer?)

I created a trigger as follows,
declare.....
select @fieldName =(select  name from syscolumns ......)
select @oldvaluesql ='select @oldvalue = ' + @fieldName + '  from deleted'

I am on  Windows 2003 using SQL Server 2000 EE. I have heard both good and
bad things about parallelization.
I am an Oracle DBA getting into SQL SERVER  World. Oracle will only use
parameterization if certain conditions have been met, i.e., table is set with