Sql Create error: edition

Showing posts with label edition. Show all posts

Sunday, March 25, 2012

Create table

Hi,
How would I create a table programmatically in a database. I am using C#
2005 Express edition.
For example I want to create a table named tblHours in a database
dbEmployees with the columns hours worked (integer), hourly pay (currency),
etc...
TIA
Roy
How about looking up "create table" in BOL?
ms-help://MS.SQLCC.v9/MS.SQLMobile.v3.en/SSMProg3/html/143cad25-5c1d-4c96-bd8b-6a95dbfb1b00.htm
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:5rEuf.56416$DQ4.1492398@.weber.videotron.net.. .
> Hi,
> How would I create a table programmatically in a database. I am using C#
> 2005 Express edition.
> For example I want to create a table named tblHours in a database
> dbEmployees with the columns hours worked (integer), hourly pay
> (currency),
> etc...
>
> TIA
> Roy
>
>

Create table

Hi,
How would I create a table programmatically in a database. I am using C#
2005 Express edition.
For example I want to create a table named tblHours in a database
dbEmployees with the columns hours worked (integer), hourly pay (currency),
etc...
TIA
Roy>> create a table programmatically in a database.. <<
You do not do that at all. First, you write a data model of your real
world, then you implement in a schema. Your real world does not change
on the fly. If the model needs to add, alter or remove tables , you do
it with other tools, such as QA. Never in a front end program.
You might also want stop putting silly prefixes in front of data
element names (see ISO-11179).|||What do you mean "programatically?" If you mean permanently then you need
to get the Management Studio Express from
(http://msdn.microsoft.com/sql/express/)
If you mean you want to formulate a table based on some input (hopefully for
temporary usage) you just simply formulate a CREATE TABLE statement and
execute it in ADO.NET. Do you know how to execute a SQL Statement?
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:snEuf.56318$DQ4.1489316@.weber.videotron.net...
> Hi,
> How would I create a table programmatically in a database. I am using C#
> 2005 Express edition.
> For example I want to create a table named tblHours in a database
> dbEmployees with the columns hours worked (integer), hourly pay
> (currency), etc...
>
> TIA
> Roy
>|||What's wrong with prefixes? If you have dozens or hundreds of tables and
views, it is useful to distinguish them at a glance in stored procedure for
example.
Peter|||Nothing, the guy doesn't understand the term KISS (Keep It Simple Sweet).
Table prefixes are useful for segmenting code, personally, i don't use tbl_
type prefixes, but i do use vw_ because if and when I use views in code I
can quickly see that I am using a view in a query and then can more quickly
understand that there is further logic underneath that might be causing a
performance problem.
I prefix stored procedures using logical segmentation, for instance
events_sel; research_sel etc... groups objects together in the database to
make life (and development/maintanence) easier.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"Rogas69" <rogas69@.no_spamers.o2.ie> wrote in message
news:%23ZSEWRSEGHA.916@.TK2MSFTNGP10.phx.gbl...
> What's wrong with prefixes? If you have dozens or hundreds of tables and
> views, it is useful to distinguish them at a glance in stored procedure
> for example.
> Peter
>|||"Tony Rogerson" <tonyrogerson@.sqlserverfaq.com>:
news:eGy3wlTEGHA.3200@.tk2msftngp13.phx.gbl...
> Nothing, the guy doesn't understand the term KISS (Keep It Simple Sweet).
> Table prefixes are useful for segmenting code, personally, i don't use
> tbl_ type prefixes, but i do use vw_ because if and when I use views in
> code I can quickly see that I am using a view in a query and then can more
> quickly understand that there is further logic underneath that might be
> causing a performance problem.
> I prefix stored procedures using logical segmentation, for instance
> events_sel; research_sel etc... groups objects together in the database to
> make life (and development/maintanence) easier.
> Tony.
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
> "Rogas69" <rogas69@.no_spamers.o2.ie> wrote in message
> news:%23ZSEWRSEGHA.916@.TK2MSFTNGP10.phx.gbl...
>
This is something newer
For me KISS stands for "keep it simple, stupid"
--
Andrey Odegov
avodeGOV@.yandex.ru
(remove GOV to respond)|||Celko has strong opinions and rarely is gentle with his advice (look past
that for some good advice much of the time, but as with all advice, there
are plenty of opinions.)
Personally, I don't like any type based prefixes on anything :) I do
something like this with stored procedures, functions etc (seperated by a $
(dollar sign) like table$action or purchaseOrder$delete, or something along
these lines.
On programming objects, I don't think either way is a big deal. I don't
prefix stuff with an indication if it is a procedure or a view, etc., but
either way is fine. I do feel that prefixes on tables, views and columns
look bad because the user is often presented these names, and they don't
need to know which are tables and which are views, and a programmer can tell
based on context. And since I always look at lists of objects in the
context of what they are:
select table_schema, table_name, table_type
from information_schema.tables
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Rogas69" <rogas69@.no_spamers.o2.ie> wrote in message
news:%23ZSEWRSEGHA.916@.TK2MSFTNGP10.phx.gbl...
> What's wrong with prefixes? If you have dozens or hundreds of tables and
> views, it is useful to distinguish them at a glance in stored procedure
> for example.
> Peter
>

Create table

Hi,
How would I create a table programmatically in a database. I am using C#
2005 Express edition.
For example I want to create a table named tblHours in a database
dbEmployees with the columns hours worked (integer), hourly pay (currency),
etc...
TIA
RoyHow about looking up "create table" in BOL?
ms-help://MS.SQLCC.v9/MS.SQLMobile.v3.en/SSMProg3/html/143cad25-5c1d-4c96-bd8b-6a95dbfb1b00.htm
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:5rEuf.56416$DQ4.1492398@.weber.videotron.net...
> Hi,
> How would I create a table programmatically in a database. I am using C#
> 2005 Express edition.
> For example I want to create a table named tblHours in a database
> dbEmployees with the columns hours worked (integer), hourly pay
> (currency),
> etc...
>
> TIA
> Roy
>
>

Create table

Hi,
How would I create a table programmatically in a database. I am using C#
2005 Express edition.
For example I want to create a table named tblHours in a database
dbEmployees with the columns hours worked (integer), hourly pay (currency),
etc...
TIA
RoyHow about looking up "create table" in BOL?
ms-help://MS.SQLCC.v9/MS.SQLMobile.v3.en/SSMProg3/html/143cad25-5c1d-4c96-bd
8b-6a95dbfb1b00.htm
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:5rEuf.56416$DQ4.1492398@.weber.videotron.net...
> Hi,
> How would I create a table programmatically in a database. I am using C#
> 2005 Express edition.
> For example I want to create a table named tblHours in a database
> dbEmployees with the columns hours worked (integer), hourly pay
> (currency),
> etc...
>
> TIA
> Roy
>
>

Monday, March 19, 2012

Create reports with SQL Express

Is it possible to create reports with Sql Express edition i.e. like you can with SQL full edition? If not are there any other add on free tools that allow you to do this?

Thanks

See this link here for the SQL Server toolkit:

http://msdn2.microsoft.com/en-us/library/ms365166.aspx

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Create project/stored procedure for SQLCRL

I installed SQLServer 2005 Standard Edition and tried to created a
stored procedure in VB. From START/PROGRAMS/MICROSOFT VISUAL STUDIO
2005, I created a blank solution. What type of project shall I create
for creating a stored procedure in VB ?

I tried to install SQL Server again in case I left back some parts, but
I got a message that all parts were installed.On 7 Jun 2006 00:37:56 -0700, Chris wrote:

>I installed SQLServer 2005 Standard Edition and tried to created a
>stored procedure in VB. From START/PROGRAMS/MICROSOFT VISUAL STUDIO
>2005, I created a blank solution. What type of project shall I create
>for creating a stored procedure in VB ?
>I tried to install SQL Server again in case I left back some parts, but
>I got a message that all parts were installed.

Hi Chris,

Create a "database" project, using the "SQL Server Project" template.
After that, you can choose the "Project" / "Add Stored Procedure" menu
choice to add a CLR stored procedure to your project.

--
Hugo Kornelis, SQL Server MVP|||Thanks a lot, Hugo.

Thursday, March 8, 2012

create new user on MS SQL 2005 Professional edition problem

Hi Everyone,

Can you please kindly tell me how to create a new user on the MS SQL 2005 Professional edition for accessing the existing database called VCalendar?

thanks for your time and help!

Jiimmy

1. Create a login: Open Management Studio->MySQLInstance->Security->Logins->New Login, type the name for the new login, and select a default database for the new login.

2. In the 'User Mapping' panel, check the 'Map' checkbox for the databases (VCalendar) that you want the login to access. Make sure the new login has user mapping to its default database.

3. Click 'OK' to save the new login. You can press F1 for help in the process.

|||

Iori_Jay:
1. Create a login: Open Management Studio->MySQLInstance->Security->Logins->New Login, type the name for the new login, and select a default database for the new login.
2. In the 'User Mapping' panel, check the 'Map' checkbox for the databases (VCalendar) that you want the login to access. Make sure the new login has user mapping to its default database.
3. Click 'OK' to save the new login. You can press F1 for help in the process.

Thank you very much for you help! I will try it tonight.

Jimmy

|||

Iori_Jay:
1. Create a login: Open Management Studio->MySQLInstance->Security->Logins->New Login, type the name for the new login, and select a default database for the new login.
2. In the 'User Mapping' panel, check the 'Map' checkbox for the databases (VCalendar) that you want the login to access. Make sure the new login has user mapping to its default database.
3. Click 'OK' to save the new login. You can press F1 for help in the process.

No it does not work. I am using MS SQL Server 2005 Professional edition. Thanks,

Jimmy

|||

Go to the new security section inside VCalendar database and create the User but that just creates the database login, then go to the Management section of Management Studio and then create the server login for the User. The reason is there are two permissions in SQL Server database permissions in the new security section within the database and the Server permissions in the Security section in the management section of Management Studio. Another option is to use System Stored Procssp_adduser and sp_addlogin, try the links below for details. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms181422.aspx

http://msdn2.microsoft.com/en-us/library/ms173768.aspx

|||

Caddre:
Go to the new security section inside VCalendar database and create the User but that just creates the database login, then go to the Management section of Management Studio and then create the server login for the User. The reason is there are two permissions in SQL Server database permissions in the new security section within the database and the Server permissions in the Security section in the management section of Management Studio. Another option is to use System Stored Procssp_adduser and sp_addlogin, try the links below for details. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms181422.aspx

http://msdn2.microsoft.com/en-us/library/ms173768.aspx

First, thanks for your time and help! I try two ways and both of the ways don't work.

1st way I try:

Right click on Security of VCalendar -> select New -> select User (Database User - New window open) Now I enter jimmy_user into the User name: box and I enter jimmy_login into the Login name: box. And I got an error message such as: "Create failed for User 'jimmy_user'. .... 'jimmy_login' is not a valid login or you do not have permission."

2nd way I try:

expand SBTOR101EV\SQLEXPRESS -> expand Security -> Right click on Logins -> Choose New Login (Login - New window open) Now enter jimmy_login into the Login name: box -> And then select Windows authenticaion -> click on OK. And I got an error message such as:

"Create failed for Login 'jimmy_login'. .... 'jimmy_login is not a valid Windows NT name. Give the complete name:
<domain\username>."

Please just let me know if you find a way to solve me problem. Thanks again!

I am not 100% understand the following two links so that I didn't try it.

http://msdn2.microsoft.com/en-us/library/ms181422.aspx

http://msdn2.microsoft.com/en-us/library/ms173768.aspx

Jimmy

|||

MayLam:
2nd way I try:
expand SBTOR101EV\SQLEXPRESS -> expand Security -> Right click on Logins -> Choose New Login (Login - New window open) Now enter jimmy_login into the Login name: box -> And then select Windows authenticaion -> click on OK. And I got an error message such as:
"Create failed for Login 'jimmy_login'. .... 'jimmy_login is not a valid Windows NT name. Give the complete name:
<domain\username>."

Look at the error message, which indicates that you choose Window Authentiaction (should be something like domain\account) as the login type and that's why 'jimmy_login' is no valid. So please select SQL Server Authentication for the new login 'jimmy_login', and do remember to add necessary database mapping for the new login. For more information about Authentication Modes, you can take a look at this article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp

|||

I think the error means SQL Server wants the login created before the database permissions. So you can use the gui or modify the code in the links below for your server and database. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms189751.aspx

http://msdn2.microsoft.com/en-us/library/ms173463.aspx

|||

Iori_Jay:
MayLam:
2nd way I try:
expand SBTOR101EV\SQLEXPRESS -> expand Security -> Right click on Logins -> Choose New Login (Login - New window open) Now enter jimmy_login into the Login name: box -> And then select Windows authenticaion -> click on OK. And I got an error message such as:
"Create failed for Login 'jimmy_login'. .... 'jimmy_login is not a valid Windows NT name. Give the complete name:
<domain\username>."
Look at the error message, which indicates that you choose Window Authentiaction (should be something like domain\account) as the login type and that's why 'jimmy_login' is no valid. So please select SQL Server Authentication for the new login 'jimmy_login', and do remember to add necessary database mapping for the new login. For more information about Authentication Modes, you can take a look at this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp

No this way does now work. Thanks for letting me know.

Jimmy

|||

Caddre:
I think the error means SQL Server wants the login created before the database permissions. So you can use the gui or modify the code in the links below for your server and database. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms189751.aspx
http://msdn2.microsoft.com/en-us/library/ms173463.aspx

No this way does not work. Thanks for letting me know.

Jimmy

|||

How about I uninstall MS SQL Server 2005 and then re-install MS SQL Server 2005. And I hope that it will ask me to choose a username and choose a password during the installation. Will it ask me choosing a username and choosing a password during the installation?

Thanks,

Jimmy

|||

MayLam:
Iori_Jay:
MayLam:
2nd way I try:
expand SBTOR101EV\SQLEXPRESS -> expand Security -> Right click on Logins -> Choose New Login (Login - New window open) Now enter jimmy_login into the Login name: box -> And then select Windows authenticaion -> click on OK. And I got an error message such as:
"Create failed for Login 'jimmy_login'. .... 'jimmy_login is not a valid Windows NT name. Give the complete name:
<domain\username>."
Look at the error message, which indicates that you choose Window Authentiaction (should be something like domain\account) as the login type and that's why 'jimmy_login' is no valid. So please select SQL Server Authentication for the new login 'jimmy_login', and do remember to add necessary database mapping for the new login. For more information about Authentication Modes, you can take a look at this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp
No this way does now work. Thanks for letting me know.
Jimmy

Sorry I mean this way does not work. Thanks.

Jimmy

|||

Thanks,

Jimmy

|||

MayLam:
How about I uninstall MS SQL Server 2005 and then re-install MS SQL Server 2005. And I hope that it will ask me to choose a username and choose a password during the installation. Will it ask me choosing a username and choosing a password during the installation?
Thanks,
Jimmy

What is did is that

- uninstall the MS SQL Server 2005 Professional edition

- and then install the MS SQL Server 2005 Express edition.

And it works.

Thanks for all your time and all your help!

Jimmy

Create New SQL Server Mobile Edition Database

Hi, I follow the instruction to install SQL Server 2005 Mobile Edition, but when I try to change the Data Source to add a new connection, I don't find "Create New SQL Server Mobile Edition Database".
Does anyone know how to fix this?

Thanks Paolo GiorgioThe following steps should give you a brand new Sql Mobile database

- Go to the new connection dialog. Quickest way is to right click on Data Connections in the Server Explorer and choosing to add a connection

- Make sure you have the Sql Mobile provider selected. The full name is "Microsoft SQL Server Mobile Edition (.NET Framework Data Provider for SQL Server CE)"

- Now you should see a 'Create' button which will let you create a new Sql Mobile database|||

I just follow your step, but when i have to choose the Sql Mobile provider, "Microsoft SQL Server Mobile Edition" is not available, evenif i installed .Net compact framework for Sql Mobile.

|||Do you see Sql Mobile in your Add/Remove programs list?|||Which Program List?|||In your Control Panel->Add or Remove programs, do you see an entry which says "Microsoft Sql Server 2005 Mobile [ENU] Developer Tools"?|||No i don't find in the List.
I find only "Microsoft Sql Server 2005 Mobile [ENU] Beta 3".|||I try to find "Microsoft Sql Server 2005 Mobile [ENU] Developer Tools" by Google but i don't find anything|||

In the early beta days of "Microsoft SQL Server 2005 Mobile [ENU] Developer Tools" was registered as "Microsoft SQL Server 2005 Mobile [ENU] Beta 3".

If you have uninstalled and reinstalled .NET Fx after VS Installation, this problem would arise. Can you please search for Data Providers in .NET Framework config file.

%SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.xxxxx\config\machine.config

Open this file in NOTEPAD, and search for "SQL Server CE Data Provider". If it is not there then, you may try adding the following line AS IT IS in Data Providers section.

You may need to restart the VS or even the PC to make VS detect this new setting.

Let us know if this has worked for you!

Thanks,
Laxmi NRO, SQL Mobile

|||

Thank you, but it still not working.
We follow your instruction, reboot the PC, but the Dataprovider still not in the list of the Data Sources.

Any other solution?
Thanks,
Paolo Giorgio

|||DEVTOOLS ==> Microsoft SQL Server 2005 Mobile [ENU] Beta 3 or Microsoft SQL Server 2005 Mobile [ENU] Developer Tools

Uninstall & Reinstall DEVTOOLS using the MSI sqlmobile30devtoolsenu.msi in wcu\SQLCE sub directory of your Whidbey Installation Disc.

Goto ADD/REMOVE programs to uninstall DEVTOOLS.

Thanks,
Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation