Hello,

DBA is DataBase Administrator. The developers that are used to write their procedures will continue to write them themselves. Please, read and download SQL Server 2000 Operations Guide from

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops0.mspx

There...

I know a couple of web developers with the same problem and they say you can use Provider's SQL Server but it is expensive. So what each of them do...

I totally agree with Brian. I am an MCDBA. I started to feel myself much more comfortable after passing 70-215 Windows 2000 Server exam. At least half of the exam topics...

There is a good download on http://www.microsoft.com/sql

called Choosing an edition of SQL Server 2000 (ChoosEd.doc) that explanes the differences between SQL Server 2000 editions. There is a very good...

I would say, Server Network Utility first because it is what you should know and it is where you configure it. Error Log is certainly the only correct one of...

Very good question! I actually have a similar job running. The business need in our case is to append data and I am using the export into Excel spreadsheet. Thanks...

I think it would depend on edition and 32- or 64- bit?

Product Information says Enterprise 64-bit goes up to 512 GB of memory, Enterprise 32-bit up to 64 GB and...

Additional reading:

http://support.microsoft.com/default.aspx?scid=kb;en-us;839269

Microsoft Knowledge Base Article - 839269

You may not be able to connect to an instance of SQL Server that is configured to use the Named Pipes...

Hi,

Everyone talks about scheduling the log shipping. You can also schedule your reports since the original question was about using Reporting Services. This way you can do both: use log...

Hi,

I would combine both previous replies. I would certainly store resumes as individual files with storing the path in SQL Server. Your developers have to write a simple attachment front...

Hi all,

I just got a task to determine the editions of all SQL Servers on the network. I used "Select @@version" because, as you say, SERVERPROPERTY does not work in...

Mark,

See

http://www.bstconsultants.com/tsug/Dec99/REDUCING_THE_SIZE_OF_THE_LOG_FILE.htm

Yelena

I have seen similar messages under one of the following conditions:

1. Users were accessing the database through the view in another database The permissions were denied after applying SQL 2000...

Did somebody noticed that setting

SET FMTONLY on

does not allow to switch databases in both Query Analyzer or USE statement? So the second part of the query returns the error...

Hi, what do you mean? 

Do you need certain data from a page or do you want to store like HTML docs in the database?

Can you do whatever you want...