To insert into a temp table use the format: 

select fname, lname, job_desc

into #temp

from employee

join jobs on employee.job_id = jobs.job_id

The INTO #temp creates the temp table and stores the...

Where I live (Winnipeg, Manitoba) There are quite a number of homes and business that are now being built using geothermal heat as you describe.  One new community (hundreds of homes)...

Apex SQL makes a tool to do this.  Check out this script as well

http://www.sqlservercentral.com/scripts/contributions/1589.asp

type Select @@version

the respose in part should be:

Microsoft SQL Server  2000 - 8.00.2039...

SQL Server likes memory and will attempt to take as much as it can.  There is nothing wrong with...

Yes it works fine now.  Thanks

Guest is a database user.  It is not a login. Only Login names have passwords.  Once you have logged into SQL Server using either your NT login or a SQL Server...

Sometimes it helps to see everything all at once.  Now that I look at the boot.ini I see the error (I think)  I have /3G when I should have put...

In perf mon both target server memory and total server memory are 1662704.

This is sp_configure

name                                minimum     maximum     config_value run_value  

----------------------------------- ----------- ----------- ------------ -----------

affinity mask                     -2147483648 2147483647     0           ...

Did you find a resolution for this?  I have a new Windows 2003 server with 4G memory running SQL Server 2000 SP4.  I also use the /3G switch in the...

You have to edit the registry - Regedt, Hkey_Local_Machine, Software, Microsoft, Microsoft SQL Server, 80, MSSQLLicenseInfo, MSSQL8.00, Mode key. Change it to 1 and you get both options available again.

HTH

We are definately onto something here.  The box with problems does not have Builtin/Administrators as sysadmin anymore.  (but then neither does the server that works)   I ran the workaround described...

I tried this on another server and it works fine.  The server is does not work on uses Windows 2003 and SQL Server SP4.  The server this works on is Windows...

I get a '1'.   looks ok.  At least if I got an error of sorts.  My fulltext seach service is running under localaccount.  Is this ok?

OK Now I understand what you mean.  It had never occurred to me that someone could develop generic software for this.  We have a very large database were we wanted...

We use ArcServer to copy backups to tape.  ArcServe has a SQL option but we don't use it.  The backup is just like any other file we backup and doesn't...