Creatng Charts Using scripts in sql server 2005 express

Hi all,

I want to Create charts for database table entries in sql server 2005 express edition, by using the scripts only not through wizards...

Plz help me for the above topic

Thanks & Regards,
Srinivaswhat scripts are you refering to? TSQL?|||Hi,
I just want to prepare the charts with out using wizards..., by using some stored proceduers we can get the data from database and then create the charts with some code( script).., that scripts r in visual studio or any thing ,

give me some idea about that one (or) give me some links related to this topic..

thanking you very much..

regards,
Srinivas|||

Hi,

I really did not understand what you are talking about, but perhaps you are referencing the ReportViewer controls..http://msdn2.microsoft.com/en-us/library/ms251671.aspx

regards

|||

T-SQL only returns data, you will need to use some other program to generate the charts from the data. You could use the Reporting controls in VS but I believe the report designer for VS is only available in VS Pro and as a download for VWD Express. (The other Express products don't have report design as a feature.) You can also consider Report Server, which is part of SQL Express Advanced. You will additionally need the SQL Express Toolkit to get the report design projects as part of BIDS.

Office also provides charting capabilities in both Excel and Access. Just retrieve the data and create your chart. In Office 2003 I found Access to have slightly better charting capabilities because of the use of the Office Web Components, but Excel has better analytical tools if you want to manipulate the data prior to creating your charts.

There are also a number of third-party tools and controls that you should be able to find by searching the web.

Regards,
Mike Wachal

Creating...Connecting... i'm missing something...

I'm creating a data storage program in VB 2005 Express. it works perfectly, and installs and everything, but it stores the database in an obscure data file in the user's local settings folder as an mdf file.

once that's created, i want to create an access front-end to view the data, but can't get it to work...

when i try to create linked tables, i establish the connection to sql server (2005 express) through the wizards, but the database i want to connect to isn't in the list of DBs, so i can't connect to it. There's an option to add a database, but it just asks for the name, and i don't know what to tell it, because the file i want is in the obscure data file, and i don't actually know what it's asking for. full path? just file name? no idea...

Here's all the other ways i can think of to add it to the list of DBs in my instance of SQL...

if i open Express Manager to edit the databases in the instance of SQL server, i can create new databases, but i can't seem to add existing databases to SQL Server's list of databases in the instance.

I can use the instance of SQL server to connect to the DB through VB 2005 express's database explorer, but once i close it down, the connection's gone.

when the program is packaged and installed, it automatically creates the link to the database, and it isn't added to SQL Server's list either.

what am i missing? how can i get my Access FE to connect properly to the mdf BE?

Can anyone help me?I think you have ended up using something called user instances, these are dynamically brought online at connect time, to connect to the database from Access it needs to be attached to SQL Server as a regular database.

Lookup sp_attach... in the help file. I also suggest moving the database to the data directorty for SQL Server

creating users in sql eypress

Hi,

wanted to add a login in via c# to sql server express.

Is this possible?

I treid this:

String connString = "data source=xtrlt027;Initial catalog=master;Integrated Security=true;";
SqlConnection conn= new SqlConnection();;
conn.ConnectionString = connString;

try
{
System.Console.WriteLine("Opening Connection...");
conn.Open();
System.Console.WriteLine("Connection opened!!!");
SqlCommand cmd = new SqlCommand("create login tommtk with Password='tomm2tomm'; use master; create user tommtk;", conn);
cmd.ExecuteNonQuery();
System.Console.WriteLine("Login created!!!");

}
catch (Exception deleteEx)
{
System.Console.WriteLine("SqlException Handle :{0}", deleteEx.ToString());
}
finally
{
conn.Close();
System.Console.WriteLine("Connection closed!!!");
}

But i get an exception, that there is an error near the keyword login and the keyword user.

So wahts wrong

can anybody help me?

Greetz
What is the exact error message ?

jens Suessmeyer.

http://www.sqlserver2005.de

|||Pretty sure each of you commands inside the cmd object need to be execute as separate statements/commands, not as one.|||Hi,

really looks like, that it is not possible to create logins in sql server express.
Downloaded sql studio management express and in an sql query it did not even recognized the key words.

The exception in my app was:

SQL syntax error near 'login'

So is it really not possible to create logins in sql express? i have the version that is included in visual Studio 2005 professional.

Greetz
|||It absolutely is possible can you please post the script you are trying to run in SSMS-E?|||

I assure you that it is possible to create Logins in SQL Express.

You need to separate certain commands for SQL to recognize them. All the CREATE commands fall into this category. You're code has them all run together as one big statement, which isn't going to work regardless of where you try to run them.

Here is some T-SQL that will accomplish what you're trying to do from the query window. You should be able to translate this to your code by simply running each statement separately. (e.g. Each thing between the GO keywords.)

USE master
GO

CREATE LOGIN tommtk
WITH PASSWORD = N'tomm2tomm'
GO

USE AdventureWorks
GO

-- For login tommtk, create a user in the database
CREATE USER tommtk
FOR LOGIN tommtk
WITH DEFAULT_SCHEMA = dbo
GO

-- Add user to the database owner role
EXEC sp_addrolemember N'db_owner', N'tommtk'
GO

I've actually changes the database context from master to AdventureWorks to create my user as I can't imagine why you were actually trying to create the User in master. If you really were tyring to create a user with permissions in master, just ignore the 'USE AdventureWorks' statement in your code. I've also added a call to give the User a specific database role, db_owner in this case, but that isn't required if you were not planning on assigning a specific role.

Regards,

Mike Wachal
SQL Express team

Mark the best posts as Answers!

|||Tried the following sql statement:

create login tommtk
with Password='tomm2tomm';
use master;
create user tommtk
|||Hi,

tried this statement in a developers edition:

create login tommtk with Password='tomm2tomm'; use master; create user tommtk

it worked fine, but not in the express edition. Or what edition ist it, included in VisualStudio 2005.

In the query window it does not even recognize the keyword login.

And in permission-properties i can not switch to mix of windows auth and sql server auth.
It is inactive

Greetz
|||Are you currently running windows Auth only?

Creating Sql Server 2005 Express Databases via VS2005 Std.

Hello all,

I use Visual Studio 2005 Standard. I would like to know the best way that I can create Sql Server 2005 Express databases visually since VS2005 Std. does not allow me to do it.

Any help is appreciated and thanks in advance,

I'd be interested in knowing how VS doesn't allow you to create a database. What error are you getting?

There are two ways to create databases, depending on your goal:

To just create a database on your server, do the following:

Creating Sql Server 2005 Express Databases via VS2005 Std.

Hello all,

I use Visual Studio 2005 Standard. I would like to know the best way that I can create Sql Server 2005 Express databases visually since VS2005 Std. does not allow me to do it.

Any help is appreciated and thanks in advance,

I'd be interested in knowing how VS doesn't allow you to create a database. What error are you getting?

There are two ways to create databases, depending on your goal:

To just create a database on your server, do the following:

Creating Report using Visual Web Developer 2005 Express with SQL 2005 Reporting Services A

Hi

I am wanting to learn how to create a Report using SQL 2005 Reporting Services, I use Visual Web Developer 2005 Express and have installed the Reporting Services Add-In for Visual Web Developer 2005 Express.

Does anyone here know of any good step-by-step tutorials on how to get started creating the reports. As I want something to go through how to create the datasource right through to creating / formating the report ready for use.

Matthew

This links might help you:

http://technoblab.blogspot.com
http://www.databasejournal.com
http://www.codeproject.com/aspnet/ReportViewer.asp

Creating relationships in asp.net enterprise manager

Hello

I am using a web hosting company for my web site, unfortunately after developing the site with server express the company told me they do not support this. As the database only holds three tables and only contained test data, this was not too much of a problem and I thought I would rebuild the databse on the development tool (ASP.net enterprise manager). I have managed to create the tables and populate them with the required data. My only problem is the user interface of the enterprise manager is not the friendliest and I am not too sure how to create the relationships between the tables. The interface only seems to have facilities for creating tables, views, stored procedures, users and roles.

Any tips on how I can create relationships between the tables.

Graeme

In SQL Enterprise Manager right-click on a table, and select Design. A design window will open from the table. What you want is on the SQL Enterprise main window (parent window) - the 3 icons on the right: Manage Constraints, Manage Indexes, and Manage Relationships. clicking on anyone of them opens the same dialog, which lets you manage any of the three.

Good luck.

|||

Hi Alex

I think the interface the webhosting company allows me to use is not the actual program as it does not allow right clicking; all the images and tables etc seem to be hyperlinks. I am trying to get around this by hardcoding the tables in SQL and then running the queries.

|||

Hi,

From your description, it seems that you can't use some functions of enterprise manager in the website based enterprise manager they provided, right?

Right, actually, the website based enterprise manager is a web application which runs the underlying SQL command for your specific operations. (such as create,drop tables, insert records and etc..) And the function you can use is totally based on your hosters, since it's not a real Enterprise Manager of SQLServer. So as you mentioned, if the interface only seems to have facilities for creating tables, views, stored procedures, users and roles, but not for creating relations, you have to handle it in another way.

Based on my understanding, lot's of hosters are support remote connections. So you may connect to the database instance on your hoster's server by IP address and userid, passwords. And then export the data on your local instance to the remote instance, or you can just create your tables on remote instance directly and handle the relation by the real Enterprise Manger tool.

Thanks.

Creating RDL Files - Software Requirements

I have a copy of SQL Server Express running, but am not sure how to create
reports. Does this require a full/regular copy of Visual Studio or is there
an 'express' (read:free) solution to create reports.
Thanks,
MatthewThere is another version called SQL Server 2005 Express Edition with
Advanced Services SP1 which comes with everything you need to develop
reports. Note that the data for your reports need to be local (in your SQL
Server Express database is what I believe that means).
Download here: http://msdn.microsoft.com/vstudio/express/sql/download/
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"matthew gibson" <matthewgibson@.discussions.microsoft.com> wrote in message
news:9D74D31A-EFB3-492F-8D23-C2D9B51CEADD@.microsoft.com...
>I have a copy of SQL Server Express running, but am not sure how to create
> reports. Does this require a full/regular copy of Visual Studio or is
> there
> an 'express' (read:free) solution to create reports.
> Thanks,
> Matthew|||yes, I think. I have that. Here is a select @.@.version to clarify...
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition with Advanced Services on Windows NT 5.2 (Build 3790:
Service Pack 1)
I have seen references to Business Intelligence Designer. I have the
virtual directory for reports. I can go out to it and there is an option to
upload RDL files; however, I am not sure what tool is necessary to create RDL
files. I know Visual Studio (for pay ones) can do it, but I don't know if
there is a free version. I don't see anything in the SQL MGMT tool or in the
Start Menu which allow me to create reports. I do see the Report SErver
configuration tool... and it shows it to be setup correctly.
Thanks!
Matthew
"Bruce L-C [MVP]" wrote:
> There is another version called SQL Server 2005 Express Edition with
> Advanced Services SP1 which comes with everything you need to develop
> reports. Note that the data for your reports need to be local (in your SQL
> Server Express database is what I believe that means).
> Download here: http://msdn.microsoft.com/vstudio/express/sql/download/
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "matthew gibson" <matthewgibson@.discussions.microsoft.com> wrote in message
> news:9D74D31A-EFB3-492F-8D23-C2D9B51CEADD@.microsoft.com...
> >I have a copy of SQL Server Express running, but am not sure how to create
> > reports. Does this require a full/regular copy of Visual Studio or is
> > there
> > an 'express' (read:free) solution to create reports.
> > Thanks,
> > Matthew
>
>|||I don't know about the setup but it shouldn't be any difference. You need to
install the Business Intelligence tools. It will install a version of VS to
host the report designer. Run setup and see about a choice to install. Once
installed you should be have something in your program files called SQL
Server Business Intelligence Development Studio.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"matthew gibson" <matthewgibson@.discussions.microsoft.com> wrote in message
news:81305E18-ABEF-449E-AA63-76CEF9583387@.microsoft.com...
> yes, I think. I have that. Here is a select @.@.version to clarify...
> Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
> Apr 14 2006 01:12:25
> Copyright (c) 1988-2005 Microsoft Corporation
> Express Edition with Advanced Services on Windows NT 5.2 (Build 3790:
> Service Pack 1)
> I have seen references to Business Intelligence Designer. I have the
> virtual directory for reports. I can go out to it and there is an option
> to
> upload RDL files; however, I am not sure what tool is necessary to create
> RDL
> files. I know Visual Studio (for pay ones) can do it, but I don't know if
> there is a free version. I don't see anything in the SQL MGMT tool or in
> the
> Start Menu which allow me to create reports. I do see the Report SErver
> configuration tool... and it shows it to be setup correctly.
> Thanks!
> Matthew
>
> "Bruce L-C [MVP]" wrote:
>> There is another version called SQL Server 2005 Express Edition with
>> Advanced Services SP1 which comes with everything you need to develop
>> reports. Note that the data for your reports need to be local (in your
>> SQL
>> Server Express database is what I believe that means).
>> Download here: http://msdn.microsoft.com/vstudio/express/sql/download/
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "matthew gibson" <matthewgibson@.discussions.microsoft.com> wrote in
>> message
>> news:9D74D31A-EFB3-492F-8D23-C2D9B51CEADD@.microsoft.com...
>> >I have a copy of SQL Server Express running, but am not sure how to
>> >create
>> > reports. Does this require a full/regular copy of Visual Studio or is
>> > there
>> > an 'express' (read:free) solution to create reports.
>> > Thanks,
>> > Matthew
>>

Creating over 100-databases.

Hi,

I'm using SQL Server 2005 Express for an application.

SQL Server 2005 Express supports 4GB user data per database. Because need over 4GB(may be 20GB ~ 30GB) data space, I should split database which each max size up to 200 MB. And create 100 databases.

Is it reasonable? If true, what about the performance or system's overhead?

Thank you.

No, that is not feasible for what you list for a variety of reasons. If you need 20-30GB, you need (and SHOULD) purchase SQL Server full version. What about the workgroup edition to save some money?

Creating new instances of SQL Server 2005 Express

Greetings,
I am trying to create new instances of sqlserver express (while the
default SQLEXPRESS is still there). How can i do that?
I'm trying to set up a development and production instance in one
machine. is this a right way to do it?
please advice.
am i doing the right thing? do people really do this? as in separating
development and production with the sql server instance?
On May 23, 3:49 pm, "vt" <vinu.t.1...@.gmail.com> wrote:[vbcol=seagreen]
> cerebellum,
> Run the SQLEXPRESS installation again, during the installation time setup
> will ask for an instance name., give the new instance name there
> regards
> VT
> Knowledge is power, share it...http://oneplace4sql.blogspot.com/
> "cerebellum" <wilsone...@.gmail.com> wrote in message
> news:1179906209.618347.241560@.p77g2000hsh.googlegr oups.com...
>
|||Hi
Actually , it will be better if you would have a separated server for
developing. Make sure that you have enough memory on the server as each
instance will consume memory and it may hurt performance
"cerebellum" <wilsoneden@.gmail.com> wrote in message
news:1179988261.600407.241950@.a26g2000pre.googlegr oups.com...
> am i doing the right thing? do people really do this? as in separating
> development and production with the sql server instance?
> On May 23, 3:49 pm, "vt" <vinu.t.1...@.gmail.com> wrote:
>

Creating new instances of SQL Server 2005 Express

Greetings,
I am trying to create new instances of sqlserver express (while the
default SQLEXPRESS is still there). How can i do that?
I'm trying to set up a development and production instance in one
machine. is this a right way to do it?
please advice.cerebellum,
Run the SQLEXPRESS installation again, during the installation time setup
will ask for an instance name., give the new instance name there
regards
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"cerebellum" <wilsoneden@.gmail.com> wrote in message
news:1179906209.618347.241560@.p77g2000hsh.googlegroups.com...
> Greetings,
> I am trying to create new instances of sqlserver express (while the
> default SQLEXPRESS is still there). How can i do that?
> I'm trying to set up a development and production instance in one
> machine. is this a right way to do it?
> please advice.
>|||am i doing the right thing? do people really do this? as in separating
development and production with the sql server instance?
On May 23, 3:49 pm, "vt" <vinu.t.1...@.gmail.com> wrote:
> cerebellum,
> Run the SQLEXPRESS installation again, during the installation time setup
> will ask for an instance name., give the new instance name there
> regards
> VT
> Knowledge is power, share it...http://oneplace4sql.blogspot.com/
> "cerebellum" <wilsone...@.gmail.com> wrote in message
> news:1179906209.618347.241560@.p77g2000hsh.googlegroups.com...
> > Greetings,
> > I am trying to create new instances of sqlserver express (while the
> > default SQLEXPRESS is still there). How can i do that?
> > I'm trying to set up a development and production instance in one
> > machine. is this a right way to do it?
> > please advice.|||Hi
Actually , it will be better if you would have a separated server for
developing. Make sure that you have enough memory on the server as each
instance will consume memory and it may hurt performance
"cerebellum" <wilsoneden@.gmail.com> wrote in message
news:1179988261.600407.241950@.a26g2000pre.googlegroups.com...
> am i doing the right thing? do people really do this? as in separating
> development and production with the sql server instance?
> On May 23, 3:49 pm, "vt" <vinu.t.1...@.gmail.com> wrote:
>> cerebellum,
>> Run the SQLEXPRESS installation again, during the installation time setup
>> will ask for an instance name., give the new instance name there
>> regards
>> VT
>> Knowledge is power, share it...http://oneplace4sql.blogspot.com/
>> "cerebellum" <wilsone...@.gmail.com> wrote in message
>> news:1179906209.618347.241560@.p77g2000hsh.googlegroups.com...
>> > Greetings,
>> > I am trying to create new instances of sqlserver express (while the
>> > default SQLEXPRESS is still there). How can i do that?
>> > I'm trying to set up a development and production instance in one
>> > machine. is this a right way to do it?
>> > please advice.
>

Creating new instances of SQL Server 2005 Express

Greetings,
I am trying to create new instances of sqlserver express (while the
default SQLEXPRESS is still there). How can i do that?
I'm trying to set up a development and production instance in one
machine. is this a right way to do it?
please advice.cerebellum,
Run the SQLEXPRESS installation again, during the installation time setup
will ask for an instance name., give the new instance name there
regards
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"cerebellum" <wilsoneden@.gmail.com> wrote in message
news:1179906209.618347.241560@.p77g2000hsh.googlegroups.com...
> Greetings,
> I am trying to create new instances of sqlserver express (while the
> default SQLEXPRESS is still there). How can i do that?
> I'm trying to set up a development and production instance in one
> machine. is this a right way to do it?
> please advice.
>|||am i doing the right thing? do people really do this? as in separating
development and production with the sql server instance?
On May 23, 3:49 pm, "vt" <vinu.t.1...@.gmail.com> wrote:[vbcol=seagreen]
> cerebellum,
> Run the SQLEXPRESS installation again, during the installation time setup
> will ask for an instance name., give the new instance name there
> regards
> VT
> Knowledge is power, share it...http://oneplace4sql.blogspot.com/
> "cerebellum" <wilsone...@.gmail.com> wrote in message
> news:1179906209.618347.241560@.p77g2000hsh.googlegroups.com...
>
>
>|||Hi
Actually , it will be better if you would have a separated server for
developing. Make sure that you have enough memory on the server as each
instance will consume memory and it may hurt performance
"cerebellum" <wilsoneden@.gmail.com> wrote in message
news:1179988261.600407.241950@.a26g2000pre.googlegroups.com...
> am i doing the right thing? do people really do this? as in separating
> development and production with the sql server instance?
> On May 23, 3:49 pm, "vt" <vinu.t.1...@.gmail.com> wrote:
>

Creating Nested Tables inside of a Existing SQL Server Express Table

Hello,

Quick question, I hope, I am trying to create a table that has a column that is a nested table in SQL Server 2005 Express Edition. Any ideas how I could go about doing this?

Sincerely,

James Simpson

Straightway Technologies Inc.

The only way to "create a table that has a column that is a nested table", is to use an xml datatype.

Refer to Books Online, Topic: XML [SQL Server]

|||

As Arnie indicates, SQL Server doesn't support TABLE as a data type within a table. There is probably another way to accomlish what you're trying to do without going to XML, but it's hard to say without know what your goal is. In general, I'd suggest that you create a new table for your "nested" information and then use a 1:Many relationship between the two tables to map the nested info to the parent record.

Mike

creating master key sql 2005

Hi,
I've trying to create a master key in sql server express edition 2005. I'm
using the follow code:
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '2005Password'
when i run this, the XM send me the follow message error:
Incorrect syntax near 'master'
Where is my mistake?
Att,
Leandro CarvalhoSupport is found here:
http://communities.microsoft.com/ne...lcid=us

--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Leandro Carvalho" <LeandroCarvalho@.discussions.microsoft.com> wrote in
message news:C4EA5452-D474-4D94-9576-7DF0DE6020C8@.microsoft.com...
> Hi,
> I've trying to create a master key in sql server express edition 2005. I'm
> using the follow code:
> CREATE MASTER KEY ENCRYPTION BY PASSWORD = '2005Password'
> when i run this, the XM send me the follow message error:
> Incorrect syntax near 'master'
> Where is my mistake?
> Att,
> Leandro Carvalho
>

Creating indexes on tables from the Database Explorer

I would like to create an index on a table from the Database Explorer.

I am using Microsoft Visual C# 2005 Express Edition.

I downloaded Microsoft SQL Server Management Studio Express with the intention of using it to create an index, but it does not seem to find the database that I created from the Database Explorer.

Thanks!

Are you sure you're looking at the right server and connection? Can you post a screenshot of the two environments?

Creating indexes on tables from the Database Explorer

I would like to create an index on a table from the Database Explorer.

I am using Microsoft Visual C# 2005 Express Edition.

I downloaded Microsoft SQL Server Management Studio Express with the intention of using it to create an index, but it does not seem to find the database that I created from the Database Explorer.

Thanks!

Are you sure you're looking at the right server and connection? Can you post a screenshot of the two environments?

Creating functions

Well, I just downloaded SQL 2005 Express to have a play. Good old Bill
says "up and running in 20 minutes"

Well 5 hrs, 5 reboots and 4 full un-install and re-install later I have
finally got it working. About what I expected really.

Anyway, my question relates to creating user defined functions. I've 10
yrs exp in MS Access and VB, and user ent Manager to create views on
the work server, but havnt done much with functions.

I'm using the Management Studio Express.

I've opened a new view and copied the following sample code but it wont
let me save it.

--------
IF OBJECT_ID(N'dbo.GetWeekDay', N'FN') IS NOT NULL
DROP FUNCTION dbo.GetWeekDay;
GO
CREATE FUNCTION dbo.GetWeekDay -- function name
(@.Date datetime) -- input parameter name and data
type
RETURNS int -- return parameter data type
AS
BEGIN -- begin body definition
RETURN DATEPART (weekday, @.Date) -- action performed
END;
GO
-------------

When I try to save it it says
"incorrect syntax near the key work 'IF'
incorrect syntax near 'GO'
CREATE FUNCTION must be the first statement in a query batch
must declair the scalar variable "@.Date"

Whats wrong with the syntax?

Thanks in advance

GrantHi frnd
there is no need for ' ; ' inside sql its on c++...
remove ' ; ' and try it might work...|||ok I'm confused about functiosn. In the past I have used MS Access ADP
to create function in SQL Server and they have shown up as a separate
object under views. But now I have executed a Create Function and it
says its execute ok, and I can run a select statement and call the
function and return valurs, so its obvoiusly there (somewhere), but its
nto showing up under views, so where to i view and edit functions??

Thanks

Grant|||Functions are under Functions (not Views).

g...@.technologyworks.co.nz wrote:

Quote:

Originally Posted by

ok I'm confused about functiosn. In the past I have used MS Access ADP
to create function in SQL Server and they have shown up as a separate
object under views. But now I have executed a Create Function and it
says its execute ok, and I can run a select statement and call the
function and return valurs, so its obvoiusly there (somewhere), but its
nto showing up under views, so where to i view and edit functions??
>
Thanks
>
Grant

|||(grant@.technologyworks.co.nz) writes:

Quote:

Originally Posted by

ok I'm confused about functiosn. In the past I have used MS Access ADP
to create function in SQL Server and they have shown up as a separate
object under views. But now I have executed a Create Function and it
says its execute ok, and I can run a select statement and call the
function and return valurs, so its obvoiusly there (somewhere), but its
nto showing up under views, so where to i view and edit functions??

There is a Functions node under Programmability.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Creating Database

How do you create a SQL database (Sql Express 2005) in real time using VB.Net 2005 ASP.net 2.0?Answer Found! For those who want can visithttp://www.vb-tips.com/default.aspx?ID=73eab21d-db5f-46b2-8eea-6680e677e994 to view sample code|||

A good sample can be downloaded here:

http://download.microsoft.com/download/C/3/8/C3888A3E-52F8-4FE9-8E41-89150AB0302F/CreateDB.zip.exe