I need to delete ID '1' and '3' using SQL:
ID    Customer   DateTime
1      1              3/06/2005 03:00:00
2      1              3/06/2005 00:00:00

Hi, our ERP software connects to SQL server 2005 Ent. 64 bit throw ADO
2.8.
The application runs on a Windows 2003 Server with Terminal Server
environment.... so the users work on the same server.... and a second

Good morning!
Okay, this question is regarding putting a second instance of SQL2000 on the
SBS2003 box.  Client has an application that makes use of SQL and they
have - against our suggestions and recommendations - decided to install a

I have an Access 2003 application that works well in a LAN environment with
a Jet based back end. However, I would like to move this back end to a SQL
Server database hosted on a website so that my users could run the
application from any Internet-connected PC, using a modified ...

Error:
Type:    Replica creation
Status:    Failed
Description:    An unexpected error occurred during job execution. (ID 104

table 1
abc
241060     3332.29   
table  2

I was deleteing old data (app 400 MB) from an MSSQL server, with max 4
GB. Now it is 4,83 GB, and I cannot loginm I get a timeout error.
When I try to login with a username it gives a correct error, seems
like it works, but it is just slow (due to size?)

I backup and detach a database ABC , then delete  ABC log file for ABC
database, then attach database ABC .
This affects the XYZ  log file and XYZ database. The datestamp for XYZ
database and XYZ  log file is then the same as for the ABC database.

I had SQL express installed and tried to upgrade to SQL 2005.  It allows me
to create a new named instance but won't upgrade the default instance.
Is there any way to upgrade the default instance or can I remove the default
instance so that I can reinstall it at 2005?

I want to write a query that will tell me if there are queries that are
still running  and are past 20 mins since it came in ? How can I do so ?
I am using SQL 2000. If i can have one for 2005, that would be fine too.
Thank you.

I'm suspecting that one of the .NET applications that connects to our SQL
Server 2005 occasionnaly goes into an infinite loop while inside a
transaction.
Is there a way to force an error on the connection in case it is in a

SQL Server 2005
What's the best way to move a half-terabyte database from one drive to
another, while minimizing downtime? Simple backup/restore or detach/
copy/reattach take too much time.

My question is about updating statistics.  I have come to find out
that letting SQL Server create and update statistics did not work for
me in my highly transactional production database.  We started seeing
applications timing out for stored procedures running 30 seconds or

Our SAN storage team states that we dont have to worry about RAID 10 or RAID
5 and they will give us the performance we need. They said its RAID 5 and
because they have so many spindles under that RAID 5, it is equivalent to
RAID 10.

I just upgraded an old SQL7.0 db to SQL 2000, and put it on a new server.  I
can't get the backups to run from the maint plan.  It gives the above error.
I found this, but the directory I'm saving to doesn't have -S in it.
http://support.microsoft.com/kb/326485