We migrated a large database (50GB)  from SQL 2000 to SQL 2005 using
backup/restore method. After restore, we tested a query that takes 20-30
seconds in SQL 2000 where in SQL 2005 it takes forever. I have run
sp_updatestats on the database on SQL 2005 but still no improvement. On ...

I'm planning my installation of MS CRM 4.0 Workgroup Server. I'm going
through the checklist for system requirements and it requires one of the
below listed versions of SQL.
·         Microsoft SQL Server 2005, Standard Edition with SP2

When I came in to work today, I booted up a dev web server that also has SQL
Server 2005 running on it. When I tried to connect to the main server
instance via Management Studio, I saw the following message:
TITLE: Connect to Server

I am trying to run an automated job that grabs data every half hour from a
table. I am hosting this downloaded data in mySQL but the source is DB2. The
code for the query currently looks something like this:
SELECT

We have a problem with performance of our Microsoft Dynamics SQL Server 2005
box.
It is a HP DL350 with P400 Controller (with battery and 512MB cache on
controller)

I have a question about how many licenses we have and how many connections
can be made to this setup.....
The windows version is Windows Server 2003,  The server is in workgroup mode
(not domain/AD mode)

   I have a database server with MSSQL 2005 installed and two webserver
work on VS.NET 2.0
   It works fine before.But when connecting the dbserver from another
remote WebServer with TCP/IP( connection string as "Data

Hope someone can help me out here. I've had a long running problem with
SQLserver 2005 (Standard, Developers and Express).
When I try to import or export data to or from a database I get the
following message:

In the following code, I need to exclude anyone who has a
gs.giving_amount that is greater than $500.  The problem is that the
results are separated by year.  If the individual has ever given a
gift of more than $500, they need to be excluded entirely from the

say we have a table
create table mytable
(
my_id int identity(1,1),

I have created a simple maintenance plan which should call a stored
procedure to perform database maintenance. I add a T-SQL Statement
task with the following code;
USE [Investran53]

This may be a dumb question, but I have a Sql DB being hosted at a third
party vendor.  We have had some problems and I had them send me the
transaction logs for the DB.  They sent me .trn files.
But how can I view those files so I can actually see what transactions have

i have two poweredge 2950's (one is production and the other is
disaster recovery)
-Sql Server 2000 Standard Edition SP4
the OS's are slightly different

Not a new install.  Everything was working last week.  No messages in logs
that I can see.  But now when I try to open a table in SSMS, I get the
message:  Object reference not set to an instance of an object. (SQLEditors)
Saw that SL2005 SP2 was indicated as a resolution but that ...

Has anyone ever experienced or know if several failed SQL Server jobs to
caused the database engine to become nonresponsive or crashing the server?
The job failed to run stored procedure against a database, it cleans and
readd the indexes back on table within the database. ...