Database

14-Feb-06 1:49

Hi all!!

With SQL Server 2000, there was a cool tool called Enterprise Manager where you could create databases, check tables, etc.

Where do I do this in SQL Server 2005.

Thanks
ma se

Slow Learner14-Feb-06 2:26

Slow Learner

14-Feb-06 2:26

Hello Ma se,
There is a tool called Management Studio in Sql server 2005. Its the tool that every developer would use most. I mean its like a combo of Enterprise manager and Query analyzer.

Going forward with your learning. Shall i know what you are trying to do? I mean did you try getting VWD(Visula Web Developer)? If you tried getting VWD then the SQL Express(which is desktop engine kind of version of Sql server 2005) would also get installed as part of the VWD installation. Once you are done installing VWD you will only Configuration tools of Sql server 2005. You still won't get Mnagement Studio. To get the management studio express edition you have got to get it off the web seperately.

Here is the link

http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en

and scroll the page to the bottom and you should see the

SQLServer2005_SSMSEE.msi

at the bottom of the page. This installs Management Studio. You also can get AdventureWorks and the rest of the databses. Hope this helps you understand how to get going with it. Please let me know if you need any further assistance on this.
Thanks
Learner

Brendan Vogt14-Feb-06 19:26

14-Feb-06 19:26

Hey..

Thanks for the reply. I've never seen any one more friendlier with help than you.

This is what I do. I'm a web developer, still new to .NET 2.0 and SQL Server 2000. I usually used classic ASP and a bit of .NET 1.1 with SQL Server 2000. So I need to find my way around SQL Server 2005.

I have VWD, and I do have SQL Server Express. I'm redoing one of our websites in .NET 2.0 with C#, and at some stage I will need to upload the database to the hosting server. I know that SQL Server 2005 and the Express edition uses the same engine, but is it possible to transfer your database created in the Express edition to the 2005 edition?

I will download that Management Studio that you suggested. I have also installed SQL Server 2005 the trial version. So you would say the Express Edition is enough?

I appreciate your reply to the previous email. O yes, one last thing. I want to learn as much as possible about SQL Server 2005, so if you have any useful articles, please send the links to brcvogt@yahoo.com.

Thanks again,
ma se

Paul Conrad14-Feb-06 19:35

Paul Conrad

14-Feb-06 19:35

ma se wrote:
is it possible to transfer your database created in the Express edition to the 2005 edition?

It should be okay. I know that MSDE (like SQL 2005 Express which comes with Office 2000) databases can transfer to the full-fledged SQL 2000.

ma se wrote:
I want to learn as much as possible about SQL Server 2005, so if you have any useful articles, please send the links to brcvogt@yahoo.com.

Codeproject has many good articles on SQL and a wonderful developer community to ask questions at. Also remember that you have a friend in google Smile | :)

Microsoft's site has many helpful resources, too.

Paul

Brendan Vogt14-Feb-06 19:54

14-Feb-06 19:54

Thanks Paul.

Have a good day!!

Cheers.

Slow Learner15-Feb-06 4:44

Slow Learner

15-Feb-06 4:44

Ma se,
Like paul suggested you should be able to migrage/move databases that you created in Sql server 2005 to it express edition or vice versa. Express edition and Sql server 2005 has the same engine. But the only differenece is Express edition doesn't come with all services that Sql server 2005 does. You shouldn't have any problem playing with it however you would like.

As far as learning the new Sql server 2005 or any thing in Sql server to that matter i would also encourage you to look into the group
microsoft.public.sqlserver.programming.

As you mentioned that you already downloaded VWD, just to let you know in case if you haven't had a chance to look at it, on the start page you should be able to find video clips prepared by Bob Taber. This gets installed by deafult during the VWD installation and he explains how to get started and that should help you get along with the new 2005 series. Hope this information helps you satisfy your lust in learning all NEW .NET 2.0, Visual Studio 2005, and Sql server 2005 Smile | :)

Please let me know if i could be of any furhter help!

Wish you happy learning.
-L

-- modified at 11:07 Wednesday 15th February, 2006

Paul Conrad15-Feb-06 15:51

Paul Conrad

15-Feb-06 15:51

Just remember that SQL 2005 Express does have limitations, found here. They don't see bad for the smaller projects.

Paul

Brendan Vogt15-Feb-06 19:41

15-Feb-06 19:41

Thanks for the information.

SQL Datatypes

Brendan Vogt14-Feb-06 1:12

14-Feb-06 1:12

Hi all!!

What is the difference between the nvarchar and varchar datatype? And so goes the ntext and text datatype? And the rest..

Regards,
ma se

Colin Angus Mackay14-Feb-06 1:44

14-Feb-06 1:44

ma se wrote:
What is the difference between the nvarchar and varchar datatype?

nvarchar is 16-bit characters, varchar is just 8-bit characters.

ma se wrote:
And so goes the ntext and text datatype?

Same deal

ma se wrote:
And the rest

You mean nchar Vs. char? Same deal again.

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Brendan Vogt14-Feb-06 1:52

14-Feb-06 1:52

Another dumb question, the difference between 8-bit and 16 bit characters are? Give me an example of an 8-bit character, and an example of a 16-bit character please.

And would it be better to rather just use nvarchar instead of varchar? Or when will you use the two in two different scenarios?

Thanks

Colin Angus Mackay14-Feb-06 2:26

14-Feb-06 2:26

Typically languages that use Latin characters are 8-bit. For example, English, French, Spanish, German, and so on. More complex languages that require more symbols use a 16-bit character set.

If in doubt go for nvarchar.

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Brendan Vogt14-Feb-06 19:14

14-Feb-06 19:14

Thanks alot.

When is your website going to be up and running. What type of content will be hosted on it?

Do you know where I can read some usefull articles on the Internet about SQL Server 2005 and it's datatypes?

How do you access your tables in SQL Server 2005? I downloaded the trial version for 6 months, but I can't seem to find a GUI like Enterprise manager.

Regards,
ma se

Colin Angus Mackay14-Feb-06 21:11

14-Feb-06 21:11

ma se wrote:
When is your website going to be up and running. What type of content will be hosted on it?

Hopefully in the next few weeks. It will evolve to have many things. Initially, I'll be putting up my articles. I'll also be putting up the slides from the presentations that I do.

ma se wrote:
Do you know where I can read some usefull articles on the Internet about SQL Server 2005 and it's datatypes?

Not off the top of my head - I bought some books on SQL Server 2005 instead.

ma se wrote:
How do you access your tables in SQL Server 2005? I downloaded the trial version for 6 months, but I can't seem to find a GUI like Enterprise manager.

Use the SQL Server Management Studio. It is a cross between Enterprise Manager and the Visual Studio 2005 IDE.

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Brendan Vogt14-Feb-06 21:24

14-Feb-06 21:24

Please let me know when your site is up and running. I hope your presentations are available for download. I only have the Internet at work and I don't have speakers here. I'll have to download and take the files home.

The SQL Server books that you bought, are they for novices as well, or for the more experienced people? You're welcome to share the ISBN numbers.

Does SQL Server Management Studio come with SQL Server 2005, or is it a separate download? What do you use to develop in, Visual Web Developer?

Colin Angus Mackay14-Feb-06 22:28

14-Feb-06 22:28

ma se wrote:
The SQL Server books that you bought, are they for novices as well, or for the more experienced people?

I'd say it was for people who had some knowledge of SQL Server 2000 and are primarily developers and not Database Admins.

Introducing SQL Server 2005 for Developers[^]

There are some beginners guides (e.g. Microsoft SQL Server 2005 for Dummies[^]) but I can't say whether they are any good or not as I've not looked at them.

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

SQLConnection Open() throws exception Instance Failure.

Slow Learner14-Feb-06 2:33

Slow Learner

14-Feb-06 2:33

Hello ma se,
There are 3 new max data types in Sql server 2005.
varchar(max),
nvarchar(max),
varbinary(max)

these are the replacements of Text, ntext, and image data types in its predecessors.

The above mentioned new data types can hold upto 2GB of data. Hope this helps!

thanks
-L

MY120113-Feb-06 22:06

Re: SQLConnection Open() throws exception Instance Failure.

13-Feb-06 22:06

Hello guys and girls.

I'm creating a Windows service with .NET, C# and SQL Server.

I have a strange problem with the SQLConnection class. Whenever I choose to call the "Open()" method. It throws an exception with message: "Instance Failure". That's it. Nothing else, just that simple message. Confused | :confused:

What could be wrong?

I've checked the following:

- The database server is running.
- The computer do have access to the database server (some of my other projects can access the data, and they use the same connection framework as the Windows service).
- My user has access to the database.
- If I install and run the service on the same computer as the database server, it still doesn't work.

Any clues would be appreciated! Thanks in advance! Smile | :)

dev dhoundiyal14-Feb-06 6:31

dev dhoundiyal

14-Feb-06 6:31

u may need to install sql server service pack 2

Re: SQLConnection Open() throws exception Instance Failure.

MY120114-Feb-06 23:40

Re: SQLConnection Open() throws exception Instance Failure.

14-Feb-06 23:40

Perhaps.

But I still don't understand, why my other applications, that use the exact same framework, can access the server's data.

This makes no sense.

Best regards
Soeren

MY120117-Feb-06 1:16

Re: SQLConnection Open() throws exception Instance Failure.

17-Feb-06 1:16

I have noticed, that the instance failures is caused by an InvalidOperationException, whenever I call the Open() method of the SQLConnection object.

But it still makes no sense.

Could it be a db permission problem?

/Soeren

MY120120-Feb-06 2:25