We have a nightly process that twice in the last week has crashed, and at
the same time I find this error message logged in the SQL Server ERRORLOG
file:
---

I understand that Express is limited to use only 1 CPU even though it
installs on multi-CPU platforms. My question is about memory, which is
limited to 1GB. Will Express install on a hardware platform that has in
excess of 1GB and then only use 1GB as it does similarly with CPUs, ...

I've been struggling with a puzzling piece of code.  Maybe someone else can
figure it out.  The gist is that it's telling me that the first branch runs
(or most of it) whether the condition is true or false
IF (@PastDue + @OpenShipAmt) > @CreditLimit

We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check.  There are no event logs or entries in the sql error logs for
what happens.  The server is just locks up and has to be powered ...

i'm trying to dump my tran logs and get the following error:
Server: Msg 8968, Level 16, State 10, Line 1
Table error: IAM page (6:258638) (object ID 2, index ID 255) is out of the
range of this database.

OS - Vindows 2003
Database - SQL Server 2005
Hi,
Below Stored Procedure has been developed to get new log key which is

It would really be helpful if I could change a named SQL Server instance to
a default instance;  can I do this?  how?
TIA

I'm using SQL Server 2000 (legacy system, not my choice), build 8.00.2039
When trying to execute SQL job, I get this error message:
Server: Msg 15009, Level 16, State 1, Procedure sp_helptext, Line 53
The object 'xp_logininfo' does not exist in database 'master'.

Hello, I am running a couple of accounting applications on SQL server 2000
and have a problem with the templog.ldf file growing to 36GB in size (I'm
almost out of disk space).  What will be the best way to resolve this issue?
Thanks,

I am considering purchasing a laptop with XP PRO sp2 and a Core 2 DUO
T5870 (2.0 Ghz) CPU.
Is this compatible with SQL Server 2005 Express Edition with Advanced
Services?

I created a SQL server 05 test database. Now I'd like to update its data to
the live database. Can you please show me how to do that?
Thank you for your help in advance.

I want to create a stored procedure that creates a new ID for the Row
that is about to be inserted. The ID must eb in this format:
Current Year + Current Month + Max Record Number of this Year and
Month.

Has SQL 2008 been officially released? i.e. can we purchase the software?

Im in the process of designing an active passive cluster environment for a
web based project (sql 2005 standard on 2003 64 bit enterprise).
Is it possible to install AD as a DC on the Active / passive nodes instead
of using a third server for this task ?

how can i set a cascade delete for a recursive relation ?
setting cascade delet to a normal PK FK Relation (2 Table) is no problem but
for recursive relation are the fields in Relationships Dialog Box disabled.
Thanks