You can check out the size of the database. You can use sp_helpdb.

Then you simply need to increase the size of the database.

If you are maxed out then users can't...

It does not matter how much disk space is available.

You need to check the size of the database and increase it.

How to increase the size of a Database:

http://msdn.microsoft.com/en-us/library/aa197143(v=sql.80).aspx

thysvdw (5/15/2011)

---

We have a NET SALES table (customer, calendar_month, net_sales),

We classify customers based on the net_sales accumulated over a 12 month period, eg. customer with net_sales over $3,000 is gold...

Luz provided you with a good solution.

Per BOL, information about temporary tables:

Temporary tables are automatically dropped when they go out of scope, unless explicitly dropped by using DROP TABLE:

A...

Is this a Distributed System question or a Mirroring question?

A quote from:

http://stackoverflow.com/questions/892351/sql-server-2005-and-temporary-table-scope

A local temporary table that is created in a stored procedure is dropped when the procedure ends; other stored procedures, or the calling process, can't see them.

Other...

Marc Bizzar (5/15/2011)

---

Hello Everyone,

In a asp.net WebForm, based on MSSQL 2008, i called a Procedure, in which it is declared and filled a #Temp_Table.

Then when the user check...

If the maxsize is specified on a...

Perhaps I'm not understanding you correctly but the issue has to...

The maxsize of the data file can cause this.

Increase the size of the database.

You can modify in EM or in Query Analyzer:

http://msdn.microsoft.com/en-us/library/ms175890.aspx

USE master;

GO

ALTER DATABASE AdventureWorks2008R2

MODIFY FILE

...

balasach82 (5/15/2011)

---

Hi,

Is there any other way to Import PDF documents into DB2 table (BLOB) column? I tried with Import Column in SSIS, but the pdf could not be retrieved from...

balasach82 (5/15/2011)

---

Test connection succeeds.

Now, tested a select query with execute sql task,getting error:

SQL02024:TableName in USERNAME type *FILE not found......

Note: Even the Dev people who have admin access to DB2...

What happens when you click on test connection, in the Connection Manager for the DB2 Data Provider?

Exclude the pdf, can you SELECT from any DB2 Table? Could you create a...

Does this work in the Development environment?

Do you...

balasach82 (5/15/2011)

---

I have setup a DSN connection to the DB2 server. We had access issues (something related to DDM). We fixed that and loaded the pdf. But the extraction was...