How to make a database in Sql2005 Express

I have installed the Sql2005 Express.
But there are not any tools like Enterprise Manager in it.
How can I establish a database in it?
You can use Microsoft SQL Server 2005 Express Manager as a database
management tool for SQL Server Express 2005.
http://www.microsoft.com/downloads/d...displaylang=en
- Peter Ward
WARDY IT Solutions
"ad" wrote:

> I have installed the Sql2005 Express.
> But there are not any tools like Enterprise Manager in it.
> How can I establish a database in it?
>
>

How to make a database in Sql2005 Express

I have installed the Sql2005 Express.
But there are not any tools like Enterprise Manager in it.
How can I establish a database in it?You can use Microsoft SQL Server 2005 Express Manager as a database
management tool for SQL Server Express 2005.
http://www.microsoft.com/downloads/details.aspx?familyid=8f92556a-6c3b-47d2-9929-ecdc5a4d25ae&displaylang=en
- Peter Ward
WARDY IT Solutions
"ad" wrote:
> I have installed the Sql2005 Express.
> But there are not any tools like Enterprise Manager in it.
> How can I establish a database in it?
>
>

How to make a database in Sql2005 Express

I have installed the Sql2005 Express.
But there are not any tools like Enterprise Manager in it.
How can I establish a database in it?You can use Microsoft SQL Server 2005 Express Manager as a database
management tool for SQL Server Express 2005.
http://www.microsoft.com/downloads/...&displaylang=en
- Peter Ward
WARDY IT Solutions
"ad" wrote:

> I have installed the Sql2005 Express.
> But there are not any tools like Enterprise Manager in it.
> How can I establish a database in it?
>
>

How to link to ACT7 with SQLexpress,both on same Notebook.

How to link to ACT7 with SQLExpress,both on same Notebook.

I tried to make ODBC via settings Adm.Tools for Sql Server, and I made System DNS,

From Msaccess 2003 I try to male "get external data" and via ODBC databases,.... but it did not work. I don't see

and popping up if listing/prgs/database or whatever, it remains dead.

I can however via Start,Programs work with Sql express studio and with a demo database it is working,but I need the ACT7 tables to work with.

What my main task is, is to connect via Msaccess/ODBC to my ACT7 ( Sql) in order to do some update/import etc etc.

because standard Import features very poor for Additional Contacts etc.

Thanks for any help.

William

Hi William,

ACT! does not support access to their database outside of their defined API, which I'm not 100% familiar with. My understanding is that they do have an OLEDB provider for use with reporting engines such as Crystral reports, but I'm not sure if they support ODBC access to their tables.

I recommend you check out the ACT! support site at http://www.act.com/support/index.cfm to find your answer. The have both a knowledge base and customer forums that should help you figure out the correct way to do this.

Mike

|||

Thanks Mike sofar, I am trying further somewhere somehow.

William

How to learn .Net

Hi there,
I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
thanks in advance
Jamie Thomson
Jamie,
I think this is a rather subjective question. Some people learn best in
a classroom where they can intereact with a teacher. Others prefer to
learn from a book where they can work at their own pace and try the
demos and examples in the book. Others prefer to just dive in and start
"hacking around" by referring to the MSDN Library when they get stuck.
You need to decide on whether you would benefit more from a structured
learning experience, i.e. classroom training, or a self-paced
experience, such as books, online learning libraries, or MELL.
I personally prefer a classroom experience for something that I am
totally new to, and once I have grasped the basics, I prefer to learn
from books or some other form of self paced learning.
Horses for courses...
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jamie wrote:
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||Jamie,
a really good place to start is the Modern Software Development seminar
series by Joe Hummel as per link below. VB focussed but does a great job of
explaining the concepts / issues. Also a lot of real world stuff , about
when its best to use certain language / .Net features etc that is missing
from a lot of the other stuff I've seen.
http://msdn.microsoft.com/vbasic/com...n/default.aspx
Andy.
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||Mark,
Classroom learning is not an option as I intend to do this off my own back and can't afford a course.
I guess I'm looking for advice on either:
a) Good books for beginners or
b) Free online training resources.
Any advice from someone in the know as to what I should concentrate on would be useful as well.
Thanks for the reply Mark, thats very useful.
Regards
Jamie Thomson
"Mark Allison" wrote:
[vbcol=seagreen]
> Jamie,
> I think this is a rather subjective question. Some people learn best in
> a classroom where they can intereact with a teacher. Others prefer to
> learn from a book where they can work at their own pace and try the
> demos and examples in the book. Others prefer to just dive in and start
> "hacking around" by referring to the MSDN Library when they get stuck.
> You need to decide on whether you would benefit more from a structured
> learning experience, i.e. classroom training, or a self-paced
> experience, such as books, online learning libraries, or MELL.
> I personally prefer a classroom experience for something that I am
> totally new to, and once I have grasped the basics, I prefer to learn
> from books or some other form of self paced learning.
> Horses for courses...
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Jamie wrote:

>
|||Hi Jamie
Fernando Guerrero, from my company Solid Quality Learning, has offered a
seminar at various conferences on .NET for the DBA, designed for just this
purpose and is VERY SQL Server centric. We are looking at ways to allow
Fernando to deliver this online in a publicly available format and should
have something scheduled by the end of the summer. Information will be
available on our site when we have all the details in place.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||I agree with Kalen, than Fernando would do an excellent job... You might
also try out some books like the Hitchihikers guide ( if there is a version
for Dot. Net.)
Companies like Learnkey also provide CD, and video based training
(www.learnkey.com)...
Getting involved with a local dot net group would be helpful as well.. (
Perhaps INETA (www.ineta.org) )
And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||Jamie,
if you're already familiar with VB 5/6 then I highly recommend this book:
http://www.amazon.co.uk/exec/obidos/...043104-6361455
Regards,
Paul Ibison
|||Thank you to all. Some very useful information there.
I shall check out Andy's link immediately. Kalen, I'll keep a check on your site as well.
Thanks again all.
"Wayne Snyder" wrote:

> I agree with Kalen, than Fernando would do an excellent job... You might
> also try out some books like the Hitchihikers guide ( if there is a version
> for Dot. Net.)
> Companies like Learnkey also provide CD, and video based training
> (www.learnkey.com)...
> Getting involved with a local dot net group would be helpful as well.. (
> Perhaps INETA (www.ineta.org) )
> And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Jamie" <Jamie@.discussions.microsoft.com> wrote in message
> news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> have an appreciation of a few development tools such as Visual Basic v5,
> Java, C++ although have never developed anything in anger using them.
> start getting up to speed with .Net in advance of Yukon and I figured its
> about time I started doing the same. I also want to satisfy my own curiosity
> about the "new world" of .Net.
> Server-centric learning curve would be preferable.
>
>

How to learn .Net

Hi there,
I'm a SQL Server professional, specialising in DTS & Analysis Services. I ha
ve an appreciation of a few development tools such as Visual Basic v5, Java,
C++ although have never developed anything in anger using them.
I read everywhere at the moment that SQL Server professionals need to start
getting up to speed with .Net in advance of Yukon and I figured its about ti
me I started doing the same. I also want to satisfy my own curiosity about t
he "new world" of .Net.
What is the best way to start for someone with my background? A SQL Server-c
entric learning curve would be preferable.
thanks in advance
Jamie ThomsonJamie,
I think this is a rather subjective question. Some people learn best in
a classroom where they can intereact with a teacher. Others prefer to
learn from a book where they can work at their own pace and try the
demos and examples in the book. Others prefer to just dive in and start
"hacking around" by referring to the MSDN Library when they get stuck.
You need to decide on whether you would benefit more from a structured
learning experience, i.e. classroom training, or a self-paced
experience, such as books, online learning libraries, or MELL.
I personally prefer a classroom experience for something that I am
totally new to, and once I have grasped the basics, I prefer to learn
from books or some other form of self paced learning.
Horses for courses...
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jamie wrote:
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5, Jav
a, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to star
t getting up to speed with .Net in advance of Yukon and I figured its about
time I started doing the same. I also want to satisfy my own curiosity about
the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL Server
-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
a really good place to start is the Modern Software Development seminar
series by Joe Hummel as per link below. VB focussed but does a great job of
explaining the concepts / issues. Also a lot of real world stuff , about
when its best to use certain language / .Net features etc that is missing
from a lot of the other stuff I've seen.
http://msdn.microsoft.com/vbasic/co...rn/default.aspx
Andy.
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Mark,
Classroom learning is not an option as I intend to do this off my own back a
nd can't afford a course.
I guess I'm looking for advice on either:
a) Good books for beginners or
b) Free online training resources.
Any advice from someone in the know as to what I should concentrate on would
be useful as well.
Thanks for the reply Mark, thats very useful.
Regards
Jamie Thomson
"Mark Allison" wrote:

> Jamie,
> I think this is a rather subjective question. Some people learn best in
> a classroom where they can intereact with a teacher. Others prefer to
> learn from a book where they can work at their own pace and try the
> demos and examples in the book. Others prefer to just dive in and start
> "hacking around" by referring to the MSDN Library when they get stuck.
> You need to decide on whether you would benefit more from a structured
> learning experience, i.e. classroom training, or a self-paced
> experience, such as books, online learning libraries, or MELL.
> I personally prefer a classroom experience for something that I am
> totally new to, and once I have grasped the basics, I prefer to learn
> from books or some other form of self paced learning.
> Horses for courses...
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Jamie wrote:
[vbcol=seagreen]
>|||Hi Jamie
Fernando Guerrero, from my company Solid Quality Learning, has offered a
seminar at various conferences on .NET for the DBA, designed for just this
purpose and is VERY SQL Server centric. We are looking at ways to allow
Fernando to deliver this online in a publicly available format and should
have something scheduled by the end of the summer. Information will be
available on our site when we have all the details in place.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||I agree with Kalen, than Fernando would do an excellent job... You might
also try out some books like the Hitchihikers guide ( if there is a version
for Dot. Net.)
Companies like Learnkey also provide CD, and video based training
(www.learnkey.com)...
Getting involved with a local dot net group would be helpful as well.. (
Perhaps INETA (www.ineta.org) )
And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
if you're already familiar with VB 5/6 then I highly recommend this book:
361455" target="_blank">http://www.amazon.co.uk/exec/obidos...6
361455
Regards,
Paul Ibison|||Thank you to all. Some very useful information there.
I shall check out Andy's link immediately. Kalen, I'll keep a check on your
site as well.
Thanks again all.
"Wayne Snyder" wrote:

> I agree with Kalen, than Fernando would do an excellent job... You might
> also try out some books like the Hitchihikers guide ( if there is a versio
n
> for Dot. Net.)
> Companies like Learnkey also provide CD, and video based training
> (www.learnkey.com)...
> Getting involved with a local dot net group would be helpful as well.. (
> Perhaps INETA (www.ineta.org) )
> And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Jamie" <Jamie@.discussions.microsoft.com> wrote in message
> news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> have an appreciation of a few development tools such as Visual Basic v5,
> Java, C++ although have never developed anything in anger using them.
> start getting up to speed with .Net in advance of Yukon and I figured its
> about time I started doing the same. I also want to satisfy my own curiosi
ty
> about the "new world" of .Net.
> Server-centric learning curve would be preferable.
>
>

How to learn .Net

Hi there,
I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
thanks in advance
Jamie ThomsonJamie,
I think this is a rather subjective question. Some people learn best in
a classroom where they can intereact with a teacher. Others prefer to
learn from a book where they can work at their own pace and try the
demos and examples in the book. Others prefer to just dive in and start
"hacking around" by referring to the MSDN Library when they get stuck.
You need to decide on whether you would benefit more from a structured
learning experience, i.e. classroom training, or a self-paced
experience, such as books, online learning libraries, or MELL.
I personally prefer a classroom experience for something that I am
totally new to, and once I have grasped the basics, I prefer to learn
from books or some other form of self paced learning.
Horses for courses...
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jamie wrote:
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
a really good place to start is the Modern Software Development seminar
series by Joe Hummel as per link below. VB focussed but does a great job of
explaining the concepts / issues. Also a lot of real world stuff , about
when its best to use certain language / .Net features etc that is missing
from a lot of the other stuff I've seen.
http://msdn.microsoft.com/vbasic/community/webcasts/modern/default.aspx
Andy.
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Hi Jamie
Fernando Guerrero, from my company Solid Quality Learning, has offered a
seminar at various conferences on .NET for the DBA, designed for just this
purpose and is VERY SQL Server centric. We are looking at ways to allow
Fernando to deliver this online in a publicly available format and should
have something scheduled by the end of the summer. Information will be
available on our site when we have all the details in place.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||I agree with Kalen, than Fernando would do an excellent job... You might
also try out some books like the Hitchihikers guide ( if there is a version
for Dot. Net.)
Companies like Learnkey also provide CD, and video based training
(www.learnkey.com)...
Getting involved with a local dot net group would be helpful as well.. (
Perhaps INETA (www.ineta.org) )
And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
if you're already familiar with VB 5/6 then I highly recommend this book:
http://www.amazon.co.uk/exec/obidos/ASIN/0672322641/qid%3D1088783844/202-5043104-6361455
Regards,
Paul Ibison|||Thank you to all. Some very useful information there.
I shall check out Andy's link immediately. Kalen, I'll keep a check on your site as well.
Thanks again all.
"Wayne Snyder" wrote:
> I agree with Kalen, than Fernando would do an excellent job... You might
> also try out some books like the Hitchihikers guide ( if there is a version
> for Dot. Net.)
> Companies like Learnkey also provide CD, and video based training
> (www.learnkey.com)...
> Getting involved with a local dot net group would be helpful as well.. (
> Perhaps INETA (www.ineta.org) )
> And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Jamie" <Jamie@.discussions.microsoft.com> wrote in message
> news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> > Hi there,
> > I'm a SQL Server professional, specialising in DTS & Analysis Services. I
> have an appreciation of a few development tools such as Visual Basic v5,
> Java, C++ although have never developed anything in anger using them.
> >
> > I read everywhere at the moment that SQL Server professionals need to
> start getting up to speed with .Net in advance of Yukon and I figured its
> about time I started doing the same. I also want to satisfy my own curiosity
> about the "new world" of .Net.
> >
> > What is the best way to start for someone with my background? A SQL
> Server-centric learning curve would be preferable.
> >
> > thanks in advance
> >
> > Jamie Thomson
> >
>
>

How to know how many users are connected to my sql server 2000 and how many resources are

how can i know it? can i do it with sql 2000 tools or i need other kind of
tool?
Regards
Rick
EXEC master.dbo.sp_who2;
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Rick" <zatankloz@.gmail.com> wrote in message
news:%23aXjgLGqHHA.2044@.TK2MSFTNGP04.phx.gbl...
> how can i know it? can i do it with sql 2000 tools or i need other kind of
> tool?
> Regards
> Rick
>
|||Hello,
For SQL 2000 query the MASTER..SYPROCESSES table. Use the filtering and
group based on your requirement.
For SQL 2005 you could the dynamic management view (DMV)
sys.dm_exec_sessions
SELECT
session_id,login_name,
last_request_end_time,cpu_time
FROM sys.dm_exec_sessions
WHERE session_id >= 51 - All user SessionsSee the below URL for more
details:-
http://www.codeproject.com/useritems/Dynamic_Management_Views.asp
Thanks
Hari
"Rick" <zatankloz@.gmail.com> wrote in message
news:%23aXjgLGqHHA.2044@.TK2MSFTNGP04.phx.gbl...
> how can i know it? can i do it with sql 2000 tools or i need other kind of
> tool?
> Regards
> Rick

>

How to know how many users are connected to my sql server 2000 and how many resources are

how can i know it? can i do it with sql 2000 tools or i need other kind of
tool?
Regards
RickEXEC master.dbo.sp_who2;
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Rick" <zatankloz@.gmail.com> wrote in message
news:%23aXjgLGqHHA.2044@.TK2MSFTNGP04.phx.gbl...
> how can i know it? can i do it with sql 2000 tools or i need other kind of
> tool?
> Regards
> Rick
>|||Hello,
For SQL 2000 query the MASTER..SYPROCESSES table. Use the filtering and
group based on your requirement.
For SQL 2005 you could the dynamic management view (DMV)
sys.dm_exec_sessions
SELECT
session_id,login_name,
last_request_end_time,cpu_time
FROM sys.dm_exec_sessions
WHERE session_id >= 51 - All user SessionsSee the below URL for more
details:-
http://www.codeproject.com/useritems/Dynamic_Management_Views.asp
Thanks
Hari
"Rick" <zatankloz@.gmail.com> wrote in message
news:%23aXjgLGqHHA.2044@.TK2MSFTNGP04.phx.gbl...
> how can i know it? can i do it with sql 2000 tools or i need other kind of
> tool?
> Regards
> Rick
>