Installation is SQL Server 2005 Enterprise Edition with 8 Processor. Is it
possible to analyze which SQL Server Session is consuming how much Processor
Ressource in Time or Percent? With the DMV Views i see that there are 11000
open SQL server Session. The 8 CPU are constant by ...

I went through the data import wizard and it successfully
went through all the procedures to import data from an
access table into an sql server table,  however, there is no
data in the table?

I know sql2005 has encryption function, what about sql2000.?
Thanks

The Installation is SQL Server 2005 Enterprise Edition with 8 Processor.
With permon and the performance counter "SQLServer:Access  Methods\Full
Scans/sec" i monitor the value 80 -180. Every time these values are there
the 8 CPU have a workload of 80 Percent in Total. With the ...

I'm trying to match households based on last name, house no., street
and apt no. and select only 1 record so that I get something like 'the
DOE Family' when all criteria match. I still want to keep Frank Black
results.

Hi, I have 2 database on sql 2005
EQUIBRAS
HUB
How can I do a insert from EQUIBRAS.uf_codigos table to HUB? The table name

I am running Windows 2003 Enterprise SP2 running SQL 2005 Enterprise and am
getting repeated failures applying SQL 2005 SP2.  The error is always the
same (see below).  
I have made sure that there are no disabled services in the SQL Server

I encounter many of this errors in Application event viewer regarding
SQL server 2005:
Type:        Error
Date:        07/03/2008

Is there a way in sql server 2005 or sql server 2000 to cosume a webservice
over a view?
The aim is to have a view which other appliactions can working with.
The data from the view should not come from a table, it should come per

I have a question concerning SQL Server Licensing that myself and my
system admin can't seem to get to the bottom of.
We're looking at licensing a Standard Edition server, for use with a
web application running on JBoss. This is a hosted ASP site that will

I want to select Date and sum(Quantity) by date from a set of records
containing Date, Quantity and RouteCardNo
My view as follows:
select    distinct [Date], RouteCardNo, sum(A.Quantity) QtyA

I create a backup file in Enterprise Manager on SQL Server 2000.  When I try
to restore this file using SQL Server 2005 Express on another machine, I get
the error "The media family on [my .bak file] is incorrectly formed.  SQL
Server cannot process this media family.  RESTORE ...

We are trying to move msdb, model and master. We added the -c -m and -T3608
to the startup parameters.  When we try to restart SQL fails to start. The
error is that it cannot find master database and will not start.  We cannot
get back into Enterprise Manager to reset the startup ...

We use SSIS packages (dtsx) for databases synchronization. The packages are
executed periodically every 2 minutes and run well. The problem is that
Windows Application event log gets overfull with informational messages about
starting and finishing packages. (The main package ...

Log shipping from sql 2k to sql2005. How do I do it?
I have sql2005 reporting server need to be synched with sql2000 prod db for
reporting.
How do I make the dbs synched?