how can I confirm msde sp3a upgrade information

I would need to know if the MSDE SP3a is aleady Upgraded.
I didn't search registy and Enterprise Manager(other PC)
Thank for your help
Hi,
Login to sql server using below command from command prompt:-
OSQL -sa -Ppassword -Sserver_name (enter)
1>select serverproperty('productlevel')
2>go
This will give you the service pack level of your sql server.
For older versions < SQL 2000, use the command
select @.@.version
It will give you the service pack number. with you can check the below link
to get the service pack details.
http://vyaskn.tripod.com/sqlsps.htm
Thanks
Hari
MCDBA
"peter" <anonymous@.discussions.microsoft.com> wrote in message
news:62a701c47528$ec661070$a301280a@.phx.gbl...
> I would need to know if the MSDE SP3a is aleady Upgraded.
> I didn't search registy and Enterprise Manager(other PC)
> Thank for your help
|||http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)
"peter" <anonymous@.discussions.microsoft.com> wrote in message
news:62a701c47528$ec661070$a301280a@.phx.gbl...
> I would need to know if the MSDE SP3a is aleady Upgraded.
> I didn't search registy and Enterprise Manager(other PC)
> Thank for your help

How can I check whether a table in database has the FULLTEXT INDEX or not. -

Our production DBs are SQL Server 2000(Enterprise Edition) on Windows2003.
Can anybody tell me how can I check whether a table has a FullText Index or not?
Thank you!Using DATABASEPROERPTY you can get details on database
IsFulltextEnabled
Database is full-text enabled.

I'm not sure whether a table is enable for that, BOL refers

To check the status, tables, and schedules of a full-text catalog
Expand a server group, and then expand a server.
Expand Databases, and then expand the database that contains the full-text catalog to review.
Click Full-Text Catalogs, and then right-click the specific catalog to review.
Click Properties, and then click the Status, Tables, and Schedules tabs, as appropriate.sql

How can I change Table Scripting Options defaults?

I'm using SQL Server 2000.
In Enterprise Manager, if I right-click a table then: All Tasks/ Generate
SQL Script /Options tab, there are Table Scripting Options. How can I
change the defaults?
For example, I would like "Script PRIMARY Keys, ..." to be checked by
default.
Thanx.This is not configurable, I'm afraid.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"msnews.microsoft.com" <vincent.rineer@.capbluecross.com> wrote in message
news:%23rMrMwbSFHA.3972@.TK2MSFTNGP14.phx.gbl...
> I'm using SQL Server 2000.
> In Enterprise Manager, if I right-click a table then: All Tasks/ Generate
> SQL Script /Options tab, there are Table Scripting Options. How can I
> change the defaults?
> For example, I would like "Script PRIMARY Keys, ..." to be checked by
> default.
> Thanx.
>

How can I change Table Scripting Options defaults?

I'm using SQL Server 2000.
In Enterprise Manager, if I right-click a table then: All Tasks/ Generate
SQL Script /Options tab, there are Table Scripting Options. How can I
change the defaults?
For example, I would like "Script PRIMARY Keys, ..." to be checked by
default.
Thanx.
This is not configurable, I'm afraid.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"msnews.microsoft.com" <vincent.rineer@.capbluecross.com> wrote in message
news:%23rMrMwbSFHA.3972@.TK2MSFTNGP14.phx.gbl...
> I'm using SQL Server 2000.
> In Enterprise Manager, if I right-click a table then: All Tasks/ Generate
> SQL Script /Options tab, there are Table Scripting Options. How can I
> change the defaults?
> For example, I would like "Script PRIMARY Keys, ..." to be checked by
> default.
> Thanx.
>
sql

How can I change Table Scripting Options defaults?

I'm using SQL Server 2000.
In Enterprise Manager, if I right-click a table then: All Tasks/ Generate
SQL Script /Options tab, there are Table Scripting Options. How can I
change the defaults?
For example, I would like "Script PRIMARY Keys, ..." to be checked by
default.
Thanx.This is not configurable, I'm afraid.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"msnews.microsoft.com" <vincent.rineer@.capbluecross.com> wrote in message
news:%23rMrMwbSFHA.3972@.TK2MSFTNGP14.phx.gbl...
> I'm using SQL Server 2000.
> In Enterprise Manager, if I right-click a table then: All Tasks/ Generate
> SQL Script /Options tab, there are Table Scripting Options. How can I
> change the defaults?
> For example, I would like "Script PRIMARY Keys, ..." to be checked by
> default.
> Thanx.
>

How can I change a column with datatype "text" to "int"?

I made a mistake when I first created the column and just found out when I
tried to calculate. I tried using the design feature on Enterprise Manager,
but got an error message that this couldn't be done. Any help is deeply
appreciate.Don't use Enterprise Manager for this. Open Query Analyzer and connect to
the correct database.
-- add a new column to the table;
ALTER TABLE tablename ADD temp_column INT;
-- copy the data from the text column;
UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column)
= 1;
-- drop the text column;
ALTER TABLE tablename DROP COLUMN text_column;
-- rename the new column;
EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
Of course, you'll want to put in the correct names for tablename,
text_column, real_column, etc.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Karolus" <Karolus@.discussions.microsoft.com> wrote in message
news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
>I made a mistake when I first created the column and just found out when I
> tried to calculate. I tried using the design feature on Enterprise
> Manager,
> but got an error message that this couldn't be done. Any help is deeply
> appreciate.|||Thank you, Aaaron. I will use what you provided and make the change. Thanks
mucho. karolus
"Aaron Bertrand [SQL Server MVP]" wrote:
> Don't use Enterprise Manager for this. Open Query Analyzer and connect to
> the correct database.
> -- add a new column to the table;
> ALTER TABLE tablename ADD temp_column INT;
> -- copy the data from the text column;
> UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column)
> = 1;
> -- drop the text column;
> ALTER TABLE tablename DROP COLUMN text_column;
> -- rename the new column;
> EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
> Of course, you'll want to put in the correct names for tablename,
> text_column, real_column, etc.
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "Karolus" <Karolus@.discussions.microsoft.com> wrote in message
> news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
> >I made a mistake when I first created the column and just found out when I
> > tried to calculate. I tried using the design feature on Enterprise
> > Manager,
> > but got an error message that this couldn't be done. Any help is deeply
> > appreciate.
>
>

How can I change a column with datatype "text" to "int"?

I made a mistake when I first created the column and just found out when I
tried to calculate. I tried using the design feature on Enterprise Manager,
but got an error message that this couldn't be done. Any help is deeply
appreciate.
Don't use Enterprise Manager for this. Open Query Analyzer and connect to
the correct database.
-- add a new column to the table;
ALTER TABLE tablename ADD temp_column INT;
-- copy the data from the text column;
UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column)
= 1;
-- drop the text column;
ALTER TABLE tablename DROP COLUMN text_column;
-- rename the new column;
EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
Of course, you'll want to put in the correct names for tablename,
text_column, real_column, etc.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Karolus" <Karolus@.discussions.microsoft.com> wrote in message
news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
>I made a mistake when I first created the column and just found out when I
> tried to calculate. I tried using the design feature on Enterprise
> Manager,
> but got an error message that this couldn't be done. Any help is deeply
> appreciate.
|||Thank you, Aaaron. I will use what you provided and make the change. Thanks
mucho. karolus
"Aaron Bertrand [SQL Server MVP]" wrote:

> Don't use Enterprise Manager for this. Open Query Analyzer and connect to
> the correct database.
> -- add a new column to the table;
> ALTER TABLE tablename ADD temp_column INT;
> -- copy the data from the text column;
> UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column)
> = 1;
> -- drop the text column;
> ALTER TABLE tablename DROP COLUMN text_column;
> -- rename the new column;
> EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
> Of course, you'll want to put in the correct names for tablename,
> text_column, real_column, etc.
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "Karolus" <Karolus@.discussions.microsoft.com> wrote in message
> news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
>
>

How can I change a column with datatype "text" to "int"?

I made a mistake when I first created the column and just found out when I
tried to calculate. I tried using the design feature on Enterprise Manager,
but got an error message that this couldn't be done. Any help is deeply
appreciate.Don't use Enterprise Manager for this. Open Query Analyzer and connect to
the correct database.
-- add a new column to the table;
ALTER TABLE tablename ADD temp_column INT;
-- copy the data from the text column;
UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column)
= 1;
-- drop the text column;
ALTER TABLE tablename DROP COLUMN text_column;
-- rename the new column;
EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
Of course, you'll want to put in the correct names for tablename,
text_column, real_column, etc.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Karolus" <Karolus@.discussions.microsoft.com> wrote in message
news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
>I made a mistake when I first created the column and just found out when I
> tried to calculate. I tried using the design feature on Enterprise
> Manager,
> but got an error message that this couldn't be done. Any help is deeply
> appreciate.|||Thank you, Aaaron. I will use what you provided and make the change. Thank
s
mucho. karolus
"Aaron Bertrand [SQL Server MVP]" wrote:

> Don't use Enterprise Manager for this. Open Query Analyzer and connect to
> the correct database.
> -- add a new column to the table;
> ALTER TABLE tablename ADD temp_column INT;
> -- copy the data from the text column;
> UPDATE tablename SET temp_column = text_column WHERE ISNUMERIC(text_column
)
> = 1;
> -- drop the text column;
> ALTER TABLE tablename DROP COLUMN text_column;
> -- rename the new column;
> EXEC sp_rename 'tablename.temp_column', 'real_column', 'COLUMN';
> Of course, you'll want to put in the correct names for tablename,
> text_column, real_column, etc.
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
> "Karolus" <Karolus@.discussions.microsoft.com> wrote in message
> news:3B1473BD-7C92-4D18-80FF-F0DEE26C408F@.microsoft.com...
>
>

hot to make sure a upgrade from sql 2005 standard to enterprise edition?

Randy,

I did run upgrade advisior to check the existed sql 2005 standard edition to upgrade to enterprise editon. I got the following error message:

SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor

Is it means the upgrade advisor can only work on from 7.0, 2000 to 2005? If I need check from standard to enterjprise in 2005, what kind of tool I can use?

One of the SQL Server forums would be a better place to ask this question:

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

You'll have better luck finding an answer there.

-Tom