Cannot Create Partition function in sql 2005 7

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Cannot Create Partition function in sql 2005 7

Author

Topic

Noor Anwar
Starting Member

8 Posts

Posted - 2010-08-23 : 03:10:12

i m trying to create partition function and following error from sql2005 enterprise edition

use [Data Partition DB3]
GO
CREATE PARTITION FUNCTION [Data Partition Range](int)
AS RANGE LEFT FOR VALUES (100,200,300)

Msg 7736, Level 16, State 1
Server 'SERVERNAME\SQLEXPRESS', Line 4
Partition function can only be created in Enterprise edition of SQL Server. Only Enterprise edition
of SQL Server supports partitioning.

Please help me if anybody can

Signature

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-08-23 : 04:27:10

Please run the following and post the results

quote:
SELECT @@Version

From the looks of the instance name, that's a SQL Express instance you're connected to (free and limited), not Enterprise. Are you connected to the correct instance?

--
Gail Shaw
SQL Server MVP

Noor Anwar
Starting Member

8 Posts

Posted - 2010-08-24 : 01:30:10

Sir Gail Shaw thank You So Much for helping me,
May Almighty Allah bless you and your family.

SQL Instance that i using was Express
now i installed again sql2005 Enterprise Edition with named instance
and now partition function works perfectly.

bundle of thanks
Noor Anwar

Signature

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources