It looks like you are using a global temp table. The temp table has a constraint on column XXXX which does not allow null values.

First, why are you using...

I am going to agree with the others - mostly.

IF you are using SAN snap clone technology that is configured to work with SQL Server and freezes SQL Server during...

I use the Performance Dashboard in SSMS 2008 with no problems. I know there are a couple of issues running the reports against a 2008 system, but for the...

You can also download and install Performance Dashboard from Microsoft.

From Object Explorer - right click on the server and select Activity Monitor. Or, you can launch Activity Monitor from the toolbar button when the server is selected.

WayneS (6/26/2010)

---

Lynn, you asked specifically about BIDS, but I thought I'd talk a little bit about issues with SSMS.

If you have both 2005 and 2008 servers, do NOT use SSMS...

I believe the issue you are running into is a known issue - called the double-hop issue with Windows authentication.

To get this to work and allow Windows to authenticate to...

Yes - that is correct. With your current configuration SQL Server can only use 2GB of memory.

On x86 (32-bit) platforms, applications are limited to a maximum of 2GB of memory. To get above that limitation you have to enable PAE and AWE. However, that...

I don't think it is - but I have to ask why you would want to? What problem are you trying to solve by doing this?

How big are the databases being backed up?

Where are you seeing the in progress status? Is it the job viewer? If so, have you tried refreshing the job...

Hmm, not changing the DATEFIRST here - but I seem to get Sunday 😀

Declare @currentDate datetime

,@sundayDate datetime;

...

The only thing I know of in SSMS that would come close to what you are looking for is templates. You can create a template with placeholders for your...

If you are asking about managing transaction logs - read the article I link to in my signature. If you are asking about the error logs, then it depends...

It won't matter what you do or how you set this up. SQL Server 2000 Standard Edition is limited to 2GB of memory. Enable PAE, set AWE -...