I must be missing something. Can you not set the Font properties of the Textbox to bold?

Easy way using the GUI.

1. can i restrict growth of my mdf file to 250gb?

Answer: Yes you can restrict the size to 250gb. In SQL Server Management Studio. Right click...

If you use aggregate functions on columns in the Select list, then every column that is not being aggregated needs to be in the Group by clause.

Try this

select

rad.inner_qstn_text,case when...

Ankit,

Can you try explicitly setting the column datatype to NULL and try?

Create Table #tbl(

AccountId varchar(16) COLLATE DATABASE_DEFAULT,

RatesheetId int,

TariffId int NULL

)

And if that doesnt work...

You could also try setting the...

High level. there are lots of things to consider when upgrading to SQL 2008. There is a lot of documentation available on the install media and on microsoft site.

At a...

I am stumped. Stored procedure looks good.

Dont want to ask a dumb question so apologize for that.

Ok. Are you sure, the stored procedure being called from PHP is the...

I dont believe you can upgrade from SQL 2000 enterprise to SQL 2008 standard. Here is more details from the MS site on what is possible and supported.

Version and Edition...

nothing seems to be the issue with the create table.

can you post the stored procedure code?

See if this works. I used what Nabha posted. apologize for the mixed case.

UPDATE M1

SET M1.duplicate_with = M2.INVOICEID

FROM MJTEST M1 JOIN

(

Select InvoiceId, VendorNumber,VendorName ,InvoiceNumber ,

InvoiceDate , InvoiceAmount...

Where is the SSIS package being run from; On the SQL Server or a PC?

Only reason I ask, I have gotten this message once when I was testing SSIS...

Here are some FAQ queries asked out of the SQL Server System Catalog

Querying the SQL Server System Catalog FAQ - 2008

Querying the SQL Server System Catalog FAQ - 2005

like folks have commented, it is a start. the question originally asked, did not have enough specifics, it was broad and high level and looked like needing some direction.

anyways, these...

I dont have any experience with BCM. The issue you are experiencing is related to BCM install most likely. Anyways, I tried a few things on my end.

I installed BCM...

Where does the install fail? As part of the BCM install, did you verify if the setup is going to install SQL Server 2005 express edition?

Thanks.

I think you may have to run 7zip twice to extract the files.