How to get the exact installed Version

OK, this is a simple question for you, but i am a newbie to SQL2000, and i need to find out which Service Pack we are currently running. Could anybody please give me a short reply :)
Thanks
Chrisselect @.@.version|||Originally posted by blindman
select @.@.version

great thank you. This helped a lot.

Chris

How to get started

Hi everyone,
I'm a newbie and I want to ask if there are anyone who know some good
books, or even better, a web site that can help me get started with
Microsoft SQL Server. I already know Microsoft Access.
MarcoRead this posted before
1b46b6e12524e645" target="_blank">http://groups.google.com/group/micr...b46b6e12524e645
"marco_r" wrote:

> Hi everyone,
> I'm a newbie and I want to ask if there are anyone who know some good
> books, or even better, a web site that can help me get started with
> Microsoft SQL Server. I already know Microsoft Access.
> Marco
>|||On 10 Oct 2005 13:15:28 -0700, "marco_r" <marcorasmussen@.gmail.com>
wrote:

>Hi everyone,
>I'm a newbie and I want to ask if there are anyone who know some good
>books, or even better, a web site that can help me get started with
>Microsoft SQL Server. I already know Microsoft Access.
>Marco
Marco,
Are you wanting to learn about SQL Server 2000 or SQL Server 2005?
Visit http://www.microsoft.com/events.
Do a search for on-demand (recorded) and upcoming live Webcasts.
Filter on the product that interests you.
It's a great way to get a general feel for a product.
Andrew Watt
MVP - InfoPath|||For beginners also check out:
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days
by Richard Waymire
http://www.amazon.com/exec/obidos/t...=books&n=507846
Database Design for Mere Mortals
by Michael Hernandez
http://www.amazon.com/exec/obidos/t...=books&n=507846
HTH
Jerry
"SQL" <SQL@.discussions.microsoft.com> wrote in message
news:24CF018A-9A94-442D-B045-4B6F95863C08@.microsoft.com...[vbcol=seagreen]
> Read this posted before
> http://groups.google.com/group/micr...b46b6e12524e645
>
>
> "marco_r" wrote:
>|||Hi,
SQL Server books online will be really good resource for you to understand
the concepts of SQL Server.
Thanks
Hari
SQL Server MVP
"marco_r" <marcorasmussen@.gmail.com> wrote in message
news:1128975328.538494.293880@.z14g2000cwz.googlegroups.com...
> Hi everyone,
> I'm a newbie and I want to ask if there are anyone who know some good
> books, or even better, a web site that can help me get started with
> Microsoft SQL Server. I already know Microsoft Access.
> Marco
>|||Thaks!

How to get started

Hi everyone,
I'm a newbie and I want to ask if there are anyone who know some good
books, or even better, a web site that can help me get started with
Microsoft SQL Server. I already know Microsoft Access.
MarcoRead this posted before
http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/d8fa82c7b4055389/1b46b6e12524e645?lnk=st&q=SQl+Server+Books&rnum=3&hl=en#1b46b6e12524e645
"marco_r" wrote:
> Hi everyone,
> I'm a newbie and I want to ask if there are anyone who know some good
> books, or even better, a web site that can help me get started with
> Microsoft SQL Server. I already know Microsoft Access.
> Marco
>|||On 10 Oct 2005 13:15:28 -0700, "marco_r" <marcorasmussen@.gmail.com>
wrote:
>Hi everyone,
>I'm a newbie and I want to ask if there are anyone who know some good
>books, or even better, a web site that can help me get started with
>Microsoft SQL Server. I already know Microsoft Access.
>Marco
Marco,
Are you wanting to learn about SQL Server 2000 or SQL Server 2005?
Visit http://www.microsoft.com/events.
Do a search for on-demand (recorded) and upcoming live Webcasts.
Filter on the product that interests you.
It's a great way to get a general feel for a product.
Andrew Watt
MVP - InfoPath|||For beginners also check out:
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days
by Richard Waymire
http://www.amazon.com/exec/obidos/tg/detail/-/0672319691/qid=1128979097/sr=8-2/ref=pd_bbs_2/102-4703055-5891314?v=glance&s=books&n=507846
Database Design for Mere Mortals
by Michael Hernandez
http://www.amazon.com/exec/obidos/tg/detail/-/0201752840/qid=1128979174/sr=8-1/ref=pd_bbs_1/102-4703055-5891314?v=glance&s=books&n=507846
HTH
Jerry
"SQL" <SQL@.discussions.microsoft.com> wrote in message
news:24CF018A-9A94-442D-B045-4B6F95863C08@.microsoft.com...
> Read this posted before
> http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/d8fa82c7b4055389/1b46b6e12524e645?lnk=st&q=SQl+Server+Books&rnum=3&hl=en#1b46b6e12524e645
>
>
> "marco_r" wrote:
>> Hi everyone,
>> I'm a newbie and I want to ask if there are anyone who know some good
>> books, or even better, a web site that can help me get started with
>> Microsoft SQL Server. I already know Microsoft Access.
>> Marco
>>|||Hi,
SQL Server books online will be really good resource for you to understand
the concepts of SQL Server.
Thanks
Hari
SQL Server MVP
"marco_r" <marcorasmussen@.gmail.com> wrote in message
news:1128975328.538494.293880@.z14g2000cwz.googlegroups.com...
> Hi everyone,
> I'm a newbie and I want to ask if there are anyone who know some good
> books, or even better, a web site that can help me get started with
> Microsoft SQL Server. I already know Microsoft Access.
> Marco
>|||Thaks!

How to get started

Hi everyone,
I'm a newbie and I want to ask if there are anyone who know some good
books, or even better, a web site that can help me get started with
Microsoft SQL Server. I already know Microsoft Access.
Marco
Read this posted before
http://groups.google.com/group/micro...46b6e12524e645
"marco_r" wrote:

> Hi everyone,
> I'm a newbie and I want to ask if there are anyone who know some good
> books, or even better, a web site that can help me get started with
> Microsoft SQL Server. I already know Microsoft Access.
> Marco
>
|||On 10 Oct 2005 13:15:28 -0700, "marco_r" <marcorasmussen@.gmail.com>
wrote:

>Hi everyone,
>I'm a newbie and I want to ask if there are anyone who know some good
>books, or even better, a web site that can help me get started with
>Microsoft SQL Server. I already know Microsoft Access.
>Marco
Marco,
Are you wanting to learn about SQL Server 2000 or SQL Server 2005?
Visit http://www.microsoft.com/events.
Do a search for on-demand (recorded) and upcoming live Webcasts.
Filter on the product that interests you.
It's a great way to get a general feel for a product.
Andrew Watt
MVP - InfoPath
|||For beginners also check out:
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days
by Richard Waymire
http://www.amazon.com/exec/obidos/tg...books&n=507846
Database Design for Mere Mortals
by Michael Hernandez
http://www.amazon.com/exec/obidos/tg...books&n=507846
HTH
Jerry
"SQL" <SQL@.discussions.microsoft.com> wrote in message
news:24CF018A-9A94-442D-B045-4B6F95863C08@.microsoft.com...[vbcol=seagreen]
> Read this posted before
> http://groups.google.com/group/micro...46b6e12524e645
>
>
> "marco_r" wrote:
|||Hi,
SQL Server books online will be really good resource for you to understand
the concepts of SQL Server.
Thanks
Hari
SQL Server MVP
"marco_r" <marcorasmussen@.gmail.com> wrote in message
news:1128975328.538494.293880@.z14g2000cwz.googlegr oups.com...
> Hi everyone,
> I'm a newbie and I want to ask if there are anyone who know some good
> books, or even better, a web site that can help me get started with
> Microsoft SQL Server. I already know Microsoft Access.
> Marco
>
|||Thaks!

How to get rid of the Database Login window ?

Hi, I'm a newbie in VB.Net, need some help here. I'm generating a report and view it in a win app, which is in VB.Net. I've specified the database logon info by the following code:

*************************************************
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared

Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim crtableLogoninfo As New TableLogOnInfo()
Dim crConnectionInfo As New ConnectionInfo()
Dim CrTables As Tables
Dim CrTable As Table
Dim TableCounter
Dim crReportDocument As New cr1()
With crConnectionInfo
.ServerName = "mydb"
.UserID = "myuserid"
.Password = "mypassword"
End With

CrTables = crReportDocument.Database.Tables

For Each CrTable In CrTables
crtableLogoninfo = CrTable.LogOnInfo
crtableLogoninfo.ConnectionInfo = crConnectionInfo
CrTable.ApplyLogOnInfo(crtableLogoninfo)
Next

CrystalReportViewer1.ReportSource = crReportDocument

End Sub
*****************************************************

It's an Oracle DB and just one table, suppose to be very simple. But whenever the app starts, this "Database Login" window always opens first, asking for server info, db info, user name and password. Actually if I click "Cancel", the report still get generated. So how to get rid of this annoying "Database Login" window?

My second question is, how to automatically send this report to printer? I know in VB6 you just say action=1. Unfortunately this thing doesn't work in .Net any more.

Thanks!Just look through CrystalReport knowledgebase, seems that this is a known issue. Refer to this article:
http://support.businessobjects.com/library/kbase/articles/c2010461.asp

Is there already a fix for this ?|||Figured this out by carefully reading this article: http://support.businessobjects.com/library/kbase/articles/c2010461.asp

The Form_new method has to be overwritten, adding some customized initialization, where ser/uid/pass can be specified.

**** I just took it for granted to do it in Form_load...