My program is using a SQL Server Express 2005 database.  The program
runs fine when you first start it, but over time the performance of
the the database degrades and my program takes longer and longer to
get responses from the database.  Rebooting the database server solves

I would like to test that restorations are working from the .bak that is
created each night and .trn files that are created every 6 hours. How do we
go about it?
I hear we may have to use a 3rd party application, but I'm open to

We currently have a production server that needs replacing.  Current server
is prod01 with default instance of sql2000.  We are building a replacement
server prod02 with default instance of sql2005.  Once the replacement server
is built and all databases are copied, the plan is ...

with help SQL Management Studio i can take Script the whole DB , then i can
create NewDB with help of taken script . i just want to know what type of
order they r using ?

There are 2 tables in an application system.
The first table "grpmem" contains both group_id and member fields.
select id, c_last_name from ctct where id = 735169
id                    c_last_name

I want to recover data from one database (*.mdf) file:
1- One app were using one sqlserver 2005 express database file.
2- I dont have any backup file from that database
3- The desktop disk stop working

I had an issue with a new Dell laptop running Vista and Dell says I have to
do an Vista re-install. About a month ago I downloaded SQL Server Express
2005 and have been working on a local database. The thing is that Vista
hasn't been allowing me to run Explorer.exe so I haven't so ...

I'm attempting to copy a database from one SQL Server to another, I've made
sure the versions match PERFECTLY.  9.0.3054.  (2005 SP2 with latest patch)
I get the following errors each time I try to IMPORT/EXPORT.  I can't even
find many references to the errors online, and the ...

I have a .net 2.0 web application against SQL Server 2000.
I was interested in peeking into the database and see the activities
of this web application.  So, I issued this following query in SQL
Analyzer (pretty much like sp_who[2]):