RE: SQL Error, I know
Your database is full. Allocate more space for it in Enterprise Manager. Dan Phillips CFXHosting.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 10:42 AM To: CF-Talk Subject: SQL Error, I know I know this is suppose to be for CF stuff, but I know someone can help with this. I'm under the gun here. I'm getting this SQL 2000 error message when I try to add a new column to an existing table that's filled with data. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. Thank you in advance. Please help. D- __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Error, I know
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
Is there any solution? If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Error, I know
Ouch!! I would first find out how much space you are suposed to have for your database, then right click on your database (in enterprise manager) and view properties (it will tell you how much space is being used). If it is full (which is probably is).. and the numbers are correct (ie you are using as much as they said that they would give you). Email the administrator and ask him for more space .. if they want to charge you $200.00 to do that ... look for a new provider ..!! Best of Luck! Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector v2.0 - Commerce Builder - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, March 19, 2002 10:01 AM Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
How's this for customer relations ... e-mail from hosting company's DBA ... Your database is not configured to grow automatically. You pay for a set size monthly and that is all that is available. You can request more disk space if you need it, but that's up to you. This is definitely NOT a support issue. The server your database is on and functioning normally and all is working fine. That is our concern from a support side. The problem with inserting columns falls strictly under Professional Services. Like I said, I can fix the problem and ensure that this works, but it is up to you if you want me to go ahead and do this. Please let me know. If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
You would have to have admin rights to the SQL server to increase the space. Have your ISP check to see how much free space you have left on the SQL server. Obviously if it's under a couple Megs or has no space left, more space needs to be added. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 11:06 AM To: CF-Talk Subject: RE: SQL Error, I know Is there any solution? If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
Thanks everyone! You guys are the best! D- You would have to have admin rights to the SQL server to increase the space. Have your ISP check to see how much free space you have left on the SQL server. Obviously if it's under a couple Megs or has no space left, more space needs to be added. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 11:06 AM To: CF-Talk Subject: RE: SQL Error, I know Is there any solution? If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Error, I know
They also may be including your log files in the space that you use - If they are not backing up properly you might find that your log files are massive and that providing the segments in the logfiles are ordered properly backin g them up should free up a tonne of space -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:16 To: CF-Talk Subject: RE: SQL Error, I know Thanks everyone! You guys are the best! D- You would have to have admin rights to the SQL server to increase the space. Have your ISP check to see how much free space you have left on the SQL server. Obviously if it's under a couple Megs or has no space left, more space needs to be added. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 11:06 AM To: CF-Talk Subject: RE: SQL Error, I know Is there any solution? If you are running SQL on SBS there is a maximum size to your filegroups (which you can easily reach). It sucks believe me -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 16:02 To: CF-Talk Subject: RE: SQL Error, I know Not quite sure. Our ISP is hosting our CF Web site along with SQL 2000. The ISP's Adminsitrator is trying to tell me it's a Professional Services request and wants to charge me $200/hour to fix the problem. D- nice one - seen this before. It aint your disk that is full it's your filegroup (SQL groups data/objects into filegroups). By any chance are you running SQL on SBS (Small business Server)? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 15:48 To: CF-Talk Subject: Re: SQL Error, I know ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'Tmp_samp_request' in database 'hititte4_db' because the 'PRIMARY' filegroup is full. is that db set to grow? if so, your disk is probably filled. if not, allow it to grow... __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists