Fire up Query Analyzer and choose Help->About. Or in SQLEM, Action->About SQL Server Enterprise Manager.

In SQL 2000, there's no provided way to turn off the identity property for a column once it's been established. You'll have to either:

- Create a new table without...

A restore will work without any problems if the backup is good. First, verify you've got a good backup:

  restore verifyonly from disk='d:\path\backupfile'

Next, identify the logical files present...

The error means that the userid you're trying to enter in personal_details doesn't exist in userlogin_details. Solution, enter the data into userlogin_details first.

Try this. It'll cover the payment back-dating.

select p.* 
from @Payment p
  join (select min(hCtrlNum) as hCtrlNum, hCustomer from @Payment group by hCustomer) as v
    on...

You can see who belongs to the group with:

  exec xp_logininfo 'builtin\administrators', 'members'

As for who's actually logging in, set up a security audit trace. You can define it...

SQL Server will not alter your source code for you. I suspect a faulty script is to blame. There needs to be a GO between the END and...

Your query is including table statistics. You need to add:

  and (status & 64)=0

or, eliminating the join:

  select distinct object_name(id) 
  from sysindexes 
  where...

I've seen a way to do that in 2000, but can't recall where. This is close enough for me:

select login_time as sqlserver_start_date from sysprocesses where spid = 1

http://support.microsoft.com/kb/283037/en-us

http://support.microsoft.com/kb/274750/en-us

http://support.microsoft.com/kb/291988/en-us

Also hit:

http://search.support.microsoft.com/search/default.aspx?query=%2FPAE+SQL+Server

It'll cover some of the potential problems with PAE.

1204 & 1205 provide info on dealdlocks. 3205 disables tape drive hardware compression.

Try this...

SELECT Column1, Column2, (case when Column1='xyz' then 'hello' end) as Column3
FROM (
  SELECT dbo.MyFunction(a) as Column1, b as Column2
  FROM Table1
) as x

Tom, I had a fairly lengthy response written but the preview clobbered it. To summarize...

Are you doing the modifications (or generating your script) through EM? EM will create...

And here's a simplification of the sp_msforeachdb version...

select name, DatabasePropertyEx(name,'Recovery') as recovery from sysdatabases

Shrinks are slow. They typically have to move a lot of data from near the end of the file to the beginning. Every data movement is logged, so...