Run this script to find out how much free space you have in your database.

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

Set Nocount On

Create Table ##filestats (

DbName varchar(100) NULL,

FileID int NULL,

FileGroupID int NULL,

FileTotalSizeMB ...

I don't think there is a way to do what you're asking.

You can remove EM all together from that user and let them use Excel.

Here is how:

http://office.microsoft.com/en-us/excel/HA100996641033.aspx

check this out:

64 bit max memory setting for SQL 2005 in SQL Server

which replication mode are you using for Server C?

in the solution explorer

1. Right click on your project name and select properties.

2. Click on deployment

3. under the target section type servername and database name.

if the database does not...

In SSIS you can encapsulate ETL process in transactions.

A good article on transactions:

[/url]

copy and paste your update statement from the profiler into query analyzer and see if it runs.

if not can you post the DDL for this table and the update statement?

http://vyaskn.tripod.com/iq.htm

you can run this script on each server

make sure xp_cmdshell is turned on

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

SET nocount ON

DECLARE @ip VARCHAR(15)

CREATE TABLE #ip (line VARCHAR(255))

INSERT #ip

EXEC master.dbo.xp_cmdshell 'ipconfig'

DELETE #ip

WHERE Charindex('IP...

Thank you all for helping me out

bbychkov looks like sql server is flushing the memory properly after setting the max to 6GB.

Can you recap what you where trying to accomplish to get to these errors?

bk

Was the database recently renamed, dropped and recreated?

Error Log should contain an entry of a full database backup like this:

Date11/19/2007 3:00:30 AM

LogSQL Server (Current - 11/21/2007 11:17:00 AM)

SourceBackup

Message

Database backed up....

that pretty much sums it up.

it also depends on the dr data center...

You have to have the same exact type of hardware and software as in prod.

Disaster Recovery options depend...

Download and install these drivers.

http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html

Oracle server 64 bit or 32 bit?

never mind someone already mentioned this to you.