Comparing Nulls

Hi All,
I am in the middle of checking data between SQL servers.
I am not getting any rows returned because in one server the amount is null
in the other is is a number. why aren't these unequal amounts coming in?
I have the same issue with date fileds.
my code is:
select a.accountkey,b.accountkey as BRacct,a.ContractID,a.ContractAmount,
b.ContractAmount as BRconAmt
from ACrepl..maincontracts a inner join BR11.AC.dbo.tblmaincontracts b
on a.contractId = b.contractID
where a.contractAmount <> b.contractAmount
TIA,
JoeThe only comparison allowed, when ansi_nulls is on, for null values are [not]
is null. Null can not be compared even with itself.
Try:
select
a.accountkey,
b.accountkey as BRacct,
a.ContractID,
a.ContractAmount,
b.ContractAmount as BRconAmt
from
ACrepl..maincontracts a
inner join
BR11.AC.dbo.tblmaincontracts b
on a.contractId = b.contractID
where
a.contractAmount <> b.contractAmount
or (contractAmount + b.contractAmount) is null
go
AMB
"jaylou" wrote:

> Hi All,
> I am in the middle of checking data between SQL servers.
> I am not getting any rows returned because in one server the amount is nul
l
> in the other is is a number. why aren't these unequal amounts coming in?
> I have the same issue with date fileds.
> my code is:
> select a.accountkey,b.accountkey as BRacct,a.ContractID,a.ContractAmount,
> b.ContractAmount as BRconAmt
> from ACrepl..maincontracts a inner join BR11.AC.dbo.tblmaincontracts b
> on a.contractId = b.contractID
> where a.contractAmount <> b.contractAmount
> TIA,
> Joesqlsql

Comparing data across two databases

Hi,
I have two identical databases (Production and Testing) sitting in different
servers (Server A and B) .
Is there anyway to compare data between these databases at all? More
particularly, I want to compare data in 20 tables from above databases and
identify any difference.
Is this possible at all? Can someone help please?
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Harish,
There are some great 3rd party tools that can accomplish this. I use the
ones offered at http://www.red-gate.com.
Shaun McDonnell
"Harish Mohanbabu" <Axapta@.online.nospam> wrote in message
news:70D2B1D3-2A33-45F0-A632-B1B4BEAAAA82@.microsoft.com...
> Hi,
> I have two identical databases (Production and Testing) sitting in
> different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||Look up the tablediff utility in Books Online...
..."TableDiff was intended for replication but can easily apply to any
scenario where you need to compare data and/or schema"
(http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx)
"Harish Mohanbabu" wrote:
> Hi,
> I have two identical databases (Production and Testing) sitting in different
> servers (Server A and B) .
> Is there anyway to compare data between these databases at all? More
> particularly, I want to compare data in 20 tables from above databases and
> identify any difference.
> Is this possible at all? Can someone help please?
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/|||You might want to use AlfaAlfa's SQL Server Comparison Tool (SCT)
http://www.sql-server-tool.com/
- you can easily compare data in databases located in different
servers. SCT has lot of fine-tuning options, like: ignoring selected
columns or specifying comparison method (record-by-record or primary
key/index comparison).
Comparison "sessions" can be saved and re-played later without need of
re-entering the parameters. Command line parameter can be used to
fully automate comparisons.
Dariusz Dziewialtowski.

Compare values of databases between SQL Server 6.5 and 2000

Hi,
I am trying to compare values of two tables which are on different servers
and versions of SQL Server.
All i am looking for is
select * from a where not exists (select * from b where a.docid = b.docid)
where a is a table in Sql server 6.5
where b is a table in sql server 2000
I could not link the databases because of the difference in version. What is
best and easy approach to get the final result.
--
VijayaHi,
You can simply DTS the table from one server to the other and run your
comparison query.
--
- - - - - - - - -
Thanks
Yogish
"Vijaya" wrote:
> Hi,
> I am trying to compare values of two tables which are on different servers
> and versions of SQL Server.
> All i am looking for is
> select * from a where not exists (select * from b where a.docid = b.docid)
> where a is a table in Sql server 6.5
> where b is a table in sql server 2000
>
> I could not link the databases because of the difference in version. What is
> best and easy approach to get the final result.
> --
> Vijaya|||Vijaya,
Can you run the query on the SQL 2000 box? That would work. Or maybe
transfer the table and data from 2000 to 6.5 using something simple like
bcp and run the query locally on the 6.5 box? There's not going to be an
elegant solution to this one.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Vijaya wrote:
> Hi,
> I am trying to compare values of two tables which are on different servers
> and versions of SQL Server.
> All i am looking for is
> select * from a where not exists (select * from b where a.docid = b.docid)
> where a is a table in Sql server 6.5
> where b is a table in sql server 2000
>
> I could not link the databases because of the difference in version. What is
> best and easy approach to get the final result.

Compare Two Queries - Help

Hi All,

I have two database that are duplicates of each other - but are on
different servers.

I need to write a script that will do a select from one table and then
compare it to another select of that table - but on the db on the other
server.

Is it possible to do that in a script? If so, how?

Thanks in advance.Brian Schultz (bdschultz@.gmail.com) writes:

Quote:

Originally Posted by

I have two database that are duplicates of each other - but are on
different servers.
>
I need to write a script that will do a select from one table and then
compare it to another select of that table - but on the db on the other
server.
>
Is it possible to do that in a script? If so, how?

SELECT ...
FROM localtbl l
FULL JOIN SERVER.db.dbo.remotetbl r ON l.keycol = r.keycol
WHERE l.keycol IS NULL
OR r.keycol IS NULL
OR a.col <b.col
OR a.col IS NULL AND b.col IS NOT NULL
OR a.col IS NOT NULL AND b.col IS NULL

SERVER is here a linked server that you have set up with sp_addlinkedserver.

If you need to do this on a large-scale basis, you should probably
consider a third-party product. I believe Red Gate has something called
DataCompare.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||you could try firefly. it's a free tool that i wrote:
http://www.getfirefly.net/
let me know if you have any problems.
thanks,
James

Compare tables layout in dev and prod

Hi,
Does anyone know that without the tool, how to compare table's layout those
are existing development and production servers?
Regards,
-ChenHi,
You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
and compare.
SQLCompare from Redgate software has got a very good tool for data and
schema comparison.
http://www.red-gate.com/sql_tools.htm
Thanks
Hari
SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> Hi,
> Does anyone know that without the tool, how to compare table's layout
> those
> are existing development and production servers?
> Regards,
> -Chen|||Thank you very much!
"Hari Prasad" wrote:
> Hi,
> You could use INFORMATION_SCHEMA.COLUMNS Views.Put the contents into a table
> and compare.
> SQLCompare from Redgate software has got a very good tool for data and
> schema comparison.
> http://www.red-gate.com/sql_tools.htm
>
> Thanks
> Hari
> SQL Server MVP
>
> "Chen" <Chen@.discussions.microsoft.com> wrote in message
> news:15706083-2F97-4811-B33A-4A1D6547A159@.microsoft.com...
> > Hi,
> >
> > Does anyone know that without the tool, how to compare table's layout
> > those
> > are existing development and production servers?
> >
> > Regards,
> > -Chen
>
>

Compare feilds in seperate databases on seperate servers

Hi,
I want to run an update script where a field in a table in a database on a
server is equal to another field in a table in a database on a seperate
server. Here are the details:
Server 1:
Server name - Server1\Logi
Database - Ascent
Table - _customers
Field - email
Server 2:
Server name - Server2\Web
Database - ProductCart
Table - customers
Field - email
I want to update a field called 'flag' to equal 1 where the email addresses
are equal.
Can anyone help?To do this right we'd have to see more DDL - particulary interested in keys.
ML
http://milambda.blogspot.com/|||Hi
assuming you are on Server1\Logi, you can do something like
sp_addlinkedserver Web, @.srvproduct='', @.provider='SQLNCLI',
@.datasrc='Server2\WEB'
update _customers set flag = 1
from _customers a inner join Web.ProductCart.dbo.customers b on a.email =
b.email
exec sp_dropserver Web
Note that you should take care about proper credentials when connecting to
the linked server - read BOL about sp_addlinkedserver sproc. It is possible
also that it might be better to join tables on other column[s], but you did
not give any info on this.
HTH
Peter|||Hi Peter,
Thanks for the reply. I ran your script but got the following error:
Server: Msg 446, Level 16, State 9, Line 4
Cannot resolve collation conflict for equal to operation.
Any ideas what this means?
Darren
"Rogas69" <rogas69@.no_spamers.o2.ie> wrote in message
news:OAH9afjAGHA.1460@.TK2MSFTNGP14.phx.gbl...
> Hi
> assuming you are on Server1\Logi, you can do something like
> sp_addlinkedserver Web, @.srvproduct='', @.provider='SQLNCLI',
> @.datasrc='Server2\WEB'
> update _customers set flag = 1
> from _customers a inner join Web.ProductCart.dbo.customers b on a.email =
> b.email
> exec sp_dropserver Web
> Note that you should take care about proper credentials when connecting to
> the linked server - read BOL about sp_addlinkedserver sproc. It is
> possible also that it might be better to join tables on other column[s],
> but you did not give any info on this.
> HTH
> Peter
>|||You have to make sure that they are using the same collation to join
them, sample below:
Select * FROM
sometable localtable
Inner join
SomeotherServer.Database.Owner.SomeTable linkedtable
WHERE linkedserv.Somecolumn COLLATE SQL_Latin1_General_CP1_CI_AI =3D
localtable.somecolumn COLLATE SQL_Latin1_General_CP1_CI_AI
Normally you don=B4t need to specify that on both sides if you just
specify the collation on the side that is different to this on your
local server and vice cersa.
HTH, jens Suessmeyer.|||This means that the two databases use different collations. Look up
collations in Books Online, there you'll also find the COLLATE keyword, whic
h
you can use to solve the problem.
Something like that:
update _customers set flag = 1
from _customers a
inner join Web.ProductCart.dbo.customers b
on a.email = b.email collate <collation
name>
The collation name is displayed in database properties in Enterprise manager
.
ML
http://milambda.blogspot.com/|||Thanks guys, i'll go check it out.
"ML" <ML@.discussions.microsoft.com> wrote in message
news:70933017-66F0-4438-B8EE-E5824B77E3C9@.microsoft.com...
> This means that the two databases use different collations. Look up
> collations in Books Online, there you'll also find the COLLATE keyword,
> which
> you can use to solve the problem.
> Something like that:
> update _customers set flag = 1
> from _customers a
> inner join Web.ProductCart.dbo.customers b
> on a.email = b.email collate <collation
> name>
> The collation name is displayed in database properties in Enterprise
> manager.
>
> ML
> --
> http://milambda.blogspot.com/

Compare databases between 2 SQL servers

Hello,
I wish to see if the tables from database A server A1 exist in database
A on server B1.
I setup a linked server from my first server (robertcamarda) to a
target (cognos-dev)
This works from robertcamarda:
select count(*) from [cognos-dev].ds_v6_source.dbo.stdmas

and this works:
select * from ds_v6_source.information_schema.tables order by
table_name

but this wont work:
select * from [cognos-dev].ds_v6_source.information_schema.tables order
by table_name

Error:
Msg 117, Level 15, State 1, Line 1
The object name 'cognos-dev.ds_v6_source.dbo.information_schema.tables'
contains more than the maximum number of prefixes. The maximum is 3.

I want to do something like:
select * from ds_v6_source.information_schema.tables
where table_name not in (select table_name from
[cognos-dev].ds_v6_source.information_schema.tables order by
table_name)

so I can see of the sql server (robertcamarda) has any missing tables
that exist on the server (cognos-dev)
TIA
Rob
SQL Server 2005 Enterpriseuse sqlcompare tool to compare anything and everything between two
databases

www.red-gate.com

download the trial version and see if it works for you.|||On 17 May 2006 05:30:36 -0700, "rcamarda" <robc390@.hotmail.com> wrote:

>Hello,
>I wish to see if the tables from database A server A1 exist in database
>A on server B1.
winsql has a trial that is pretty useful
hth
Jeff Kish|||rcamarda (robc390@.hotmail.com) writes:
> but this wont work:
> select * from [cognos-dev].ds_v6_source.information_schema.tables order
> by table_name
> Error:
> Msg 117, Level 15, State 1, Line 1
> The object name 'cognos-dev.ds_v6_source.dbo.information_schema.tables'
> contains more than the maximum number of prefixes. The maximum is 3.

There is an apparent inconsistency between the error message and the
command you presented.

Then again, I was not able to get it to work with the proper command
either. This is probably because the INFORMATION_SCHEMA views are
not present in the databases, only in master. (Hm, I believe they
were in SQL 7, so with if you connect to SQL 7 it might work.)

Rather than using INFORMATION_SCHEMA, use the system tables or
the catalog views depending on which version of SQL Server you
are on.

SELECT name FROM [cognos_dev].ds_v6_source.dbo.sysobjects
WHERE type = 'U'
ORDER BY name

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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Compare database on developer and enduser server

Hello Group,
Sorry my english is very littel.
In my company I have two servers: first developer server (DevSvr)- for
developers and second server (MainSvr)to use for other emplooy - for user of
application.
One of databases was changed on DevSvr (add new tables, sp, indexes etc.).
How compare databeses on DevSvr and MainSvr (db structure) and create script
to alter database on MainSvr.
Thx PawelRtry www.red-gate.com
Lutz|||Before you invest several hundred dollars in a schema comparison tool,
consider the option of using Enterprise Manager to generate scripts for each
DB to seperate folders and using a GPL tool like WinMerge to perform the
file comparisons. You can configure to list only scripts and individual
lines that are different.
http://groups.google.com/group/micr...f9cfe0c46abfa76
Also, if you are checking your scripts into Visual Source Safe, there is a
feature to perform file comparisons between projects.
"PawelR" <pawelratajczak@.poczta.onet.pl> wrote in message
news:ecxsuFjqFHA.3800@.TK2MSFTNGP11.phx.gbl...
> Hello Group,
> Sorry my english is very littel.
> In my company I have two servers: first developer server (DevSvr)- for
> developers and second server (MainSvr)to use for other emplooy - for user
> of application.
> One of databases was changed on DevSvr (add new tables, sp, indexes etc.).
> How compare databeses on DevSvr and MainSvr (db structure) and create
> script to alter database on MainSvr.
> Thx PawelR
>|||You can use my free tools SQLDBDiff, the first time you lunch the tool it is
in French you can easly switch to English version by clicking :
Taches/Options/Language
Here is the link (My site will be in English soon)
http://www.sqldbtools.com/Downloads.aspx?ProductId=1
I'm waiting for your comments and feedback
"PawelR" <pawelratajczak@.poczta.onet.pl> wrote in message
news:ecxsuFjqFHA.3800@.TK2MSFTNGP11.phx.gbl...
> Hello Group,
> Sorry my english is very littel.
> In my company I have two servers: first developer server (DevSvr)- for
> developers and second server (MainSvr)to use for other emplooy - for user
> of application.
> One of databases was changed on DevSvr (add new tables, sp, indexes etc.).
> How compare databeses on DevSvr and MainSvr (db structure) and create
> script to alter database on MainSvr.
> Thx PawelR
>

Communication link failure

I am running an SSIS packsge across 2 servers. There at 33 Mil rows being copied over. At 5.6 mil rows I get this

[OLE DB Source [1]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Protocol error in TDS stream". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Communication link failure". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Communication link failure". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "Communication link failure". An OLE DB record is available.Source: "Microsoft SQL Native Client"Hresult: 0x80004005Description: "TCP Provider: The specified network name is no longer available. ".

[DTS.Pipeline] Error: The PrimeOutput method on component "OLE DB Source" (1) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Is there any known cause of this?

Thanks

Looks like a connection problem and that something, somewhere starts to drop packets or even the connection. You might have to enlist the help of the network guys if such people exist where you're at.

Communication between SQL6.5 and SQL200

Hi!
I'm in a fix, we're changing domains and I need to communicate between SQL6.5 and SQL200 for a short while.
Both servers reside in the same domain (at the moment) so all I want to do is communicate between 6.5 and 2000.
There seems to be a problem with that...
Is this a common problem?
WCS is to install 2000 on all machines, but time is agains me. I will get to that evenually.

Any ideas?

The communication I want is to access data in a table in SQL2000 using a SP on the sql2000 server. The call is invoced by a SP on SQL6.5.

Anu ideas?

Thanks!
/BixProblem solved!
And as I can see it, there was no problem...
It worked just as it's supposed to do, but I had other errors to handle first.

/Bix

communicate between two servers

I have two sql servers, A and B. each one has one database, A and B. I am trying to write a stored porcedure in database A to retrieve the data in database B. how do I do it? can you give me a simple example. (like "select")Check Books on Line for info on Linked Servers. Set that up and then you use the fully qualified names

From server A:

select field1, field2 from serverb.databasename.ownername.tablename
where ...|||When I use
servera.database...... in server A it works
but when I use
serverb.database...... in server A it doesnt work.|||what's the error message?

it's supposed to be.. [ [ [ server. ] [ database ] . ] [ owner_name ] . ] object_name|||first, I link two servers. then I run a select in view.
the error msg is
"Access to the remote server is denied because no login-mapping exists"
how do I do?|||It's BOL on how to do it. Linking the servers opens a channel between them. You have to map logins so that you then have the proper access. Basically, you say "If I'm logged in as Joe on server A, when I connect to server B from server A, I want to act like server B's user named Fred." Right click the linked server, Properties, Security tab.

Command works in DOS but not in xp_cmdshell

Can anyone give clues as to why the same copy command works in
DOS and not in xp_command shell.I am an admin in both servers and
in the database.

The results indicate one file is copied but no file is found
at destination.

Your input is appreciated

Vincento

copy "D:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\QMISDEV\back1.
txt" "\\corp156\d$\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\QMISDEV\"

works just fine but

use
master
exec xp_cmdshell 'copy "D:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\QMISDEV\back1.
txt" "\\corp156\d$\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\QMISDEV\"'What is the user context that the script is running in? Usually it is
system (I think), which isn't going to have access rights to corp156.

Zach

Vincento Harris wrote:
> Can anyone give clues as to why the same copy command works in
> DOS and not in xp_command shell.I am an admin in both servers and
> in the database.
> The results indicate one file is copied but no file is found
> at destination.
> Your input is appreciated
> Vincento
>
>
> copy "D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\QMISDEV\back1.
> txt" "\\corp156\d$\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\QMISDEV\"
> works just fine but
> use
> master
> exec xp_cmdshell 'copy "D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\QMISDEV\back1.
> txt" "\\corp156\d$\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\QMISDEV\"'|||"Vincento Harris" <wumutek@.yahoo.com> wrote in message
news:2fa13ee7.0410130938.3a4db7ec@.posting.google.c om...
> Can anyone give clues as to why the same copy command works in
> DOS and not in xp_command shell.I am an admin in both servers and
> in the database.
> The results indicate one file is copied but no file is found
> at destination.
> Your input is appreciated
> Vincento
>
>
> copy "D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\QMISDEV\back1.
> txt" "\\corp156\d$\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\QMISDEV\"
> works just fine but
> use
> master
> exec xp_cmdshell 'copy "D:\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\QMISDEV\back1.
> txt" "\\corp156\d$\Program Files\Microsoft SQL
> Server\MSSQL\BACKUP\QMISDEV\"'

I tried this out, and it worked fine for me (I didn't test using a share,
but I did test using folder names with spaces) - was the result you saw "1
file(s) copied"? Or did you run this as a scheduled job perhaps? When a
sysadmin executes xp_cmdshell, it runs as the MSSQL service account, so you
might want to check that account's permissions also.

Simon|||"Simon Hayes" <sql@.hayes.ch> wrote in message news:<416d9609$1_3@.news.bluewin.ch>...
> "Vincento Harris" <wumutek@.yahoo.com> wrote in message
> news:2fa13ee7.0410130938.3a4db7ec@.posting.google.c om...
> > Can anyone give clues as to why the same copy command works in
> > DOS and not in xp_command shell.I am an admin in both servers and
> > in the database.
> > The results indicate one file is copied but no file is found
> > at destination.
> > Your input is appreciated
> > Vincento
> > copy "D:\Program Files\Microsoft SQL
> > Server\MSSQL\BACKUP\QMISDEV\back1.
> > txt" "\\corp156\d$\Program Files\Microsoft SQL
> > Server\MSSQL\BACKUP\QMISDEV\"
> > works just fine but
> > use
> > master
> > exec xp_cmdshell 'copy "D:\Program Files\Microsoft SQL
> > Server\MSSQL\BACKUP\QMISDEV\back1.
> > txt" "\\corp156\d$\Program Files\Microsoft SQL
> > Server\MSSQL\BACKUP\QMISDEV\"'
> I tried this out, and it worked fine for me (I didn't test using a share,
> but I did test using folder names with spaces) - was the result you saw "1
> file(s) copied"? Or did you run this as a scheduled job perhaps? When a
> sysadmin executes xp_cmdshell, it runs as the MSSQL service account, so you
> might want to check that account's permissions also.
> Simon
I appreciate your answers guys .It does work on the same server for me too.
When the mssqlserver was under local admin account
The result was " Access denied"

When I made this account part of the admin account
The result was "1 file copied" and it actually works

So my problem was not making mssqlservice account an admin
of the //server (//corp156)

Thanks again for the exceptional contributions I always get from
this group

Vincento

Command line to find RAID Level

I have about 20 servers and want to compile a report to
find out RAID level without using the OS
Does anyone know how we can d that from command line so
that we can wrap that in SQL
thanks
This is typically a hardware setting associated with the Raid Card in your
server. You should check with your hardware vendor to see if they have a
tool for this.
"Ap" <anonymous@.discussions.microsoft.com> wrote in message
news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
>I have about 20 servers and want to compile a report to
> find out RAID level without using the OS
> Does anyone know how we can d that from command line so
> that we can wrap that in SQL
> thanks
|||But if we are doing software raid from windows 2003 then
can we know wha tis the type by using any commands?

>--Original Message--
>This is typically a hardware setting associated with the
Raid Card in your
>server. You should check with your hardware vendor to
see if they have a
>tool for this.
>
>"Ap" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
>
>.
>
|||Do the following yield anything:
WMIC DISKDRIVE
WMIC LOGICALDISK
WMIC IDECONTROLLER
WMIC SCSICONTROLLER
http://www.aspfaq.com/
(Reverse address to reply.)
"Ap" <anonymous@.discussions.microsoft.com> wrote in message
news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
> I have about 20 servers and want to compile a report to
> find out RAID level without using the OS
> Does anyone know how we can d that from command line so
> that we can wrap that in SQL
> thanks
|||It does but no the RAID level that says 1,5
thnaks for the effort
>--Original Message--
>Do the following yield anything:
>WMIC DISKDRIVE
>WMIC LOGICALDISK
>WMIC IDECONTROLLER
>WMIC SCSICONTROLLER
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Ap" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
>
>.
>

Command line to find RAID Level

I have about 20 servers and want to compile a report to
find out RAID level without using the OS
Does anyone know how we can d that from command line so
that we can wrap that in SQL
thanksThis is typically a hardware setting associated with the Raid Card in your
server. You should check with your hardware vendor to see if they have a
tool for this.
"Ap" <anonymous@.discussions.microsoft.com> wrote in message
news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
>I have about 20 servers and want to compile a report to
> find out RAID level without using the OS
> Does anyone know how we can d that from command line so
> that we can wrap that in SQL
> thanks|||But if we are doing software raid from windows 2003 then
can we know wha tis the type by using any commands?
>--Original Message--
>This is typically a hardware setting associated with the
Raid Card in your
>server. You should check with your hardware vendor to
see if they have a
>tool for this.
>
>"Ap" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
>>I have about 20 servers and want to compile a report to
>> find out RAID level without using the OS
>> Does anyone know how we can d that from command line so
>> that we can wrap that in SQL
>> thanks
>
>.
>|||Do the following yield anything:
WMIC DISKDRIVE
WMIC LOGICALDISK
WMIC IDECONTROLLER
WMIC SCSICONTROLLER
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ap" <anonymous@.discussions.microsoft.com> wrote in message
news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
> I have about 20 servers and want to compile a report to
> find out RAID level without using the OS
> Does anyone know how we can d that from command line so
> that we can wrap that in SQL
> thanks|||It does but no the RAID level that says 1,5
thnaks for the effort
>--Original Message--
>Do the following yield anything:
>WMIC DISKDRIVE
>WMIC LOGICALDISK
>WMIC IDECONTROLLER
>WMIC SCSICONTROLLER
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Ap" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
>> I have about 20 servers and want to compile a report to
>> find out RAID level without using the OS
>> Does anyone know how we can d that from command line so
>> that we can wrap that in SQL
>> thanks
>
>.
>

Command line to find RAID Level

I have about 20 servers and want to compile a report to
find out RAID level without using the OS
Does anyone know how we can d that from command line so
that we can wrap that in SQL
thanksThis is typically a hardware setting associated with the Raid Card in your
server. You should check with your hardware vendor to see if they have a
tool for this.
"Ap" <anonymous@.discussions.microsoft.com> wrote in message
news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
>I have about 20 servers and want to compile a report to
> find out RAID level without using the OS
> Does anyone know how we can d that from command line so
> that we can wrap that in SQL
> thanks|||But if we are doing software raid from windows 2003 then
can we know wha tis the type by using any commands?

>--Original Message--
>This is typically a hardware setting associated with the
Raid Card in your
>server. You should check with your hardware vendor to
see if they have a
>tool for this.
>
>"Ap" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
>
>.
>|||Do the following yield anything:
WMIC DISKDRIVE
WMIC LOGICALDISK
WMIC IDECONTROLLER
WMIC SCSICONTROLLER
http://www.aspfaq.com/
(Reverse address to reply.)
"Ap" <anonymous@.discussions.microsoft.com> wrote in message
news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
> I have about 20 servers and want to compile a report to
> find out RAID level without using the OS
> Does anyone know how we can d that from command line so
> that we can wrap that in SQL
> thanks|||It does but no the RAID level that says 1,5
thnaks for the effort
>--Original Message--
>Do the following yield anything:
>WMIC DISKDRIVE
>WMIC LOGICALDISK
>WMIC IDECONTROLLER
>WMIC SCSICONTROLLER
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Ap" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0baf01c4f449$91f551a0$a401280a@.phx.gbl...
>
>.
>