DBCC MEMORYSTATUS

microsoft.public.sqlserver.server

18 Mar 2006 6:36 AM

doller

Dear all,

How can i execute DBCC MEMORYSTATUS command on Linked server or Remote
Computer.

I dont want to connect my Query Analyser to the server i want to get
information.

thanx

Doller

19 Mar 2006 7:18 AM

Tibor Karaszi

EXEC TIBWORK.master.dbo.sp_executesql N'DBCC MEMORYSTATUS'

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quoteHide quote

"doller" <sufiana***@gmail.com> wrote in message
news:1142663795.418452.123220@e56g2000cwe.googlegroups.com...
> Dear all,
>
> How can i execute DBCC MEMORYSTATUS command on Linked server or Remote
> Computer.
>
> I dont want to connect my Query Analyser to the server i want to get
> information.
>
> thanx
>
> Doller
>

Are all your drivers up to date? click for free checkup

20 Mar 2006 1:34 AM

doller

HI Thanx