new to sql and need some help. connectivity problems.

hi guy
i've installed sql on a dedicated box for the purpose of using it for mom and sms but the only problem is when i go to install sms or mom on the other boxes it doesnt see the sql server. however if i start the mom setup process on the sql box it sees the sql sever
i have installed the client tools on both the sms and mom boxes and configured them point to the sql server over tcp/ip and the named pipe but to no avail. i also added a data source to the odbc console thinking that may help but no it didnt
what i've done so fa
installed sql with integrated windows authenticatio
added it to a
got the Microsoft SQL Server 2000 Books Online from the ms sit
gone and purchased the ms sql server 2000 administration guid
started to read both books and am now scared of sql server 200
are there some connectivity tools that would help in troubleshooting this or am i barking up the wrong tree
i have used sms and mom extensively before but this is my first attempt at sql
cheer
dDid you install SQL Server or MSDE? Basically, on the client, you use SQL Server's "Client Network Utility"
and on the server, you use "Server Network Utility" to configure the connectivity. If you have MSDE, it
doesn't have network access turned on by default, and you won't have an icon for SNU, but it is there and the
name of the exe file is: svrnetcn.exe.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1AFB725A-1AF3-47BC-808B-198916327FCA@.microsoft.com...
> hi guys
> i've installed sql on a dedicated box for the purpose of using it for mom and sms but the only problem is
when i go to install sms or mom on the other boxes it doesnt see the sql server. however if i start the mom
setup process on the sql box it sees the sql sever.
> i have installed the client tools on both the sms and mom boxes and configured them point to the sql server
over tcp/ip and the named pipe but to no avail. i also added a data source to the odbc console thinking that
may help but no it didnt.
> what i've done so far
> installed sql with integrated windows authentication
> added it to ad
> got the Microsoft SQL Server 2000 Books Online from the ms site
> gone and purchased the ms sql server 2000 administration guide
> started to read both books and am now scared of sql server 2000
> are there some connectivity tools that would help in troubleshooting this or am i barking up the wrong tree?
> i have used sms and mom extensively before but this is my first attempt at sql.
> cheers
> d

new to sql and need some help. connectivity problems.

hi guys
i've installed sql on a dedicated box for the purpose of using it for mom and sms but the only problem is when i go to install sms or mom on the other boxes it doesnt see the sql server. however if i start the mom setup process on the sql box it sees the
sql sever.
i have installed the client tools on both the sms and mom boxes and configured them point to the sql server over tcp/ip and the named pipe but to no avail. i also added a data source to the odbc console thinking that may help but no it didnt.
what i've done so far
installed sql with integrated windows authentication
added it to ad
got the Microsoft SQL Server 2000 Books Online from the ms site
gone and purchased the ms sql server 2000 administration guide
started to read both books and am now scared of sql server 2000
are there some connectivity tools that would help in troubleshooting this or am i barking up the wrong tree?
i have used sms and mom extensively before but this is my first attempt at sql.
cheers
d
Did you install SQL Server or MSDE? Basically, on the client, you use SQL Server's "Client Network Utility"
and on the server, you use "Server Network Utility" to configure the connectivity. If you have MSDE, it
doesn't have network access turned on by default, and you won't have an icon for SNU, but it is there and the
name of the exe file is: svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1AFB725A-1AF3-47BC-808B-198916327FCA@.microsoft.com...
> hi guys
> i've installed sql on a dedicated box for the purpose of using it for mom and sms but the only problem is
when i go to install sms or mom on the other boxes it doesnt see the sql server. however if i start the mom
setup process on the sql box it sees the sql sever.
> i have installed the client tools on both the sms and mom boxes and configured them point to the sql server
over tcp/ip and the named pipe but to no avail. i also added a data source to the odbc console thinking that
may help but no it didnt.
> what i've done so far
> installed sql with integrated windows authentication
> added it to ad
> got the Microsoft SQL Server 2000 Books Online from the ms site
> gone and purchased the ms sql server 2000 administration guide
> started to read both books and am now scared of sql server 2000
> are there some connectivity tools that would help in troubleshooting this or am i barking up the wrong tree?
> i have used sms and mom extensively before but this is my first attempt at sql.
> cheers
> d

new to sql and need some help. connectivity problems.

hi guys
i've installed sql on a dedicated box for the purpose of using it for mom an
d sms but the only problem is when i go to install sms or mom on the other b
oxes it doesnt see the sql server. however if i start the mom setup process
on the sql box it sees the
sql sever.
i have installed the client tools on both the sms and mom boxes and configur
ed them point to the sql server over tcp/ip and the named pipe but to no ava
il. i also added a data source to the odbc console thinking that may help bu
t no it didnt.
what i've done so far
installed sql with integrated windows authentication
added it to ad
got the Microsoft SQL Server 2000 Books Online from the ms site
gone and purchased the ms sql server 2000 administration guide
started to read both books and am now scared of sql server 2000
are there some connectivity tools that would help in troubleshooting this or
am i barking up the wrong tree?
i have used sms and mom extensively before but this is my first attempt at s
ql.
cheers
dDid you install SQL Server or MSDE? Basically, on the client, you use SQL Se
rver's "Client Network Utility"
and on the server, you use "Server Network Utility" to configure the connect
ivity. If you have MSDE, it
doesn't have network access turned on by default, and you won't have an icon
for SNU, but it is there and the
name of the exe file is: svrnetcn.exe.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"dave" <anonymous@.discussions.microsoft.com> wrote in message
news:1AFB725A-1AF3-47BC-808B-198916327FCA@.microsoft.com...
> hi guys
> i've installed sql on a dedicated box for the purpose of using it for mom and sms
but the only problem is
when i go to install sms or mom on the other boxes it doesnt see the sql ser
ver. however if i start the mom
setup process on the sql box it sees the sql sever.
> i have installed the client tools on both the sms and mom boxes and configured the
m point to the sql server
over tcp/ip and the named pipe but to no avail. i also added a data source t
o the odbc console thinking that
may help but no it didnt.
> what i've done so far
> installed sql with integrated windows authentication
> added it to ad
> got the Microsoft SQL Server 2000 Books Online from the ms site
> gone and purchased the ms sql server 2000 administration guide
> started to read both books and am now scared of sql server 2000
> are there some connectivity tools that would help in troubleshooting this
or am i barking up the wrong tree?
> i have used sms and mom extensively before but this is my first attempt at
sql.
> cheers
> d

new to SQL 2005

Hello,

I just installed SQL 2005 on my laptop,,,, I know this is not an email question but maybe you can guide me to where i can find the answers.....

I want to test it out and configure it with cognos and informatica.....

Is it possible for me to create sample servers and configure it for a test

I did instal web Server (Abyss), not sure if this helps......

How do i set up a test server on my computer

And is all possible to do it on one computer?

thank-you in advance

Is this what you're looking for?

https://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

Best regards

- Jens

|||

Thank-you! but i already installed them,

Im looking for is how to configure it so it will work with them?

thank-you !

|||

Hi,

How can i create a server on my windows xp computer so i can connect to it from SQL 2005?

thank-you

|||

Have a look at this url:

http://msdn2.microsoft.com/en-us/library/ms143708.aspx

Best regards

- Jens

new to SQL 2005

Hello,

I just installed SQL 2005 on my laptop,,,, I know this is not an email question but maybe you can guide me to where i can find the answers.....

I want to test it out and configure it with cognos and informatica.....

Is it possible for me to create sample servers and configure it for a test

I did instal web Server (Abyss), not sure if this helps......

How do i set up a test server on my computer

And is all possible to do it on one computer?

thank-you in advance

Is this what you're looking for?

https://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

Best regards

- Jens

|||

Thank-you! but i already installed them,

Im looking for is how to configure it so it will work with them?

thank-you !

|||

Hi,

How can i create a server on my windows xp computer so i can connect to it from SQL 2005?

thank-you

|||

Have a look at this url:

http://msdn2.microsoft.com/en-us/library/ms143708.aspx

Best regards

- Jens

New to SQL

Hello,

I just installed SQL 2005 on my laptop,,,, I know this is not an email question but maybe you can guide me to where i can find the answers.....

I want to test it out and configure it with cognos and informatica.....

Is it possible for me to create sample servers and configure it for a test

I did instal web Server (Abyss), not sure if this helps......

How do i set up a test server on my computer

And is all possible to do it on one computer?

thank-you in advance

You already have a default instance ( 1 server) installed on your computer. If you want to have more use Microsoft Virtual PC to install another instance as you have another pc. Or install a second instance , a named instance that mean you have another server on your laptop.

Sure for working with Virtual PC or install another instance you have to have disk size, RAM (for a Virtual PC application with SS2k5 you have to have 512 MB Ram )

So, 512 RAM for SQL on the laptop with 512 Mb RAM for SQL on Virtual PC you have to have minimum 1 GB RAM.

As a web server you can use IIS (Internet Information Services) on Microsoft host

|||

Thank-you!

How can i create a server on my windows xp computer so i can connect to it from SQL 2005?

thank-you

|||In windows XP you can install only SQL express edition or SQL Server 2005 trail version (180 days valid).

Download SQL express
|||

Vidhya Sagar wrote:

In windows XP you can install only SQL express edition or SQL Server 2005 trail version (180 days valid).

No, it is not correct

I have Windows XP Professional and the command select @.@.version has output:

-

Microsoft SQL Server 2005 - 9.00.3027.00 (Intel X86)

Oct 27 2006 15:59:00

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

(1 row(s) affected)

|||

russski wrote:

How can i create a server on my windows xp computer so i can connect to it from SQL 2005?

If ou install a SQL server on a machine you install both client and server ; in some time ou have the option to install only client tools. So , if you have a SQL on the host and a virtual PC machine running on that machine with SQL installed you can experiment connecting one to another.|||Hi,

Thx for the information. As you said all editions of SQL2k5 can be installed on XP Professional edition expect Enterprise edition.
In XP Home edition you can go only for express or developer or trial edition.

New to SQL

Hello,

I just installed SQL 2005 on my laptop,,,, I know this is not an email question but maybe you can guide me to where i can find the answers.....

I want to test it out and configure it with cognos and informatica.....

Is it possible for me to create sample servers and configure it for a test

I did instal web Server (Abyss), not sure if this helps......

How do i set up a test server on my computer

And is all possible to do it on one computer?

thank-you in advance

You already have a default instance ( 1 server) installed on your computer. If you want to have more use Microsoft Virtual PC to install another instance as you have another pc. Or install a second instance , a named instance that mean you have another server on your laptop.

Sure for working with Virtual PC or install another instance you have to have disk size, RAM (for a Virtual PC application with SS2k5 you have to have 512 MB Ram )

So, 512 RAM for SQL on the laptop with 512 Mb RAM for SQL on Virtual PC you have to have minimum 1 GB RAM.

As a web server you can use IIS (Internet Information Services) on Microsoft host

|||

Thank-you!

How can i create a server on my windows xp computer so i can connect to it from SQL 2005?

thank-you

|||In windows XP you can install only SQL express edition or SQL Server 2005 trail version (180 days valid).

Download SQL express
|||

Vidhya Sagar wrote:

In windows XP you can install only SQL express edition or SQL Server 2005 trail version (180 days valid).

No, it is not correct

I have Windows XP Professional and the command select @.@.version has output:

-

Microsoft SQL Server 2005 - 9.00.3027.00 (Intel X86)

Oct 27 2006 15:59:00

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

(1 row(s) affected)

|||

russski wrote:

How can i create a server on my windows xp computer so i can connect to it from SQL 2005?

If ou install a SQL server on a machine you install both client and server ; in some time ou have the option to install only client tools. So , if you have a SQL on the host and a virtual PC machine running on that machine with SQL installed you can experiment connecting one to another.|||Hi,

Thx for the information. As you said all editions of SQL2k5 can be installed on XP Professional edition expect Enterprise edition.
In XP Home edition you can go only for express or developer or trial edition.

New to Pl/SQl and SQL

I am new to this group and beginner to SQL and PL/SQL, I installed Microsoft SQL Server 2000, learned the basic SQL statments and ran them in the SQL Query Analyzer.

Now I am learning some PL/SQL tutorials and was wondering if I could run PL/SQL scripts in the SQL Query Analyzer ? Any help would be highly appreciated.PL/SQL is Oracle's procedural extension to the SQL standard and I believe will only run against Oracle databases.|||If you want to try pl/sql and don't have oracle I believe the open source database postgres (www.postgres.org) is very similar and has a pl/sql equivalent in pg/sql|||Originally posted by axis
PL/SQL is Oracle's procedural extension to the SQL standard and I believe will only run against Oracle databases.

Thanks for your response, I dont have oracle database, I will try it against oracle db.

New to MS SQL

We just installed sql server 2005 on our server, how do I log into SQL server 2005 as an administrator from my workstation as opposed to working from the server console

Thanks,

Mike

Quote:

Originally Posted by Michaelrc0

We just installed sql server 2005 on our server, how do I log into SQL server 2005 as an administrator from my workstation as opposed to working from the server console

Thanks,

Mike

Install the management studio on your desktop.

new to .net MSDE (database) question ?

Hi, I am new to .net, I installed .net sdk and framework.
now I downloaded MSDE and installed it, I got this directory : C:\MSDERelA
but when I double click in the setup file nothing happened, please help me on what should I do .
thanksMay be missing parameters.

Open the ReadmeMSDE2000A.htm and read under the '3.4.4 MSDE 2000 Release A Installation Examples'.

New System.OutOfMemoryException on RTM release

Last week I removed the CTP version of SQL Server 2005 and installed the RTM
SQL Server 2005 Developer from the MSDN downloads. In doing some baseline
testing, I discovered that a trivial query that had been working correctly is
now generating:
"An error occurred while executing batch. Error message is: Exception of
type 'System.OutOfMemoryException' was thrown."
I installed fresh Microsoft Windows Server 2003 Standard + SP + critical
updates.
I installed fresh SQL Server 2005 Developer RTM.
The error still occurs. The query is "select <column> from <table>", where
column is a date_time field. Number of rows in <table> is about 42 million
... a mediums-sized table for our customers.
The machine hardware has not changed. It is a development box with a 3.0GHz
hyperthreaded P4 and 2GB of RAM. Something like 200GB of disk available.
Current space allocated to the database is 2X data size and 2x log size with
autogrowth at 100MB on each.
Only "unusual" thing about the box is that it has an Infineon Trusted
Platform Module installed. Device manager says that its active and working
correctly. In the My Computer -> Properties dialog box on the General tab, in
the Computer: section, below the lines that give the processor and RAM
information, appears the text "Physical Address Extension". I've never seen
this before and I don't know if it's related to the TPM or to the problem for
that matter.
This is looking like a client-side issue. It occurs when going against a
duplicate database an another server (SQL Server 2000) as well. When I
switched output from grid to text it still errored out, but the the error is
"Could not replace text."
The same query in the SQL Server 2000 QA executes will no problem, returned
the expected 42 million+ rows.
"ScottL" wrote:

> Last week I removed the CTP version of SQL Server 2005 and installed the RTM
> SQL Server 2005 Developer from the MSDN downloads. In doing some baseline
> testing, I discovered that a trivial query that had been working correctly is
> now generating:
> "An error occurred while executing batch. Error message is: Exception of
> type 'System.OutOfMemoryException' was thrown."
> I installed fresh Microsoft Windows Server 2003 Standard + SP + critical
> updates.
> I installed fresh SQL Server 2005 Developer RTM.
> The error still occurs. The query is "select <column> from <table>", where
> column is a date_time field. Number of rows in <table> is about 42 million
> ... a mediums-sized table for our customers.
> The machine hardware has not changed. It is a development box with a 3.0GHz
> hyperthreaded P4 and 2GB of RAM. Something like 200GB of disk available.
> Current space allocated to the database is 2X data size and 2x log size with
> autogrowth at 100MB on each.
> Only "unusual" thing about the box is that it has an Infineon Trusted
> Platform Module installed. Device manager says that its active and working
> correctly. In the My Computer -> Properties dialog box on the General tab, in
> the Computer: section, below the lines that give the processor and RAM
> information, appears the text "Physical Address Extension". I've never seen
> this before and I don't know if it's related to the TPM or to the problem for
> that matter.
>
>
|||Hi Scott,
Welcome to use MSDN Managed Newsgroup!
Thanks so much for your detailed information. From your descriptions, I
understood your query via SQL Server 2005 RTM will report the error message
"An error occurred while executing batch. Error message is: Exception of
type 'System.OutOfMemoryException' was thrown". If I have misunderstood
your concern, please feel free to point it out.
Based on my knowledge, since SQL Server Management Studio was built via
.NET technology. The limitation of System.Data.DataRows might be the root
cause for this error message. When total memory footprint was used up by 42
million rows, Management Studio will report System.OutOfMemoryException.
For now, answer/perform the steps below and let me know the result.
1. If you use SELECT statement to select other tables in AdventureWorks,
will it reproduce this behavior? For example
use AdventureWorks
go
SELECT * FROM HumanResources.Employee
go
2. If you change the SELECT statement to be SELECT TOP 100 <column> from
<table>, will you get the result as expected?
3. If you connect SQL Server via SQLCMD instead of SQL Server Management
Studio, will this SELECT statement report the error message?
4. In the SQL Server Management Studio, click menu Query -> Query
Options...
Make sure everything was set to Default and then have a test again.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Michael, thanks for the response. Here are the additional results you
requested:
1. Sorry, AdventureWorks is not loaded, so I instead executed the same query
against a summary table with 2.1 million rows. Result: completed OK. Then I
executed the same query against a detail table with 6.3 million rows. Result:
completed OK.
2. Experimenting with TOP shows that 100 records = OK, 40 million = error,
20 million = OK, 30 million = OK, 35 million = error. So on this system with
it's current processes, it begins to error out between 30 and 35 million rows.
3. I am assuming that you mean to use SQLCMD from the command line so that
it uses OleDB, not SQLCMD Mode in Management Studio. I ran the following
query from a command shell window:
sqlcmd -S <server name> -U sa -P <password> -d <db name> -q "select <column>
from <table>"
Result: Completed OK - 42.x million rows returned.
Actually, I went ahead and ran the query using SQLCMD Mode in Management
Studio as well (so as to try SQLCMD using SqlClient as a provider).
Result: same error, System.OutOfMemoryException
4. I selected Query --> Query Options and on the Query Options dialog
selected the button Reset to Default for each of the property pages. Clicked
OK to close dialog and reran the original query.
Result: same error, System.OutOfMemoryException

> .NET technology. The limitation of System.Data.DataRows might be the root
> cause for this error message. When total memory footprint was used up by 42
Note that it also errors when output is in Text mode. The error message is
"An error occurred while executing batch. Error message is: Couldn't replace
text" I repeated the TOP experiments (#2) in text mode. The results were: 100
rows = OK, 40 million = error, 20 million = error, 10 million = OK, 15
million = error.
Please advise. I know that this is kind of a far-out case, but this is
exactly the kind of thing that some of our customers will do and when it no
longer works with SQL Server 2005, as MS knows, we ISVs will be the
customers' first support call. :-)
Thanks, Scott
"Michael Cheng [MSFT]" wrote:

> Hi Scott,
> Welcome to use MSDN Managed Newsgroup!
> Thanks so much for your detailed information. From your descriptions, I
> understood your query via SQL Server 2005 RTM will report the error message
> "An error occurred while executing batch. Error message is: Exception of
> type 'System.OutOfMemoryException' was thrown". If I have misunderstood
> your concern, please feel free to point it out.
> Based on my knowledge, since SQL Server Management Studio was built via
> .NET technology. The limitation of System.Data.DataRows might be the root
> cause for this error message. When total memory footprint was used up by 42
> million rows, Management Studio will report System.OutOfMemoryException.
> For now, answer/perform the steps below and let me know the result.
> 1. If you use SELECT statement to select other tables in AdventureWorks,
> will it reproduce this behavior? For example
> use AdventureWorks
> go
> SELECT * FROM HumanResources.Employee
> go
> 2. If you change the SELECT statement to be SELECT TOP 100 <column> from
> <table>, will you get the result as expected?
> 3. If you connect SQL Server via SQLCMD instead of SQL Server Management
> Studio, will this SELECT statement report the error message?
> 4. In the SQL Server Management Studio, click menu Query -> Query
> Options...
> Make sure everything was set to Default and then have a test again.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
|||Hi Scott,
Thanks for your testing and prompt update.
I believe too much results bring up the error message:
System.OutOfMemoryException. I am afriad this is a by design "feature" for
SQL Server Management Studio 2005 and we do not have a better workaround
except not using SSMS 2005.
You may also submit your feedback to the site below
http://lab.msdn.microsoft.com/produc...k/default.aspx
If this is urgent, you may open a Support incident with Microsoft Customer
Service and Support (CSS) so that a dedicated Support Professional can work
with you in a more timely and efficient manner. If you need any help in
this regard, please let me know.
Please be advised that contacting phone support will be a charged call.
However, if you are simply requesting a hotfix be sent to you and no other
support then charges are usually refunded or waived.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

New System.OutOfMemoryException on RTM release

Last week I removed the CTP version of SQL Server 2005 and installed the RTM
SQL Server 2005 Developer from the MSDN downloads. In doing some baseline
testing, I discovered that a trivial query that had been working correctly is
now generating:
"An error occurred while executing batch. Error message is: Exception of
type 'System.OutOfMemoryException' was thrown."
I installed fresh Microsoft Windows Server 2003 Standard + SP + critical
updates.
I installed fresh SQL Server 2005 Developer RTM.
The error still occurs. The query is "select <column> from <table>", where
column is a date_time field. Number of rows in <table> is about 42 million
... a mediums-sized table for our customers.
The machine hardware has not changed. It is a development box with a 3.0GHz
hyperthreaded P4 and 2GB of RAM. Something like 200GB of disk available.
Current space allocated to the database is 2X data size and 2x log size with
autogrowth at 100MB on each.
Only "unusual" thing about the box is that it has an Infineon Trusted
Platform Module installed. Device manager says that its active and working
correctly. In the My Computer -> Properties dialog box on the General tab, in
the Computer: section, below the lines that give the processor and RAM
information, appears the text "Physical Address Extension". I've never seen
this before and I don't know if it's related to the TPM or to the problem for
that matter.This is looking like a client-side issue. It occurs when going against a
duplicate database an another server (SQL Server 2000) as well. When I
switched output from grid to text it still errored out, but the the error is
"Could not replace text."
The same query in the SQL Server 2000 QA executes will no problem, returned
the expected 42 million+ rows.
"ScottL" wrote:
> Last week I removed the CTP version of SQL Server 2005 and installed the RTM
> SQL Server 2005 Developer from the MSDN downloads. In doing some baseline
> testing, I discovered that a trivial query that had been working correctly is
> now generating:
> "An error occurred while executing batch. Error message is: Exception of
> type 'System.OutOfMemoryException' was thrown."
> I installed fresh Microsoft Windows Server 2003 Standard + SP + critical
> updates.
> I installed fresh SQL Server 2005 Developer RTM.
> The error still occurs. The query is "select <column> from <table>", where
> column is a date_time field. Number of rows in <table> is about 42 million
> ... a mediums-sized table for our customers.
> The machine hardware has not changed. It is a development box with a 3.0GHz
> hyperthreaded P4 and 2GB of RAM. Something like 200GB of disk available.
> Current space allocated to the database is 2X data size and 2x log size with
> autogrowth at 100MB on each.
> Only "unusual" thing about the box is that it has an Infineon Trusted
> Platform Module installed. Device manager says that its active and working
> correctly. In the My Computer -> Properties dialog box on the General tab, in
> the Computer: section, below the lines that give the processor and RAM
> information, appears the text "Physical Address Extension". I've never seen
> this before and I don't know if it's related to the TPM or to the problem for
> that matter.
>
>|||Hi Scott,
Welcome to use MSDN Managed Newsgroup!
Thanks so much for your detailed information. From your descriptions, I
understood your query via SQL Server 2005 RTM will report the error message
"An error occurred while executing batch. Error message is: Exception of
type 'System.OutOfMemoryException' was thrown". If I have misunderstood
your concern, please feel free to point it out.
Based on my knowledge, since SQL Server Management Studio was built via|||Hi Michael, thanks for the response. Here are the additional results you
requested:
1. Sorry, AdventureWorks is not loaded, so I instead executed the same query
against a summary table with 2.1 million rows. Result: completed OK. Then I
executed the same query against a detail table with 6.3 million rows. Result:
completed OK.
2. Experimenting with TOP shows that 100 records = OK, 40 million = error,
20 million = OK, 30 million = OK, 35 million = error. So on this system with
it's current processes, it begins to error out between 30 and 35 million rows.
3. I am assuming that you mean to use SQLCMD from the command line so that
it uses OleDB, not SQLCMD Mode in Management Studio. I ran the following
query from a command shell window:
sqlcmd -S <server name> -U sa -P <password> -d <db name> -q "select <column>
from <table>"
Result: Completed OK - 42.x million rows returned.
Actually, I went ahead and ran the query using SQLCMD Mode in Management
Studio as well (so as to try SQLCMD using SqlClient as a provider).
Result: same error, System.OutOfMemoryException
4. I selected Query --> Query Options and on the Query Options dialog
selected the button Reset to Default for each of the property pages. Clicked
OK to close dialog and reran the original query.
Result: same error, System.OutOfMemoryException
> .NET technology. The limitation of System.Data.DataRows might be the root
> cause for this error message. When total memory footprint was used up by 42
Note that it also errors when output is in Text mode. The error message is
"An error occurred while executing batch. Error message is: Couldn't replace
text" I repeated the TOP experiments (#2) in text mode. The results were: 100
rows = OK, 40 million = error, 20 million = error, 10 million = OK, 15
million = error.
Please advise. I know that this is kind of a far-out case, but this is
exactly the kind of thing that some of our customers will do and when it no
longer works with SQL Server 2005, as MS knows, we ISVs will be the
customers' first support call. :-)
Thanks, Scott
"Michael Cheng [MSFT]" wrote:
> Hi Scott,
> Welcome to use MSDN Managed Newsgroup!
> Thanks so much for your detailed information. From your descriptions, I
> understood your query via SQL Server 2005 RTM will report the error message
> "An error occurred while executing batch. Error message is: Exception of
> type 'System.OutOfMemoryException' was thrown". If I have misunderstood
> your concern, please feel free to point it out.
> Based on my knowledge, since SQL Server Management Studio was built via
> .NET technology. The limitation of System.Data.DataRows might be the root
> cause for this error message. When total memory footprint was used up by 42
> million rows, Management Studio will report System.OutOfMemoryException.
> For now, answer/perform the steps below and let me know the result.
> 1. If you use SELECT statement to select other tables in AdventureWorks,
> will it reproduce this behavior? For example
> use AdventureWorks
> go
> SELECT * FROM HumanResources.Employee
> go
> 2. If you change the SELECT statement to be SELECT TOP 100 <column> from
> <table>, will you get the result as expected?
> 3. If you connect SQL Server via SQLCMD instead of SQL Server Management
> Studio, will this SELECT statement report the error message?
> 4. In the SQL Server Management Studio, click menu Query -> Query
> Options...
> Make sure everything was set to Default and then have a test again.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Hi Scott,
Thanks for your testing and prompt update.
I believe too much results bring up the error message:
System.OutOfMemoryException. I am afriad this is a by design "feature" for
SQL Server Management Studio 2005 and we do not have a better workaround
except not using SSMS 2005.
You may also submit your feedback to the site below
http://lab.msdn.microsoft.com/productfeedback/default.aspx
If this is urgent, you may open a Support incident with Microsoft Customer
Service and Support (CSS) so that a dedicated Support Professional can work
with you in a more timely and efficient manner. If you need any help in
this regard, please let me know.
Please be advised that contacting phone support will be a charged call.
However, if you are simply requesting a hotfix be sent to you and no other
support then charges are usually refunded or waived.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

New System.OutOfMemoryException on RTM release

Last week I removed the CTP version of SQL Server 2005 and installed the RTM
SQL Server 2005 Developer from the MSDN downloads. In doing some baseline
testing, I discovered that a trivial query that had been working correctly i
s
now generating:
"An error occurred while executing batch. Error message is: Exception of
type 'System.OutOfMemoryException' was thrown."
I installed fresh Microsoft Windows Server 2003 Standard + SP + critical
updates.
I installed fresh SQL Server 2005 Developer RTM.
The error still occurs. The query is "select <column> from <table>", where
column is a date_time field. Number of rows in <table> is about 42 million
... a mediums-sized table for our customers.
The machine hardware has not changed. It is a development box with a 3.0GHz
hyperthreaded P4 and 2GB of RAM. Something like 200GB of disk available.
Current space allocated to the database is 2X data size and 2x log size with
autogrowth at 100MB on each.
Only "unusual" thing about the box is that it has an Infineon Trusted
Platform Module installed. Device manager says that its active and working
correctly. In the My Computer -> Properties dialog box on the General tab, i
n
the Computer: section, below the lines that give the processor and RAM
information, appears the text "Physical Address Extension". I've never seen
this before and I don't know if it's related to the TPM or to the problem fo
r
that matter.This is looking like a client-side issue. It occurs when going against a
duplicate database an another server (SQL Server 2000) as well. When I
switched output from grid to text it still errored out, but the the error is
"Could not replace text."
The same query in the SQL Server 2000 QA executes will no problem, returned
the expected 42 million+ rows.
"ScottL" wrote:

> Last week I removed the CTP version of SQL Server 2005 and installed the R
TM
> SQL Server 2005 Developer from the MSDN downloads. In doing some baseline
> testing, I discovered that a trivial query that had been working correctly
is
> now generating:
> "An error occurred while executing batch. Error message is: Exception of
> type 'System.OutOfMemoryException' was thrown."
> I installed fresh Microsoft Windows Server 2003 Standard + SP + critical
> updates.
> I installed fresh SQL Server 2005 Developer RTM.
> The error still occurs. The query is "select <column> from <table>", where
> column is a date_time field. Number of rows in <table> is about 42 million
> ... a mediums-sized table for our customers.
> The machine hardware has not changed. It is a development box with a 3.0GH
z
> hyperthreaded P4 and 2GB of RAM. Something like 200GB of disk available.
> Current space allocated to the database is 2X data size and 2x log size wi
th
> autogrowth at 100MB on each.
> Only "unusual" thing about the box is that it has an Infineon Trusted
> Platform Module installed. Device manager says that its active and working
> correctly. In the My Computer -> Properties dialog box on the General tab,
in
> the Computer: section, below the lines that give the processor and RAM
> information, appears the text "Physical Address Extension". I've never see
n
> this before and I don't know if it's related to the TPM or to the problem
for
> that matter.
>
>|||Hi Scott,
Welcome to use MSDN Managed Newsgroup!
Thanks so much for your detailed information. From your descriptions, I
understood your query via SQL Server 2005 RTM will report the error message
"An error occurred while executing batch. Error message is: Exception of
type 'System.OutOfMemoryException' was thrown". If I have misunderstood
your concern, please feel free to point it out.
Based on my knowledge, since SQL Server Management Studio was built via
.NET technology. The limitation of System.Data.DataRows might be the root
cause for this error message. When total memory footprint was used up by 42
million rows, Management Studio will report System.OutOfMemoryException.
For now, answer/perform the steps below and let me know the result.
1. If you use SELECT statement to select other tables in AdventureWorks,
will it reproduce this behavior? For example
use AdventureWorks
go
SELECT * FROM HumanResources.Employee
go
2. If you change the SELECT statement to be SELECT TOP 100 <column> from
<table>, will you get the result as expected?
3. If you connect SQL Server via SQLCMD instead of SQL Server Management
Studio, will this SELECT statement report the error message?
4. In the SQL Server Management Studio, click menu Query -> Query
Options...
Make sure everything was set to Default and then have a test again.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael, thanks for the response. Here are the additional results you
requested:
1. Sorry, AdventureWorks is not loaded, so I instead executed the same query
against a summary table with 2.1 million rows. Result: completed OK. Then I
executed the same query against a detail table with 6.3 million rows. Result
:
completed OK.
2. Experimenting with TOP shows that 100 records = OK, 40 million = error,
20 million = OK, 30 million = OK, 35 million = error. So on this system with
it's current processes, it begins to error out between 30 and 35 million row
s.
3. I am assuming that you mean to use SQLCMD from the command line so that
it uses OleDB, not SQLCMD Mode in Management Studio. I ran the following
query from a command shell window:
sqlcmd -S <server name> -U sa -P <password> -d <db name> -q "select <column>
from <table>"
Result: Completed OK - 42.x million rows returned.
Actually, I went ahead and ran the query using SQLCMD Mode in Management
Studio as well (so as to try SQLCMD using SqlClient as a provider).
Result: same error, System.OutOfMemoryException
4. I selected Query --> Query Options and on the Query Options dialog
selected the button Reset to Default for each of the property pages. Clicked
OK to close dialog and reran the original query.
Result: same error, System.OutOfMemoryException

> .NET technology. The limitation of System.Data.DataRows might be the root
> cause for this error message. When total memory footprint was used up by 42[/vbcol
]
Note that it also errors when output is in Text mode. The error message is
"An error occurred while executing batch. Error message is: Couldn't replace
text" I repeated the TOP experiments (#2) in text mode. The results were: 10
0
rows = OK, 40 million = error, 20 million = error, 10 million = OK, 15
million = error.
Please advise. I know that this is kind of a far-out case, but this is
exactly the kind of thing that some of our customers will do and when it no
longer works with SQL Server 2005, as MS knows, we ISVs will be the
customers' first support call. :-)
Thanks, Scott
"Michael Cheng [MSFT]" wrote:
[vbcol=seagreen]
> Hi Scott,
> Welcome to use MSDN Managed Newsgroup!
> Thanks so much for your detailed information. From your descriptions, I
> understood your query via SQL Server 2005 RTM will report the error messag
e
> "An error occurred while executing batch. Error message is: Exception of
> type 'System.OutOfMemoryException' was thrown". If I have misunderstood
> your concern, please feel free to point it out.
> Based on my knowledge, since SQL Server Management Studio was built via
> .NET technology. The limitation of System.Data.DataRows might be the root
> cause for this error message. When total memory footprint was used up by 4
2
> million rows, Management Studio will report System.OutOfMemoryException.
> For now, answer/perform the steps below and let me know the result.
> 1. If you use SELECT statement to select other tables in AdventureWorks,
> will it reproduce this behavior? For example
> use AdventureWorks
> go
> SELECT * FROM HumanResources.Employee
> go
> 2. If you change the SELECT statement to be SELECT TOP 100 <column> from
> <table>, will you get the result as expected?
> 3. If you connect SQL Server via SQLCMD instead of SQL Server Management
> Studio, will this SELECT statement report the error message?
> 4. In the SQL Server Management Studio, click menu Query -> Query
> Options...
> Make sure everything was set to Default and then have a test again.
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
>|||Hi Scott,
Thanks for your testing and prompt update.
I believe too much results bring up the error message:
System.OutOfMemoryException. I am afriad this is a by design "feature" for
SQL Server Management Studio 2005 and we do not have a better workaround
except not using SSMS 2005.
You may also submit your feedback to the site below
http://lab.msdn.microsoft.com/produ...ck/default.aspx
If this is urgent, you may open a Support incident with Microsoft Customer
Service and Support (CSS) so that a dedicated Support Professional can work
with you in a more timely and efficient manner. If you need any help in
this regard, please let me know.
Please be advised that contacting phone support will be a charged call.
However, if you are simply requesting a hotfix be sent to you and no other
support then charges are usually refunded or waived.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.sql

New SQL Server User Questions

I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this part.
Thank you for your help.
Regards,
SailFL
You get a command prompt by going to Start->Run and typing CMD. From that,
you run SQLCMD. From what you have given us, try:
SQLCMD -S NGT\SQLEXPRESS
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"SailFL" <SailFL@.discussions.microsoft.com> wrote in message
news:28954F43-0CBC-42FC-B7BC-B14C3E67BC83@.microsoft.com...
I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this
part.
Thank you for your help.
Regards,
SailFL
|||SQLCMD can be issued from the commadn prompt of Windows, so
Start->Run->cmd
int he doscommand you can type in e.g.
sqlcmd.exe -S NGT\SQLEXPRESS -E
-Whereas NGT is the servername and SQLEXPRESS the instancename
-E if you are using Trusted authentication to connect to the database
server.
You can test the successfull connection therefore that you get no error
are issue a Select command to any table:
USE AdventureWorks
GO
SELECT * from Person.Contact
GO
--or simpler
SELECT 1
GO
HTH, jens Suessmeyer.
|||Thank both you for your assistance.
I was able to use the commands and to attach the AdventureWorks Database to
my SQL server.
SailFL
"Jens" wrote:

> SQLCMD can be issued from the commadn prompt of Windows, so
> Start->Run->cmd
> int he doscommand you can type in e.g.
> sqlcmd.exe -S NGT\SQLEXPRESS -E
> -Whereas NGT is the servername and SQLEXPRESS the instancename
> -E if you are using Trusted authentication to connect to the database
> server.
> You can test the successfull connection therefore that you get no error
> are issue a Select command to any table:
> USE AdventureWorks
> GO
> SELECT * from Person.Contact
> GO
> --or simpler
> SELECT 1
> GO
>
> HTH, jens Suessmeyer.
>

New SQL Server User Questions

I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this part.
Thank you for your help.
Regards,
--
SailFLYou get a command prompt by going to Start->Run and typing CMD. From that,
you run SQLCMD. From what you have given us, try:
SQLCMD -S NGT\SQLEXPRESS
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"SailFL" <SailFL@.discussions.microsoft.com> wrote in message
news:28954F43-0CBC-42FC-B7BC-B14C3E67BC83@.microsoft.com...
I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this
part.
Thank you for your help.
Regards,
SailFL|||SQLCMD can be issued from the commadn prompt of Windows, so
Start->Run->cmd
int he doscommand you can type in e.g.
sqlcmd.exe -S NGT\SQLEXPRESS -E
-Whereas NGT is the servername and SQLEXPRESS the instancename
-E if you are using Trusted authentication to connect to the database
server.
You can test the successfull connection therefore that you get no error
are issue a Select command to any table:
USE AdventureWorks
GO
SELECT * from Person.Contact
GO
--or simpler
SELECT 1
GO
HTH, jens Suessmeyer.|||Thank both you for your assistance.
I was able to use the commands and to attach the AdventureWorks Database to
my SQL server.
--
SailFL
"Jens" wrote:
> SQLCMD can be issued from the commadn prompt of Windows, so
> Start->Run->cmd
> int he doscommand you can type in e.g.
> sqlcmd.exe -S NGT\SQLEXPRESS -E
> -Whereas NGT is the servername and SQLEXPRESS the instancename
> -E if you are using Trusted authentication to connect to the database
> server.
> You can test the successfull connection therefore that you get no error
> are issue a Select command to any table:
> USE AdventureWorks
> GO
> SELECT * from Person.Contact
> GO
> --or simpler
> SELECT 1
> GO
>
> HTH, jens Suessmeyer.
>

New SQL Server User Questions

I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this par
t.
Thank you for your help.
Regards,
SailFLYou get a command prompt by going to Start->Run and typing CMD. From that,
you run SQLCMD. From what you have given us, try:
SQLCMD -S NGT\SQLEXPRESS
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"SailFL" <SailFL@.discussions.microsoft.com> wrote in message
news:28954F43-0CBC-42FC-B7BC-B14C3E67BC83@.microsoft.com...
I have installed SQL Server 2005 Express. I am having trouble understanding
how to connect up with the AdventureWorksDB. Looking at the online book, I
found these instructions:
1) Open the command prompt on the server.
2) From the command prompt, connect to an instance of SQL Server by using
the following sqlcmd command:
sqlcmd -S Server\Instance
Where Server is the name of the computer and Instance is the name of the
instance.
These instructions assume you have some previous knowledge.
1) I am assuming that you are in the SQL Server Management Express Console.
2) How do you open the command prompt? Or where is it?
3) The "sqlcmd -S Server\Instance" instruction. I looked at the SQL Server
Service Manager and I believe I have the right information for my
installation: Server = NGT\SQLEXPRESS and Instance = SQL Server which came
from the Services:.
If this is not correct, what name do I use for the Server and Instance?
After I run this command, what will the results be and how will I know they
have run correctly?
I believe I can follow the remaining instructions if I can get past this
part.
Thank you for your help.
Regards,
SailFL|||SQLCMD can be issued from the commadn prompt of Windows, so
Start->Run->cmd
int he doscommand you can type in e.g.
sqlcmd.exe -S NGT\SQLEXPRESS -E
-Whereas NGT is the servername and SQLEXPRESS the instancename
-E if you are using Trusted authentication to connect to the database
server.
You can test the successfull connection therefore that you get no error
are issue a Select command to any table:
USE AdventureWorks
GO
SELECT * from Person.Contact
GO
--or simpler
SELECT 1
GO
HTH, jens Suessmeyer.|||Thank both you for your assistance.
I was able to use the commands and to attach the AdventureWorks Database to
my SQL server.
SailFL
"Jens" wrote:

> SQLCMD can be issued from the commadn prompt of Windows, so
> Start->Run->cmd
> int he doscommand you can type in e.g.
> sqlcmd.exe -S NGT\SQLEXPRESS -E
> -Whereas NGT is the servername and SQLEXPRESS the instancename
> -E if you are using Trusted authentication to connect to the database
> server.
> You can test the successfull connection therefore that you get no error
> are issue a Select command to any table:
> USE AdventureWorks
> GO
> SELECT * from Person.Contact
> GO
> --or simpler
> SELECT 1
> GO
>
> HTH, jens Suessmeyer.
>

New SQL Server Registration

Hello,
I just installed SS2K5 Developer's edition (MSDN). I am unable to create a
new SQL Server Registration. Any help with this would be appreciated.
--
Thanks in advance,
sck10What exactly is the problem?
Try View, Registered Servers. Click and then right-click Database Engine,
New, Server Registration. Complete the data, Test and Save.
Ben Nevarez, MCDBA, OCP
Database Administrator
"sck10" wrote:
> Hello,
> I just installed SS2K5 Developer's edition (MSDN). I am unable to create a
> new SQL Server Registration. Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>
>

New SQL Server Registration

Hello,
I just installed SS2K5 Developer's edition (MSDN). I am unable to create a
new SQL Server Registration. Any help with this would be appreciated.
--
Thanks in advance,
sck10What exactly is the problem?
Try View, Registered Servers. Click and then right-click Database Engine,
New, Server Registration. Complete the data, Test and Save.
Ben Nevarez, MCDBA, OCP
Database Administrator
"sck10" wrote:

> Hello,
> I just installed SS2K5 Developer's edition (MSDN). I am unable to create
a
> new SQL Server Registration. Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>
>

New SQL Server registartion problem

Hi everybody,
I have 2 systems with operating system 2003 on both of them.
I have installed the SQL Server 2000 on both machines with instance name
as SQLServer1 and SQLServer2.
I have created a SQL Server group on one machine on which SQLServer1
instance is created.Now on this machine i want to register SQLServer2
through new SQL Server registration wizard (SQLServer2 is instance
created on anather machine and both machines are in same domain). But at
the end of the wizard i am getting error as,
"SQL Server registrtion failed because of the connection failure
displayed as below. Do you wish to register any way?".
"SQL Server does not exists or access denied".
So please let me know how to overcome this problem.
Thanks in advance,
Regards
Vishal
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!The message indicates that the SQL Server service is either not running or
you are not able to connect to the SQL Server machine. Are you able to ping
the SQL Server machine from the client machine? Some information on
troubleshooting connectivity issues at:
http://support.microsoft.com/default.aspx?kbid=812817
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Vishal Pawar" <pv_vishal@.hotmail.com> wrote in message
news:uhNVIfZZEHA.3304@.TK2MSFTNGP09.phx.gbl...
Hi everybody,
I have 2 systems with operating system 2003 on both of them.
I have installed the SQL Server 2000 on both machines with instance name
as SQLServer1 and SQLServer2.
I have created a SQL Server group on one machine on which SQLServer1
instance is created.Now on this machine i want to register SQLServer2
through new SQL Server registration wizard (SQLServer2 is instance
created on anather machine and both machines are in same domain). But at
the end of the wizard i am getting error as,
"SQL Server registrtion failed because of the connection failure
displayed as below. Do you wish to register any way?".
"SQL Server does not exists or access denied".
So please let me know how to overcome this problem.
Thanks in advance,
Regards
Vishal
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

New SQL Server registartion problem

Hi everybody,
I have 2 systems with operating system 2003 on both of them.
I have installed the SQL Server 2000 on both machines with instance name
as SQLServer1 and SQLServer2.
I have created a SQL Server group on one machine on which SQLServer1
instance is created.Now on this machine i want to register SQLServer2
through new SQL Server registration wizard (SQLServer2 is instance
created on anather machine and both machines are in same domain). But at
the end of the wizard i am getting error as,
"SQL Server registrtion failed because of the connection failure
displayed as below. Do you wish to register any way?".
"SQL Server does not exists or access denied".
So please let me know how to overcome this problem.
Thanks in advance,
Regards
Vishal
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
The message indicates that the SQL Server service is either not running or
you are not able to connect to the SQL Server machine. Are you able to ping
the SQL Server machine from the client machine? Some information on
troubleshooting connectivity issues at:
http://support.microsoft.com/default.aspx?kbid=812817
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Vishal Pawar" <pv_vishal@.hotmail.com> wrote in message
news:uhNVIfZZEHA.3304@.TK2MSFTNGP09.phx.gbl...
Hi everybody,
I have 2 systems with operating system 2003 on both of them.
I have installed the SQL Server 2000 on both machines with instance name
as SQLServer1 and SQLServer2.
I have created a SQL Server group on one machine on which SQLServer1
instance is created.Now on this machine i want to register SQLServer2
through new SQL Server registration wizard (SQLServer2 is instance
created on anather machine and both machines are in same domain). But at
the end of the wizard i am getting error as,
"SQL Server registrtion failed because of the connection failure
displayed as below. Do you wish to register any way?".
"SQL Server does not exists or access denied".
So please let me know how to overcome this problem.
Thanks in advance,
Regards
Vishal
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!