I have two physical drives attached to my local machine (C: (40GB) & E:
(250GB) )
I have a large .mdf & .ldf that I detached from C: and (using windows
explorer) moved to my E: drive.

I am very new to SQL 2000 and I created an operator. Can anyone guide me on
how can I delete this newly created operator?

Every article which I've seen proposing Stored Procedures makes the same
comparison: Stored Procs are faster than submitted SQL because Stored Procs
are precompiled. Fine, but there's a third alternative, which I haven't seen
mentioned at all. How do Stored Procedures compare ...

I currently have SQL 2000 w/sp4 on my server. Can anyone tell me how I can
create a new instance? I'm looking to install WSUS and so far, because I've
installed it without creating a new instance, backing up the database is a
bit difficult for me.

CREATE TABLE Sales1
(
 varchar (10) CustID,
 varchar (10) TransID,

can anyone tell me the command to invoke Microsoft SQl Server 2000 backup
wizard. Other than using Enterprise manger or T SQL.
Which can be run from the command prompt

Hi again,
I am able to schedule a backup and default it to the server. However, is
there an option or a way to locate the backup somewhere else on the network?
regards,

Hey all, sorry for asking such a grunt question, and thanks in advance
for any help...
My hosting ISP offers access to their MS-SQL database, and my
understanding is that it's generally simplest to use some sort of

I need to upgrade an access app to sql server, for the first time. In the
first phase I would like to upgrade only the backend to save time. Are there
any pointers for a newbie to help in the upgraded?
I need to give a time/cost estimate to client for the upgrade (backend &

Please help!
Getting this error intermittently:
System.Data.SqlClient.SqlException: Timeout expired.  The timeout period
elapsed prior to completion of the operation or the server is not

I'm chasing after a documetn that was available on one of the Microsoft
websites that was titled somethign like "MS SQL Server Best Practices"
and detailed a nyumber of best practices about securing the server.
Included in this was revoking public access to the system table

What would be the correct way of writing a sql select state with where
clause while also using IF ELSE. I am using T-SQL and I cannot get it
to work. I probably have the syntax wrong.
I want to be able to have different where/and/or clauses in the sql

I have a table that has a units column that is varchar because some of the
units have text in them.  I'm attempting to update the units into a new
field that is called Fxd_Units.
Update Tbl_MyTable

Could anybody tell me why is better have an ERP with SQL Server than other
with Visual Fox Pro databases?.
My boss are evaluating two software one in Visual Fox and other in with
Visual Basic or ASP but both with SQL Server database.

We are moving to a new ERP system next year based upon a SQL database. Max
100 users, generally between 50-60 users. I've tried to find out what the
recommendations are for running SQL on a different server to the actual ERP
system, but there don't seem to be any. Would anybody ...