kienway (3/31/2009)

---

Can I change the setting to production server as this is not a development server? Is there any impact?

The setting is as per below.

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(2)\WINNT

[operating systems]

multi(0)disk(0)rdisk(0)partition(2)\WINNT="Microsoft Windows 2000...

Heh I don't know why Mirosoft doesn't make that option avalaible in the GUI.

I really don't like the backup GUI interface that comes with SSMS; I would the file selection/path...

sqlfriend (3/31/2009)

---

Hello Mohit,

thank you.

I'm not quite sure what you mean (I'm probably too new to the topic): I was looking for an option to use V.2000 of the SQL...

As Ramesh suggested the GUI interface will not show you network drives or network servers. But you can enter in any path the SQL Service account has access.

You can...

What database the user has access to? Can you confirm their permissions are correct in the database in question?

Mohit.

To check for 3GB or sorry PAE (Physical Address Extention) not PWE switch are enabled in the BOOT.ini file on the root of C:\.

Those errors are saying your OS was...

Name resolution problems? IP looks like personal network? Two options ...

try setting up HOSTS file with your server IP / Name...

try using SQL Browser service.

Thanks.

What I do on servers that I suspect the databases/logins are not being used is setup a DBManagement database. That gets populated with connection information every min by SQL Agent...

Database mirroring doesn't care about compatibility mode; you should be able to use the SQL Native Client to connect to database running in 2000 compatibility mode.

For example:

Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;

These connection strings...

Yes you can ignore it it does not affect the operations of your SQL ... as per this KB article. You will get some inaccurate numbers if you are...

In 2000 it's pretty much same thing...

Check the Scan Density [Best Count:Actual Count] to see how much hopping around a scan will have to do; this value should be close...

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Product Level = SP.

Also a good reference is http://sqlserverbuilds.blogspot.com/ to see your build :).

Thanks.

As Gift said it should be supported; as Microsoft does not mention anything in their feature list document here.

Thanks.

Mohit.

Swirl80 (3/27/2009)

---

that's the problem, they are seperate in the fact they're seperate physical dbs, but in actual fact they all refer to each other as part of one application but...

Hmm oops I ran it on SQL 2008; I'll check it on 2005 and get back to you. Sorry.

Mohit.