how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always th
e
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:

> we have a server installed SQL 2005 with Microsoft Action Pack Product Key
,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>

how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.
Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always the
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:

> we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>

how can I change SQL 2005 Licence key

we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
because we had to install a application program before we got the Licence.
Now we got the Licence and Product Key for this server. Their are two
questions I am wondered.
One is I couldn't find the licence infromation in SQL menues. Where can I
find the Licence information in SQL?
The other is How can I swap the Licence Key in this situation.Do you really need to change SQL2005 license key?
I have never found any need to fiddle with the SQL2005 license key. It's
hard coded in the install media--well, I'm not sure whether that's always the
case, but it's always the case where I have dealt with SQL2005.
Linchi
"snailsnail" wrote:
> we have a server installed SQL 2005 with Microsoft Action Pack Product Key,
> because we had to install a application program before we got the Licence.
> Now we got the Licence and Product Key for this server. Their are two
> questions I am wondered.
> One is I couldn't find the licence infromation in SQL menues. Where can I
> find the Licence information in SQL?
> The other is How can I swap the Licence Key in this situation.
>sql

How can I change PRIMARY KEY using code?

Hi,
Assume I have a PRIMARY KEY on one column.
How can I change PRIMARY KEY onto a new column using code?
Do I have to recreate the table?
Thanks.Hi
Here is the code to solve your problem
ALTER TABLE <TABLE_NAME>
DROP CONSTRAINT <Constraint_Name>
ALTER TABLE <TABLE_NAME>
ADD CONSTRAINT <Constraint_Name> PRIMARY KEY (<Column> )
best Regards,
Chandra
---
"§Chrissi§" wrote:

> Hi,
> Assume I have a PRIMARY KEY on one column.
> How can I change PRIMARY KEY onto a new column using code?
> Do I have to recreate the table?
> Thanks

How can I change my Primary Key

Hello,
I have transactional replication in place with @. 450 articles in the main
publication.
I need to modify the primary key to include an additional field.
How can I do this best?
Thanks.
~Lb
you can't without dropping your subscriptions and publications.
"Lonnye Blake Bower" <lbower@.excellerx.com> wrote in message
news:OoJcCdAMFHA.1096@.tk2msftngp13.phx.gbl...
> Hello,
> I have transactional replication in place with @. 450 articles in the main
> publication.
> I need to modify the primary key to include an additional field.
> How can I do this best?
> Thanks.
> ~Lb
>
|||Thank you...
Can I remove the table from the publication easily and then make the
changes... and finally create a new publication with just this table?
|||yes with transactional replication you can do with by using sp_droparticle.
You will have to drop the subscription(s) before you do this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lonnye Blake Bower" <lbower@.excellerx.com> wrote in message
news:%23c3blpAMFHA.3632@.TK2MSFTNGP10.phx.gbl...
> Thank you...
> Can I remove the table from the publication easily and then make the
> changes... and finally create a new publication with just this table?
>
sql

How can I automate the column titled as ID NUmber in my database, in VS 2005?

I have a table with a primary key titled as 'ID NUmber' which needs to be created automatically, however every time i add a new record the ID is not added and i have to write it manually i.e. 1, 2, 3.., could you please advice me how i can format this; i know you can do this with microsoft Access but with VS 2005 + VB language this option is not available under data type

*i am using VS 2005 and VB language

Go into design view for the table

toward the bottom, you'll see Identity Specification - open that up and set IS IDentity to True

|||Thank you, i have found the 'IS identity' but mine is set to 'No' and is blocked (i can't click on it). should i be using an specific data type; currenly i am using 'Real' is that right? I had to use 'Real' as with other data types the option for 'primary key' was not available.|||

Generally (though it might be possible some other way that I'm not familiar with), the way to do this is with an INT datatype, so it can automatically increment.

Maybe someone else can chime in here, how to do it some other way

|||

To set a column as an Identity column the datatype has to be one of the INT types - tinyint, smallint, int, bigint etc.

|||

i have used the tinyint to set the IS identity as 'yes', however when i run the database and add a new row to the database the row id is for example 9 instead of 2, even though i have deleted all the previous records and doesn't realise that i have now only 1 row and that the next id should be 2. is there any way to correct this?

|||

You need to read up books online about Identity columns. Once a number is assigned to a row, its gone. Even if the row is deleted the number is gone. Any new rows will get the next number. If you were doing this as a test and want to empty the table and reset the identity you can TRUNCATE the table instead of delete. Again, before doing the truncate, read up books online about the command. You can also use DBCC CHEKCIDENT to reset the seed value.

|||Remember, also - tinyint is defined like this:

tinyint

0 to 255

So - I'd recommend at least using INT

One last thing also - you said that your column is titled "ID Number"

My (and others) recommend that you remove the space (IDNumber) and that you never put spaces in your field or table names. Believe me, this will cause you less grief in the future.

how can I add a unique key column to a table and generate its values automatically?

Hi, all,

I have a question about adding a unique key column to an existing table.

what i trying to do is that: I have already created a table, now i wanna add a ID column to this table, and generate the values for ID column from 1 to the existing row number. How can I get this done?

Thanks a lot in advance for any guidance.

Here is an example of how to add an identity column

create table TestID (SomeField varchar(49))
insert into TestID values ('1.1.9')
insert into TestID values ('2.2.2.10')
insert into TestID values ('2.2.2.8')
insert into TestID values ('2.2.2.9')
insert into TestID values ('1.1.7')
insert into TestID values ('1.1.8')
insert into TestID values ('1.2.1')
insert into TestID values ('1.1.1')
insert into TestID values ('1.1.10')
insert into TestID values ('1.1.10')
GO
select * from TestID
GO

alter table TestID add IdField int identity not null
Go
select * from TestID
GO

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||

Hi, thanks a lot.

Got it done, but the problem is: the new added identity column is not in order? like its values from 1 to 82 is actually not in the order, it is sorted out based on other columns values in the existing table. So how can I modify its values from 1 to 83 in the oder?

Thanks a lot.

|||Order is never guaranteed for a table, use ORDER BY to get the rows back in the order that you want|||Hi, thanks a lot.

How about cascade insert and update

I am desgining a new database.
Is it suitable to set the cascade insert and cascade update to the foreign
key constrain?While this can be done on the application level, or through triggers it is
best to do it through cascading update and deletes. Please refer to
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q142/4/80.asp&NoWebContent=1
for more information.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:egYkwM1PGHA.648@.TK2MSFTNGP14.phx.gbl...
>I am desgining a new database.
> Is it suitable to set the cascade insert and cascade update to the foreign
> key constrain?
>|||"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:egYkwM1PGHA.648@.TK2MSFTNGP14.phx.gbl...
>I am desgining a new database.
> Is it suitable to set the cascade insert and cascade update to the foreign
> key constrain?
>
"Cascade insert" doesn't exist. "Cascade delete" is useful, and you should
use it on foreign keys between related entities, but not on foreign keys to
reference or "lookup" tables. "Cascade updates" should almost never be
used, since they only apply where you are updating a primary key, which you
should almost never do.
David

hot key for "Expression" in VS2005

Is there a hotkey for "Expression" right-click menu item in report designer?
--
Regards,
Dmitryit sure would be nice if they gave us office-style shortcut keys;
instead of subjecting us to a piece of shit IDE for uber-geeks
VS crashes on me; it's slow..
time to correct your strategy, Microsoft.. moving Query Analyzer and
Enterprise Manager did _NOTHING_ to help database developers.
Making BIDS in VS instead of in Office?
IT DID NOTHING TO HELP US OUT.
-Susie
Dmitry Duginov wrote:
> Is there a hotkey for "Expression" right-click menu item in report designer?
> --
> Regards,
> Dmitry|||Hi Dmitry,
There is no HotKey for "Expression".
You could click the Context Menu Key and then click "E".
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Wei;
THERE SHOULD BE A SHORTCUT KEY FOR EVERYTHING
stop forcing people to use Visual Studio for everything; it's not as
user-friendly as Office is.
-Aaron
Wei Lu [MSFT] wrote:
> Hi Dmitry,
> There is no HotKey for "Expression".
> You could click the Context Menu Key and then click "E".
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)|||Hello Aaron,
You could set up your customize Hotkey in the Visual Studio. But it does
not contain the Expression action, so we could not set a Hotkey for this
operation.
To provide your feedback directly to the product groups:
http://connect.microsoft.com/VisualStudio
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||it's another symptom that MS should have used Office instead of VS for
BIDS.
VS is a usability NIGHTMARE.
maybe you kids should stop selling us on new products; and start using
your existing products
-Susie
Wei Lu [MSFT] wrote:
> Hello Aaron,
> You could set up your customize Hotkey in the Visual Studio. But it does
> not contain the Expression action, so we could not set a Hotkey for this
> operation.
> To provide your feedback directly to the product groups:
> http://connect.microsoft.com/VisualStudio
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Susie,
If you have any concern, please send your feedback to the Product Team
directly.
http://connect.microsoft.com/VisualStudio
Microsoft will consider your request and improve our product. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||how about SQL authtentication?
where can we send feedback about having a gaping hole in ALL of our
databases for the past decade?
Do you really think that Microsoft LISTENS to anyone outside the
company?
Can SQL Authentication be secured?
How does Oracle and IBM and mySql do it?
Why is it that Microsoft has ZERO ABILITY to secure SQL
authentication'
Wei Lu [MSFT] wrote:
> Hello Susie,
> If you have any concern, please send your feedback to the Product Team
> directly.
> http://connect.microsoft.com/VisualStudio
> Microsoft will consider your request and improve our product. Thank you!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.