If you have a backup and other changes have happened in the databases since you made this change then restore to a new (temporary) database and copy the one table. ...

The DBA needs to be a member of the sysadmin server role with complete access to do everything/see everything.   Thats the nature of the job.  If you encrypt the data...

Put your 2 cents worth in http://www.mssqlsurvey.com/TakeSurvey.asp?SurveyID=105

Your are right Danette,  looking at BOL you can't change a column to have an identity value.  You must drop/recreate it.

See http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000--Part-1/6/ for some suggestions about using Identity with replication. ...

The line 'add parmkey INT IDENTITY' is trying to add a column called parmkey.  If this column already exists you will get an error.   If it already exists use...

1.  see http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867

2.  Yes, change the startup parameter -e to move all these

Are you saying that when you have created and populated the table app_parms the run this statement to add the primary key it doesn't work?  Do you get an error...

Lots of great scripts and resources are available right here on this site.  see

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=594

for a good pivot table proc.  There have also been a number of discussion on...

Although unrelated you may want to consider shutting down the browser server on the SQL box.  You don't want you SQL box becoming the BDC or the PDC.

Log shipping may be a good alternative.

I like self joins, they often get better performance than the alternative.  But having said that the alternative is usually a sub query.  For example:

the self join

SELECT e1.LastName, e1.FirstName

FROM...

Nice going Glenda.  Its great to see people learning on their own.  This site is great for learning.  I've bee doing DBA work for a while, but I learn from...

The focus of SQL Server 2000 Web Release 3 (SQLXML 3.0) is Web services. (You can download SQLXML 3.0 at http://www.microsoft.com/downloads/details.aspx?familyid=4023deea-f179-45de-b41d-84e4ff655a3b&displaylang=en.) SQLXML 3.0 lets you select stored procedures from...

Are statistics current?  In order for the SQL Server Query Optimizer to make good decisions, it must have up-to-date statistics on the tables and indexes in your database.  How you...

I've compressed a 20 G database to about 4 using WINRAR, the I was able to copy it to a DVD and mail it.  There also exist several Large File...