| Author |
Between database servers
|
|
| Matthew Z 2005-09-30, 9:23 am |
| Hi all,
I like to access a production database server from my development database,
I need to count how fast one table in the production table grows, is there
any way to do it without actually getting on the production server? linked
server?
Thanks.
| |
|
| Yes you can create a linked server
http://sqlservercode.blogspot.com/
"Matthew Z" wrote:
> Hi all,
> I like to access a production database server from my development database,
> I need to count how fast one table in the production table grows, is there
> any way to do it without actually getting on the production server? linked
> server?
>
> Thanks.
| |
| Matthew Z 2005-09-30, 11:23 am |
| Thanks. Because the company security reseans, I can't use the linked server,
is there a way to work around?
"SQL" wrote:
[color=darkred]
> Yes you can create a linked server
>
> http://sqlservercode.blogspot.com/
>
>
> "Matthew Z" wrote:
>
| |
|
| look up OPENROWSET and OPENDATASOURCE in Books on line
http://sqlservercode.blogspot.com/
"Matthew Z" wrote:
[color=darkred]
> Thanks. Because the company security reseans, I can't use the linked server,
> is there a way to work around?
>
>
> "SQL" wrote:
>
| |
| Matthew Z 2005-09-30, 11:23 am |
| Thanks for reply.
Even I have sa permission to all sql servers, I still can't have have access
from one server to a different server.
"SQL" wrote:
[color=darkred]
> look up OPENROWSET and OPENDATASOURCE in Books on line
>
> http://sqlservercode.blogspot.com/
>
>
>
> "Matthew Z" wrote:
>
| |
| Jerry Spivey 2005-09-30, 11:23 am |
| Matthew,
as SQL said:
1. Linked Server
2. OPENROWSET or OPENDATASOURCE - neither requires a linked server to be
created
3. Use EM, QA, OSQL or some other application to connect directly to your
other server.
4. Job or DTS to get the value required to your local db
HTH
Jerry
"Matthew Z" < MatthewZ@discussions
.microsoft.com> wrote in message
news:46E45877-8585-4709-AEA8- BDD7886E7FC5@microso
ft.com...[color=darkred]
> Thanks for reply.
> Even I have sa permission to all sql servers, I still can't have have
> access
> from one server to a different server.
>
> "SQL" wrote:
>
| |
|
| Another option is to create an xp_sendmail proc job on the production DB
that will mail the result to yourself whenever you execute this job
"Matthew Z" wrote:
[color=darkred]
> Thanks for reply.
> Even I have sa permission to all sql servers, I still can't have have access
> from one server to a different server.
>
> "SQL" wrote:
>
| |
| Matthew Z 2005-09-30, 11:23 am |
| Thanks guys, based on your replies,I got a idea, I may try DTS job & send
mail functions. This is not a one time process, it runs every week for
reporting Purpose.
"Matthew Z" wrote:
> Hi all,
> I like to access a production database server from my development database,
> I need to count how fast one table in the production table grows, is there
> any way to do it without actually getting on the production server? linked
> server?
>
> Thanks.
|
|
|
|