bitbucket - no worries - I was only trying to understand how best to help you - so no butt kicking here!

Another lesson learned for me too - must write...

OK - fair point - subtle difference between checkboxes and radio buttons - I'll make any future questions very explicit!

I thought it read ok with 'which of the following statements'...

Sorry, maybe I am missing something, or looking too deep into this but I still don't understand what the issue is.

I asked which statements would guarantee 1000 rows, the answer...

bitbucket - I don't get what you are saying. Why don't you agree with the 'supposed' correct answer?

The quotes you provide, are exactly what I am saying with the...

the example you give 'b7a83d8-e6d7-415f-9664-056e2ea7ea0b' isn't a valid GUID - the first part before the first hyphen needs to have 8 characters

Kev

santosh_kollipaka (7/24/2008)

---

I've created procedure

Create procedure [dbo].[Options] @COMPANY_ID varchar

as

declare @company_IdUnique uniqueidentifier

--The reason why iam converting below is i have to insert the row into...

Is it possible to set a named instance to an ip address, and remove the need to specify the instancename or port?

In my scenario I have a Win server "SERVER1"...

I'm pretty sure that binary collations are case sensitive so @cmd is not the same as @CMD.

Change one or the other and try again.

Kev

Ron Kunce (7/3/2008)

---

jim.powers (7/3/2008)

---

This really isn't that hard to understand. The link posted with the question's answer is plainly obvious.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

In the Workgroup column on the row for RAM, the limit...

that url didn't work for me did you mean

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/09bcf20b-0a40-4131-907f-b61479d5e4d8.htm

that's the h/w reqs for installing and running SQL, NOT the supported features - a subtle difference, but a difference.

I don't...

in fact if you check BOL at this page

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/95e5e902-66f9-4ef0-a7c6-61f42d81362e.htm

(put that into the address bar of BOL)

it states again that Workgroup Edn supports a max of 3Gb.

Kev

BOL is stating the requirements for install

Whereas the MS link is stating the features and limits

I would be more likely to believe the 3Gb limit

Kev

bilalhaider86 ,

I'm not sure where you got those values from, but that article is about SQL2000 and you originally asked about SQL2005.

Plus be careful when calculating the number of bytes...

Try this link

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

It states that the maximum rows per table is only limited by your available storage

Kev

Duplicate post of

http://www.sqlservercentral.com/Forums/FindPost526430.aspx

AND

http://www.sqlservercentral.com/Forums/FindPost526428.aspx

Please don't cross post!