Do any members in the same group have same issue? If you can, login using 'sa' to see whether you are still unable to see the logs.

Did you run same query on both scenarios and received 'not enough memory to execute query' on Scenario2?

What is the value of counter of ' SQL Server:Memory Manager Counter: Memory...

Use PASSWORD parameter to set the password for the backup set. PASSWORD is a character string. If a password is defined for the backup set, the password must be supplied...

Did you login as 'sysadmin'?

quote:

---

I'm getting and error "Arithmetic overflow error converting numeric to data type numeric".

---

According...

Each SQL Server instance needs at least one logical disk resource and two instances can't share the same disk resource.

You could creaet multiple logical disks with 2 SCSI/Shared Disks as...

What is the data type of column 'id' in table 'jobActivity'?

A column constraint is specified as part of a column definition and applies only to that column.

A table constraint is declared independently from a column definition and can apply to...

The statement will create temp table with same structue as original table and with data. If you just need table's defintion, truncate the temp table.

Edited by - allen_cui on 10/06/2003...

Can you post your code and indicate which line generates the error?

select * into #MonthlyStuff from MonthlyStuff

You may try Microsoft Baseline Security Analyzer.

Check your machine application/system logs and perform hardware check before going to restore your database.

823 Error messages usually imply on disk corruption most typically arising from problems at a level below the operating system (e.g. Hardware component failure, bad/outdated device driver, or external

failure such...

You may have a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;300676