How to get the current version?

I just want to confirm if SP2 has been installed successfullly on my SQL Server Express, but I don't know where to check?

Any help would be appreciated...

Try:

SELECT SERVERPROPERTY( ProductLevel )

|||

You can also use this:

select @.@.version

sql

How to get started?

This is a repost of my post on the VB Express board.

I would like your opinions.

I am a network guy. I learned basic years ago. I can do some html edits as needed to change sites.

Today I would like to start the long process of learning VB with .net applications. I thought I could start with Office developer xp to learn VB. I have that package.

I also would like to be able to build SQL quaries and integrations or automate and manipulate data exports and imports later down the road.

Example: Export various order and customer information from a shopping cart and import it in to Quickbooks or MS Accounting.

First off I need to be able to build web sites and I know I want to grow into VB and SQL.

What should I do?

Learn HTML from web monkey?

Start with Office xp developer Tutorials?

Start with VB Express?

Buy a book?

Can someone tell me where to start and when to move to the next language?

What is the best resource to get to it, without the bla bla bla and a commnd/syntax refference?

How do I mix Html, CSS and .Net (VB)...in the learning process?

I would like to get the fast track for the long haul.

Thanks so much.

There are a lot of different ways to get started. Think about how you like to learn. Do you like the class environment, informal or structured, do you just like to play with new technology, do you like to read and then apply what you learn.
Here are some suggestions:
* Before you go and buy a bunch of books, go to your local library and see what interests you. Looks for books that give a lot of examples
*Come up with a simple application that you would like to create. Then find examples on how folks have done it already
*Search the internet for examples and samples
* focus on one technology first and then expand
* Purse MCP certification: http://www.microsoft.com/learning/mcpexams/default.mspx
* Download the free editions of products; such as SQL Server Express: http://msdn.microsoft.com/vstudio/express/sql/
There are a lot or resources out there. Check out: http://www.microsoft.com/learning/books/default.mspx. The step-by-step series are great when you are just getting started.
The learning never stops & there is no quick simple solution.
Hope this helps,
Peter Saddow

How to get started on Microsoft SQL Server Management Studio Express

Hi,

Was trying to open AdventureWorks when i got this error: "There is no editor available "C: Program Flies.....\AdventureWorksDW_Log.LDF'
Make sure the application for the file type(.LDF) is installed.
How can this error be corrected? I also have some error on mdf not installed.May i know how should be the initally steps to be done inorder for me to view this database.
And if i do have a database from microsoft access, what are the steps that i need to do inorder to get it export to Microsoft SQL Server Management Studio Express. Please advise as i really new to it. Thanks!

Hi,

if you want to let the database be controlled by the instance you will have to do a right click on the database node > Attach Database > Select the Database files. The instance will be automatically attached and you will be able to access the database through the server Explorer.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi,

Thanks for the info.Btw, how do we attach access database which is mdb format?
The form design that i have in access database...can this be viewable in microsoft sql server management studio express. Please advise.

|||

Hi,

I have managed to attached the AdventureWorks data. But it seem like there are some restrictions. Must we set any rights to user so that we can view the AdventureWorks data? Please advise. Thanks.

|||

hi,

kumalla wrote:

Thanks for the info.Btw, how do we attach access database which is mdb format?
The form design that i have in access database...can this be viewable in microsoft sql server management studio express. Please advise.

you can not attach an Access database to a SQL Server instance... you have to use the Upsize Wizard or similar tool to import the JET db into a new SQL Server database..

regards

|||

hi,

kumalla wrote:

Hi,

I have managed to attached the AdventureWorks data. But it seem like there are some restrictions. Must we set any rights to user so that we can view the AdventureWorks data? Please advise. Thanks.

start reading BOL at http://msdn2.microsoft.com/en-us/library/ms187648.aspx .. you can there find the whole security architecture to understand permissions and requirements to connect to SQL Server instances, databases and individual objects and their data..

regards

How to get started

Hi -
I need to start from the beginning with SQL Server 7 2005 Express. I want to get financial data and perform analysis in conjunction with Excel. I have downloaded the file from Microsoft and would like a resource for getting going. What is the best way to go?

Your help appreciated.

Doug

Loads of information on the microsoft sites:

http://msdn2.microsoft.com/en-gb/express/aa718391.aspx

http://msdn2.microsoft.com/en-gb/sql/Aa336346.aspx

http://blogs.msdn.com/sqlexpress/

Books Online is a great resource:

http://www.microsoft.com/downloads/details.aspx?FamilyID=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

HTH!

How to get SQL Express working remotely?

Hello all,

I am having trouble getting SQL Express 2005 on Windows Server 2003

working remotely. I have set it up for TCP connections and all,

and I can connect to the server fine, but I am unable to login. How do

I go about creating accounts for the db that will allow me to access it

remotely?

Mike's blog has a great explanation of what needs to be done to enable remote connections. Here's the link:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Thanks,
Sam Lester (MSFT)

How to get Row Numbers from SQL Express 2005 query?

Hi,

I'm using SQL Express 2005 and VIsual Studio 2005, and this sounds like it should be easy. I'm trying to return the row numbers of my queries, but if I use the Row_Number() command I get the following error:

"The OVER SQL construct or statement is not supported."

So, is Row_Number() not supported in SQL Express 2005? If not, how can I return row numbers with my queries? Or, more specifically, how can I return a limited result set from a query (i.e. Return only row number 10-20)?

My current command is as follows:

SELECT (SELECT Row_Number()OVER (ORDER BY UserName)As RowNumber), *
FROM Users
ORDER BY UserName

Thanks for any advice you can offer!

like this

With Cust AS
( SELECT CustomerID, CompanyName,
ROW_NUMBER() OVER (order by CompanyName) as RowNumber
FROM Customers )
select *
from Cust
Where RowNumber Between 20 and 30

Hope this helps

|||

SELECT ROW_NUMBER() OVER (ORDER BY ProductID) as RowNumber,ProductID, ProductName, UnitPrice FROM Products WHERE RowNumber BETWEEN 20 AND 30;

|||

Thank you both for your replies. I'm sorry, I think I my question may have been a bit misleading. I know that you can return a limited result set by using the statements you have provided, but the error message I am getting is as follows:

"The OVER SQL construct or statement is not supported."

Both your suggestions use the OVER construct, and this does not appear to be supported bySQL Server Express 2005. If I run your suggested queries inVisual Studio 2005 I get the aforementioned error and the query will not run (though the SQL validation check says it's fine).

So, is the "Row_Number() OVER" command supported by SQL Express 2005 or not? If not, what other ways can I return a limited result set?

|||

i think you are using the designer, go in the sql server management studio and to this

Select File / New / Query and type your queries in the editing window instead.

Hope this helps

|||

Run this in SQL SERVER 2005 Management Studio Express:

EXEC sp_dbcmptlevel yourDataBase

If the current compatibility level of your database is 80, then run this:

EXEC sp_dbcmptlevel yourDataBase, 90

You need the compatibility level at 90 to run the Row_Number() OVER() query and other new features.

|||

Hi Limno,

That sounds promising. I've tried getting my website database into SQL Server Management Studio Express in the past but without success. My database is held as a .MDF file within my project - is there a way of importing this directly into Management Studio? The "Connect To Server" dialog displayed on startup does not allow me to browse to a specific .MDF file, and the File -> Open dialog has no option to open .MDF files.

Thanks

|||

I just found out how to import an MDF here:

http://forums.asp.net/p/1147899/1871779.aspx#1871779

And my database shows a compatibility rating of 90. Using the Row_Number() command works within SQL Server Management Express Studio! In that case, how can I perform a query in Visual Studio 2005 that uses this command if Visual Studio does not support this command?

I'm using strongly typed Table Adapters and Data Tables using the DAL component in Visual Studio. Is it impossible? If not, can I at least perform this query programmatically (C#) and cast the results to my strongly typed Data Table? If it can be done programmatically, does anyone have any examples of how to do this?

Thanks again!

|||

In Visual Studio 2005, you will see that not support message. Have you tried to ingnore it and see what will happen? It seems is should work fine. Another way, you can wrap your query in a Stored Procedure to work with.

How to get INSERT-SQL for rows?

Hi

I'm using the SQL Server 2005 Express edition.
I've manually created some rows in a table "Books".

If I right-click on "dbo.Books" and choose "Script Table As --> Create To --> New Query Editor Window", I get the SQL for creating that table.

But how do I get the INSERT-SQL for the rows already inserted?

Kind Regards

hi,

there's no support for that task, you have to do it your self..

or you can have a look at a free prj of mine, amInsert, available at http://www.asql.biz/en/Download2005.aspx

regards

|||

Hi Andrea

Thanks for your ImInsert!
It worked perfectly!

Kind Regards

How To Get HTML Rendering

I am using a ReportViewer with SQL Server Express. The ReportViewer provides options for output as Excel or PDF but not HTML. According to what I have read, SQL Server Express supports HTML rendering. How do I get it to do that?Let me clarify my own post. I have HTML-formatted text in two columns in the database. I need to have those two columns format as HTML in their respective textboxes. I've done a lot of reading on this issue and no one seems to have a very good solution.