we are using sqlserver 2005 on windows server 2003 sp1 with 4 gb of ram.
sqlservr .exe normally shows 70 aor 80 mb memory utilization.but from last
few days it is showing 700 mb to 800mb due to which our processing become too
slow.

I'm hoping someone can shed some light on this.  We're using sql
server express edition, and our server has a couple of databases (in
addition to the built in ones).  We've been using user sa, with a
password set (non-blank) to access the databases.  Suddenly, we can't

Hi, we are using sql 2000, what would be the good way to validate different
databases current data with seconday server's data after logshipping applied?
thank you

I'm trying to find a way to import data from a local access database into a
remote sql server database where the databases are similar and of the same
product (but different versions) and different enough with constraints, keys,
columns, that I can't use the SQL Server Import and ...

SQL server service and agent did not start when OS start, when I went to SQL
server configration manager ,try to start MSSQLSERVER and agent , it can not
start either,  by this way I can not log into Sql Server.
How to solve this problem?

I have just received data files ( .mdf and .ldf ) and I need to attach them
to a sql express 2005. My machine is WinXP vers. 2002 SP2.
I downloaded the varius files (.NET 2, sql 2005, sql management studio
express) and installation was ok. No errors. No warnings

We have top function such as:
Select top 100 *
From SomeTable
Why not there is a bottom function? We are doing a project and after

Hello, all.  I have come across a dilemma working with SQL server 2005.  My
company has a parts database.  They want to be able to select a range of
parts based on the part number.  Problem is that the part numbers are mixed
with non-numeric characters and special characters.  ...

Hi --
I am working on a project on top of SQL Server 2005 and I would like to
store some additional information relating to the tables and fields in my
data base. Is it acceptable to alter the system tables to add my own fields?

When I send results of query analyser to file, it puts a header (with ---)
and the footer indicating how many lines were exported. Is there a way not
have this in the export file?
Thank you!

If a sql server instance is at SQL Server 2000, 8.0.818, which is sp3 plus
something???, can i apply windows 2003 sp2 without needing to update the DB?
thanks

I have about 20 sql servers (2000 and 2005). I setup an MSX/TSX job in
SQL Agent to Register the Server in Active Directory to make sure that
all future targets are registered, etc..
---Enroll the server in Active Directory

Hello, I have a SQL Server 2000 box (Server 2003 sp1) that I have been
running a scheduled task to defrag the drives using the built-in defrag.  It
appears that this built-in defrag is not keeping up or doing its job very
well.

I have average database with something like 15M records. I have to change
some fields property of tables with average 4M records. On smaller tables I
can change one field at time and save design would be successful but on
larger tables I got timeout something like 25 seconds ...

I have an (really) old SQL 2000 server. It's getting very unstable, having
critical hardware errors when booted. Among other things, I need to copy the
SQL statements to all of the view on two-three databases. It's some 50 views
and I desperatly need to backup the ...