Can I hide system objects in QA like in EM

...using SQL SERVER 2k
I know how to hide system objects in Enterprise Manager, but can this same
sort of thing be done in Query Analyzer... like what I see done on the Server
tab of Visual Studio?
thanks
kevin
No, that functionality is not available in QA. All you have is the pre-defined folders for user
tables and system tables. No such for stored procedures, but I hope that you don't have user
procedures in master? :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kevin" <kevin@.discussions.microsoft.com> wrote in message
news:56016547-01C2-4E59-9F6B-5FD784744711@.microsoft.com...
> ...using SQL SERVER 2k
> I know how to hide system objects in Enterprise Manager, but can this same
> sort of thing be done in Query Analyzer... like what I see done on the Server
> tab of Visual Studio?
> thanks
> kevin
|||"Tibor Karaszi" wrote:

> No, that functionality is not available in QA. All you have is the pre-defined folders for user
> tables and system tables. No such for stored procedures, but I hope that you don't have user
> procedures in master? :-)
No, of course not. And I am not referring to the master, model, etc database.
In Enterprise Manager, in user created databases there are a number of SPs,
tables and views that are hidden if you select to hide system objects.
Obviously SQL SERVER/EM is intelligent enough to recognize the difference,
but Query Analyzer doesn't seem to be able to. Even users restricted to a
single DB can see master in QA.
It leads to a lot of scrolling to get to that one SP.
thanks
kevin
|||I see what you mean.
QA:
Tables:
These are already in separate folders, right?
Procedures:
You can delete the dt_ procedures, but they will come back when anyone uses EM to create diagram
etc.
Views:
The three system views will always be shown.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kevin" <kevin@.discussions.microsoft.com> wrote in message
news:7BC4ED53-51A9-441C-BA8F-F5318B56FE7B@.microsoft.com...
> "Tibor Karaszi" wrote:
>
> No, of course not. And I am not referring to the master, model, etc database.
> In Enterprise Manager, in user created databases there are a number of SPs,
> tables and views that are hidden if you select to hide system objects.
> Obviously SQL SERVER/EM is intelligent enough to recognize the difference,
> but Query Analyzer doesn't seem to be able to. Even users restricted to a
> single DB can see master in QA.
> It leads to a lot of scrolling to get to that one SP.
> thanks
> kevin
|||Ah!!! Now you see. Its only the SP's that are a pain... honestly my middle
finger is cramping from all this damn scrolling. I just have to increase the
number of lines the scroll button moves with the mouse setup.
peace
kevin
"Tibor Karaszi" wrote:

> I see what you mean.
> QA:
> Tables:
> These are already in separate folders, right?
> Procedures:
> You can delete the dt_ procedures, but they will come back when anyone uses EM to create diagram
> etc.
> Views:
> The three system views will always be shown.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "kevin" <kevin@.discussions.microsoft.com> wrote in message
> news:7BC4ED53-51A9-441C-BA8F-F5318B56FE7B@.microsoft.com...
>
>

Can I have different SQL clients co-exist?

Can I have both SQL 6.5 client (Enterprise Manager, ISQL_w etc) and SQL 2000
(Enterprise Manager, SQL Analyzer) installed on the same machine?
Ippy wrote:
> Can I have both SQL 6.5 client (Enterprise Manager, ISQL_w etc) and
> SQL 2000 (Enterprise Manager, SQL Analyzer) installed on the same
> machine?
I don't believe that is supported. You can do what you want using a tool
like VirtualPC from Microsoft or VMWare. That is, you can run a virtual
PC and install whatever you want and have the virtual session connect
with your main PC or other PCs on your network.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Hi
It is possible and usable, but due to the fact that SQL Server 6.5 is no
longer supported by Microsoft, and Service Packs and hotfixes for SQL Server
2000 you may apply might break it.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Ippy" <Ippy@.discussions.microsoft.com> wrote in message
news:857A42FB-1367-4278-A23E-4219812D495E@.microsoft.com...
> Can I have both SQL 6.5 client (Enterprise Manager, ISQL_w etc) and SQL
> 2000
> (Enterprise Manager, SQL Analyzer) installed on the same machine?
|||Hi,
Yes, you install SQL 6.5 and SQL 2000 in same machine. As well as you can
execute ISQLW and Enterprise manager of both versions in parallel.
Note:
If you are installing SQL 2000 client in a machine with SQL 7 client, the
SQL 2000 setup program will overwrite your SQL 7 client tools.
But SQL 2000 client tools support all SQL 7 activities.
Thanks
Hari
SQL Server MVP
"Ippy" <Ippy@.discussions.microsoft.com> wrote in message
news:857A42FB-1367-4278-A23E-4219812D495E@.microsoft.com...
> Can I have both SQL 6.5 client (Enterprise Manager, ISQL_w etc) and SQL
> 2000
> (Enterprise Manager, SQL Analyzer) installed on the same machine?
sql

can I export a database from query analyzer?

Is there a command or script I can run from query analyzer to export a
database?
Its a long story but I can only get to the database through query analyzer
and there is one database I need to pull out to another machine.
Thanks,
You can do a couple of things:
1) Backup the database and then restore it on the other server. Refer to SQL Server Books Online for syntax and examples
2) If you have a copy of the database files (data + logs) then you can use sp_attach_db to attach the database files on another server.
3) If you don't have the database files but can take the database offline for sometime then you can take the database offline (one method will be to use sp_dboption) then
copy the files to the new server. Now you can take db online. connect to the new server using QA and use sp_attach_db
HTH,
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||Great I do have the database files and log. I will just attach those in
another instance.
Thanks for your help.
"Uttam Parui[MS]" wrote:

> You can do a couple of things:
> 1) Backup the database and then restore it on the other server. Refer to SQL Server Books Online for syntax and examples
> 2) If you have a copy of the database files (data + logs) then you can use sp_attach_db to attach the database files on another server.
> 3) If you don't have the database files but can take the database offline for sometime then you can take the database offline (one method will be to use sp_dboption) then
> copy the files to the new server. Now you can take db online. connect to the new server using QA and use sp_attach_db
> HTH,
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
> to do this is to visit the following websites: http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
sql

Can I do this in SQL Analyzer or with a dts package?

I am not sure how to approach this problem or if I can even do it
within SQL.

Say I have 2 tables invoice_hdr and invoice_dtl. I want to pull
specific fields from both tables, I want the data to be grouped
together however I want the information to be on different lines. One
for the information from the header and one for each corresponding
detail record.

So my output might look like

Invoice_number (1), Invoice_date, Customer_Number
Item_number (1-1), qty, price, description
Item_number (1-2), qty, price, description

Invoice_number (2), Invoice_data, Customer_number
Item_number (2-1), qty, price, description
Item_number (2-2), qty, price, description
Item_number (2-3), qty, price, description

etc..
So the invoice_number (1) is my first invoice and item_number (1-1)
would be the 1st item on tins invoice, etc...

My ultimate goal is to export this to a text or csv file.
Thanks.Hi Mike,

It can be done in a SQL stored proc but it will get kind of ugly. Basically
it sounds like you are taking two tables and trying to return one result set
(with 1 schema) or maybe just one text (varchar) column with all the data
written and concatenated as text.

Using VB Script, or a console application written in C, VB.Net or something
you could have your stored proc return two result sets in Invoice Number
order and then create the text (CSV file) by marching through the two
recordsets (if you are using ADO) and outputing records to your text file in
the application that calls the stored proc.

If you use VB Script you could put that in a DTS Package, Call the stored
proc and create the output file.

What is the schema of invoice_hdr and invoice_dtl?

-Dick Christoph
"mike" <mike.a.rea@.gmail.com> wrote in message
news:1141241610.678093.61540@.v46g2000cwv.googlegro ups.com...
>I am not sure how to approach this problem or if I can even do it
> within SQL.
> Say I have 2 tables invoice_hdr and invoice_dtl. I want to pull
> specific fields from both tables, I want the data to be grouped
> together however I want the information to be on different lines. One
> for the information from the header and one for each corresponding
> detail record.
> So my output might look like
> Invoice_number (1), Invoice_date, Customer_Number
> Item_number (1-1), qty, price, description
> Item_number (1-2), qty, price, description
> Invoice_number (2), Invoice_data, Customer_number
> Item_number (2-1), qty, price, description
> Item_number (2-2), qty, price, description
> Item_number (2-3), qty, price, description
> etc..
> So the invoice_number (1) is my first invoice and item_number (1-1)
> would be the 1st item on tins invoice, etc...
> My ultimate goal is to export this to a text or csv file.
> Thanks.|||If you are pushing this through some sort of parser, grid, asp page,
etc., here's what I usually do...

1) Use correlated tables with two datasets. Google search for
that--some of the .net controls support it via nesting.

2) Return everything on every record. e.g.
Invoice_number (1), Invoice_date, Customer_Number, Item_number (1-1),
qty, price, description
Invoice_number (1), Invoice_date, Customer_Number, Item_number (1-2),
qty, price, description
Invoice_number (1), Invoice_date, Customer_Number, Item_number (1-3),
qty, price, description

Then when you display this, just check neighbor rows (pseudocode):

For Each Row
If PreviousRow.InvoiceNumber <> CurrentRow.InvoiceNumber Then
Output Header Row (invoicenum, date, cust num)
Output Detail row(item number, qty, price, description)
Else
Output Detail row(item number, qty, price, description)
End If
Next

Sure this approach returns some data you won't use for every row but it
is very easy to do, and involves just one record set.

You could presumably implement this approach or DickChristoph's idea in
a cursor, too.sql

can connect using sql query analyzer but not osql or isql

I have a SQL server 2000 enterprise edition installed on windows 2000
advanced server. It starts successfully and using SQL query analyzer, I can
connect to it using windows authentication and execute sql statements without
a problem.
But when I used isql (either just isql or isql [-U login id]), I got the
following error message:
Msg 18456, Level 14, State 1:
Login failed for user 'Administrator'.
DB-Library: Login incorrect.
If I use osql,
I got:
Login failed for user 'Administrator'.
Weirdly, NO logon information is recorded in ERRORLOG.
In SQL query analyzer, I used the login id Administrator, which is what I
used to login to Windows.
After installation of sql server, we changed the password of Windows
Administrator account, so there might be a password mismatch. But I can use
the new password
to connect to sql server in SQL query analyzer, but not osql or isql.
I tried osql and isql with both the new password and the old one(not sure if
it is correct), but neither of them worked.
What might be the cause?
Thank you very much,
I think you're confusing Windows authentication with SQL
authentication. When you try connecting with osql try the -E (trusted
login) parameter rather than -U Administrator. With Windows
authentication you don't specify a password as the windows security
token for your windows account is used instead (which has already been
authenticated by a domain controller).
*mike hodgson*
http://sqlnerd.blogspot.com
Tammy wrote:

>I have a SQL server 2000 enterprise edition installed on windows 2000
>advanced server. It starts successfully and using SQL query analyzer, I can
>connect to it using windows authentication and execute sql statements without
>a problem.
>But when I used isql (either just isql or isql [-U login id]), I got the
>following error message:
>Msg 18456, Level 14, State 1:
>Login failed for user 'Administrator'.
>DB-Library: Login incorrect.
>If I use osql,
>I got:
>Login failed for user 'Administrator'.
>Weirdly, NO logon information is recorded in ERRORLOG.
>In SQL query analyzer, I used the login id Administrator, which is what I
>used to login to Windows.
>After installation of sql server, we changed the password of Windows
>Administrator account, so there might be a password mismatch. But I can use
>the new password
>to connect to sql server in SQL query analyzer, but not osql or isql.
>I tried osql and isql with both the new password and the old one(not sure if
>it is correct), but neither of them worked.
>What might be the cause?
>Thank you very much,
>
>
|||It works! Thank you, Mike.
"Mike Hodgson" wrote:

> I think you're confusing Windows authentication with SQL
> authentication. When you try connecting with osql try the -E (trusted
> login) parameter rather than -U Administrator. With Windows
> authentication you don't specify a password as the windows security
> token for your windows account is used instead (which has already been
> authenticated by a domain controller).
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Tammy wrote:
>

can connect using sql query analyzer but not osql or isql

I have a SQL server 2000 enterprise edition installed on windows 2000
advanced server. It starts successfully and using SQL query analyzer, I can
connect to it using windows authentication and execute sql statements withou
t
a problem.
But when I used isql (either just isql or isql [-U login id]), I got the
following error message:
Msg 18456, Level 14, State 1:
Login failed for user 'Administrator'.
DB-Library: Login incorrect.
If I use osql,
I got:
Login failed for user 'Administrator'.
Weirdly, NO logon information is recorded in ERRORLOG.
In SQL query analyzer, I used the login id Administrator, which is what I
used to login to Windows.
After installation of sql server, we changed the password of Windows
Administrator account, so there might be a password mismatch. But I can use
the new password
to connect to sql server in SQL query analyzer, but not osql or isql.
I tried osql and isql with both the new password and the old one(not sure if
it is correct), but neither of them worked.
What might be the cause?
Thank you very much,I think you're confusing Windows authentication with SQL
authentication. When you try connecting with osql try the -E (trusted
login) parameter rather than -U Administrator. With Windows
authentication you don't specify a password as the windows security
token for your windows account is used instead (which has already been
authenticated by a domain controller).
*mike hodgson*
http://sqlnerd.blogspot.com
Tammy wrote:

>I have a SQL server 2000 enterprise edition installed on windows 2000
>advanced server. It starts successfully and using SQL query analyzer, I can
>connect to it using windows authentication and execute sql statements witho
ut
>a problem.
>But when I used isql (either just isql or isql [-U login id]), I got th
e
>following error message:
>Msg 18456, Level 14, State 1:
>Login failed for user 'Administrator'.
>DB-Library: Login incorrect.
>If I use osql,
>I got:
>Login failed for user 'Administrator'.
>Weirdly, NO logon information is recorded in ERRORLOG.
>In SQL query analyzer, I used the login id Administrator, which is what I
>used to login to Windows.
>After installation of sql server, we changed the password of Windows
>Administrator account, so there might be a password mismatch. But I can use
>the new password
>to connect to sql server in SQL query analyzer, but not osql or isql.
>I tried osql and isql with both the new password and the old one(not sure i
f
>it is correct), but neither of them worked.
>What might be the cause?
>Thank you very much,
>
>|||It works! Thank you, Mike.
"Mike Hodgson" wrote:

> I think you're confusing Windows authentication with SQL
> authentication. When you try connecting with osql try the -E (trusted
> login) parameter rather than -U Administrator. With Windows
> authentication you don't specify a password as the windows security
> token for your windows account is used instead (which has already been
> authenticated by a domain controller).
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Tammy wrote:
>
>

can connect using sql query analyzer but not osql or isql

I have a SQL server 2000 enterprise edition installed on windows 2000
advanced server. It starts successfully and using SQL query analyzer, I can
connect to it using windows authentication and execute sql statements without
a problem.
But when I used isql (either just isql or isql [-U login id]), I got the
following error message:
Msg 18456, Level 14, State 1:
Login failed for user 'Administrator'.
DB-Library: Login incorrect.
If I use osql,
I got:
Login failed for user 'Administrator'.
Weirdly, NO logon information is recorded in ERRORLOG.
In SQL query analyzer, I used the login id Administrator, which is what I
used to login to Windows.
After installation of sql server, we changed the password of Windows
Administrator account, so there might be a password mismatch. But I can use
the new password
to connect to sql server in SQL query analyzer, but not osql or isql.
I tried osql and isql with both the new password and the old one(not sure if
it is correct), but neither of them worked.
What might be the cause?
Thank you very much,This is a multi-part message in MIME format.
--070107040706020904060707
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
I think you're confusing Windows authentication with SQL
authentication. When you try connecting with osql try the -E (trusted
login) parameter rather than -U Administrator. With Windows
authentication you don't specify a password as the windows security
token for your windows account is used instead (which has already been
authenticated by a domain controller).
--
*mike hodgson*
http://sqlnerd.blogspot.com
Tammy wrote:
>I have a SQL server 2000 enterprise edition installed on windows 2000
>advanced server. It starts successfully and using SQL query analyzer, I can
>connect to it using windows authentication and execute sql statements without
>a problem.
>But when I used isql (either just isql or isql [-U login id]), I got the
>following error message:
>Msg 18456, Level 14, State 1:
>Login failed for user 'Administrator'.
>DB-Library: Login incorrect.
>If I use osql,
>I got:
>Login failed for user 'Administrator'.
>Weirdly, NO logon information is recorded in ERRORLOG.
>In SQL query analyzer, I used the login id Administrator, which is what I
>used to login to Windows.
>After installation of sql server, we changed the password of Windows
>Administrator account, so there might be a password mismatch. But I can use
>the new password
>to connect to sql server in SQL query analyzer, but not osql or isql.
>I tried osql and isql with both the new password and the old one(not sure if
>it is correct), but neither of them worked.
>What might be the cause?
>Thank you very much,
>
>
--070107040706020904060707
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>I think you're confusing Windows authentication with SQL
authentication. When you try connecting with osql try the -E (trusted
login) parameter rather than -U Administrator. With Windows
authentication you don't specify a password as the windows security
token for your windows account is used instead (which has already been
authenticated by a domain controller).</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Tammy wrote:
<blockquote cite="mid2F4B9DBB-392C-4D73-B9E0-5709FE1E206F@.microsoft.com"
type="cite">
<pre wrap="">I have a SQL server 2000 enterprise edition installed on windows 2000
advanced server. It starts successfully and using SQL query analyzer, I can
connect to it using windows authentication and execute sql statements without
a problem.
But when I used isql (either just isql or isql [-U login id]), I got the
following error message:
Msg 18456, Level 14, State 1:
Login failed for user 'Administrator'.
DB-Library: Login incorrect.
If I use osql,
I got:
Login failed for user 'Administrator'.
Weirdly, NO logon information is recorded in ERRORLOG.
In SQL query analyzer, I used the login id Administrator, which is what I
used to login to Windows.
After installation of sql server, we changed the password of Windows
Administrator account, so there might be a password mismatch. But I can use
the new password
to connect to sql server in SQL query analyzer, but not osql or isql.
I tried osql and isql with both the new password and the old one(not sure if
it is correct), but neither of them worked.
What might be the cause?
Thank you very much,
</pre>
</blockquote>
</body>
</html>
--070107040706020904060707--|||It works! Thank you, Mike.
"Mike Hodgson" wrote:
> I think you're confusing Windows authentication with SQL
> authentication. When you try connecting with osql try the -E (trusted
> login) parameter rather than -U Administrator. With Windows
> authentication you don't specify a password as the windows security
> token for your windows account is used instead (which has already been
> authenticated by a domain controller).
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Tammy wrote:
> >I have a SQL server 2000 enterprise edition installed on windows 2000
> >advanced server. It starts successfully and using SQL query analyzer, I can
> >connect to it using windows authentication and execute sql statements without
> >a problem.
> >
> >But when I used isql (either just isql or isql [-U login id]), I got the
> >following error message:
> >Msg 18456, Level 14, State 1:
> >Login failed for user 'Administrator'.
> >DB-Library: Login incorrect.
> >
> >If I use osql,
> >I got:
> >Login failed for user 'Administrator'.
> >
> >Weirdly, NO logon information is recorded in ERRORLOG.
> >
> >In SQL query analyzer, I used the login id Administrator, which is what I
> >used to login to Windows.
> >After installation of sql server, we changed the password of Windows
> >Administrator account, so there might be a password mismatch. But I can use
> >the new password
> >to connect to sql server in SQL query analyzer, but not osql or isql.
> >
> >I tried osql and isql with both the new password and the old one(not sure if
> >it is correct), but neither of them worked.
> >
> >What might be the cause?
> >
> >Thank you very much,
> >
> >
> >
>

CAN CONNECT ONE WAY TO SQL SERVER BUT NOT BACK

There is a Remote SQL server 2000 server that can connect (register
thru query analyzer or enterprise manager) with 3 remote Sql server
2000 servers without issue. When these 3 servers try and connect back
(thru query analyzer or enterprise manager) I get the "SQL Server does
not exist or access denied" error message.
I have confirmed with my network guys that the request is making it to
the server so the failure point is at the server (Windows 2003). the
firewall is turned off so I know that is not the issue.
Any insight would be very helpful.
you may read the following kb for a possible resolution:
http://support.microsoft.com/default...b;en-us;827422
-billyy
"csmftbb" <andrew.farris@.sbcglobal-dot-net.no-spam.invalid> ?
news:e5qdnXI6DIJiKgvfRVn_vg@.giganews.com...
> There is a Remote SQL server 2000 server that can connect (register
> thru query analyzer or enterprise manager) with 3 remote Sql server
> 2000 servers without issue. When these 3 servers try and connect back
> (thru query analyzer or enterprise manager) I get the "SQL Server does
> not exist or access denied" error message.
> I have confirmed with my network guys that the request is making it to
> the server so the failure point is at the server (Windows 2003). the
> firewall is turned off so I know that is not the issue.
> Any insight would be very helpful.
>

CAN CONNECT ONE WAY TO SQL SERVER BUT NOT BACK

There is a Remote SQL server 2000 server that can connect (register
thru query analyzer or enterprise manager) with 3 remote Sql server
2000 servers without issue. When these 3 servers try and connect back
(thru query analyzer or enterprise manager) I get the "SQL Server does
not exist or access denied" error message.
I have confirmed with my network guys that the request is making it to
the server so the failure point is at the server (Windows 2003). the
firewall is turned off so I know that is not the issue.
Any insight would be very helpful.you may read the following kb for a possible resolution:
http://support.microsoft.com/defaul...kb;en-us;827422
-billyy
"csmftbb" <andrew.farris@.sbcglobal-dot-net.no-spam.invalid> '
news:e5qdnXI6DIJiKgvfRVn_vg@.giganews.com...
> There is a Remote SQL server 2000 server that can connect (register
> thru query analyzer or enterprise manager) with 3 remote Sql server
> 2000 servers without issue. When these 3 servers try and connect back
> (thru query analyzer or enterprise manager) I get the "SQL Server does
> not exist or access denied" error message.
> I have confirmed with my network guys that the request is making it to
> the server so the failure point is at the server (Windows 2003). the
> firewall is turned off so I know that is not the issue.
> Any insight would be very helpful.
>

Can connect from Query Analyzer but not from Report Services

I can terminal service into the box running Reporting Services. If I try to
run the
report I can't connect, it says login failed. Using the same
username/password which is sa because it's a log shipped server. I can
connect through Query Analizer. The only rememdy is to restart both servers.
Then I can connect. Then it will go hey wire after a day or two and same
situation. What could be causing this?
Please help me,
BryanAlso if I try to do net stop reportserver it says the server is not
responding to the control function. Actually the same thing happens if I try
to shut down the secondary log shipped server that the reports are pointing
at. If I do net stop mssqlserver. It gives me the same error. Something is
going on here between the two and I can't figure out what it is that is going
on?
"bmurtha" wrote:
> I can terminal service into the box running Reporting Services. If I try to
> run the
> report I can't connect, it says login failed. Using the same
> username/password which is sa because it's a log shipped server. I can
> connect through Query Analizer. The only rememdy is to restart both servers.
> Then I can connect. Then it will go hey wire after a day or two and same
> situation. What could be causing this?
> Please help me,
> Bryan

Calling web services from Query Analyzer

I've made a database change to a table to add home and
operational amounts. In an upgrade path, I need to
populate these columns with values. There is already C#
code that does the currency conversion based on comparing
transactional currency to both the home and operational
currency codes. Right now, our upgrade scripts are run
via Query Analyzer. Is there a way for me to call web
services and execute methods that have already been
written to do the currency conversion for me? I'd hate to
reinvent the wheel and rewrite code for something that's
already been in done C#.
We are running SQL Server 2000.
Thanks in advance,
BettinaSQL Server's T-SQL language doesn't have any in-built features that can
perform any kind of http calls - soap or otherwise.
T-SQL does provide ability to call external libraries and operating system
commands via things such as sp_OACreate (COM) and xp_cmdshell (console
commands), so it's arguable that your could conceivably call a web-service
from within the Query Analyser, consume it with sp_xml_preparedocument etc
but this is really getting into the zen mastery area & not really what Query
Analyser was designed to perform.
You might do better writing a VBScript or JScript & running that as a DTS
package, or perhaps just coding something in a VS.Net project (with
whatever's your favourite language flavour..)
Regards,
Greg Linwood
SQL Server MVP
"bpdee" <anonymous@.discussions.microsoft.com> wrote in message
news:cb4301c3ef43$84912d60$a101280a@.phx.gbl...
> I've made a database change to a table to add home and
> operational amounts. In an upgrade path, I need to
> populate these columns with values. There is already C#
> code that does the currency conversion based on comparing
> transactional currency to both the home and operational
> currency codes. Right now, our upgrade scripts are run
> via Query Analyzer. Is there a way for me to call web
> services and execute methods that have already been
> written to do the currency conversion for me? I'd hate to
> reinvent the wheel and rewrite code for something that's
> already been in done C#.
> We are running SQL Server 2000.
> Thanks in advance,
> Bettina
>|||Hi Greg,
Thank you so much for your response. Unfortunately, I'm
not a database programmer (I only have experience as an
Oracle Forms programmer) and I am not knowledgeable in
creating VBScripts, JScript, or writing something up using
VS .NET. I was hoping to find an easier answer.
Thanks again for your response.
Bettina

>--Original Message--
>SQL Server's T-SQL language doesn't have any in-built
features that can
>perform any kind of http calls - soap or otherwise.
>T-SQL does provide ability to call external libraries and
operating system
>commands via things such as sp_OACreate (COM) and
xp_cmdshell (console
>commands), so it's arguable that your could conceivably
call a web-service
>from within the Query Analyser, consume it with
sp_xml_preparedocument etc
>but this is really getting into the zen mastery area &
not really what Query
>Analyser was designed to perform.
>You might do better writing a VBScript or JScript &
running that as a DTS
>package, or perhaps just coding something in a VS.Net
project (with
>whatever's your favourite language flavour..)
>Regards,
>Greg Linwood
>SQL Server MVP
>"bpdee" <anonymous@.discussions.microsoft.com> wrote in
message
>news:cb4301c3ef43$84912d60$a101280a@.phx.gbl...
comparing
to
>
>.
>|||Sorry there's not an easier answer.. :c/
This (xml, soap etc) is an area where things are improving in SQL Server but
for now it's not a simple task to perform in QA & is better suited to
language development..
Regards,
Greg Linwood
SQL Server MVP
"bpdee" <anonymous@.discussions.microsoft.com> wrote in message
news:d76901c3ef5c$3bad51f0$a401280a@.phx.gbl...
> Hi Greg,
> Thank you so much for your response. Unfortunately, I'm
> not a database programmer (I only have experience as an
> Oracle Forms programmer) and I am not knowledgeable in
> creating VBScripts, JScript, or writing something up using
> VS .NET. I was hoping to find an easier answer.
> Thanks again for your response.
> Bettina
>
> features that can
> operating system
> xp_cmdshell (console
> call a web-service
> sp_xml_preparedocument etc
> not really what Query
> running that as a DTS
> project (with
> message
> comparing
> to

Calling web services from Query Analyzer

I've made a database change to a table to add home and
operational amounts. In an upgrade path, I need to
populate these columns with values. There is already C#
code that does the currency conversion based on comparing
transactional currency to both the home and operational
currency codes. Right now, our upgrade scripts are run
via Query Analyzer. Is there a way for me to call web
services and execute methods that have already been
written to do the currency conversion for me? I'd hate to
reinvent the wheel and rewrite code for something that's
already been in done C#.
We are running SQL Server 2000.
Thanks in advance,
BettinaSQL Server's T-SQL language doesn't have any in-built features that can
perform any kind of http calls - soap or otherwise.
T-SQL does provide ability to call external libraries and operating system
commands via things such as sp_OACreate (COM) and xp_cmdshell (console
commands), so it's arguable that your could conceivably call a web-service
from within the Query Analyser, consume it with sp_xml_preparedocument etc
but this is really getting into the zen mastery area & not really what Query
Analyser was designed to perform.
You might do better writing a VBScript or JScript & running that as a DTS
package, or perhaps just coding something in a VS.Net project (with
whatever's your favourite language flavour..)
Regards,
Greg Linwood
SQL Server MVP
"bpdee" <anonymous@.discussions.microsoft.com> wrote in message
news:cb4301c3ef43$84912d60$a101280a@.phx.gbl...
> I've made a database change to a table to add home and
> operational amounts. In an upgrade path, I need to
> populate these columns with values. There is already C#
> code that does the currency conversion based on comparing
> transactional currency to both the home and operational
> currency codes. Right now, our upgrade scripts are run
> via Query Analyzer. Is there a way for me to call web
> services and execute methods that have already been
> written to do the currency conversion for me? I'd hate to
> reinvent the wheel and rewrite code for something that's
> already been in done C#.
> We are running SQL Server 2000.
> Thanks in advance,
> Bettina
>|||Hi Greg,
Thank you so much for your response. Unfortunately, I'm
not a database programmer (I only have experience as an
Oracle Forms programmer) and I am not knowledgeable in
creating VBScripts, JScript, or writing something up using
VS .NET. I was hoping to find an easier answer.
Thanks again for your response.
Bettina
>--Original Message--
>SQL Server's T-SQL language doesn't have any in-built
features that can
>perform any kind of http calls - soap or otherwise.
>T-SQL does provide ability to call external libraries and
operating system
>commands via things such as sp_OACreate (COM) and
xp_cmdshell (console
>commands), so it's arguable that your could conceivably
call a web-service
>from within the Query Analyser, consume it with
sp_xml_preparedocument etc
>but this is really getting into the zen mastery area &
not really what Query
>Analyser was designed to perform.
>You might do better writing a VBScript or JScript &
running that as a DTS
>package, or perhaps just coding something in a VS.Net
project (with
>whatever's your favourite language flavour..)
>Regards,
>Greg Linwood
>SQL Server MVP
>"bpdee" <anonymous@.discussions.microsoft.com> wrote in
message
>news:cb4301c3ef43$84912d60$a101280a@.phx.gbl...
>> I've made a database change to a table to add home and
>> operational amounts. In an upgrade path, I need to
>> populate these columns with values. There is already C#
>> code that does the currency conversion based on
comparing
>> transactional currency to both the home and operational
>> currency codes. Right now, our upgrade scripts are run
>> via Query Analyzer. Is there a way for me to call web
>> services and execute methods that have already been
>> written to do the currency conversion for me? I'd hate
to
>> reinvent the wheel and rewrite code for something that's
>> already been in done C#.
>> We are running SQL Server 2000.
>> Thanks in advance,
>> Bettina
>
>.
>|||Sorry there's not an easier answer.. :c/
This (xml, soap etc) is an area where things are improving in SQL Server but
for now it's not a simple task to perform in QA & is better suited to
language development..
Regards,
Greg Linwood
SQL Server MVP
"bpdee" <anonymous@.discussions.microsoft.com> wrote in message
news:d76901c3ef5c$3bad51f0$a401280a@.phx.gbl...
> Hi Greg,
> Thank you so much for your response. Unfortunately, I'm
> not a database programmer (I only have experience as an
> Oracle Forms programmer) and I am not knowledgeable in
> creating VBScripts, JScript, or writing something up using
> VS .NET. I was hoping to find an easier answer.
> Thanks again for your response.
> Bettina
> >--Original Message--
> >SQL Server's T-SQL language doesn't have any in-built
> features that can
> >perform any kind of http calls - soap or otherwise.
> >
> >T-SQL does provide ability to call external libraries and
> operating system
> >commands via things such as sp_OACreate (COM) and
> xp_cmdshell (console
> >commands), so it's arguable that your could conceivably
> call a web-service
> >from within the Query Analyser, consume it with
> sp_xml_preparedocument etc
> >but this is really getting into the zen mastery area &
> not really what Query
> >Analyser was designed to perform.
> >
> >You might do better writing a VBScript or JScript &
> running that as a DTS
> >package, or perhaps just coding something in a VS.Net
> project (with
> >whatever's your favourite language flavour..)
> >
> >Regards,
> >Greg Linwood
> >SQL Server MVP
> >
> >"bpdee" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:cb4301c3ef43$84912d60$a101280a@.phx.gbl...
> >> I've made a database change to a table to add home and
> >> operational amounts. In an upgrade path, I need to
> >> populate these columns with values. There is already C#
> >> code that does the currency conversion based on
> comparing
> >> transactional currency to both the home and operational
> >> currency codes. Right now, our upgrade scripts are run
> >> via Query Analyzer. Is there a way for me to call web
> >> services and execute methods that have already been
> >> written to do the currency conversion for me? I'd hate
> to
> >> reinvent the wheel and rewrite code for something that's
> >> already been in done C#.
> >>
> >> We are running SQL Server 2000.
> >>
> >> Thanks in advance,
> >> Bettina
> >>
> >
> >
> >.
> >