We have recently upgraded from SQL Server 2000 to SQL Server 2005. Most of
the app's seem to be working fine. But I have one query that takes a huge
amount of time now. Also, we have observed that though all apps work well
there has been a reduction in the speed.

In SQL 2000 Enterprise Manager, we had a view that showed a list of
database's tables with number of rows and some use full information such as
fragmentation. I can't remember details.
Do we have such screen in management studio?

I imported about 7.5 mill records into the Address table. But now I am
getting the below message when I am trying to save the relation into the
Address table.
I have a simple table like MoveType that has 2 fields: MoveType_PK which is

I have a client that is experiencing high CPU. In their word
everything was OK until a couple of weeks ago. It was around 50% and
then it jumped to 100%. At that point, they have:
•    released a new version of the product

Hi, my apologies if this posting is considered inappropriate but I'm not
having luck with the dedicated RMS forum.  
We have a customer who is running Microsoft Dynamics Retail Management
System on a SQL Express 2005 engine.  Running fine for the last year on an XP

We are looking to shut down an old server that is running SQL 2000 SP4.  We
are going to build a new server with 2005 and would like to move the data,
etc. from the old server to the new server.  The new server will have the
same name and IP, so we will not be able to have them ...

Looking for some import tool that can work with CSV or dbf format to import.
Something that may help me to process fields on the fly etc.. I mean a 3rd
party import tool. I need to import millions of record quickly.
Thanks,

I am upsizing a backend from Access and have a field that tracks a picture
as an OLE Object.  What type of field should I use in SQL to track the link?
Thanks,
Rob

I'm trying out this simple procedure but it won't report out any rows.
This is the defn
ALTER PROCEDURE [dbo].[CustomerSearch]
(

Okay I need some help.  I am no SQL professional.  Our company is
smaller sized company and our DB guy is leaving for family reasons,
and anyhow I need some help on a Log file problem.
For whatever reason the log file is HUGE and has obviously filled the

We have SQLServer which is used only by our webserver. Webserver is
public thus we do not now how many people is connecting.
What kind of license we need: Do we need SQL Serveer standard plus one
CAL for webserver or we need CPU license?

Hi,
I would like to query the system tables in order to obtain all the Primary
and Foreign keys for any particular table.
I have tried using the syscolumns.colstat field but it only outputs zero.  I

I need a report of all job monitoring activities.  How can you run a report
out of SQL 2005 which list the reports by day, date and time

I need to block users to have read only permission for prod db.
Users knows the sql user password(i can't change the password). that sql
user has read and write permission.
How do I block users? if user using the sql user, can I block that use by

I need to store the Image file in Text datatype format .Its working fine
when I am saving the image in database with Image datatype but its throw me
a error when I am tring to save it in text Datatype
Regards