Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
restore master database: no restart
Posted by jouj at 2/5/2006 11:03:27 PM
I'm working on MS SQL 2000 SP3.
I'm trying to switch to a new server.
When I tried to restore the master database, the server wouldn't re-start.
so I tried another way, that is to restore user-databases and transfer the
users-accounts (DTS) but it seems that the users cannot connec...more >>
Converting Paradox database to SQL Server
Posted by Anup at 2/5/2006 10:31:36 PM
I have a paradox database and i want to convert it into SQL Server
all i have is a folder having Paradox data files like .px, .db etc.
i have already installed SQL Server 2000,and i know about DTS Import
export tool provided with it.
please let me know which all other toos i need and ...more >>
Dual Core CPUs and SQL Server 2000
Posted by Marks70 at 2/5/2006 10:16:27 PM
I need to configure and purchase two new servers running SQL 2000 Enterprise
Edition on Windows 2003 Enterprise Edition each equipped with 2 processors.
I'm wondering if anyone has experience with or knowledge of using dual core
Intel Xeon Processors with SQL Server, and if there are definite ...more >>
dbcc inputbuffer does not list parameters
Posted by Hassan at 2/5/2006 8:07:45 PM
I have a lot of sprocs being called but a dbcc inputbuffer on the spid only
lists the sproc name without the parameters being passed. Why is that ?
Using SQL 2000 and SP3a. Thanks
General network error
Posted by Hassan at 2/5/2006 7:51:06 PM
What are some of the reasons why one could get a "General Network error "
from the app especially if the n/w between the app and SQL appears to be
Error Message 17883 (Scheduler 5 appears to be hung)
Posted by soonyu at 2/5/2006 7:50:26 PM
we have this problem
1. whereby sql transaction is blocked by spid -2
2. check the error log it dump mini dump at 4.00am
3. error log repeat with
The Scheduler 5 appears to be hung. SPID 102, ECID 0, UMS Context 0x03ADD340.
Error: 17883, Severity: 1, State: 0
3. blocking happen at 10.00am
SQL 2005 - Backup restore Q
Posted by rupart at 2/5/2006 7:46:27 PM
I have a database with multiple file groups and mdf(M:\) resides in
different disk and ldf(L:\) resides in different disk.
I dump all the backup to different disk (X:\).
Now, I am testing to restore the files.
When i choose "Retore Files and Filegroups" or "Restore Database" and
Max Memory Support of SQL 2000 Enterprise on Windows 2003 Enterpri
Posted by Marks70 at 2/5/2006 6:31:26 PM
Pretty simple question, what is the maximum amount of memory SQL 2000
Enterprise Edition can support on Windows 2003 Enterprise Edition (all
refering to the 32-bit versions). Thanks!...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Can't access an instance installed on same server
Posted by Multitasker at 2/5/2006 12:16:28 PM
About 2 months ago I loaded a new instance on my SQL Server 200 box. I have
been working with the database in that instance. However, now I try to
access the other instance on the server and I get connection failed check
server registration properties. When I check them I get "login failed."...more >>
Insert a picture in an MS SQL Server table
Posted by De kessé at 2/5/2006 10:49:19 AM
Insert a picture in an MS SQL Server table
How can u insert a picture an an image field in SQL server table? Is it
possible from SQL server tools or other tools, programming?
is displayed when returned from database call
Posted by koldskaal at 2/5/2006 6:50:07 AM
I am making a web Application, where non breakable space ( ) is
crucial to the layout. When I write directly into the html, it
is displayed correctly. But If I store a value in the database (MS Sql
server 2003) containing the code it is rendered to the browser
Performance of SQL2k5 with snapshot isolation level turned on
Posted by andsm at 2/5/2006 4:57:27 AM
I did several tests of performance of SQL2k5, and I see quite strange results.
I restored database from SQL2k, rebuilded indexes, updated statistics. I did
all what described in migration process. Backuped the resulting database. In
each of next tests I restored the database from backup. Next ...more >>
Is this an ok design?
Posted by CharlesT via SQLMonster.com at 2/5/2006 12:00:00 AM
Hey im really confused about this database design ive encountered, and I
wonder if anyone can help me understqand if this is a decent design and what
to do about it. The database contains about 24 billion records. It is split
into a distributed partitioned view on a RAID 5 of 7 different harddriv...more >>