I have some processes on my SQL 2000 Enterprise SP3, that won't go away
unless I reboot the whole physical server.  I've tried restarting the SQL
service but no luck.  Anyone has suggestions on why these processes won't go
away?

I have a table that has 8 columns and if looked at on row by row basis, every
row has at least one entry.
I need to keep the data in the first 2 columns together, second 2, third 2
and fourth 2........basically the integrity of the rows is by groupings of 2

I am having a database in SQL which is of size 6GB. My application will be
logging the data into database, which makes increases the size of
database.(currently it is growing by 10%).
I am running a query againest the database, which refers many tables, which

I'm trying to stop and re-start my MSDE instance (it shows one user is still
connected). I've used the Service manager to stop it thinking this would
disconnect the user (really new at this). It shows "stopping instance name"
and it doesn't do anything.

Hello all, i have a question i've beenk thinking for a little bit and
cant seem to come up with a solution. What i want to do is add a unique
counter to a resultset in query. For example
SELECT ColumnA, ColumnB, ColumnC, ColumnD

     I write you because I have a big problem with request access : when
       I use a sql server wiev in access (attached view) and i join it with
       a local access table, the sql server trace say sql server send all
       the data of the view to a access   . This view have ...

I'm in search of a sample database (along the lines of Northwind or AdventureWorks...
but not) that I can use in product demos. Preferably free, but if you know
of one that's also for sale that would be great too. Any ideas where I can
find something like this?

Using VB, I'm creating a table in SQL Server that has two columns defined as
a primary key, however I get an error msg telling me I can't have multiple
primary keys.   Here is my SQL statement.
CREATE TABLE INSP_Detail (INSPDT_Ins_Num integer PRIMARY KEY, INSPDT_Seq

Using Sql Srv 7
I know I can use the system sp's sp_stored_procedures and  sp_sproc_columns
to determine all the sps in a db, and what input parms there are for a
particular sp... but... if the sp returns a result set, is there a way to

Please see my data below, for each account, I would need the lastest
balance_date with the corresponding balance. Can anyone help me with
the query? Thanks a lot!
create table a

We are replacing our server with a new 2 processor system, with Windows 2003
server.  My question really has to do with licensing, partially.
If I use our currently licensing for SQL2000, which is licensing the server,
and CALS per workstation, will SQL be able to utilize both ...

I having trouble with this sproc. I get the following error when testing:
Server: Msg 245, Level 16, State 1, Procedure UTL_CompletenessCheckLoan, Line
231
Syntax error converting the varchar value 'danwet w125 ' to a column of data

i want to use the result set from a stored proc in another stored proc, for
example:
create stored procedure proc1 (@x int) as
declare @tbl (y1 int, y2 int)

In my SQL Server 2000, I have a Table MyUser which has one colum PassWord,
and the PassWord's datatype is Image.  I'm wondering how can a password be
an image.
Thanks for help.

I have recently installed SQL Server 2005 on a server running Windows Server
2003.  I subsequently installed Visual Studio, which installed SQL Server
2005 Express Edition CTP.  I am concerned that the Express Edition might
interfere with the regular SQL Server.  Are there ...