Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1322 > unrolled thread

Command-line

Back to article view | Back to comp.databases.ms-sqlserver

Contents

  Command-line fcache <fcache@gmail.com> - 2012-10-03 20:43 -0700
    Re: Command-line "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2012-10-04 10:17 -0400
      Re: Command-line fcache <fcache@gmail.com> - 2012-10-04 16:55 -0700
        Re: Command-line Erland Sommarskog <esquel@sommarskog.se> - 2012-10-05 07:32 +0000

#1322 — Command-line

Hi,

I work for a healthcare system and I support medical devices on the IT side of things.  I am running into PC based devices running MS SQL that fail and I'd like to be able to run consistency checks on their databases.  So, I want to create a flash drive with a command-line utility that will let me do this.  Is this possible?  The utility would basically need to be a stand-alone executable.

What say you?

Thanx,
Ed

[toc] | [next] | [standalone]

#1323

What versions and editions of SQL Server are involved?
Are the PCs in a network domain or are they remote/disconnected from a
network?

It is possible to run DBCC using isql or osql depending on the version of
SQL Server on the machine. Google or Books OnLine should provide you plenty
of information on both utilities.

fcache wrote:
> Hi,
>
> I work for a healthcare system and I support medical devices on the
> IT side of things.  I am running into PC based devices running MS SQL
> that fail and I'd like to be able to run consistency checks on their
> databases.  So, I want to create a flash drive with a command-line
> utility that will let me do this.  Is this possible?  The utility
> would basically need to be a stand-alone executable.
>
> What say you?
>
> Thanx,
> Ed

[toc] | [prev] | [next] | [standalone]

#1324

The version of MS SQL can differ, depending on the medical device.  The PCs are attached to a network domain.

On Thursday, October 4, 2012 10:17:18 AM UTC-4, Bob Barrows wrote:
> What versions and editions of SQL Server are involved?
> 
> Are the PCs in a network domain or are they remote/disconnected from a
> 
> network?
> 
> 
> 
> It is possible to run DBCC using isql or osql depending on the version of
> 
> SQL Server on the machine. Google or Books OnLine should provide you plenty
> 
> of information on both utilities.
> 
> 
> 
> fcache wrote:
> 
> > Hi,
> 
> >
> 
> > I work for a healthcare system and I support medical devices on the
> 
> > IT side of things.  I am running into PC based devices running MS SQL
> 
> > that fail and I'd like to be able to run consistency checks on their
> 
> > databases.  So, I want to create a flash drive with a command-line
> 
> > utility that will let me do this.  Is this possible?  The utility
> 
> > would basically need to be a stand-alone executable.
> 
> >
> 
> > What say you?
> 
> >
> 
> > Thanx,
> 
> > Ed

[toc] | [prev] | [next] | [standalone]

#1325

fcache (fcache@gmail.com) writes:
> The version of MS SQL can differ, depending on the medical device.  The
> PCs are attached to a network domain. 
 
In such case you could schedule a job from a central server that connects 
to the servers and you don't have to walk around with a stick. Or is SQL 
Server typically configured to accept local connections only?

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-sqlserver

csiph-web