Hello, we have a live production database and then another database that is
just for testing purposes. We would like to update the test database so that
it is identical to the live database. Someone told me that I can just take a
copy (i'm assuming he means backup) of my live ...

i'm looking at a query running on two different servers. It's the same
query, but in the SHOWPLAN and execution plan in QA on one server show the
keyword OPTMIZED.
e.g.:

Interesting subject to be sure.  I have MS SQL 2000.  Normally my users are
logged in via Terminal Services.  So to kill off the users I would log them
off via TM Manager.
However, I now have some FAT clients that do not use TS.  I can see the

Can anyone and everyone offer suggestions on a novice to intermediate book
or books to get on SSIS?

I am an XP Home user and Windows OneCare has tried to install SQL SERVER 2005
Service Pak 2 (KB948109).  It fails to update.
OneCare technicians say its not their issue to fix.  Error Message reads:
hotfix.exe is not a valid WIN 32 Application.  Extraction failed:

I'm trying to migrate from SQL Server 2000 to SQL Server 2005.  I've written
a number of SQL Server Agent jobs that do database backups every night in SQL
Server 2000.  I'm trying to copy the steps from these jobs that were created
in SQL Server 2000 to corresponding jobs in SQL ...

why this
update INTERFAC SET PARENTGUID = COMPUTERINFORMATION.GUID
generates this:
Server: Msg 107, Level 16, State 3, Line 1

Is there a simple way to get the time token
 $(ESCAPE_NONE(TIME))
to always show with six numbers, rather than dropping leading zeros?

I am having a problem with a datetime when passed as a paramater in a
procedure.
To demonstrate the problem I have created a small procedure which
selects from a view which has a datetime column.

Is it possible to restore a backup from a SQL Server 2005 SP2
installation to a SQL Server 2005 RTM installation?  (RTM = no service
packs installed)
In case there are no backups, is it possible to copy the SP2 database

I am running SQL Server 2005 SP2.  I am unable to get the SQL Server Agent
(MSSQLSERVER) service on Local Computer to start under any account other
than Local System.  The error is:
Error 1053: The service did not respond to the start or control request in a

Hi,
I need to move a SQL 2005 installation to another drive, or at least all its
databases. How do I go about it?

I found a deadlock situation during stress testing our ASP.Net app. The
deadlock is on a primary key index between two select statements select
against the same table where the index sits. How could deadlock happen in
Select statements is just beyond me.

We are considering installing an instance of SQL Server which would serve as
a back-end to Sharepoint. There is alrready a default instance of SQL Server
2005 on this server but the collation is case sensitive and Sharepoint
requires case insenstive.

Hi, I am using a store procedure that calls another three store
procedures. Two of them use linked server.
When I run this two store procedures on the query analizer it works
fine, but when I run the store procedures from the application displays