RE: dbcc against remote sql server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mingqing Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 05/28/04 

Date: Fri, 28 May 2004 02:24:34 GMT

Hi,

>From your descriptions, I understood that you would like to excute DBCC
SQLPERF( logspace) with a remote server as a linked server. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know :)

Based on my knowledge, you could it make the with the following steps:
1) create a stored procedure on the remote linked server first:
create procedure get_dbcc_sqlperf
as
begin
dbcc sqlperf(logspace)
end

2) Then call with the following syntax:
execute servername.dbname.dbo.get_dbcc_sqlperf

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!

Sincerely yours,

Mingqing Cheng
Microsoft Online Support
------------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Relevant Pages

  • Re: copying data from one server to another
    ... EXEC sp_addlinkedserver 'RemoteServer', N'SQL Server' ... Based on security settings you may need to map remote server logins. ... Then you just run a normal query referencing the linked server table with 4 ... 'SET IDENTITY_INSERT ON' before execute insert ...
    (comp.databases.ms-sqlserver)
  • Linked server using ODBC Provider and DB transaction.
    ... I need to have some stored procedure that reference a linked server but not ... provider going to a ODBC System DSN to the remote server. ... but I also need to have transaction. ...
    (microsoft.public.sqlserver.odbc)
  • Problem with Linkserver and new user
    ... If this via NT Authentication then check the security tab ... on the linked server and ensure that option "Be made using ... Otherwise map the user's account to a specific remote user ... >Access to the remote server is denied because no login- ...
    (microsoft.public.sqlserver.programming)
  • connection problem
    ... You can use the linked server feature on SQLServer. ... use the remote server name directly in your script, ... > Im trying to connect to remote database in the Query ...
    (microsoft.public.sqlserver.security)
  • Re: User-Defined Function
    ... It doesn't even have to be this elaborate with a linked server. ... Declare @line varchar ... suitable extended stored procedure. ... > server setup and an example of how to get directory information (but not ...
    (microsoft.public.sqlserver.programming)