Sql Stop Logging: version

Showing posts with label version. Show all posts

Friday, March 23, 2012

How to tell which version is installed

Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thankshttp://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsout
h.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>

How to tell which version is installed

Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thanks
http://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>
|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net.. .
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>

How to tell which version is installed

Regarding SQL server 2000
How do you tell...
1. Which version is installed (Enterprise / Standard / Developer etc.) ?
2. The service packs installed to date ?
Thankshttp://www.aspfaq.com/show.asp?id=2160
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rob C" <rwc1960@.bellsouth.net> wrote in message news:JmPad.77189$yp.12057@.bignews1.bellsouth.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>|||I use serverproperty
select serverproperty('productlevel' )
See serverproperty in Books on line
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Rob C" <rwc1960@.bellsouth.net> wrote in message
news:JmPad.77189$yp.12057@.bignews1.bellsouth.net...
> Regarding SQL server 2000
> How do you tell...
> 1. Which version is installed (Enterprise / Standard / Developer etc.) ?
> 2. The service packs installed to date ?
> Thanks
>

Wednesday, March 21, 2012

How to tell what version of SQL Server.

quote:

> If I am running an MSDN version of SQL Server how would I be able to tell
> using Query Analyzer?
> I tried @.@.Version ... but it says Enterprise Edition ... when I know I

have

quote:

> install MSDN copy.
> -Lars
>

|||Still does not tell me whether server is running MSDN copy of SQL Server.
Perhaps this is not possiable.
-Lars
"Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...

quote:

> Please check it out at the following link
> http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
>
> --
> HTH
> Satish Balusa
> Corillian Corp.
>
> "Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
> news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
tell[QUOTE]
> have
>

|||There's no such thing as an MSDN version of SQL Server. The MSDN people at M
S quite simply shipped
MSDN with the edition they found most appropriate. In the beginning of SQL2K
, you had all editions
and after a while the shipments only contained the developer edition.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:ukZJsub6DHA.2064@.TK2MSFTNGP11.phx.gbl...

quote:

> Still does not tell me whether server is running MSDN copy of SQL Server.
> Perhaps this is not possiable.
> -Lars
> "Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
> news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...
> tell
>

How to tell what version of SQL Server.

If I am running an MSDN version of SQL Server how would I be able to tell
using Query Analyzer?
I tried @.@.Version ... but it says Enterprise Edition ... when I know I have
install MSDN copy.
-LarsPlease check it out at the following link
http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
HTH
Satish Balusa
Corillian Corp.
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
> If I am running an MSDN version of SQL Server how would I be able to tell
> using Query Analyzer?
> I tried @.@.Version ... but it says Enterprise Edition ... when I know I
have
> install MSDN copy.
> -Lars
>|||Still does not tell me whether server is running MSDN copy of SQL Server.
Perhaps this is not possiable.
-Lars
"Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...
> Please check it out at the following link
> http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
>
> --
> HTH
> Satish Balusa
> Corillian Corp.
>
> "Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
> news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
> > If I am running an MSDN version of SQL Server how would I be able to
tell
> > using Query Analyzer?
> > I tried @.@.Version ... but it says Enterprise Edition ... when I know I
> have
> > install MSDN copy.
> >
> > -Lars
> >
> >
>|||There's no such thing as an MSDN version of SQL Server. The MSDN people at MS quite simply shipped
MSDN with the edition they found most appropriate. In the beginning of SQL2K, you had all editions
and after a while the shipments only contained the developer edition.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:ukZJsub6DHA.2064@.TK2MSFTNGP11.phx.gbl...
> Still does not tell me whether server is running MSDN copy of SQL Server.
> Perhaps this is not possiable.
> -Lars
> "Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
> news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...
> > Please check it out at the following link
> >
> > http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
> >
> >
> > --
> > HTH
> > Satish Balusa
> > Corillian Corp.
> >
> >
> > "Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
> > news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
> > > If I am running an MSDN version of SQL Server how would I be able to
> tell
> > > using Query Analyzer?
> > > I tried @.@.Version ... but it says Enterprise Edition ... when I know I
> > have
> > > install MSDN copy.
> > >
> > > -Lars
> > >
> > >
> >
> >
>

How to tell what version of SQL 2005 is intalled (Enterprise or standard)

I need to make sure that the proper version of SQL Server 2005 was installed on the production server.

What do I do to find out?

Thanks in advance!

Connect to the instance using SQLCMD and run:

1> select @.@.version;
2> go

You should get output that looks like:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

The 9.00.1399.06 is the version for SQL Server 2005 RTM.

Or from SQLCMD you can run:

1> select CONVERT(char(20), SERVERPROPERTY('productversion'));
2> go

Which will output:

9.00.1399.06

Also, if you connect to the server using SQL Server Management Studio, the version is displayed in Object Explorer on the root server node. Here it's displayed as 9.00.1399.

Cheers,
Dan

|||

Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Name: Edition

Type: REG_SZ

Data: Enterprise Edition

This result supports you install SQL Server 2005 on a clean machine. Most often, you should check the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.n\Setup if you install multiple instances.

|||

In my previous posting,

"This result supports you install SQL Server 2005 on a clean machine."

should be

"This result supposes you install SQL Server 2005 ENT on a clean machine."

In addition, you can also get the version information from the registry key by checking the value of "Version".

sql

How to tell what SQL 2005 version I'm runing?

Hey everyone,
We have a server that is running SQL 2005 but we don't know if it's full SQL
2005 or SQL 2005 Express. Can someone tell me how I can find out?
We DON'T have SQL Server Mangement Studio installed.
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************> We have a server that is running SQL 2005 but we don't know if it's full
> SQL 2005 or SQL 2005 Express. Can someone tell me how I can find out?
> We DON'T have SQL Server Mangement Studio installed.
Anywhere?
If you're going to manage SQL Server, you should have it SOMEWHERE. If not
regular Management Studio then at least the express version (which is free).
http://tinyurl.com/j7wjl
From there you can run
SELECT @.@.VERSION;|||You should be able to tell something from your services applet in control
panel / administrative tools. By default I think a SQL Express instance
will be listed as SQL Server (SQLEXPRESS).
But, what on earth could you be doing with SQL Server? If you can't even
connect to it in order to see what edition it is, how are you managing it,
how do you expect to create databases, etc.? This is why I suggested
getting at least Management Studio Express. It doesn't do everything, but
it is better than zero.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Clayton Sutton" <none@.none.com> wrote in message
news:lXM%h.208335$RF.182058@.fe02.news.easynews.com...
> Hey Aaron,
> We need to know which version we have installed so we will know how to
> back it up. If is't the Express version then NetBackup will not back it
> up with their SQL Agent. However, if it's the Express version then we
> have to us a command line to back it up. But we don't know which version
> is installed.
> Here is a screen shot of what I have installed.|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uVOXCDPkHHA.1340@.TK2MSFTNGP04.phx.gbl...
> You should be able to tell something from your services applet in control
> panel / administrative tools. By default I think a SQL Express instance
> will be listed as SQL Server (SQLEXPRESS).
> But, what on earth could you be doing with SQL Server? If you can't even
> connect to it in order to see what edition it is, how are you managing it,
> how do you expect to create databases, etc.?
>This is why I suggested getting at least Management Studio Express. It
>doesn't do everything, but it is better than zero.
Well, this is one reason I want to know which version is installed so I will
know which Management Studio to install, the full version or the Express
version.
SQL is running on a SharePoint 2007 server. SharePoint needed SQL, however,
no one can remember if the full version or the Express version was installed
during instalation.
Clayton
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:lXM%h.208335$RF.182058@.fe02.news.easynews.com...
>> Hey Aaron,
>> We need to know which version we have installed so we will know how to
>> back it up. If is't the Express version then NetBackup will not back it
>> up with their SQL Agent. However, if it's the Express version then we
>> have to us a command line to back it up. But we don't know which version
>> is installed.
>> Here is a screen shot of what I have installed.
>|||> Well, this is one reason I want to know which version is installed so I
> will know which Management Studio to install, the full version or the
> Express version.
Well, since Management Studio Express is free, it is not going to hurt you
to install it.
And if you had access to Management Studio (e.g. on a SQL Server
installation CD), then I guess you could look at the CD to see which edition
you have, since it's printed on the label. :-)
> SQL is running on a SharePoint 2007 server. SharePoint needed SQL,
> however, no one can remember if the full version or the Express version
> was installed during instalation.
Have you looked at the SharePoint site, or the SharePoint documentation?
Surely it is listed there somewhere. Also, did you try looking in the
services applet like I suggested earlier?|||How about connection with SQLCMD and execute below?
SELECT @.@.VERSION
GO
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Clayton Sutton" <none@.none.com> wrote in message
news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
> Hey everyone,
> We have a server that is running SQL 2005 but we don't know if it's full SQL 2005 or SQL 2005
> Express. Can someone tell me how I can find out?
> We DON'T have SQL Server Mangement Studio installed.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it. You can find it at:
> http://www.nikoli.net/itunepod
> *******************
>
>|||Hey Aaron,
After I got in to work today I checked the services on that server and it
looks like we are running SQL Express. This is what it says: SQL Server
(SQLEXPRESS).
Thanks for your help dude! Now I will install the Management Studio.
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23nHfu0RkHHA.1828@.TK2MSFTNGP05.phx.gbl...
>> Well, this is one reason I want to know which version is installed so I
>> will know which Management Studio to install, the full version or the
>> Express version.
> Well, since Management Studio Express is free, it is not going to hurt you
> to install it.
> And if you had access to Management Studio (e.g. on a SQL Server
> installation CD), then I guess you could look at the CD to see which
> edition you have, since it's printed on the label. :-)
>> SQL is running on a SharePoint 2007 server. SharePoint needed SQL,
>> however, no one can remember if the full version or the Express version
>> was installed during instalation.
> Have you looked at the SharePoint site, or the SharePoint documentation?
> Surely it is listed there somewhere. Also, did you try looking in the
> services applet like I suggested earlier?
>|||Hey Tibor,
Thanks for the advice, however, I don't know how to use the sqlcmd command.
Got any tips? I tried the /? but that didn't help much.
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:edgGDLVkHHA.568@.TK2MSFTNGP02.phx.gbl...
> How about connection with SQLCMD and execute below?
> SELECT @.@.VERSION
> GO
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
>> Hey everyone,
>> We have a server that is running SQL 2005 but we don't know if it's full
>> SQL 2005 or SQL 2005 Express. Can someone tell me how I can find out?
>> We DON'T have SQL Server Mangement Studio installed.
>> --
>> TIA,
>>
>> Clayton
>>
>> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
>> You can find it at: http://www.nikoli.net/itunepod
>> *******************
>>
>>
>|||Sorry Aaron,
I was looking at the wrong server. Looking at the "right" server services
it says: SQL Server (OFFICESERVERS).
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Clayton Sutton" <none@.none.com> wrote in message
news:j2%%h.274750$9i2.95644@.fe06.news.easynews.com...
> Hey Aaron,
> After I got in to work today I checked the services on that server and it
> looks like we are running SQL Express. This is what it says: SQL Server
> (SQLEXPRESS).
> Thanks for your help dude! Now I will install the Management Studio.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
> You can find it at: http://www.nikoli.net/itunepod
> *******************
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:%23nHfu0RkHHA.1828@.TK2MSFTNGP05.phx.gbl...
>> Well, this is one reason I want to know which version is installed so I
>> will know which Management Studio to install, the full version or the
>> Express version.
>> Well, since Management Studio Express is free, it is not going to hurt
>> you to install it.
>> And if you had access to Management Studio (e.g. on a SQL Server
>> installation CD), then I guess you could look at the CD to see which
>> edition you have, since it's printed on the label. :-)
>> SQL is running on a SharePoint 2007 server. SharePoint needed SQL,
>> however, no one can remember if the full version or the Express version
>> was installed during instalation.
>> Have you looked at the SharePoint site, or the SharePoint documentation?
>> Surely it is listed there somewhere. Also, did you try looking in the
>> services applet like I suggested earlier?
>|||http://msdn2.microsoft.com/en-us/library/ms162773.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Clayton Sutton" <none@.none.com> wrote in message
news:s3%%h.405811$mJ2.249092@.fe10.news.easynews.com...
> Hey Tibor,
> Thanks for the advice, however, I don't know how to use the sqlcmd command. Got any tips? I tried
> the /? but that didn't help much.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it. You can find it at:
> http://www.nikoli.net/itunepod
> *******************
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:edgGDLVkHHA.568@.TK2MSFTNGP02.phx.gbl...
>> How about connection with SQLCMD and execute below?
>> SELECT @.@.VERSION
>> GO
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
>> Hey everyone,
>> We have a server that is running SQL 2005 but we don't know if it's full SQL 2005 or SQL 2005
>> Express. Can someone tell me how I can find out?
>> We DON'T have SQL Server Mangement Studio installed.
>> --
>> TIA,
>>
>> Clayton
>>
>> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it. You can find it at:
>> http://www.nikoli.net/itunepod
>> *******************
>>
>>
>>
>|||select @.@.version
will give you:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Clayton Sutton" <none@.none.com> wrote in message
news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
> Hey everyone,
> We have a server that is running SQL 2005 but we don't know if it's full
> SQL 2005 or SQL 2005 Express. Can someone tell me how I can find out?
> We DON'T have SQL Server Mangement Studio installed.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
> You can find it at: http://www.nikoli.net/itunepod
> *******************
>
>

How to tell version difference between 2000 Enterprise vs. Standard

I have kind of an urgent need here. I need to know if there is a dll file or registry key or something of that nature that I can query on to find out if my SQL 2000 installations are Enterprise or Standard.

I understand I can do this using query analyser, but that will not work with my reporting tool (this is for reporting numbers of SQL installations in our very large enterprise for Microsoft license compliance).

Thanks for any guidance!!

Cheryl Marland

cheryl.marland@.va.gov

In SQL 2000 that information is not written to the registry in a readable format.

If you can't run osql in the discovery process, you could create a windows batch file that's scheduled to run every night at midnight - the batch job could run

select convert(char(20), serverproperty('edition'))
go

and dump the results to an output file. If you can't read the file you could author the script to update a reg key with the information so you're reporting process could pick it up.

Cheers,
Dan

|||

Dan,

Is this info more readily available in SQL 2005?

How to tell version difference between 2000 Enterprise vs. Standard

Thanks for any guidance!!

Cheryl Marland

cheryl.marland@.va.gov

In SQL 2000 that information is not written to the registry in a readable format.

If you can't run osql in the discovery process, you could create a windows batch file that's scheduled to run every night at midnight - the batch job could run

select convert(char(20), serverproperty('edition'))
go

and dump the results to an output file. If you can't read the file you could author the script to update a reg key with the information so you're reporting process could pick it up.

Cheers,
Dan

|||

Dan,

Is this info more readily available in SQL 2005?

Monday, March 19, 2012

how to tell expiration date of eval version

First question: I have sql server 2005 enterprise eval edition installed. is there a query, command or tool can tell me the exact expiration date? I understand it is 180 day but I still want some way to query the exact date.

Second question: does sql server log any warning message before eval expires?

Simply look at the creation date of the SQL folders. There is a message in the event log telling about the expiration date of SQL Server.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Sunday, February 19, 2012

How to stop PAD_INDEX being scripted

Our team checks SQL scripts into version control. On my machine, however, the generated script always differs slightly. When I generate a create table script, the primary key part always has PAD_INDEX = OFF. Nobody else's server generates this. Does anyone know what option or setting I need to change to prevent PAD_INDEX = OFF from being output?

WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]

BOL specifies

When creating indexed views or manipulating rows in tables participating in an indexed view, seven SET options must be assigned specific values. The SET options ARITHABORT, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, ANSI_PADDING, and ANSI_WARNINGS must be ON. The SET option NUMERIC_ROUNDABORT must be OFF.

If any of these settings is different, data modification statements (INSERT, UPDATE, DELETE) on any table referenced by an indexed view fail and SQL Server raises an error listing all SET options that violate setting requirements. In addition, for a SELECT statement that involves an indexed view, if the values of any of the SET options are not the required values, SQL Server processes the SELECT without considering the indexed view substitution. This ensures correctness of query result in cases where it can be affected by the above SET options.

If the application uses a DB-Library connection, all seven SET options on the server must be assigned the required values. (By default, OLE DB and ODBC connections have set all of the required SET options correctly, except for ARITHABORT.)

|||

Thank you for taking the time to copy and paste. However, I don't see how your post is relevant.

I am asking what determines whether the PAD_INDEX option is included in scripted CREATE TABLE statements.

|||Is anyone able to help with this?

Friday, March 23, 2012

How to tell which version is installed

How to tell which version is installed

How to tell which version is installed

Wednesday, March 21, 2012

How to tell what version of SQL Server.

How to tell what version of SQL Server.

How to tell what version of SQL 2005 is intalled (Enterprise or standard)

How to tell what SQL 2005 version I'm runing?

How to tell what SQL 2005 version I'm runing?

How to tell version difference between 2000 Enterprise vs. Standard

How to tell version difference between 2000 Enterprise vs. Standard

Monday, March 19, 2012

how to tell expiration date of eval version

Sunday, February 19, 2012

How to stop PAD_INDEX being scripted

Sql Stop Logging

Blog Archive

About Me