How to get two different SQL servers to talk to one another

Hi all I need to create a view for another sql server on the network.

I can create a view for two to databases on the same sql server to talk but how do you do it for a differend sql server??

CREATE VIEW dbo.Revocations_View
AS
SELECT TM#, LastName, FirstName, MI, SSN, [I/R #], Date, ReasonofRevocation, Notes, Termination, Conditional, WasEmployeeFined, LicenseSuspension,
Status
FROM LicensingActions.dbo.Revocations_TblUse sp_addlinkedserver (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp) to put the servers on "speaking terms" with each other. In a secured network, you may have to deal with Security Account Delegation (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp). After you've resolved that, you need to use four part names (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_5vvp.asp) and you're in business.

-PatP|||thanks pat thats exaclty what I need
appreciate it :)|||a fine meal and big bottle of wine outta do it. could'nt resist.

How to get the default data path of a SQL Server?

Could I get the default data path of a SQL Server if under following condition:
1) I have only known the SQL Server Name in my network.
2) I am using a workstation computer that connects to a SQL Server through network.
3) I can use store procedure.

The result I wanted is the default data path of a SQL Server like:
"[SQL Server Installed path]\MSSQL\Data", ie. most common case "C:\Program Files\Microsoft SQL Server\MSSQL\Data"

Does any method or store procedure could do the above case?I forget to state the following point:
1) I also need to handle the case if a SQL Server in network has multiple instances.
2) I use a SQL Server 2000.|||Hi,

One easy method is,

SELECT * FROM master..sysdatabases WHERE name LIKE '<database name>'

You can also find information @. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q272705&SD=MSKB&

Thanks
Yogish

Originally posted by king
Could I get the default data path of a SQL Server if under following condition:
1) I have only known the SQL Server Name in my network.
2) I am using a workstation computer that connects to a SQL Server through network.
3) I can use store procedure.

The result I wanted is the default data path of a SQL Server like:
"[SQL Server Installed path]\MSSQL\Data", ie. most common case "C:\Program Files\Microsoft SQL Server\MSSQL\Data"

Does any method or store procedure could do the above case?|||by Alexander Chigrik
USE master
GO
DECLARE @.install_path NVARCHAR(260)
EXEC sp_MSgettools_path @.install_path OUTPUT
SELECT @.install_path
GO

... its an undocumented XP available.

How to get started?

This is a repost of my post on the VB Express board.

I would like your opinions.

I am a network guy. I learned basic years ago. I can do some html edits as needed to change sites.

Today I would like to start the long process of learning VB with .net applications. I thought I could start with Office developer xp to learn VB. I have that package.

I also would like to be able to build SQL quaries and integrations or automate and manipulate data exports and imports later down the road.

Example: Export various order and customer information from a shopping cart and import it in to Quickbooks or MS Accounting.

First off I need to be able to build web sites and I know I want to grow into VB and SQL.

What should I do?

Learn HTML from web monkey?

Start with Office xp developer Tutorials?

Start with VB Express?

Buy a book?

Can someone tell me where to start and when to move to the next language?

What is the best resource to get to it, without the bla bla bla and a commnd/syntax refference?

How do I mix Html, CSS and .Net (VB)...in the learning process?

I would like to get the fast track for the long haul.

Thanks so much.

There are a lot of different ways to get started. Think about how you like to learn. Do you like the class environment, informal or structured, do you just like to play with new technology, do you like to read and then apply what you learn.
Here are some suggestions:
* Before you go and buy a bunch of books, go to your local library and see what interests you. Looks for books that give a lot of examples
*Come up with a simple application that you would like to create. Then find examples on how folks have done it already
*Search the internet for examples and samples
* focus on one technology first and then expand
* Purse MCP certification: http://www.microsoft.com/learning/mcpexams/default.mspx
* Download the free editions of products; such as SQL Server Express: http://msdn.microsoft.com/vstudio/express/sql/
There are a lot or resources out there. Check out: http://www.microsoft.com/learning/books/default.mspx. The step-by-step series are great when you are just getting started.
The learning never stops & there is no quick simple solution.
Hope this helps,
Peter Saddow

How to get SQL Server Info(Version/SP Version/Server Statistics) from a network.

Does anyone know how to get SQL Server versions, Service pack versions
and the Server that instance of SQL is running on a network. I have
seen some threads on how to list SQL servers in a network but I need to
find more info about these SQL servers.

Any help appreciated..!
Thx...SELECT @.@.VERSION

--
Regards Bagieta
~~~~~~~~~~~~~~~~~~~~~~~~~~~
dbDeveloper - Multiple databases editor
http://www.prominentus.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~

how to get SQL SERVER 2005 NETWORK CONFIGURATION...

hI ALL,
i wrote my problem before also...n it was
I have installed SQL SERVER 2005 CTP,Version 9.00.1314 but the problem is...as soon as i m trying to connect..i gave the local server name as SHUCHI during the installation and now i m trying to connect to it... then it gives me error as :
cannot connect to SHUCHI
additional information: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server)(Microsoft SQL Server,Error:2)

n now i think i have another problem...this problem is still there and no one could tell me the right solution :(( ....n now when i saw the sql configuration tool i found that in the SQL SERVER 2005 NETWORK CONFIGURATION there are NO PROTOCOLS at all...in short i think they r not installed at all...i tried to install the SQL SERVER thrice but the problem is stil the same....can someone tell me...if i can just install these protocols only from somewhere>?

please try to HELP MEEEEE.....
thnks,
shuch.Are you inside SAC (Surace Area Configuration)?
You need to enable the protocols.
After that, you need to enable remote connections.
|||

For more information about SAC, see BOL topic:

http://msdn2.microsoft.com/en-us/library/ms230995(en-US,SQL.90).aspx

|||Hi,
the problem is that as soon as i click on SAC...the ERROR comes and it tells me that i m not in the ADMINISTRATOR's group ...n the sad part is that I M in the administrator group...is there any way from where i can download just the SQL SERVER 2005 NETWORK CONFIGURATION...so as to get the PROTOCOLS n everythin...or if there is some other way to do it in the SAC only..but i cant click anything in there since it gives me ERROR....i thought may b the problem is with installation so i REINSTALLED it THRICE but all the times the problem still exist...
please try to think of somethin n PLEASEEE HELP ME..
thnks for your reply,
shuchi.|||

What OS are you using?
How are you logged into your machine?
Can you verify that you're in the Administrator's group?
Can you verify that you logged into the machine with an account that belongs in the Administrator's group?
Did you try logging into your machine as Administrator?

|||I m using WINDOWS XP,
i have a user name and a password to log into my machine(since its a company),
yeah...in the groups i saw my name in the ADMINISTRATOR's group(even the admin told me that me that i m there in the group),
i didnt try logging as administrator on my machine...i can try that on monday...but i dont knw if its really goin to help or not...since its not connectin with the server at all...anyways,i will try n write my reply again on monday..thnks for ur suggestions though...

How to get list of all Sql servers on network

Hi,
Is there any function/API in vb to retrieve all the sql servers that are avaiable on a network? Basically, i wanted to implement this facility in my application where users can select a server from list of all avaiable servers on LAN.

Thanks!
Asif.Net, Im having trouble with a couple of the TYPES that are used in the functions.

Have you got this figured out in .NET yet?

Please let me know if you have a resolution.

Thanks,
Malcolm Phillips
Malcolm.Phillps@.prgx.com|||If you get GFI lanscan you'll find there's a script there that enumerates SQL Servers on the network. Its basically VB script but I don;'t have it here at home.

To do it in asp.net I think you'd need to import the SQLDMO namespace|||How do I import the SQLDMO namespace? Please|||You add the Microsoft SQLDMO Object Library as a (COM) Reference to your project, then you add

<%@. Import Namespace="SQLDMO"%>

to your ASP.NET page.

Terri|||Take a look at http://www.extremeexperts.com/sql/faq/SQLDMO-ListServers.aspx for an example ... This works in VB also ...|||Dim mDMOApp As New SQLDMO.Application Dim mNames As SQLDMO.NameList Dim t As Integer mDMOApp = New SQLDMO.Application mNames = mDMOApp.ListAvailableSQLServers() lstServers.Items.Clear() For t = 1 To mNames.Count lstServers.Items.Add(mNames.Item(t)) Next