Hi
Can anyone explain me the options for linked servers in the enterprise
manager.
I've tried to link another sql server but i'm gettng errors.> Can anyone explain me the options for linked servers in the enterprise
> manager.
Check the "Configuring Linked Servers" topic in Books OnLine
(mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\ad
minsql.chm::/ad_1_server_4uuq.htm).
> I've tried to link another sql server but i'm gettng errors.
Any specific errors?
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||do u know the ip address of your second server if yes then enter the name or
the ipaddress then give the username as u use for your local server and admi
n
as username for remote server and give the password as your local server
password
and in the server option use select the above five options
and set ok
it will work for u but keep one thing in mind that u can not see the tables
or views u can only execute the hetrogenious queries.
from
sufian
"Dejan Sarka" wrote:
> Check the "Configuring Linked Servers" topic in Books OnLine
> (mk:@.MSITStore:C:\Program%20Files\Micros
oft%20SQL%20Server\80\Tools\Books\
ad
> minsql.chm::/ad_1_server_4uuq.htm).
>
> Any specific errors?
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>
Showing posts with label explain. Show all posts
Showing posts with label explain. Show all posts
Wednesday, March 28, 2012
Monday, March 19, 2012
Limits SQLServer Express
Hi, can someone explain which are the limits o maximum values that SQLServer Express permit?
I dont see anywhere a compare table in which it says, 10 concurrent connections, etc.
Thanks in advance.
The only limitations that apply are shown here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
There is no longer a workload governor.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)