Add New Database to solution

I'm running VS 2005 Enterprise, and SQL Server 2005 Developer / workgroup edition.

I'm trying to follow a few online examples to play around, and some of these examples require that you add a SQL DB to your solution by going:
-right click on website
-Add new Item
-Add SQL DataBase.

WHen I do that, I get the error that SQL Express isn't installed. Now the question is, why would I want SQL Express installed when I have SQL server 2005 already installed? My Machine can support it, but it's sort of a waste when I need to run SQL Server 2000, SQL Server 2005 and then SQL Server express all at the same time.

Any advice?

You are getting the error because you are using SQL Server as Access database when you have the developer edition which is the enterprise edition with deployment restrictions installed.

Now go to programs SQL Server, then management studio and then go to databases right click and go to new and then create a new database to create the blank database. To connect go to VS and click to datalink property and you should be able to connect. Hope this helps.

|||Caddre, thank you for the quick response! That solved it.|||I am glad I could help.

Add internal drive to one of two nodes within MS 2000 Cluster?

If I offline one of two nodes in a cluster, can I add an internal
drive to the offlined-node, then bring the node back online into the
cluster?
Will this new drive cause any problems?
Thanks.
As the new drive is going to be in different bus(system bus), shouldn't
create any problem. I guess the internal drive to be added is SCSI.
BTW, the ideal sequence will be offline the node, shut down the node, add
the disk and bring the node up online.
Van Thothathri
Windows Clustering
High Availability Microsoft Enterprise Server Products
"This posting is provided "AS IS" with no warranties, and confers no
rights."
Use of included script samples, if any, are subject to the terms specified
at http://www.microsoft.com/info/cpyright.htm
"Eric Cross" <ericwoven@.yahoo.com> wrote in message
news:6a585633.0404021029.6b1b37c2@.posting.google.c om...
> If I offline one of two nodes in a cluster, can I add an internal
> drive to the offlined-node, then bring the node back online into the
> cluster?
> Will this new drive cause any problems?
> Thanks.

add index

I know someone will refer me to online books, but I did a search on the
microsoft site and can't get to it.
I know the general format for adding an index is:
Alter Table tablename ADD INDEX indexname, type, FieldName
The thing is, I'm not sure what to put in for type? Do I use quotes? Can
someone actually give me an URL to an example that will show?
E. coli Happens.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200512/1HockeyFan via webservertalk.com wrote:

> I know someone will refer me to online books, but I did a search on
> the microsoft site and can't get to it.
> I know the general format for adding an index is:
> Alter Table tablename ADD INDEX indexname, type, FieldName
> The thing is, I'm not sure what to put in for type? Do I use quotes?
> Can someone actually give me an URL to an example that will show?
Search for CREATE INDEX in BOL.
examples:
CREATE INDEX emp_order_ind
ON order_emp (orderID, employeeID)
CREATE UNIQUE CLUSTERED INDEX employeeID_ind
ON emp_pay (employeeID)
HTH,
Stijn Verrept|||>I know someone will refer me to online books, but I did a search on the
> microsoft site and can't get to it.
SQL 2000:
http://msdn.microsoft.com/library/e...portal_7ap1.asp
SQL 2005:
http://msdn.microsoft.com/en-us/library/ms130214(en-US,SQL.90).aspx

> Alter Table tablename ADD INDEX indexname, type, FieldName
Actually, I'm not sure where you got that syntax, it's...
CREATE [UNIQUE] [NON|CLUSTERED] INDEX
indexname
ON tablename (columnName [DESC] [, ...]);
SQL 2000:
http://msdn.microsoft.com/library/e...create_64l4.asp
SQL 2005:
http://msdn2.microsoft.com/en-us/library/ms188783.aspx