SQL DB Question

  • Thread starter Thread starter Me to You
  • Start date Start date
M

Me to You

I have installed VB.net 2003 standard and the latest MSDE. I can open and
use the Northwind examples and such. I want to use the "Create New SQL
Server Database" option under the server explorer but it is always grayed
out.

Where do I fix this?

Thanks
 
I am not sure if you can administer the server using the standard version of
DotNet you may need to upgrade to the Professional version.

Also are you the administrator of the SQL Server if so you could use
Enterprise manager or TSQL to create the database.
 
Me to You said:
I have installed VB.net 2003 standard and the latest MSDE. I can open and
use the Northwind examples and such. I want to use the "Create New SQL
Server Database" option under the server explorer but it is always grayed
out.

Where do I fix this?

I just discovered the same problem and I bought MSDE Admin to solve it
http://www.msde.biz/msdeadmin/msdeadmin.htm

It costs $20 but I already think it's worth it just to solve some user
privilege issues I had.
 
I think you won't have access to the visual tools with the version you are
using...however, you can just write a script and set the script as the
commandtext of a command object and you'll be able to create everything that
way.

HTH,

Bill
 
Thanks for the info.

I had a feeling that it had to do with the version. I find it funny that I
pay $100 for the VB.net Standard and I am not allowed to create a SQL db.
Yet I can download Web Matrix, which lets me create SQL db's, for free from
the same company that charged me $100 for the VB.net.

Logic & Reasoning ?????????????????
 
If I remember my microeconomics correctly it's called Type I customer
discrimination.

If the price for a product is the same for everyone (picture the two
intersecting diagonal lines representing supply and demand), you will get the
supplier's income represented as a rectangle defined by the origin and the point
of supply/demand intersection. The two triangles immediately outside this
rectangle represent consumer and supplier surplus. Consumer surplus is where
people would have bought the product anyway, even at a higher price.

Suppliers have a few methods at their disposal to reduce this consumer surplus
to more efficiently extract profit. One of them is to change the price based on
the customer's willingness or ability to pay for their product. They could
conceivably do this by polling each customer before purchase as to their income
or willingness to pay, and then charge each individual the maximum price they
would tolerate. Another, less efficient, but more practical method is to force
customers to self-select based on their desire for convenience. Grocery coupons
are a good example: poor(er) people find it worth their time to cut out coupons
from the paper, and rich(er) people just can't be bothered with it. This
generates two price points instead of one, which allows suppliers to take away
surplus from you, the consumer, to directly increase profit. Consider the
"inconvenient/obscure extra download" your very own coupon of sorts, a Type I
customer discriminator. This artificially created inconvenience means rich(er)
people pay more, and you pay less.

HTH,
Bob
 
?!??

Bob said:
If I remember my microeconomics correctly it's called Type I customer
discrimination.

If the price for a product is the same for everyone (picture the two
intersecting diagonal lines representing supply and demand), you will get the
supplier's income represented as a rectangle defined by the origin and the point
of supply/demand intersection. The two triangles immediately outside this
rectangle represent consumer and supplier surplus. Consumer surplus is where
people would have bought the product anyway, even at a higher price.

Suppliers have a few methods at their disposal to reduce this consumer surplus
to more efficiently extract profit. One of them is to change the price based on
the customer's willingness or ability to pay for their product. They could
conceivably do this by polling each customer before purchase as to their income
or willingness to pay, and then charge each individual the maximum price they
would tolerate. Another, less efficient, but more practical method is to force
customers to self-select based on their desire for convenience. Grocery coupons
are a good example: poor(er) people find it worth their time to cut out coupons
from the paper, and rich(er) people just can't be bothered with it. This
generates two price points instead of one, which allows suppliers to take away
surplus from you, the consumer, to directly increase profit. Consider the
"inconvenient/obscure extra download" your very own coupon of sorts, a Type I
customer discriminator. This artificially created inconvenience means rich(er)
people pay more, and you pay less.

HTH,
Bob
 
Back
Top