Can't find AdventureWorksDW

I did see a post from early Oct saying that there would be a link on
msdn to download this.
But I wondered if anyone else has this database and where they found
it. It's used in the AS tutorial.
No one in my shop has seen it -- we've been through the June and Sept
CTP's and now we're on the final release.
Have you tried following the installation instructions in the Books Online
topic "Running Setup to Install AdventureWorks Sample Databases and
Samples"?
Alternatively, you can download the sample databases from this site:
http://msdn.microsoft.com/sql/downloads/samples/
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
<jhcorey@.yahoo.com> wrote in message
news:1133188697.921791.84240@.g47g2000cwa.googlegro ups.com...
>I did see a post from early Oct saying that there would be a link on
> msdn to download this.
> But I wondered if anyone else has this database and where they found
> it. It's used in the AS tutorial.
> No one in my shop has seen it -- we've been through the June and Sept
> CTP's and now we're on the final release.
>

Can't find AdventureWorksDW

I did see a post from early Oct saying that there would be a link on
msdn to download this.
But I wondered if anyone else has this database and where they found
it. It's used in the AS tutorial.
No one in my shop has seen it -- we've been through the June and Sept
CTP's and now we're on the final release.Have you tried following the installation instructions in the Books Online
topic "Running Setup to Install AdventureWorks Sample Databases and
Samples"?
Alternatively, you can download the sample databases from this site:
http://msdn.microsoft.com/sql/downloads/samples/
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
<jhcorey@.yahoo.com> wrote in message
news:1133188697.921791.84240@.g47g2000cwa.googlegroups.com...
>I did see a post from early Oct saying that there would be a link on
> msdn to download this.
> But I wondered if anyone else has this database and where they found
> it. It's used in the AS tutorial.
> No one in my shop has seen it -- we've been through the June and Sept
> CTP's and now we're on the final release.
>

Can't find AdventureWorksDW

I did see a post from early Oct saying that there would be a link on
msdn to download this.
But I wondered if anyone else has this database and where they found
it. It's used in the AS tutorial.
No one in my shop has seen it -- we've been through the June and Sept
CTP's and now we're on the final release.Have you tried following the installation instructions in the Books Online
topic "Running Setup to Install AdventureWorks Sample Databases and
Samples"?
Alternatively, you can download the sample databases from this site:
http://msdn.microsoft.com/sql/downloads/samples/
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
<jhcorey@.yahoo.com> wrote in message
news:1133188697.921791.84240@.g47g2000cwa.googlegroups.com...
>I did see a post from early Oct saying that there would be a link on
> msdn to download this.
> But I wondered if anyone else has this database and where they found
> it. It's used in the AS tutorial.
> No one in my shop has seen it -- we've been through the June and Sept
> CTP's and now we're on the final release.
>

Can't create partitioned table in Developer Edition?

I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
fails saying that partitioned tables may only be created in Enterprise
Edition. What gives, DE is supposed to have all the capabilities of EE?
Scott
On Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
> fails saying that partitioned tables may only be created in Enterprise
> Edition. What gives, DE is supposed to have all the capabilities of EE?
> Scott
I have no problem on a developer edition
What does this return?
select serverproperty('Edition')
I have no problem running the following on a developer edition
CREATE PARTITION FUNCTION pf_Range (int)
AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
GO
CREATE TABLE TestPartition (id int not null)
INSERT TestPartition VALUES(1)
INSERT TestPartition VALUES(2)
INSERT TestPartition VALUES(3)
INSERT TestPartition VALUES(10)
INSERT TestPartition VALUES(11)
INSERT TestPartition VALUES(17)
INSERT TestPartition VALUES(18)
INSERT TestPartition VALUES(19)
INSERT TestPartition VALUES(21)
INSERT TestPartition VALUES(25)
INSERT TestPartition VALUES(22)
INSERT TestPartition VALUES(23)
INSERT TestPartition VALUES(0)
INSERT TestPartition VALUES(5)
GO
CREATE PARTITION SCHEME ps_Range
AS PARTITION pf_Range
ALL TO ([PRIMARY])
GO
CREATE CLUSTERED INDEX IX_TestPartition_ID
ON TestPartition(ID) ON ps_Range(ID)
SELECT $PARTITION.pf_Range(ID) AS Partition,*
FROM TestPartition
ORDER BY Partition
Denis the SQL Menace
http://sqlservercode.blogspot.com/
|||That's interesting, it returns 'Standard Edition'. I thought I downloaded DE
with my MDSN subscription. I'll go back through the process to see where I
went wrong.
Thanks.
"SQL Menace" wrote:

> On Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I have no problem on a developer edition
> What does this return?
> select serverproperty('Edition')
> I have no problem running the following on a developer edition
> CREATE PARTITION FUNCTION pf_Range (int)
> AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
> GO
>
> CREATE TABLE TestPartition (id int not null)
> INSERT TestPartition VALUES(1)
> INSERT TestPartition VALUES(2)
> INSERT TestPartition VALUES(3)
> INSERT TestPartition VALUES(10)
> INSERT TestPartition VALUES(11)
> INSERT TestPartition VALUES(17)
> INSERT TestPartition VALUES(18)
> INSERT TestPartition VALUES(19)
> INSERT TestPartition VALUES(21)
> INSERT TestPartition VALUES(25)
> INSERT TestPartition VALUES(22)
> INSERT TestPartition VALUES(23)
> INSERT TestPartition VALUES(0)
> INSERT TestPartition VALUES(5)
> GO
>
> CREATE PARTITION SCHEME ps_Range
> AS PARTITION pf_Range
> ALL TO ([PRIMARY])
> GO
>
> CREATE CLUSTERED INDEX IX_TestPartition_ID
> ON TestPartition(ID) ON ps_Range(ID)
>
> SELECT $PARTITION.pf_Range(ID) AS Partition,*
> FROM TestPartition
> ORDER BY Partition
>
> Denis the SQL Menace
> http://sqlservercode.blogspot.com/
>

Can't create partitioned table in Developer Edition?

I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
fails saying that partitioned tables may only be created in Enterprise
Edition. What gives, DE is supposed to have all the capabilities of EE?
ScottOn Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
> fails saying that partitioned tables may only be created in Enterprise
> Edition. What gives, DE is supposed to have all the capabilities of EE?
> Scott
I have no problem on a developer edition
What does this return?
select serverproperty('Edition')
I have no problem running the following on a developer edition
CREATE PARTITION FUNCTION pf_Range (int)
AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
GO
CREATE TABLE TestPartition (id int not null)
INSERT TestPartition VALUES(1)
INSERT TestPartition VALUES(2)
INSERT TestPartition VALUES(3)
INSERT TestPartition VALUES(10)
INSERT TestPartition VALUES(11)
INSERT TestPartition VALUES(17)
INSERT TestPartition VALUES(18)
INSERT TestPartition VALUES(19)
INSERT TestPartition VALUES(21)
INSERT TestPartition VALUES(25)
INSERT TestPartition VALUES(22)
INSERT TestPartition VALUES(23)
INSERT TestPartition VALUES(0)
INSERT TestPartition VALUES(5)
GO
CREATE PARTITION SCHEME ps_Range
AS PARTITION pf_Range
ALL TO ([PRIMARY])
GO
CREATE CLUSTERED INDEX IX_TestPartition_ID
ON TestPartition(ID) ON ps_Range(ID)
SELECT $PARTITION.pf_Range(ID) AS Partition,*
FROM TestPartition
ORDER BY Partition
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||That's interesting, it returns 'Standard Edition'. I thought I downloaded DE
with my MDSN subscription. I'll go back through the process to see where I
went wrong.
Thanks.
"SQL Menace" wrote:
> On Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> > I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
> > fails saying that partitioned tables may only be created in Enterprise
> > Edition. What gives, DE is supposed to have all the capabilities of EE?
> >
> > Scott
> I have no problem on a developer edition
> What does this return?
> select serverproperty('Edition')
> I have no problem running the following on a developer edition
> CREATE PARTITION FUNCTION pf_Range (int)
> AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
> GO
>
> CREATE TABLE TestPartition (id int not null)
> INSERT TestPartition VALUES(1)
> INSERT TestPartition VALUES(2)
> INSERT TestPartition VALUES(3)
> INSERT TestPartition VALUES(10)
> INSERT TestPartition VALUES(11)
> INSERT TestPartition VALUES(17)
> INSERT TestPartition VALUES(18)
> INSERT TestPartition VALUES(19)
> INSERT TestPartition VALUES(21)
> INSERT TestPartition VALUES(25)
> INSERT TestPartition VALUES(22)
> INSERT TestPartition VALUES(23)
> INSERT TestPartition VALUES(0)
> INSERT TestPartition VALUES(5)
> GO
>
> CREATE PARTITION SCHEME ps_Range
> AS PARTITION pf_Range
> ALL TO ([PRIMARY])
> GO
>
> CREATE CLUSTERED INDEX IX_TestPartition_ID
> ON TestPartition(ID) ON ps_Range(ID)
>
> SELECT $PARTITION.pf_Range(ID) AS Partition,*
> FROM TestPartition
> ORDER BY Partition
>
> Denis the SQL Menace
> http://sqlservercode.blogspot.com/
>

Can't create partitioned table in Developer Edition?

I'm trying to create a partitioned table in SQL2K5 Developer Edition and it
fails saying that partitioned tables may only be created in Enterprise
Edition. What gives, DE is supposed to have all the capabilities of EE?
ScottOn Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I'm trying to create a partitioned table in SQL2K5 Developer Edition and i
t
> fails saying that partitioned tables may only be created in Enterprise
> Edition. What gives, DE is supposed to have all the capabilities of EE?
> Scott
I have no problem on a developer edition
What does this return?
select serverproperty('Edition')
I have no problem running the following on a developer edition
CREATE PARTITION FUNCTION pf_Range (int)
AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
GO
CREATE TABLE TestPartition (id int not null)
INSERT TestPartition VALUES(1)
INSERT TestPartition VALUES(2)
INSERT TestPartition VALUES(3)
INSERT TestPartition VALUES(10)
INSERT TestPartition VALUES(11)
INSERT TestPartition VALUES(17)
INSERT TestPartition VALUES(18)
INSERT TestPartition VALUES(19)
INSERT TestPartition VALUES(21)
INSERT TestPartition VALUES(25)
INSERT TestPartition VALUES(22)
INSERT TestPartition VALUES(23)
INSERT TestPartition VALUES(0)
INSERT TestPartition VALUES(5)
GO
CREATE PARTITION SCHEME ps_Range
AS PARTITION pf_Range
ALL TO ([PRIMARY])
GO
CREATE CLUSTERED INDEX IX_TestPartition_ID
ON TestPartition(ID) ON ps_Range(ID)
SELECT $PARTITION.pf_Range(ID) AS Partition,*
FROM TestPartition
ORDER BY Partition
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||That's interesting, it returns 'Standard Edition'. I thought I downloaded DE
with my MDSN subscription. I'll go back through the process to see where I
went wrong.
Thanks.
"SQL Menace" wrote:

> On Apr 10, 9:46 am, Scott <S...@.discussions.microsoft.com> wrote:
> I have no problem on a developer edition
> What does this return?
> select serverproperty('Edition')
> I have no problem running the following on a developer edition
> CREATE PARTITION FUNCTION pf_Range (int)
> AS RANGE RIGHT FOR VALUES(5,10,15,20,25)
> GO
>
> CREATE TABLE TestPartition (id int not null)
> INSERT TestPartition VALUES(1)
> INSERT TestPartition VALUES(2)
> INSERT TestPartition VALUES(3)
> INSERT TestPartition VALUES(10)
> INSERT TestPartition VALUES(11)
> INSERT TestPartition VALUES(17)
> INSERT TestPartition VALUES(18)
> INSERT TestPartition VALUES(19)
> INSERT TestPartition VALUES(21)
> INSERT TestPartition VALUES(25)
> INSERT TestPartition VALUES(22)
> INSERT TestPartition VALUES(23)
> INSERT TestPartition VALUES(0)
> INSERT TestPartition VALUES(5)
> GO
>
> CREATE PARTITION SCHEME ps_Range
> AS PARTITION pf_Range
> ALL TO ([PRIMARY])
> GO
>
> CREATE CLUSTERED INDEX IX_TestPartition_ID
> ON TestPartition(ID) ON ps_Range(ID)
>
> SELECT $PARTITION.pf_Range(ID) AS Partition,*
> FROM TestPartition
> ORDER BY Partition
>
> Denis the SQL Menace
> http://sqlservercode.blogspot.com/
>

Can't connect to SQL server Northwind database

I am trying to connect to SQL 7.0 northwind database via visual studio
2005. But I can't open the connection. I get an error saying remote
access is not allowed. But the remote access is ok. I can used the same
login and connect to the sql server via enterprise manage.

SqlConnection conn = new SqlConnection("Data
Source=(sqlserver:1433);Initial Catalog=Northwind;User
ID=me;Password=mypassword");

The above is the string I am trying to use.

Is there a way to do this in Visual studio thankspodx (nate.eckstine@.seattle.gov) writes:

Quote:

Originally Posted by

I am trying to connect to SQL 7.0 northwind database via visual studio
2005. But I can't open the connection. I get an error saying remote
access is not allowed. But the remote access is ok. I can used the same
login and connect to the sql server via enterprise manage.
>
SqlConnection conn = new SqlConnection("Data
Source=(sqlserver:1433);Initial Catalog=Northwind;User
ID=me;Password=mypassword");
>
The above is the string I am trying to use.

Is the name of the SQL Server machine realluy "sqlserver"? If SQL
Server is running on your local machine, try "(local)" instead.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx