This is a cross posting - it appears under "Development" as well but with a little less information.

In addition to GilaMonsters advice can you:

I can only assume that when your...

One can ask why you want to increase available size, I can only assume that when your DB was created autogrowth (If memory serves me correctly Autogrowth enabled is the...

In the upper right hand corner of this page is a window labeled "Search", may I suggest you input "Debug T-SQL" and then click on the Go button. If...

I have noted how helpful, understanding, and patient all the regular respondents are. In fact, I'm often astounded at how much time and effort some of you guys spend posting...

This information you have provided is rather skimpy to say the least. If it is possible can you read the article in my signature block and provide as much...

May I sugget reading the EXCELLENT article by Jeff Moden

http://www.sqlservercentral.com/articles/TSQL/62867/

About half way through the article Jeff has an example that is very, very close to what you want (need)...

Starting with SQL 2000 Microsoft Introduction "Extended Properties", a brief description of what they can be utilized for is:

Using Extended Properties on Database Objects

Microsoft® SQL Server™ 2000 introduces extended properties...

Here is another way that might work for you.

CREATE TABLE #Table_1

(

[Doc] [varchar](50) NULL,

[Prodtype] [varchar](50) NULL,

[TERM] [int] NULL,

[Yr] [int] NULL,

[MTH] [int] Null

)

INSERT INTO...

I can not help but wonder, if the bean counters (Accountants) have taken into consideration the considerable cost associated with such a switch. That is the cost of retraining...

Akhlaq.

It would assist us in assisting you if you can:

1. Post your current code that promotes the student, that is increments the classid value.

2. Describe what you want...

May I suggest that you read the topics in Books On Line (BOL) titled Full-Text Search... be prepared there is a lot to read, but you should be able to...

This is a duplicate posting .. with SQL Server 2005 Integration Services.

For the most assistance please post to only one topic ....

Have installed both (Express versions) without any obvious problems. I Use Query Analyzer for 2000 work and SQL Server Management Studio (SSMS) for 2005, although SSMS can be used...

Try this:

select A.Account_number, A.Customer_name, A.Known_As,

A.Legacy_Account_Number, A.Account_Established_Date,

CASE A.Customer_Status

WHEN 'I' THEN 0

ELSE 1

END,

A.Account_Established_Date

from

dbo.BILL_TO_Customers A

...

Techybala -- In the upper right hand corner of this page is a Search window. Input SSIS and you will obtain a list of articles / school videos on...