.NET

SQL Server 2000 Service packs + Hotfixes

• by skeily

• ASPToday

• Topic

For SQL Server 2000 Enterprise Edition is the following list the full Service packs + Hotfixes etc : SQL Server 2000 Service pack 1 FIX: Local Connection Attempt Fails When Windows NT Server Name is Mixed Case http://support.microsoft.com/support/kb/articles/Q285/1/00.asp?FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D27347%26redirect%3Dno SQL Server Security Patch - SQL Server 7.0 and SQL Server 2000 Security Patch: Extended Stored Procedures […]

2001-11-06

3 reads

Jacksonville FL, SQL DBA / T-SQL Coder

• by tpantazi

• Other

• Topic

We are a SQL 7.0 / 2000 shop. We support ASP applications that use our databases. Our data is heavily replicated from/to several AS400 systems. We are looking for a new member of our team that knows T-SQL very well. We are one of the largest trucking companies in the country. Our pay is very […]

2001-11-05

Worst Practices - Depending on the GUI

• by Steve Jones

• MSDN Communities

• Topic

Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/wp_gui.asp

2001-11-02

11 reads

Attach files from SQL Server 7.0 to SQL 2000

• by vduggaraju

• SQLServerCentral.com

• Topic

I am trying to attach the database files of SQL 7.0 to SQL 2000. Its gives me an error Device activation error : the physical file name 'E:\mssql7\orderprocessing_log.ldf' may be incorrect. Device activation error : the physical file name 'E:\mssql7\data\orderprocessing_log1.ldf' may be incorrect. I also tried with single file attach but it still gives same […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-10-25

8 reads

MSDE for SQL 2000?

• by petedoyon

• Other

• Topic

I'm probably asking a really stupid question but is there a new version of MSDE that's fully compatible with SQL2000 and if not what are my options going forward. I don't want to stay with SQL7 for this reason. Pete Doyon

2001-10-16

Improve System Performance in Your Indexing Scheme Using Asynchronous

• by Additional Articles

• Microsoft MSDN

• Administration

• Article

The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.

2001-10-10

1,911 reads

• Discuss

Data Shaping

• by paras_98

• SQLServerCentral.com

• Topic

Where is the data shaping really useful? Has anyone used data shaping in live environment. Please do let me know your experiences. Thankx Paras Shah Evision Technologies Mumbai, India

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-09-24

3 reads

Using sp_MSforeachdb in SQL6.5

• by sftey1

• SQLServerCentral.com

• Topic

I was trying to use above mentioned stored procedure but hit the following error : Msg 229, Level 14, State 2 SELECT permission denied on object #SQLOLEDbUserProfile00000000F6, database tempdb, owner dbo Any idea how to solve it ?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-09-17

6 reads

Columns.Remove Dependancy Problem

• by bigdave

• Other

• Topic

Hi folks, I am using the following: sqlTbl.Columns.Remove ColName and getting the error: [Microsoft][ODBC SQL Server Driver][SQL Server]The object 'DF_Answers_test_1__64' is dependent on column 'test'. [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE DROP COLUMN test failed because one or more objects access this column. There is no object I can find of this name. There are […]

2001-09-11

4 reads

Error on backup...

• by parasu

• SQLServerCentral.com

• Topic

Hi all, I backed-up (full) a database in one sql server and copied the backed-up file to another sql server machine. I created a new database and when I tried to restore from the backed-up file, I got the following error "The backup set holds a backup of a database other than the existing 'databasename' […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2001-09-03

2 reads