I have started looking at the some of the sys.dm views - for instance,
sys.dm_exec_query_stats.  Also started reading Inside MSSQL server 2005 QUery
Tuning and optimization.
The servers I manage have lots of databases on them, in some cases, I have

I really need some assistance, please.  short story, sql v2000, very large
database, two tables storing all 'order messages'.  the two tables are
related by orderno.  I need the fastest, most expedient means of retrieving
parent AND child records. Basically, I need to retrieve ...

Hello folks.  I am somewhat new to the SQL World, but have a basic
understanding of the language.  I have a table that I am trying to
update, and not having much success with it.  The table has three keys
(AssociateNumber,DeptIndex,RecordDate) and one foreign key

I use EM to manage DBs all over the US as well as a couple of DBs in
Canada. Whenever I use Design Table, performance is a little bit
slower, but still workable. There is one server, however, where the
Design Table option is incredibly slow. All other operations on this

Quick question. I have a table that logs Cost-per-Click data,
including the ID of the Affiliate that will be paid that CPC.
I want to create a 'report' SQL SP that shows all the CPCs for a
particular Affiliate for say the last week grouped by day, however I

I am in the planning stages of moving an existing SQL 2000 server (Server A)
to SQL 2005 (Server B).  In an ideal world, I would like to try to take the
following steps:
1.  Install SQL 2005 on Server B

When I try to use Microsoft SQL Server Management Studio to modify or view a
store procedure on an instance of SQL Server 2000 SP4 I get an exception.
In Management Studio I right click the stored procedure and select Modify.
Script failed for StoredProcedure '<sp name>'. ...

Msg 195, Level 15, State 10, Procedure usp_GetPageDetails, Line 27
'object_schema_name' is not a recognized built-in function name.
Msg 156, Level 15, State 1, Procedure usp_GetPageDetails, Line 42
Incorrect syntax near the keyword 'as'.

hi,
i amlooking for a monitoring and analyzing tool for sql 2005 that will trace
my db activity for 20-30 days and after that i will have a report of the
level of usage for each index.

We have 3 instances of SQL 2000 SP4 on 3 different machines running log
shipping. The build numbers are as follows:
Primary: 8.0.2215
Secondary: 8.0.2039

Can Reporting Services Std be installed on a machine without the database
engine (i.e. host the DB elsewhere).
I realise this must be possible for the Enterprise edition via the scale out
feature but am wondering if it can be done on the Standard version as well.

Recently, I have changed my company lab test SQL 2005 server
computer's name, after that I tried to run our application that talks
to the database, but i found out that our application couldn't work
and showing some strange error message that tells me the SQL server

I have a lot of jobs that was schedule in SQL Server Agent and since
2008-03-13, the status won't be update. But, i know that the job still
running well. But the status of the next run date was OK.
I have search on the web and i don't see anything that can help me.

DECLARE @ret INT EXECUTE @ret = msdb.dbo.sp_send_dbmail @profile_name =
N'smtp.isp.com', @recipients = N'scott@domain.co.uk', @subject = N'SQL
Server Alert System: ''SQL
performance alert'' occurred on \\sqlserver', @body = N'DATE/TIME: 5/13/2008

When I attempt to connect to the Database Engine Tuning Advisor I receive
the following error:
The Channel 'ipc' is not registered with remoting services. (mscorlib).
I can sometimes get past this error and create a DETA session to the SQL