Link Server settings

Hello:
I am trying to create linked server ( another SQL Server) to my SQL Server,
using Enterprise Manager, but new alias pointed me only to master database.
How can I change settings of the link server to get access to pubs database?
Thanks,
GBYou could change the default database for the user the linked server is
configured to use, using sp_defaultdb on the remote server.
Or, use the USE statement or proper 4-part naming to qualify the database
name you are accessing from the local server. e.g. you should not be saying
this:
SELECT <col_list> FROM LinkedServer...TableName;
You should be saying:
SELECT <col_list> FROM LinkedServer.DatabaseName.dbo.TableName;
"GB" <v7v1k3@.hotmail.com> wrote in message
news:y_zvf.57264$OU5.43252@.clgrps13...
> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL
> Server,
> using Enterprise Manager, but new alias pointed me only to master
> database.
> How can I change settings of the link server to get access to pubs
> database?
> Thanks,
> GB
>|||You could change the default database for the user the linked server is
configured to use, using sp_defaultdb on the remote server.
Or, use the USE statement or proper 4-part naming to qualify the database
name you are accessing from the local server. e.g. you should not be saying
this:
SELECT <col_list> FROM LinkedServer...TableName;
You should be saying:
SELECT <col_list> FROM LinkedServer.DatabaseName.dbo.TableName;
"GB" <v7v1k3@.hotmail.com> wrote in message
news:y_zvf.57264$OU5.43252@.clgrps13...
> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL
> Server,
> using Enterprise Manager, but new alias pointed me only to master
> database.
> How can I change settings of the link server to get access to pubs
> database?
> Thanks,
> GB
>|||What you see in Enterprise Manager is simply the default database for the
account that you are using to authenticate to the linked server. Changed th
e
default database for that user, and refresh and you will see another
databases tables.
You will still be able to access all databases to which that user has access
.
kevin
"GB" wrote:

> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL Server
,
> using Enterprise Manager, but new alias pointed me only to master database
.
> How can I change settings of the link server to get access to pubs databas
e?
> Thanks,
> GB
>
>

Limiting tables displayed in new window for SQL 2000 Enterprise Manager

Can anyone tell me if there's a way to create new windows from the
tables section of a database in Enterprise Manager such that I can
limit the tables included in that window? Ultimately, I'm looking for
a solution whereby I can group tables, stored procedures, etc. into
logical groups that can then be displayed using different MMC
consoles. I'm looking for either a GUI-level or programatic approach.

Thank you,
Dax WestermanUsing EM as is no. You can build your own version of EM though and display
whatever you want using SQL-DMO.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Dax Westerman" <daxw@.bellsouth.net> wrote in message
news:273bcb55.0404300435.7ac4ba6b@.posting.google.c om...
> Can anyone tell me if there's a way to create new windows from the
> tables section of a database in Enterprise Manager such that I can
> limit the tables included in that window? Ultimately, I'm looking for
> a solution whereby I can group tables, stored procedures, etc. into
> logical groups that can then be displayed using different MMC
> consoles. I'm looking for either a GUI-level or programatic approach.
> Thank you,
> Dax Westerman

Limiting a users resource ie CPU, disk and/or memory

We are currently using Great Plains. This accounting package runs on SQL Server and we have performance problems running integration manager. The result is that users can not get work done when integration manager is running.
Is there any way I can limit the user running integration manager to a certain amount of CPU time and allocate the rest to the other users?
In Oracle, this is easy - I could just use resource plans, but I don't know if there is a way to do this with SQL Server 2K.
TIA
No, SQL Server does not support the ability to limit the amount of =
resources an application or a connections uses.
--=20
Keith
"ramick" <anonymous@.discussions.microsoft.com> wrote in message =
news:9327DE01-32DA-47B7-917F-E2513C31CB5C@.microsoft.com...
> We are currently using Great Plains. This accounting package runs on =
SQL Server and we have performance problems running integration manager. =
The result is that users can not get work done when integration manager =
is running.
>=20
> Is there any way I can limit the user running integration manager to a =
certain amount of CPU time and allocate the rest to the other users?
>=20
> In Oracle, this is easy - I could just use resource plans, but I don't =
know if there is a way to do this with SQL Server 2K.
>=20
> TIA

Limiting a users resource ie CPU, disk and/or memory

We are currently using Great Plains. This accounting package runs on SQL Se
rver and we have performance problems running integration manager. The resu
lt is that users can not get work done when integration manager is running.
Is there any way I can limit the user running integration manager to a certa
in amount of CPU time and allocate the rest to the other users?
In Oracle, this is easy - I could just use resource plans, but I don't know
if there is a way to do this with SQL Server 2K.
TIANo, SQL Server does not support the ability to limit the amount of =
resources an application or a connections uses.
--=20
Keith
"ramick" <anonymous@.discussions.microsoft.com> wrote in message =
news:9327DE01-32DA-47B7-917F-E2513C31CB5C@.microsoft.com...
> We are currently using Great Plains. This accounting package runs on =
SQL Server and we have performance problems running integration manager. =
The result is that users can not get work done when integration manager =
is running.
>=20
> Is there any way I can limit the user running integration manager to a =
certain amount of CPU time and allocate the rest to the other users?
>=20
> In Oracle, this is easy - I could just use resource plans, but I don't =
know if there is a way to do this with SQL Server 2K.
>=20
> TIA

Limiting a users resource ie CPU, disk and/or memory

We are currently using Great Plains. This accounting package runs on SQL Server and we have performance problems running integration manager. The result is that users can not get work done when integration manager is running
Is there any way I can limit the user running integration manager to a certain amount of CPU time and allocate the rest to the other users
In Oracle, this is easy - I could just use resource plans, but I don't know if there is a way to do this with SQL Server 2K
TIANo, SQL Server does not support the ability to limit the amount of =resources an application or a connections uses.
-- Keith
"ramick" <anonymous@.discussions.microsoft.com> wrote in message =news:9327DE01-32DA-47B7-917F-E2513C31CB5C@.microsoft.com...
> We are currently using Great Plains. This accounting package runs on =SQL Server and we have performance problems running integration manager. = The result is that users can not get work done when integration manager =is running.
> > Is there any way I can limit the user running integration manager to a =certain amount of CPU time and allocate the rest to the other users?
> > In Oracle, this is easy - I could just use resource plans, but I don't =know if there is a way to do this with SQL Server 2K.
> > TIA

Limitation on Number of Parameters??

Hi,
I would like to know, while running the report in the Report Manager, do we
have any limitation on number of parameters or specifically in number of drop
down parameters?
One of my report is having 35 parameters for the user to enter, it is
working fine in Designer's Preview mode, but when i deploy it to server and
when i run the report from the server, its not showing the output and no
errors also. If i reduce the number of parameters its working fine. Why is
this strange behaviour, your help is highly appreciated in this.
TIA,
Sen KHi
it seems to me that the limitation is not in the number of parameters but in
the length of the calling sql statement. I don't know how to explain
exactly... I had about 14 parameters with dependencies among them. And one
value in the combobox was extremely long. Report behaved in the same way. The
only workaround i found - place a shorter name for this long value and in the
main stored procedure simply "decode" it to its longer variant.
Ailil
"Sen K" wrote:
> Hi,
> I would like to know, while running the report in the Report Manager, do we
> have any limitation on number of parameters or specifically in number of drop
> down parameters?
> One of my report is having 35 parameters for the user to enter, it is
> working fine in Designer's Preview mode, but when i deploy it to server and
> when i run the report from the server, its not showing the output and no
> errors also. If i reduce the number of parameters its working fine. Why is
> this strange behaviour, your help is highly appreciated in this.
> TIA,
> Sen K

limit resources per user

Is there some kind of way to limit the resources (CPU, number of sessions)
per user in MS SQL 2000 database.
Some kind of resorce manager thing...Dalibor Grudeni (inet) (dgrudeni@.inet.hr) writes:
> Is there some kind of way to limit the resources (CPU, number of sessions)
> per user in MS SQL 2000 database.
> Some kind of resorce manager thing...

Not really. There are some knobs for the query governor, but there are
no knobs to say that this user may only use that much CPU etc.

However, you could implement some monitoring on your own by peeking
at sysprocesses.

I would not be surprised if there are third-party tools out there for
this puprpose.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx