Conventional wisdom says that this is a bad idea. However I recall reading somewhere that if you have a fast enough disk subsystem this may not be an...

pshroads@gmail.com

08-15-2005 06:33 AM
GMG

I have a fresh-built server running Windows 2003 SP1 (from a slipstream CD). Firewall is turned off. When I run the SQL 2000 setup, get the usual...

Adam Hall

08-15-2005 12:07 AM
Adam Hall

Hi, all I am planning to migrate a SQL server from a NT4 domain to AD, could someone please help to provide a procedure. Many thanks for great help

ae110

08-14-2005 11:15 PM
ae110

Trying to install MSDE on XP Pro SP2. Get the below in a verbose log (pertinent portion only). Help! Jim Maher MSDELog.log (excerpt)...

JimMaher

08-14-2005 05:15 PM
JimMaher

I'm having trouble installing Visual Studio 2005 beta 2. SQL Server express doesn't install and the errors are totally vague.

Paul Marangoni

08-14-2005 01:34 PM
Mike Epprecht \(SQL MVP\)

I try to access an attached SQL db from the Server Explorer in Visual Studio. Net and get the following error: SQL Sever does not exist or...

M K

08-14-2005 11:26 AM
John Bell

I have MSDE that came with ASP.Net (Sams) book. When I run setup.exe I get the following: 'The instance name specified is invalid' Any...

M K

08-14-2005 09:24 AM
Andrea Montanari

I cannot understand why Microsoft has no complete WA to this problem since it, in my case, clearly spells out 1) This version is not supported 2)...

Patrik

08-12-2005 04:34 PM
Patrik

I want print (on paper) the structure of some tables in my database. Is it possible to do this? Thank you. Sam

John Smith

08-12-2005 03:20 PM
John Smith

Hi, I have benn using Raid 5 arrays....I have a vendor that says Microsoft does not recommend Raid 5 but does recommend rais 0+1 or Raid 10 From...

Dan DeCoursey

08-12-2005 12:39 PM
Andrew J. Kelly

Hi, We have a clustered web server setup which accesses a backend SQL 2000 server. This SQL server is not accessable from the internet (only via...

Jane Smith

08-12-2005 11:35 AM
Jane Smith

We are going to be installing an active/active sql2000 cluster on Windows 2003 enterprise server. My question is being we are going to create...

Ray Skweres

08-12-2005 07:18 AM
Geoff N. Hiten

Hi, I have a 2 instance sql failover cluster on two nodes. Currently, write and read back caching are enabled on all disks in the SAN. Could this...

JT

08-12-2005 04:55 AM
Geoff N. Hiten

Gud day! I am new in my company. And I am new to the SQL Server. I want to know how do I check the edition of the SQL server / the...

insanedaily®

08-12-2005 04:46 AM
Mike Epprecht (SQL MVP)

Hello, This SQL Statement which takes 1 second on a server with SP3 takes 24 MINUTES after I upgrade to SP4. SELECT MDL1. FROM Entity E INNER JOIN...

Marcelo

08-11-2005 05:00 PM
Mike Epprecht \(SQL MVP\)

I have two disks on my PC one is C:\ and other is F:\, I want to install the SQL Server 2005 Beta on F:\ instead of C:\ But by default it is always...

Joriveek

08-11-2005 04:11 PM
ibrahims salahm

how can i view the contents of the Ldf ? do i have to use TRUNCATE / NOTRUNCATE ?? dbcc shrinkfile( 'MyDB_Log', 10) why to do a backup ? dbcc...

bajopalabra

08-11-2005 03:12 PM
Hari Prasad

I have an interesting problem. I am using the ODBC administrator to connect to a central SQL server over a WAN. On the workstation at the remote...

Bob Bartel

08-11-2005 10:02 AM
Bob Bartel

Hi everybody, I queried newsgroups and googled for hours, but was not able to find a solution for this nerv-wrecking problem: Windows 2000 Server...

Marc Kuerten

08-11-2005 09:21 AM
Andrea Montanari

Hi everybody, I queried newsgroups and googled for hours, but was not able to find a solution for this nerv-wrecking problem: Windows 2000 Server...

Marc Kuerten

08-11-2005 04:00 AM
Marc Kuerten

O/S = Windows 2000 Professional Service Pack4 I am pulling my hair out on this one. I was very careful with the installation making sure none of...

Adam

08-10-2005 07:17 PM
Suneberg

Hi All, i can not see performance counters of SQL Server object in Performance mmc. can any one advise me, how to enable it? and what steps should...

John

08-10-2005 07:11 PM
LT

I "discovered" a development server on our network that has SQL Server Developer Edition installed. According to...

Patty

08-10-2005 03:50 PM
Patty

on model, and other databases that i didn't manually create, i wanted to move the log file to a different disk than the data file. however, i keep...

jason

08-10-2005 02:17 PM
Andrew J. Kelly

I have a few questions about installing SP4 on a 2-node active-passive cluster: 1. Is it OK to install SP4 on the passive node, then manually...

Andre

08-10-2005 12:41 PM
Mike Epprecht \(SQL MVP\)

Well time to add another irritating problem to the server migration list... I need to reinstall MSDE2000. I uninstalled the old version from...

XxLicherxX

08-10-2005 11:30 AM
XxLicherxX

sqlserver Developer's addition win 2k 500 meg Ram 800 Mh AMD processor 2 Hard Dives 1. 120 gig 2 x 60 gig partitions 2. 40 gig 2 x 20 gig...

Jim Bunton

08-10-2005 07:19 AM
Jim Bunton

Hi, I have a SQL server 2k std running on a Windows 2k TS, set up as DC. I want to run the SQL server services under an account allowing SQL...

JIK

08-10-2005 02:09 AM
JIK

Dear All, I can't seem to find this in FAQs or googling anywhere, but it would seem to be a common problem: I'm trying to use a .bat file to setup...

Andrew John

08-09-2005 06:36 AM
Uri Dimant

According to www.sqlsquare.com/docs/SQL2KAdm-02.ppt, Upgrading Vs Side-by-Side Installation If SQL Server 6.5 is already installed, the SQL Server...

Jacob Moran

08-08-2005 10:29 PM
Dandy Weyn [Dandyman]

I'm upsizing my A2k database to SQL Server 2000 with an adp file front end. I need to allow clients to store session data locally...can use the MSDE...

Eric

08-08-2005 06:15 PM
Jacob Moran

Hi, I'm running VS 2005 Beta 2 and I get the error "SQLExpress database file auto-creation error" when I try to create a Provider using the ASP.net...

Fred Dag

08-08-2005 06:01 PM
Fred Dag

Hello! In my company, we have implemented C# as the development tool and we are using Reporting Services. I have a problem in one computer. I have...

Sandra

08-08-2005 04:41 PM
Sandra

Hello I have a full TXlog. I have increased it by 100mb . I have disk space to spare, but am wondering how to deal with this file ...... what...

Dan DeCoursey

08-08-2005 02:18 PM
Hari Prasad

I am moving databases from one SQL7 to another SQL7. I do not wish to move all logins from one SQL7 to another. Is there a way to move specific...

Michael Henderson

08-08-2005 02:08 PM
Hari Prasad

I'm getting SQL Setup failed to connect to the database server for server configuration. The error was: Login failed for user 'NT...

lazurs

08-08-2005 01:07 PM
lazurs

I have a Windows 2000 Server using SQL Server 7.0. If I rename the WIndows 2000 Server, is there anything that must be done in SQL Server...

Michael Henderson

08-08-2005 12:40 PM
Jasper Smith

Hello, My configuration : - The client : Windows NT Pro SP4 with all security patches, - SQL 2000 client & tools installed correctly, - MDAC 2.8...

Patrice HERMINIE

08-08-2005 10:11 AM
Patrice HERMINIE

One of my clients has a 4 processor Server free (probably Windows 2000 Server). My application ships with MSDE 2000 SP3a. Will MSDE install and run...

WolfO

08-08-2005 07:43 AM
David Portas

I have Office 2003 and have installed Business Contact Manager. Had no problem sending and recieving at that point. Received Small...

John A. Smith

08-08-2005 06:33 AM
John Bell

I'm experiencing a problem with Microsoft SQL Server Migrator Assistant. I want to migrate an Oracle 8I on SQL Server 2000. The tool seems to...

Floriano

08-08-2005 02:49 AM
Floriano

I need to find MS literature that w2k3 sp1 is certified for sql server 2000 standard edition. when I try to install sql server 2000 std on w2k3...

jgouillon

08-07-2005 10:34 AM
John Bell

Hello everyone. We have recently bought a dual-CPU system and will install windows 2000 Server + MS SQL Server 2000 on it. However, when the unit...

arifi

08-07-2005 05:50 AM
arifi

Just installed SqlServer2000 on Windows 2000 processor 900 mh memory 128 mb installed on c:\program files etc 2 hard disks (2 partitions each ) C & D...

Jim Bunton

08-06-2005 07:08 AM
Jim Bunton

Hello Iam working on asp.net, but the irony is that whenever i run my asp.net application it returns me an error :=- "Login Failed For...

Sincere

08-05-2005 12:09 PM
Sincere

All, Running SQL 2000 SP4 on a Windows 2003 server. I'm having some trouble getting SQL Agent service to start using the LocalSystem account....

Mike

08-05-2005 11:40 AM
Mike

I've been asked to look at a problem installing Veritas 9.1 onto a NT 4 server. I don't know the full history of the server setup but suspect a fair...

Milseh

08-05-2005 05:24 AM
Milseh

Hej, what I want to do is setting up a test database on a WinXPhome laptop. It is just for programming and testing the correctness of the database I...

Dagmar

08-05-2005 03:48 AM
Dagmar

Most likely your read issues are related to poorly tuned queries or indexes. You would probably get more gain by tuning them then anything else. As...

Hank Arnold

08-04-2005 10:28 PM
Andrew J. Kelly

Auto commit is on in Query analyzer as default. It is sometimes dangerous to run update or delete queries with auto commit. How to turn off auto...

Charts

08-04-2005 12:22 PM
Charts