Viewing 15 posts - 2,776 through 2,790 (of 3,221 total)
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...
November 20, 2008 at 10:33 am
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...
November 20, 2008 at 10:28 am
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...
November 20, 2008 at 9:06 am
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...
November 19, 2008 at 12:45 pm
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...
November 18, 2008 at 11:50 am
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)...
November 18, 2008 at 11:36 am
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...
November 17, 2008 at 9:47 am
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...
November 15, 2008 at 11:40 am
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...
November 15, 2008 at 8:58 am
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...
November 15, 2008 at 8:43 am
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...
November 15, 2008 at 8:06 am
This is a duplicate posting .. with SQL Server 2005 Integration Services.
For the most assistance please post to only one topic ....
November 13, 2008 at 3:57 pm
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...
November 12, 2008 at 9:57 am
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
...
November 11, 2008 at 7:17 pm
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...
November 11, 2008 at 6:38 pm
Viewing 15 posts - 2,776 through 2,790 (of 3,221 total)