We are running SQL-server 2000 Standard Edition on a W2K-server today and we
are going to buy a new server for faster performance. My question is: Is it
possible to change to SQL2000-server Enterprise Edition on a Windows 2003
Standard Edition-server or do we need another ...

I have a query :
Exec 'Select * From Receiving Where Code In (' +  @pCode + ')'
@pCode will contain more than one string parameter, eg : A1, A2, A3
How can i write that parameters, I try use :

Does anybody know how to get tables structure of linked server (DBF tables
via ODBC connection). I know that table structure of "normal" (not linked)
server can get from systables and syscolumns tables, but now I need a
structure of linked server tables.

I have this scenario :
My log is full, and nobody can writte into the db, how can I clean it ?
(recovery model is full and I have a backup of log before this problem)
Do you know the steps ?

I am not sure if this is possbile.
I would like to create one record set, based on the count of say like 6
tables.
Select Count(*) as RecCount from Table1 where User = 'John' (6 matches)

Someone told me that some non-US address do not have State/Province, and
some might not have Postal Code.  Is this true?

We are experiencing problems inserting or updating image fields from
one table to another in SQL Server.
When we do this what ever size of file we insert is doubled in size
when it is inserted into the destination table.

Hello group,
Does anyone know how near a word needs to be to another word to be
included in the results of a CONTAINS search that uses NEAR? Is this
setting adjustable? Is is stored in the registry? INI or config file?

I did an upgrade of a site system, computers and servers from NT4 server and
workstation to Win2K server and XP workstations. I made a backup of the
datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
change DB owner and then preformed another backup from the ...

I am doing a test on migrating an Oracle 8i database to
SQL 2000. I've never done this before and I would like
to find out if there are any complications or side effects
if I try doing the transfer of data using DTS?

I have a SQL Server with a fair number of databases and a large number of
tables per database.  I want to audit user inserts/updates/deletes, etc.  I
would also like comprehensive reporting features as well.  Is there a tool
for this?  I would be willing to invest the money it ...

Please i would like someone to assist me. I am new to the SQL and
how to use it...I need to know how to  efficiently use the SELECT
statement through error messages from our server. I look forward to
your kind reply soonest.

Please see my schema for this table at http://www.middletree.net/latest.GIF
I want to do a query that returns to me the data from the BriefDesc field
from row which, according to the TIMESTMP field, is the most recent row. I
am doing a search by TicketID. That is, there will be ...

Hi,
I'm trying to create a Stored Procedure that returns a recordset, but I
want to be able to choose the ORDER BY clause in mijn parameter list of
the Stored Procedure. Since CASE .. WHEN can only be used in the SELECT

I have a fairly complex access frontend/backend app which I need to upsize
to SQL Server. At this stage I would prefer to use access as frontend. I
have the following questions;
1. Should I keep using the mdb as frontend or switch to an adp (access