Link two server

Dear community
I have two SQL Server 7.0 one on Win2000 second on NT SP6
I would like to link them in order to use information from both of them for
reports.
To have same stored procedures on both servers I would like to name links
same way on both servers.
At the begin servers were able to see each other only using IP address. I
created corresponding to IP names and windows server names records into
LMHOSTS and then was able to use server names to create links.
Then I tried to create entries into HOSTS file where actual IP addresses
are refers to names I would like to have ( names are completely different to
name of any server into the network and have only alphabetic characters).
The strange thing is on WIN2000 I can create a link with name as defined
into HOSTS file but on NT4 that did not work . I cleared IP cache after any
change into LMHOSTS or HOSTS on both sites and I can ping with no problem
WIN2000 server from NT4 server site with any name I pointed into HOSTS.
Can somebody give an idea how to make that work ?
I was thinking about restarting NT4 server, but network administrator
doesn't want even hear about that.
Any ideas will be very much appreciated
With best regards
VitoYou can create a true linked server that will allow you to execute a =select statement like the following:
SELECT * FROM SomeServer.pubs.dbo.authors
Where SomeServer is the name of the linked server that you defined.
The easiest way to create a linked server is to do so within Enterprise =Manager. Open up the security tab, right-click on linked servers, =choose new linked server, hit the 'SQL Server' radio button, type in the =name of the server, set the security options and you are done. You =should be able to select from the linked server. If you want to give =the linked server a different name from the name of the SQL Server that =you are linking to you can do so by typing whatever name you want to =give your linked server within the text box and make sure that you =specify Microsoft OLE DB Provider for SQL Server within the Provider =name list box.
-- Keith
"VS" <nospam@.please.thanks> wrote in message =news:WEdoc.49795$wY.17731@.nwrdny03.gnilink.net...
> Dear community
> I have two SQL Server 7.0 one on Win2000 second on NT SP6
> > I would like to link them in order to use information from both of =them for
> reports.
> To have same stored procedures on both servers I would like to name =links
> same way on both servers.
> > At the begin servers were able to see each other only using IP =address. I
> created corresponding to IP names and windows server names records =into
> LMHOSTS and then was able to use server names to create links.
> Then I tried to create entries into HOSTS file where actual IP =addresses
> are refers to names I would like to have ( names are completely =different to
> name of any server into the network and have only alphabetic =characters).
> The strange thing is on WIN2000 I can create a link with name as =defined
> into HOSTS file but on NT4 that did not work . I cleared IP cache =after any
> change into LMHOSTS or HOSTS on both sites and I can ping with no =problem
> WIN2000 server from NT4 server site with any name I pointed into =HOSTS.
> > Can somebody give an idea how to make that work ?
> I was thinking about restarting NT4 server, but network administrator
> doesn't want even hear about that.
> > Any ideas will be very much appreciated
> > With best regards
> Vito
> >

Link two server

Dear community
I have two SQL Server 7.0 one on Win2000 second on NT SP6
I would like to link them in order to use information from both of them for
reports.
To have same stored procedures on both servers I would like to name links
same way on both servers.
At the begin servers were able to see each other only using IP address. I
created corresponding to IP names and windows server names records into
LMHOSTS and then was able to use server names to create links.
Then I tried to create entries into HOSTS file where actual IP addresses
are refers to names I would like to have ( names are completely different to
name of any server into the network and have only alphabetic characters).
The strange thing is on WIN2000 I can create a link with name as defined
into HOSTS file but on NT4 that did not work . I cleared IP cache after any
change into LMHOSTS or HOSTS on both sites and I can ping with no problem
WIN2000 server from NT4 server site with any name I pointed into HOSTS.
Can somebody give an idea how to make that work ?
I was thinking about restarting NT4 server, but network administrator
doesn't want even hear about that.
Any ideas will be very much appreciated
With best regards
VitoYou can create a true linked server that will allow you to execute a =
select statement like the following:
SELECT * FROM SomeServer.pubs.dbo.authors
Where SomeServer is the name of the linked server that you defined.
The easiest way to create a linked server is to do so within Enterprise =
Manager. Open up the security tab, right-click on linked servers, =
choose new linked server, hit the 'SQL Server' radio button, type in the =
name of the server, set the security options and you are done. You =
should be able to select from the linked server. If you want to give =
the linked server a different name from the name of the SQL Server that =
you are linking to you can do so by typing whatever name you want to =
give your linked server within the text box and make sure that you =
specify Microsoft OLE DB Provider for SQL Server within the Provider =
name list box.
--=20
Keith
"VS" <nospam@.please.thanks> wrote in message =
news:WEdoc.49795$wY.17731@.nwrdny03.gnilink.net...
> Dear community
> I have two SQL Server 7.0 one on Win2000 second on NT SP6
>=20
> I would like to link them in order to use information from both of =
them for
> reports.
> To have same stored procedures on both servers I would like to name =
links
> same way on both servers.
>=20
> At the begin servers were able to see each other only using IP =
address. I
> created corresponding to IP names and windows server names records =
into
> LMHOSTS and then was able to use server names to create links.
> Then I tried to create entries into HOSTS file where actual IP =
addresses
> are refers to names I would like to have ( names are completely =
different to
> name of any server into the network and have only alphabetic =
characters).
> The strange thing is on WIN2000 I can create a link with name as =
defined
> into HOSTS file but on NT4 that did not work . I cleared IP cache =
after any
> change into LMHOSTS or HOSTS on both sites and I can ping with no =
problem
> WIN2000 server from NT4 server site with any name I pointed into =
HOSTS.
>=20
> Can somebody give an idea how to make that work ?
> I was thinking about restarting NT4 server, but network administrator
> doesn't want even hear about that.
>=20
> Any ideas will be very much appreciated
>=20
> With best regards
> Vito
>=20
>

Link two server

Dear community
I have two SQL Server 7.0 one on Win2000 second on NT SP6
I would like to link them in order to use information from both of them for
reports.
To have same stored procedures on both servers I would like to name links
same way on both servers.
At the begin servers were able to see each other only using IP address. I
created corresponding to IP names and windows server names records into
LMHOSTS and then was able to use server names to create links.
Then I tried to create entries into HOSTS file where actual IP addresses
are refers to names I would like to have ( names are completely different to
name of any server into the network and have only alphabetic characters).
The strange thing is on WIN2000 I can create a link with name as defined
into HOSTS file but on NT4 that did not work . I cleared IP cache after any
change into LMHOSTS or HOSTS on both sites and I can ping with no problem
WIN2000 server from NT4 server site with any name I pointed into HOSTS.
Can somebody give an idea how to make that work ?
I was thinking about restarting NT4 server, but network administrator
doesn't want even hear about that.
Any ideas will be very much appreciated
With best regards
Vito
You can create a true linked server that will allow you to execute a =
select statement like the following:
SELECT * FROM SomeServer.pubs.dbo.authors
Where SomeServer is the name of the linked server that you defined.
The easiest way to create a linked server is to do so within Enterprise =
Manager. Open up the security tab, right-click on linked servers, =
choose new linked server, hit the 'SQL Server' radio button, type in the =
name of the server, set the security options and you are done. You =
should be able to select from the linked server. If you want to give =
the linked server a different name from the name of the SQL Server that =
you are linking to you can do so by typing whatever name you want to =
give your linked server within the text box and make sure that you =
specify Microsoft OLE DB Provider for SQL Server within the Provider =
name list box.
--=20
Keith
"VS" <nospam@.please.thanks> wrote in message =
news:WEdoc.49795$wY.17731@.nwrdny03.gnilink.net...
> Dear community
> I have two SQL Server 7.0 one on Win2000 second on NT SP6
>=20
> I would like to link them in order to use information from both of =
them for
> reports.
> To have same stored procedures on both servers I would like to name =
links
> same way on both servers.
>=20
> At the begin servers were able to see each other only using IP =
address. I
> created corresponding to IP names and windows server names records =
into
> LMHOSTS and then was able to use server names to create links.
> Then I tried to create entries into HOSTS file where actual IP =
addresses
> are refers to names I would like to have ( names are completely =
different to
> name of any server into the network and have only alphabetic =
characters).
> The strange thing is on WIN2000 I can create a link with name as =
defined
> into HOSTS file but on NT4 that did not work . I cleared IP cache =
after any
> change into LMHOSTS or HOSTS on both sites and I can ping with no =
problem
> WIN2000 server from NT4 server site with any name I pointed into =
HOSTS.
>=20
> Can somebody give an idea how to make that work ?
> I was thinking about restarting NT4 server, but network administrator
> doesn't want even hear about that.
>=20
> Any ideas will be very much appreciated
>=20
> With best regards
> Vito
>=20
>
sql

Line

Dear all,

I'm using a table to display my data and I need to draw a double line at the last textbox, may I know is it a way to have "double" line instead of "single" line drawing at one of my columns?

Thanks in advance

Levine

Hi,

The only way I have done this in my application is to create borders for the Table (Solid or Double) and then underline the last textbox item so that it slighlty looks different then the others.

Cheers,

Limiting the Number of rows displayed per table.

Dear Report Pros,

I am New to the world of report viewer.

Problem : I have placed 3 tables on top of each other on the rdlc document, done the binding to my business Objects every thing is ok EXCEPT THAT:

the number of rows displyed by the top table are big to the point that the table would stretch Vertically (grow) to accomodate them and It would cover the other 2 tables under it , so basically the first table gets expanded so much to the point that it consumes the rest of the page and hiding / moving the other 2 tables.

I NEED a WAY to LIMIT the number of rows to be displayed per each table regardless of the resultset size, for example I just need to display the first 4 rows of the result comming to this table which might contain 20 rows, and I am hoping that there is a Scrolling / Next mechanizm that that if the user is interested to review the rest of the resltset in this particular table he can.

I understand that this can be achieved through the use of Grups and expressions, but I am not sure how to do this exactly what and where to I place my expression on the table.

Thanks very much in advance for your time and help.

HI,

I suppose you need a custom page break in this scenario. You can have a look at "Page Break " section in the following article:

http://msdn2.microsoft.com/en-us/library/ms251668(VS.80).aspx

|||

HI,

We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

Limiting a connection to an application.

Dear All,
We use NTAuthorisation. The other day we had the auditors in the other who
pointed out a problem where although security has been implelemented data ca
n
still be accessed but using a different application i.e. word excel ect
rather than our VB App.
What is the best way of changing this so that SQL will only accept
connections from a particuar application (i.e. our vb application)
TIAI suggest you check out "application roles" in Books Online.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Patricia" <Patricia@.discussions.microsoft.com> wrote in message
news:68B94CD5-3C40-404A-A236-40E1BF7ACD02@.microsoft.com...
> Dear All,
> We use NTAuthorisation. The other day we had the auditors in the other who
> pointed out a problem where although security has been implelemented data
can
> still be accessed but using a different application i.e. word excel ect
> rather than our VB App.
> What is the best way of changing this so that SQL will only accept
> connections from a particuar application (i.e. our vb application)
> TIA|||Did you think about a application role ?
http://www.sqlteam.com/item.asp?ItemID=864
HTH, Jens Smeyer.
http://www.sqlserver2005.de
--
"Patricia" <Patricia@.discussions.microsoft.com> schrieb im Newsbeitrag
news:68B94CD5-3C40-404A-A236-40E1BF7ACD02@.microsoft.com...
> Dear All,
> We use NTAuthorisation. The other day we had the auditors in the other who
> pointed out a problem where although security has been implelemented data
> can
> still be accessed but using a different application i.e. word excel ect
> rather than our VB App.
> What is the best way of changing this so that SQL will only accept
> connections from a particuar application (i.e. our vb application)
> TIA|||AFAIK, you can limit on that using Application Roles. You can take a look at
the Application roles on BOL under the title "Establishing Application
Security and Application Roles".
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Patricia" <Patricia@.discussions.microsoft.com> wrote in message
news:68B94CD5-3C40-404A-A236-40E1BF7ACD02@.microsoft.com...
> Dear All,
> We use NTAuthorisation. The other day we had the auditors in the other who
> pointed out a problem where although security has been implelemented data
can
> still be accessed but using a different application i.e. word excel ect
> rather than our VB App.
> What is the best way of changing this so that SQL will only accept
> connections from a particuar application (i.e. our vb application)
> TIA

limite the resource a stored procedure can use

Dear sir,
Some times, some unimportant stored procedure on my application are using
too much resource, etc 50% of CUP power. Is there a way to set the priority
of a SP or limite the max resource it can use?
thanks,
Guoqi Zheng
http://www.ureader.comThe only thing you can limit in SQL Server is how many processors a SQL
statement can use on a multi-processor machine. You can do this by adding
the OPTION (MAXDOP n) at the end of the statement, where n is the maximum
number of processors you want the statement to use.
Jacco Schalkwijk
SQL Server MVP
"guoqi zheng" <no@.sorry.com> wrote in message
news:dfc72681649d44efadd824ba066e2126@.ur
eader.com...
> Dear sir,
> Some times, some unimportant stored procedure on my application are using
> too much resource, etc 50% of CUP power. Is there a way to set the
> priority
> of a SP or limite the max resource it can use?
> thanks,
> Guoqi Zheng
> http://www.ureader.com|||To add on to Jacco's response, consider index and query tuning if you
haven't already done so. Excessive CPU utilization can be an indication
that additional indexes are needed or a poorly formulated query. It's best
to address the underlying cause when possible.
Hope this helps.
Dan Guzman
SQL Server MVP
"guoqi zheng" <no@.sorry.com> wrote in message
news:dfc72681649d44efadd824ba066e2126@.ur
eader.com...
> Dear sir,
> Some times, some unimportant stored procedure on my application are using
> too much resource, etc 50% of CUP power. Is there a way to set the
> priority
> of a SP or limite the max resource it can use?
> thanks,
> Guoqi Zheng
> http://www.ureader.com|||Thanks.
The CPU usage is because of some calculation. like using SELECT COUNT(*),
SUM(*) to update another table, and the records to be counted or summed are
a few 100000s.
I haven't know what might be better to do those calculation yet. The
calculation needs to be done a few times per day.
any suggestions?
regards,
Guoqi Zheng
http://www.ureader.com|||You might consider using an indexed view for frequently used aggregations.
Covering indexes may also help.
Hope this helps.
Dan Guzman
SQL Server MVP
"guoqi zheng" <no@.sorry.com> wrote in message
news:b685cc9d335546c0891cf9e7fe284d09@.ur
eader.com...
> Thanks.
> The CPU usage is because of some calculation. like using SELECT COUNT(*),
> SUM(*) to update another table, and the records to be counted or summed
> are
> a few 100000s.
> I haven't know what might be better to do those calculation yet. The
> calculation needs to be done a few times per day.
> any suggestions?
> regards,
> Guoqi Zheng
> http://www.ureader.com

Limitation on Multiple parameters with Multi-Select and default values

Dear Anyone,

I created 6 parameters in my report. Each of these parameters are multi-select enabled. Each of their available values comes from a data set. Their default values also comes from a data set in order to have the select all check box selected by default.

My problem is only the first 2 parameters gets to have the select all selected. And the rest just have blank values. I was wondering if RS parameters have some sort of limitation that I cannot enable data set default values in all of my parameters.
Thanks,
JosephThere seems to be a bug in RS2005 in the parameters section. Filter the data set your using for the parameters to not include blanks. This is aparently whats causing your problem.|||

Hello,

I need to create reports with parameters that allow for multi-selection values.

How can I make them multi-select enabled?

Appreciate your reponse.

SK

Limitation on Multiple parameters with Multi-Select and default values

Dear Anyone,

I created 6 parameters in my report. Each of these parameters are multi-select enabled. Each of their available values comes from a data set. Their default values also comes from a data set in order to have the select all check box selected by default.

My problem is only the first 2 parameters gets to have the select all selected. And the rest just have blank values. I was wondering if RS parameters have some sort of limitation that I cannot enable data set default values in all of my parameters.
Thanks,
JosephThere seems to be a bug in RS2005 in the parameters section. Filter the data set your using for the parameters to not include blanks. This is aparently whats causing your problem.|||

Hello,

I need to create reports with parameters that allow for multi-selection values.

How can I make them multi-select enabled?

Appreciate your reponse.

SK