I have an image column in my table in my SQL 2000 database.
I have inserted a row with binary data for the column.
Is there a simple way I kind view the data with Enterprise Manager?
This is so that I can check that my C++ code that inserted the data is
working?Hi Neil
"neilsolent" wrote:
> I have an image column in my table in my SQL 2000 database.
> I have inserted a row with binary data for the column.
> Is there a simple way I kind view the data with Enterprise Manager?
> This is so that I can check that my C++ code that inserted the data is
> working?
The ability to view as an image is up to the client application, and EM does
not have this ability. If you are going to store many large images it will
bloat the database see
http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
John|||Thanks for that John.
This is for (max 255) relatively small images (a few K each) so I don't
think bloating will be an issue.
I don't necessarily need to see the data as an image - if I could just
find out the number of bytes that where inserted, that would be good!
At the moment I have a C++ routine to insert data and another one to
read it. Something is not working, but I don't know whether it is the
writing routine or the reading routine, or both !
John Bell wrote:
> Hi Neil
> "neilsolent" wrote:
> > I have an image column in my table in my SQL 2000 database.
> >
> > I have inserted a row with binary data for the column.
> >
> > Is there a simple way I kind view the data with Enterprise Manager?
> >
> > This is so that I can check that my C++ code that inserted the data is
> > working?
> The ability to view as an image is up to the client application, and EM does
> not have this ability. If you are going to store many large images it will
> bloat the database see
> http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html
> John|||Hi Neil
"neilsolent" wrote:
> Thanks for that John.
> This is for (max 255) relatively small images (a few K each) so I don't
> think bloating will be an issue.
> I don't necessarily need to see the data as an image - if I could just
> find out the number of bytes that where inserted, that would be good!
See the datalength function in BOL
SELECT DATALENGTH(ImageCol)
FROM MyTable
> At the moment I have a C++ routine to insert data and another one to
> read it. Something is not working, but I don't know whether it is the
> writing routine or the reading routine, or both !
>
I assume you are using the ADO appendchunk method? If so see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappchunk.asp
an
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdmthappendchunkxvc.asp
John
Friday, March 30, 2012
how to view image data
I have an image column in my table in my SQL 2000 database.
I have inserted a row with binary data for the column.
Is there a simple way I kind view the data with Enterprise Manager?
This is so that I can check that my C++ code that inserted the data is
working?Hi Neil
"neilsolent" wrote:
> I have an image column in my table in my SQL 2000 database.
> I have inserted a row with binary data for the column.
> Is there a simple way I kind view the data with Enterprise Manager?
> This is so that I can check that my C++ code that inserted the data is
> working?
The ability to view as an image is up to the client application, and EM does
not have this ability. If you are going to store many large images it will
bloat the database see
http://databases.aspfaq.com/databas...filesystem.html
John|||Thanks for that John.
This is for (max 255) relatively small images (a few K each) so I don't
think bloating will be an issue.
I don't necessarily need to see the data as an image - if I could just
find out the number of bytes that where inserted, that would be good!
At the moment I have a C++ routine to insert data and another one to
read it. Something is not working, but I don't know whether it is the
writing routine or the reading routine, or both !
John Bell wrote:
> Hi Neil
> "neilsolent" wrote:
>
> The ability to view as an image is up to the client application, and EM do
es
> not have this ability. If you are going to store many large images it will
> bloat the database see
> http://databases.aspfaq.com/databas...filesystem.html
> John|||Hi Neil
"neilsolent" wrote:
> Thanks for that John.
> This is for (max 255) relatively small images (a few K each) so I don't
> think bloating will be an issue.
> I don't necessarily need to see the data as an image - if I could just
> find out the number of bytes that where inserted, that would be good!
See the datalength function in BOL
SELECT DATALENGTH(ImageCol)
FROM MyTable
> At the moment I have a C++ routine to insert data and another one to
> read it. Something is not working, but I don't know whether it is the
> writing routine or the reading routine, or both !
>
I assume you are using the ADO appendchunk method? If so see
http://msdn.microsoft.com/library/d.../>
ppchunk.asp
and
http://msdn.microsoft.com/library/d...endchunkxvc.asp
John
I have inserted a row with binary data for the column.
Is there a simple way I kind view the data with Enterprise Manager?
This is so that I can check that my C++ code that inserted the data is
working?Hi Neil
"neilsolent" wrote:
> I have an image column in my table in my SQL 2000 database.
> I have inserted a row with binary data for the column.
> Is there a simple way I kind view the data with Enterprise Manager?
> This is so that I can check that my C++ code that inserted the data is
> working?
The ability to view as an image is up to the client application, and EM does
not have this ability. If you are going to store many large images it will
bloat the database see
http://databases.aspfaq.com/databas...filesystem.html
John|||Thanks for that John.
This is for (max 255) relatively small images (a few K each) so I don't
think bloating will be an issue.
I don't necessarily need to see the data as an image - if I could just
find out the number of bytes that where inserted, that would be good!
At the moment I have a C++ routine to insert data and another one to
read it. Something is not working, but I don't know whether it is the
writing routine or the reading routine, or both !
John Bell wrote:
> Hi Neil
> "neilsolent" wrote:
>
> The ability to view as an image is up to the client application, and EM do
es
> not have this ability. If you are going to store many large images it will
> bloat the database see
> http://databases.aspfaq.com/databas...filesystem.html
> John|||Hi Neil
"neilsolent" wrote:
> Thanks for that John.
> This is for (max 255) relatively small images (a few K each) so I don't
> think bloating will be an issue.
> I don't necessarily need to see the data as an image - if I could just
> find out the number of bytes that where inserted, that would be good!
See the datalength function in BOL
SELECT DATALENGTH(ImageCol)
FROM MyTable
> At the moment I have a C++ routine to insert data and another one to
> read it. Something is not working, but I don't know whether it is the
> writing routine or the reading routine, or both !
>
I assume you are using the ADO appendchunk method? If so see
http://msdn.microsoft.com/library/d.../>
ppchunk.asp
and
http://msdn.microsoft.com/library/d...endchunkxvc.asp
John
How to view field list on the left side of report layout
I want to see all the fields list on the left side of report layout, you can drag a field and put it on the report.
Thank you very much.
Should be available under View - Fields.|||From the View menu, click 'Datasets' and it will open the box for it. Then you can dock it to the left side of your screen and navigate through your dataset to your fields.
Hope this helps.
Jarret
|||But under View i don't see Fields item at all, i know i did it in the past. but forgot the steps to get the field list.
Andrew, thank you.
|||Excellent - Thank you Jarret.|||
No problem, glad I could help. Can you mark this one as answered so others can see this solution?
Jarret
How to view error messages
SQL2000.
If somebody needs to view the error logs, do they need sysadmin
rights or can this be performed with another system role?
TIA.There is an undocumented command sp_Readerrorlog which allows you to read
error log through query analyzer but it requires the user to be member of
the securityadmin role.
--
-Vishal
"Stressed" <k@.c.co.uk> wrote in message
news:OHR2dyKQDHA.3192@.tk2msftngp13.phx.gbl...
> SQL2000.
> If somebody needs to view the error logs, do they need sysadmin
> rights or can this be performed with another system role?
> TIA.
>
If somebody needs to view the error logs, do they need sysadmin
rights or can this be performed with another system role?
TIA.There is an undocumented command sp_Readerrorlog which allows you to read
error log through query analyzer but it requires the user to be member of
the securityadmin role.
--
-Vishal
"Stressed" <k@.c.co.uk> wrote in message
news:OHR2dyKQDHA.3192@.tk2msftngp13.phx.gbl...
> SQL2000.
> If somebody needs to view the error logs, do they need sysadmin
> rights or can this be performed with another system role?
> TIA.
>
how to view date dimenstion
plese help
I want to view date dimentions like DD/MM/YY, doen't want to include time.
Thank youSELECT Convert(varchar(10), GetDate(), 105) as date
For more option explore convert() function...sql
I want to view date dimentions like DD/MM/YY, doen't want to include time.
Thank youSELECT Convert(varchar(10), GetDate(), 105) as date
For more option explore convert() function...sql
how to view data whilst in an uncompleted transaction, from outside the transaction?
Hi everyone, I was hioping to obtain some help with viewing sql data
whilst within a transaction, from OUTSIDE the transaction itself.
For example, if i do the following steps:
1)
-- Do this in Query Analyzer session 1 window
-- Note: there is no commit transaction below
begin transaction
use northwind
update customers
set postalcode = 2000
where customerid = 'BLONP'
2)
-- Do this in Query Analyzer session 2 window
-- This is where I want to view the modified data
-- prior to commiting the transaction
use northwind
select postalcode from customers
where customerid = 'BLONP'
3)
-- Do this in Query Analyzer session 1 window
-- Here I commit the transaction after reviewing
-- (via step 2) that the update statement is
-- producing the results that I want
commit transaction
The problem is that performing step 2 does not work as the transaction
in step 1 is obviously locking the customers table. I have looked into
setting isolation levels, but this doesn't seem to be working. The only
result that I am getting back from step 1 is that one row has been
modified. This is an obvious help as I know that not all rows have been
affected by my update, but tells me very little.
The reason I want to be able to do the 1-2-3 step oricess is sometimes
I need to do a complex update, and wish to review the results of my
update prior to commiting. I don't want to rely on updating "test" data
alone as a gauge to the correctness of my update statement.
Any help on this would be great!
cheers,
peterCan you not just do this all in one query window:?
Start Transaction
Issue modification statements
perform queries to validate the changes
Committ or rollback as desired
<mag1kus@.yahoo.com> wrote in message
news:1143076873.038566.151900@.j33g2000cwa.googlegroups.com...
> Hi everyone, I was hioping to obtain some help with viewing sql data
> whilst within a transaction, from OUTSIDE the transaction itself.
> For example, if i do the following steps:
> 1)
> -- Do this in Query Analyzer session 1 window
> -- Note: there is no commit transaction below
> begin transaction
> use northwind
> update customers
> set postalcode = 2000
> where customerid = 'BLONP'
> 2)
> -- Do this in Query Analyzer session 2 window
> -- This is where I want to view the modified data
> -- prior to commiting the transaction
> use northwind
> select postalcode from customers
> where customerid = 'BLONP'
> 3)
> -- Do this in Query Analyzer session 1 window
> -- Here I commit the transaction after reviewing
> -- (via step 2) that the update statement is
> -- producing the results that I want
> commit transaction
>
> The problem is that performing step 2 does not work as the transaction
> in step 1 is obviously locking the customers table. I have looked into
> setting isolation levels, but this doesn't seem to be working. The only
> result that I am getting back from step 1 is that one row has been
> modified. This is an obvious help as I know that not all rows have been
> affected by my update, but tells me very little.
> The reason I want to be able to do the 1-2-3 step oricess is sometimes
> I need to do a complex update, and wish to review the results of my
> update prior to commiting. I don't want to rely on updating "test" data
> alone as a gauge to the correctness of my update statement.
> Any help on this would be great!
> cheers,
> peter
>
whilst within a transaction, from OUTSIDE the transaction itself.
For example, if i do the following steps:
1)
-- Do this in Query Analyzer session 1 window
-- Note: there is no commit transaction below
begin transaction
use northwind
update customers
set postalcode = 2000
where customerid = 'BLONP'
2)
-- Do this in Query Analyzer session 2 window
-- This is where I want to view the modified data
-- prior to commiting the transaction
use northwind
select postalcode from customers
where customerid = 'BLONP'
3)
-- Do this in Query Analyzer session 1 window
-- Here I commit the transaction after reviewing
-- (via step 2) that the update statement is
-- producing the results that I want
commit transaction
The problem is that performing step 2 does not work as the transaction
in step 1 is obviously locking the customers table. I have looked into
setting isolation levels, but this doesn't seem to be working. The only
result that I am getting back from step 1 is that one row has been
modified. This is an obvious help as I know that not all rows have been
affected by my update, but tells me very little.
The reason I want to be able to do the 1-2-3 step oricess is sometimes
I need to do a complex update, and wish to review the results of my
update prior to commiting. I don't want to rely on updating "test" data
alone as a gauge to the correctness of my update statement.
Any help on this would be great!
cheers,
peterCan you not just do this all in one query window:?
Start Transaction
Issue modification statements
perform queries to validate the changes
Committ or rollback as desired
<mag1kus@.yahoo.com> wrote in message
news:1143076873.038566.151900@.j33g2000cwa.googlegroups.com...
> Hi everyone, I was hioping to obtain some help with viewing sql data
> whilst within a transaction, from OUTSIDE the transaction itself.
> For example, if i do the following steps:
> 1)
> -- Do this in Query Analyzer session 1 window
> -- Note: there is no commit transaction below
> begin transaction
> use northwind
> update customers
> set postalcode = 2000
> where customerid = 'BLONP'
> 2)
> -- Do this in Query Analyzer session 2 window
> -- This is where I want to view the modified data
> -- prior to commiting the transaction
> use northwind
> select postalcode from customers
> where customerid = 'BLONP'
> 3)
> -- Do this in Query Analyzer session 1 window
> -- Here I commit the transaction after reviewing
> -- (via step 2) that the update statement is
> -- producing the results that I want
> commit transaction
>
> The problem is that performing step 2 does not work as the transaction
> in step 1 is obviously locking the customers table. I have looked into
> setting isolation levels, but this doesn't seem to be working. The only
> result that I am getting back from step 1 is that one row has been
> modified. This is an obvious help as I know that not all rows have been
> affected by my update, but tells me very little.
> The reason I want to be able to do the 1-2-3 step oricess is sometimes
> I need to do a complex update, and wish to review the results of my
> update prior to commiting. I don't want to rely on updating "test" data
> alone as a gauge to the correctness of my update statement.
> Any help on this would be great!
> cheers,
> peter
>
How to view Cube in WEB Browser(IE) like Pivot tables of Excel
hi,Please! Help me.How to view Cube in WEB Browser(IE) like Pivot tables of Excel.
Your help is highly appreciated.
Your help is highly appreciated.
You can use the Save As Web page functionality from Excel and publish the web page on your web server.
You can also embed OWC Pivot table within your html page, setup appropriate connections to your cube to get the functionality.
--Siva
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thanks, Siva.But How to write code to call cube which i designed with sql server 2005 Analysis Services.Thanks in advanceSatyananda|||Enclosed is the reply I got from the OWC team. Let me know if this is what you are looking for.
OWC can connect to AS 2005 using the connection string property and either the data member or command text properties.
PivotTable.ConnectionString = “PROVIDER=MSOLAP;Data Source=[Valid Server Name];INITIAL CATALOG=[Valid AS Database Name];”
PivotTable.DataMember = “[Valid Cube Name]”
‘’ Or
‘’ PivotTable.CommandText = “[Valid MDX Statement that OWC can process]”
Notes:
1. There are some limitations to the MDX that can be executed by the OWC PivotTable object. OWC tries to parse the MDX to determine what belongs on what axis. If OWC can not determine what belongs on what axis, it will fail processing the MDX. However OWC has a pretty extensive object model that can be used to build the desired PivotTable.
2. OWC Controls are not “Web Controls” as defined by ASP.NET. OWC controls exist in only one location so things like server side “Code Behind” are not relevant.
3. On a web page, client side VBScript or Jscript/JavaScript can be used to run the object model.
4. Via the object model and event handling OWC provides the ability to add custom context menus and menu actions.
Regards
Siva
This posting is provided "AS IS" with no warranties, and confers no rights.
How to view constraints...?
Hi all. I have a SQL Server DB that i need to port out of SQL Server. I do not have a diagram illustrating the constraints in the construct of the tables. What is the best way to for me learn the relationships of the tables in sql server?
thanks for your helpI'd recommend using a tool like ErWin or Visio to construct a diagram.
If that isn't acceptable, I'd script the entire database using SQL Enterprise Mangler and look for the primary key and foreign key definitions. This is free, but it can take a lot of work.
If that doesn't work for you, then I'd need to understand why it wasn't acceptable before I could even venture a guess as to what you might want to try next.
-PatP|||You can also use sp_helpconstraint 'tablename' to find not only the freign keys on 'tablename', but also the foreign keys that reference 'tablename'.|||Where are you porting your db to? Are you sure that's what you want to do?
thanks for your helpI'd recommend using a tool like ErWin or Visio to construct a diagram.
If that isn't acceptable, I'd script the entire database using SQL Enterprise Mangler and look for the primary key and foreign key definitions. This is free, but it can take a lot of work.
If that doesn't work for you, then I'd need to understand why it wasn't acceptable before I could even venture a guess as to what you might want to try next.
-PatP|||You can also use sp_helpconstraint 'tablename' to find not only the freign keys on 'tablename', but also the foreign keys that reference 'tablename'.|||Where are you porting your db to? Are you sure that's what you want to do?
How to view audit logs using MSDE
I'm using a COTS product that bundles the Microsoft Database Engine (MSDE).
We had to enable C2 auditing within MSDE but don't know how to view the logs
that are produced. If using a full version of SQL Server, you can view the
logs using SQL Profiler but with MSDE, I don't see what I can use. Can
someone tell me how I can view these logs without installing a third party
product?
Thanks for the help,
MarkOne option is to use fn_trace_gettable.
You can execute a query to view the files with something
like:
select *
FROM ::fn_trace_gettable('D:PathToYour\TraceF
ile.trc,
default)
You could use a select * into to import the files into a
table if you prefer.
-Sue
On Wed, 19 Jan 2005 13:27:10 -0800, "Mark@.GDC4S"
<Mark@.GDC4S@.discussions.microsoft.com> wrote:
>I'm using a COTS product that bundles the Microsoft Database Engine (MSDE).
>We had to enable C2 auditing within MSDE but don't know how to view the log
s
>that are produced. If using a full version of SQL Server, you can view the
>logs using SQL Profiler but with MSDE, I don't see what I can use. Can
>someone tell me how I can view these logs without installing a third party
>product?
>Thanks for the help,
>Mark
We had to enable C2 auditing within MSDE but don't know how to view the logs
that are produced. If using a full version of SQL Server, you can view the
logs using SQL Profiler but with MSDE, I don't see what I can use. Can
someone tell me how I can view these logs without installing a third party
product?
Thanks for the help,
MarkOne option is to use fn_trace_gettable.
You can execute a query to view the files with something
like:
select *
FROM ::fn_trace_gettable('D:PathToYour\TraceF
ile.trc,
default)
You could use a select * into to import the files into a
table if you prefer.
-Sue
On Wed, 19 Jan 2005 13:27:10 -0800, "Mark@.GDC4S"
<Mark@.GDC4S@.discussions.microsoft.com> wrote:
>I'm using a COTS product that bundles the Microsoft Database Engine (MSDE).
>We had to enable C2 auditing within MSDE but don't know how to view the log
s
>that are produced. If using a full version of SQL Server, you can view the
>logs using SQL Profiler but with MSDE, I don't see what I can use. Can
>someone tell me how I can view these logs without installing a third party
>product?
>Thanks for the help,
>Mark
How to View AS400 library Files from OLEDB Source (SSIS)
HI,
I'm trying to get data from AS400. using OLEDB source as my connection. i'm using IBM OLEDB provider for iSeries. and working on standard edition of SQL Server 2005.
While using OLEDB source task when i set my access mode to 'table or view' and try to see list of available libraryname.tablenames, i do not get and tables
where as when i use Data access mode as 'SQL Command' i can get data (can only see preview of data) from AS400 but not able to insert that into my destination table. At run time task Fails with the error mentioned below.
I have configured Data links tab inside the OLEDB connection manager also, but when tried to set a default library it gives me error. : "Error code :CWBZZ5042" - ( catalog is invalid ) but it does exist.
Is there some settings that needs to be done from AS400 side or SQL Server side to view the available libray and its tables ?
Can some one help me on the same.
thanks in advance
Shah
Error Message received when executed with SQL command:
Error: 0xC0202009 at Data Flow Task, OLE DB Source [1]: An OLE DB error has occurred. Error code: 0x80040E00.
Error: 0xC0047038 at Data Flow Task, DTS.Pipeline: 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.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.
Error: 0xC0047039 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.
Task failed: Data Flow Task
Shah,
PLEASE stop reposting your same issue over and over again.|||
HI Phill,
I'm Not posting the same query again,
This query is specific to see the library and table names in the OLEDB source task .
I have got a solution to insert incremental data using ODBC but not using OLEDB ( http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1057881&SiteID=1 ),
still facing the same issue of insertion of data into database when SQL command is used as 'Data access mode'
anyone having idea on how to see library list of AS400 inside an OLEDB source task and why am i not been able to insert data to my destination when using sql mode?
Thanks !!
|||
amitshah003 wrote:
HI Phill,
I'm Not posting the same query again,
This query is specific to see the library and table names in the OLEDB source task .
I have got a solution to insert incremental data using ODBC but not using OLEDB ( http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1057881&SiteID=1 ),
still facing the same issue of insertion of data into database when SQL command is used as 'Data access mode'
anyone having idea on how to see library list of AS400 inside an OLEDB source task and why am i not been able to insert data to my destination when using sql mode?
Thanks !!
Have you searched the forums? Please see my post at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1021702&SiteID=1 on how to configure the Microsoft OLEDB for DB2 connector, if that will help.|||
Shah, the variable sytax is different between the two. OLEDB uses the @. symbol to identify variables the ODBC uses a '?' as a the identifier. look into this area.
I think this might be your issue.
Ryan
sqlHow to view all user permissions?
I've seriously looked, but this simple concept eludes me. How do I go about viewing all the permissions granted to a database user? Like whether or not they can execute a stored procedure.
Hi Xorcist,
To Query all the permissions granted to a user, you can query the sys.database_permissions table. It contains all the derived permission from role and explicitly granted permissions.
The Management Studio can only show the explicitly granted permissions. In this case, I suggest you query from that table.
For more information, please check
http://msdn2.microsoft.com/en-us/ms188367.aspx
HTH. If this does not answer your question, please feel free to mark the post as Not Answered and reply. Thank you!
How to view all triggers
I need a way to view all existing triggers in our MS Server database
especially since I don't know what tables are involved.
>
>
>
- Show quoted text -
Thanks!
especially since I don't know what tables are involved.
Thanks,
kwillaSQL Server 2000:
select *
from sysobjects
where xtype ='TR'
SQL Server 2005:
Select *
from sys.triggers
MC
"kwilla" <kwilla@.comcast.netwrote in message
news:1172666233.553151.165650@.j27g2000cwj.googlegr oups.com...
Quote:
Originally Posted by
>I need a way to view all existing triggers in our MS Server database
especially since I don't know what tables are involved.
>
Thanks,
>
kwilla
>
Quote:
Originally Posted by
SQL Server 2000:
select *
from sysobjects
where xtype ='TR'
>
SQL Server 2005:
Select *
from sys.triggers
>
MC
>
"kwilla" <kwi...@.comcast.netwrote in message
>
news:1172666233.553151.165650@.j27g2000cwj.googlegr oups.com...
>
>
>
Quote:
Originally Posted by
I need a way to view all existing triggers in our MS Server database
especially since I don't know what tables are involved.
>
Quote:
Originally Posted by
Thanks,
>
Quote:
Originally Posted by
kwilla- Hide quoted text -
>
- Show quoted text -
Thanks!
How to view all the indexes in a SQL Server 2000 database
I am looking for a transact sql that will allow me to view all the indexes in
a database without viewing them on a table by table basis.
What about
Select * from sysindexes ?
Or use the INFORMATION_SCHEMA Views.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Aboki" <Aboki@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B7AE0AE2-1FBB-4486-BBA5-9512F7AEE9FA@.microsoft.com...
>I am looking for a transact sql that will allow me to view all the indexes
>in
> a database without viewing them on a table by table basis.
|||You can use the undocumented sp sp_msforeachtable or create a cursor to
traverse information_schema.tables and execute for each table the sp
sp_helpindex, or as recommended by Jens, select from system table
"sysindexes".
Example:
use northwind
go
exec sp_msforeachtable 'select ''?'' as [table_name]; exec sp_helpindex [?]'
go
AMB
"Aboki" wrote:
> I am looking for a transact sql that will allow me to view all the indexes in
> a database without viewing them on a table by table basis.
|||SELECT 'dbcc showcontig (' +
CONVERT(varchar(20),i.id) + ',' + -- table id
CONVERT(varchar(20),i.indid) + ') -- ' + -- index id
object_name(i.id) + '.' + -- table name
i.name -- index name
from sysobjects o
inner join sysindexes i
on (o.id = i.id)
where o.type = 'U'
and i.indid < 2
and
i.id = object_id(o.name)
ORDER BY
object_name(i.id), i.indid
a database without viewing them on a table by table basis.
What about
Select * from sysindexes ?
Or use the INFORMATION_SCHEMA Views.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Aboki" <Aboki@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B7AE0AE2-1FBB-4486-BBA5-9512F7AEE9FA@.microsoft.com...
>I am looking for a transact sql that will allow me to view all the indexes
>in
> a database without viewing them on a table by table basis.
|||You can use the undocumented sp sp_msforeachtable or create a cursor to
traverse information_schema.tables and execute for each table the sp
sp_helpindex, or as recommended by Jens, select from system table
"sysindexes".
Example:
use northwind
go
exec sp_msforeachtable 'select ''?'' as [table_name]; exec sp_helpindex [?]'
go
AMB
"Aboki" wrote:
> I am looking for a transact sql that will allow me to view all the indexes in
> a database without viewing them on a table by table basis.
|||SELECT 'dbcc showcontig (' +
CONVERT(varchar(20),i.id) + ',' + -- table id
CONVERT(varchar(20),i.indid) + ') -- ' + -- index id
object_name(i.id) + '.' + -- table name
i.name -- index name
from sysobjects o
inner join sysindexes i
on (o.id = i.id)
where o.type = 'U'
and i.indid < 2
and
i.id = object_id(o.name)
ORDER BY
object_name(i.id), i.indid
How to view all the indexes in a SQL Server 2000 database
I am looking for a transact sql that will allow me to view all the indexes in
a database without viewing them on a table by table basis.What about
Select * from sysindexes ?
Or use the INFORMATION_SCHEMA Views.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Aboki" <Aboki@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B7AE0AE2-1FBB-4486-BBA5-9512F7AEE9FA@.microsoft.com...
>I am looking for a transact sql that will allow me to view all the indexes
>in
> a database without viewing them on a table by table basis.|||You can use the undocumented sp sp_msforeachtable or create a cursor to
traverse information_schema.tables and execute for each table the sp
sp_helpindex, or as recommended by Jens, select from system table
"sysindexes".
Example:
use northwind
go
exec sp_msforeachtable 'select ''?'' as [table_name]; exec sp_helpindex [?]'
go
AMB
"Aboki" wrote:
> I am looking for a transact sql that will allow me to view all the indexes in
> a database without viewing them on a table by table basis.|||SELECT 'dbcc showcontig (' +
CONVERT(varchar(20),i.id) + ',' + -- table id
CONVERT(varchar(20),i.indid) + ') -- ' + -- index id
object_name(i.id) + '.' + -- table name
i.name -- index name
from sysobjects o
inner join sysindexes i
on (o.id = i.id)
where o.type = 'U'
and i.indid < 2
and
i.id = object_id(o.name)
ORDER BY
object_name(i.id), i.indid
a database without viewing them on a table by table basis.What about
Select * from sysindexes ?
Or use the INFORMATION_SCHEMA Views.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Aboki" <Aboki@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B7AE0AE2-1FBB-4486-BBA5-9512F7AEE9FA@.microsoft.com...
>I am looking for a transact sql that will allow me to view all the indexes
>in
> a database without viewing them on a table by table basis.|||You can use the undocumented sp sp_msforeachtable or create a cursor to
traverse information_schema.tables and execute for each table the sp
sp_helpindex, or as recommended by Jens, select from system table
"sysindexes".
Example:
use northwind
go
exec sp_msforeachtable 'select ''?'' as [table_name]; exec sp_helpindex [?]'
go
AMB
"Aboki" wrote:
> I am looking for a transact sql that will allow me to view all the indexes in
> a database without viewing them on a table by table basis.|||SELECT 'dbcc showcontig (' +
CONVERT(varchar(20),i.id) + ',' + -- table id
CONVERT(varchar(20),i.indid) + ') -- ' + -- index id
object_name(i.id) + '.' + -- table name
i.name -- index name
from sysobjects o
inner join sysindexes i
on (o.id = i.id)
where o.type = 'U'
and i.indid < 2
and
i.id = object_id(o.name)
ORDER BY
object_name(i.id), i.indid
How to view all the indexes in a SQL Server 2000 database
I am looking for a transact sql that will allow me to view all the indexes i
n
a database without viewing them on a table by table basis.What about
Select * from sysindexes ?
Or use the INFORMATION_SCHEMA Views.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Aboki" <Aboki@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B7AE0AE2-1FBB-4486-BBA5-9512F7AEE9FA@.microsoft.com...
>I am looking for a transact sql that will allow me to view all the indexes
>in
> a database without viewing them on a table by table basis.|||You can use the undocumented sp sp_msforeachtable or create a cursor to
traverse information_schema.tables and execute for each table the sp
sp_helpindex, or as recommended by Jens, select from system table
"sysindexes".
Example:
use northwind
go
exec sp_msforeachtable 'select ''?'' as [table_name]; exec sp_helpindex
[?]'
go
AMB
"Aboki" wrote:
> I am looking for a transact sql that will allow me to view all the indexes
in
> a database without viewing them on a table by table basis.|||SELECT 'dbcc showcontig (' +
CONVERT(varchar(20),i.id) + ',' + -- table id
CONVERT(varchar(20),i.indid) + ') -- ' + -- index id
object_name(i.id) + '.' + -- table name
i.name -- index name
from sysobjects o
inner join sysindexes i
on (o.id = i.id)
where o.type = 'U'
and i.indid < 2
and
i.id = object_id(o.name)
ORDER BY
object_name(i.id), i.indidsql
n
a database without viewing them on a table by table basis.What about
Select * from sysindexes ?
Or use the INFORMATION_SCHEMA Views.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Aboki" <Aboki@.discussions.microsoft.com> schrieb im Newsbeitrag
news:B7AE0AE2-1FBB-4486-BBA5-9512F7AEE9FA@.microsoft.com...
>I am looking for a transact sql that will allow me to view all the indexes
>in
> a database without viewing them on a table by table basis.|||You can use the undocumented sp sp_msforeachtable or create a cursor to
traverse information_schema.tables and execute for each table the sp
sp_helpindex, or as recommended by Jens, select from system table
"sysindexes".
Example:
use northwind
go
exec sp_msforeachtable 'select ''?'' as [table_name]; exec sp_helpindex
[?]'
go
AMB
"Aboki" wrote:
> I am looking for a transact sql that will allow me to view all the indexes
in
> a database without viewing them on a table by table basis.|||SELECT 'dbcc showcontig (' +
CONVERT(varchar(20),i.id) + ',' + -- table id
CONVERT(varchar(20),i.indid) + ') -- ' + -- index id
object_name(i.id) + '.' + -- table name
i.name -- index name
from sysobjects o
inner join sysindexes i
on (o.id = i.id)
where o.type = 'U'
and i.indid < 2
and
i.id = object_id(o.name)
ORDER BY
object_name(i.id), i.indidsql
how to view a user-owned object in sql server 7.0
how to view a user-owned object in sql server 7.0Hi,
select name from sysobjects where user_name(uid)='username'
Thanks
Hari
MCDBA
"jane lu" <anonymous@.discussions.microsoft.com> wrote in message
news:EE442784-D97C-4A12-BB3E-E4D287C3E335@.microsoft.com...
select name from sysobjects where user_name(uid)='username'
Thanks
Hari
MCDBA
"jane lu" <anonymous@.discussions.microsoft.com> wrote in message
news:EE442784-D97C-4A12-BB3E-E4D287C3E335@.microsoft.com...
quote:
>
How to view a table from another instance?
Hi,
on our server we have a default SQL 2000 instance and also another MSDE
instance with the name server\instance1.
In one of my database of the default instance I would like to create a view
to the table from the another instance. I have tried with select statement
like
SELECT * FROM server\instance1.database1.dbo.table1
but with no success (parsing problem :-) ).
Next I have tried to make a linked server but I din't succees also. How to
establish a linked server to another instance of the same server? Can
anybody help me?
IvanYou will either have to use a linked server, then you could use the
four part notation like SELECT * from
LinkedServername.Database.Owner.Objectname or you use the
OPENDATASOURCE method which can take a connection string for
establishing a connection to the other server.
HTH, Jens Suessmeyer
http://www.sqlserver2005.de
--|||Hi,
As you mentioned to access the data in a different instance you need to
create a Linked server.
Take a look into my article on creating Linked servers:-
http://www.microsoft.com/India/msdn/articles/166.aspx
Thanks
Hari
SQL Server MVP
"Ivan" <ivan@.nekje.si> wrote in message
news:u2Ri%23BB0GHA.5072@.TK2MSFTNGP03.phx.gbl...
> Hi,
> on our server we have a default SQL 2000 instance and also another MSDE
> instance with the name server\instance1.
> In one of my database of the default instance I would like to create a
> view to the table from the another instance. I have tried with select
> statement like
> SELECT * FROM server\instance1.database1.dbo.table1
> but with no success (parsing problem :-) ).
> Next I have tried to make a linked server but I din't succees also. How to
> establish a linked server to another instance of the same server? Can
> anybody help me?
> Ivan
>
>|||As others have indicated, first you need to create a linked server. Then, si
nce the instance name has a 'prohibited' character, the 'backslash' [\],
you will need to put the instance name in square brackets when you use it i
n a query.
SELECT
Column1
, Column2
, etc.
FROM [server\instance1].database1.dbo.table1
Also, please consider NOT using [ SELECT * ] and instead, using a named
list of columns. Not only is it a 'Best Practice', it will enable your code
to be more robust.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Ivan" <ivan@.nekje.si> wrote in message news:u2Ri%23BB0GHA.5072@.TK2MSFTNGP03.phx.gbl...[vbco
l=seagreen]
> Hi,
>
> on our server we have a default SQL 2000 instance and also another MSDE
> instance with the name server\instance1.
>
> In one of my database of the default instance I would like to create a vie
w
> to the table from the another instance. I have tried with select statement
> like
> SELECT * FROM server\instance1.database1.dbo.table1
> but with no success (parsing problem :-) ).
>
> Next I have tried to make a linked server but I din't succees also. How to
> establish a linked server to another instance of the same server? Can
> anybody help me?
>
> Ivan
>
>
>[/vbcol]|||Hi. There's no need to establish the server as "linked"
Look here
First a query against the second instance named ui0204\no2:
SELECT * from [ui0204\no2].bookshopdb.dbo.employees
RESPONSE:
Server: Msg 7411, Level 16, State 1, Line 1
Server 'ui0204\no2' is not configured for DATA ACCESS
Then we need to enable ui0204\no2 for data access
sp_serveroption @.server=[ui0204\no2], @.optname='data access', @.optvalue=
'TRUE'
RESPONSE:
The command(s) completed successfully.
Try the query again
SELECT * from [ui0204\no2].bookshopdb.dbo.employees
RESPONSE:
(13 row(s) affected)
That's how it's done.
gl
tt
"Arnie Rowland" wrote:
[vbcol=seagreen]
> As others have indicated, first you need to create a linked server. Then,
since the instance name has a 'prohibited' character, the 'backslash' [\
], you will need to put the instance name in square brackets when you use it
in a query.
> SELECT
> Column1
> , Column2
> , etc.
> FROM [server\instance1].database1.dbo.table1
> Also, please consider NOT using [ SELECT * ] and instead, using a name
d list of columns. Not only is it a 'Best Practice', it will enable your cod
e to be more robust.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "Ivan" <ivan@.nekje.si> wrote in message news:u2Ri%23BB0GHA.5072@.TK2MSFTNGP
03.phx.gbl...
on our server we have a default SQL 2000 instance and also another MSDE
instance with the name server\instance1.
In one of my database of the default instance I would like to create a view
to the table from the another instance. I have tried with select statement
like
SELECT * FROM server\instance1.database1.dbo.table1
but with no success (parsing problem :-) ).
Next I have tried to make a linked server but I din't succees also. How to
establish a linked server to another instance of the same server? Can
anybody help me?
IvanYou will either have to use a linked server, then you could use the
four part notation like SELECT * from
LinkedServername.Database.Owner.Objectname or you use the
OPENDATASOURCE method which can take a connection string for
establishing a connection to the other server.
HTH, Jens Suessmeyer
http://www.sqlserver2005.de
--|||Hi,
As you mentioned to access the data in a different instance you need to
create a Linked server.
Take a look into my article on creating Linked servers:-
http://www.microsoft.com/India/msdn/articles/166.aspx
Thanks
Hari
SQL Server MVP
"Ivan" <ivan@.nekje.si> wrote in message
news:u2Ri%23BB0GHA.5072@.TK2MSFTNGP03.phx.gbl...
> Hi,
> on our server we have a default SQL 2000 instance and also another MSDE
> instance with the name server\instance1.
> In one of my database of the default instance I would like to create a
> view to the table from the another instance. I have tried with select
> statement like
> SELECT * FROM server\instance1.database1.dbo.table1
> but with no success (parsing problem :-) ).
> Next I have tried to make a linked server but I din't succees also. How to
> establish a linked server to another instance of the same server? Can
> anybody help me?
> Ivan
>
>|||As others have indicated, first you need to create a linked server. Then, si
nce the instance name has a 'prohibited' character, the 'backslash' [\],
you will need to put the instance name in square brackets when you use it i
n a query.
SELECT
Column1
, Column2
, etc.
FROM [server\instance1].database1.dbo.table1
Also, please consider NOT using [ SELECT * ] and instead, using a named
list of columns. Not only is it a 'Best Practice', it will enable your code
to be more robust.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Ivan" <ivan@.nekje.si> wrote in message news:u2Ri%23BB0GHA.5072@.TK2MSFTNGP03.phx.gbl...[vbco
l=seagreen]
> Hi,
>
> on our server we have a default SQL 2000 instance and also another MSDE
> instance with the name server\instance1.
>
> In one of my database of the default instance I would like to create a vie
w
> to the table from the another instance. I have tried with select statement
> like
> SELECT * FROM server\instance1.database1.dbo.table1
> but with no success (parsing problem :-) ).
>
> Next I have tried to make a linked server but I din't succees also. How to
> establish a linked server to another instance of the same server? Can
> anybody help me?
>
> Ivan
>
>
>[/vbcol]|||Hi. There's no need to establish the server as "linked"
Look here
First a query against the second instance named ui0204\no2:
SELECT * from [ui0204\no2].bookshopdb.dbo.employees
RESPONSE:
Server: Msg 7411, Level 16, State 1, Line 1
Server 'ui0204\no2' is not configured for DATA ACCESS
Then we need to enable ui0204\no2 for data access
sp_serveroption @.server=[ui0204\no2], @.optname='data access', @.optvalue=
'TRUE'
RESPONSE:
The command(s) completed successfully.
Try the query again
SELECT * from [ui0204\no2].bookshopdb.dbo.employees
RESPONSE:
(13 row(s) affected)
That's how it's done.
gl
tt
"Arnie Rowland" wrote:
[vbcol=seagreen]
> As others have indicated, first you need to create a linked server. Then,
since the instance name has a 'prohibited' character, the 'backslash' [\
], you will need to put the instance name in square brackets when you use it
in a query.
> SELECT
> Column1
> , Column2
> , etc.
> FROM [server\instance1].database1.dbo.table1
> Also, please consider NOT using [ SELECT * ] and instead, using a name
d list of columns. Not only is it a 'Best Practice', it will enable your cod
e to be more robust.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "Ivan" <ivan@.nekje.si> wrote in message news:u2Ri%23BB0GHA.5072@.TK2MSFTNGP
03.phx.gbl...
How to View a Scheduled Job?
Silly question from a Beginner!
I have created two jobs in enterprise manager using Tools - Job Scheduling.
The jobs are working at the scheduled times, however I want to view one of them in order to check I haven't missed anything.
How do I do this?
Hi there,In Enterprise Manager expand the nodes on the left hand side of the screen like this:
Console Root > Microsoft SQL Servers > SQL Server Groups (May be diff for you if you created your own group) > Server Name > Management > SQL Server Agent > Jobs
Click on the "Jobs" node and a list of jobs will display in Enterprise Manager.
To see the history of the job (e.g. execution time, execution success of failure) right click on the job and select "View Job History..." from the context menu that appears.
Hope that helps but sorry if it didn't
|||
Excellent, there they are!
Thanks very much.
How to version control in SQL 2000?
Hi.
I would like to version control my data in SQL 2000. Currently I've
stored the data/time info of my data whenever I add or edit the table.
Are there such built in support in SQL 2000? If not, anyone care to
share some tips and tricks to perform version control with SQL 2000?
Thank you.kackson scratched out in the sand
I would like to version control my data in SQL 2000. Currently I've
stored the data/time info of my data whenever I add or edit the table.
Are there such built in support in SQL 2000? If not, anyone care to
share some tips and tricks to perform version control with SQL 2000?
Thank you.kackson scratched out in the sand
> Hi.
> I would like to version control my data in SQL 2000. Currently I've
> stored the data/time info of my data whenever I add or edit the table.
> Are there such built in support in SQL 2000? If not, anyone care to
> share some tips and tricks to perform version control with SQL 2000?
> Thank you.
I'd say use a VC system such as CVS or subversion and store your exported
schema there.
--
kai - kai at 3gproductions dot com
www.gamephreakz.com || www.filesite.org
"friends don't let friends use windows xp"|||kackson (kackson@.yahoo.com) writes:
> I would like to version control my data in SQL 2000. Currently I've
> stored the data/time info of my data whenever I add or edit the table.
> Are there such built in support in SQL 2000? If not, anyone care to
> share some tips and tricks to perform version control with SQL 2000?
No, there is no built-in support, and you better come up with a
requirement specification of what you really want, because this may be a
tall order. It's certainly nothing you do for fun.
I really don't want to say more until I know more about your system.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
How to verify user's login and IP with SQL Authentication?
I have SQL server 2000 with SQL Authentication. Can I verify user's
login and IP when he is connecting to the server. Our network doesn't
use Domain. All what I want is just - "User can logging only from his
computer".
Thanks
I don't know of a simple way of getting hold of the IP address of the
client - I suspect if there is a means, it's not particularly nice.
You can get the name of the client's PC, using HOST_NAME(), SUSER_SNAME()
will get you the login.
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:42e7dba4-bdb1-40d7-8d36-515978fa96ac@.d21g2000prf.googlegroups.com...
>I have SQL server 2000 with SQL Authentication. Can I verify user's
> login and IP when he is connecting to the server. Our network doesn't
> use Domain. All what I want is just - "User can logging only from his
> computer".
> Thanks
|||A bit of searching turned up this:
http://www.codeprof.com/dev-archive/33/19-85-338850.shtm
...I would advise considering an upgrade to 2005 if and when you can - the
fact that you can get the IP address from the connections DMV is just one of
the wonders that the DMVs/DMFs can work!
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:42e7dba4-bdb1-40d7-8d36-515978fa96ac@.d21g2000prf.googlegroups.com...
>I have SQL server 2000 with SQL Authentication. Can I verify user's
> login and IP when he is connecting to the server. Our network doesn't
> use Domain. All what I want is just - "User can logging only from his
> computer".
> Thanks
|||2 Will Alber
Thanks for link. Unfortunately we can't upgrate to 2005 8( But how to
retrieve this information from moment when user is trying to connect.
Maybe I need to write DLL (I know C++ well) or trigger on that event.
This is very important for me, because it touches on the security of
our network.
|||2 Tibor Karaszi
Understood. I was have one's suggestion from community. It's including
setup a middle level (ISA server - proxy) between a user and SQL
Server. Of course I can analysing IP address, but how to get SQL
login? And where I can read about installing such thing?
sql
login and IP when he is connecting to the server. Our network doesn't
use Domain. All what I want is just - "User can logging only from his
computer".
Thanks
I don't know of a simple way of getting hold of the IP address of the
client - I suspect if there is a means, it's not particularly nice.
You can get the name of the client's PC, using HOST_NAME(), SUSER_SNAME()
will get you the login.
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:42e7dba4-bdb1-40d7-8d36-515978fa96ac@.d21g2000prf.googlegroups.com...
>I have SQL server 2000 with SQL Authentication. Can I verify user's
> login and IP when he is connecting to the server. Our network doesn't
> use Domain. All what I want is just - "User can logging only from his
> computer".
> Thanks
|||A bit of searching turned up this:
http://www.codeprof.com/dev-archive/33/19-85-338850.shtm
...I would advise considering an upgrade to 2005 if and when you can - the
fact that you can get the IP address from the connections DMV is just one of
the wonders that the DMVs/DMFs can work!
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:42e7dba4-bdb1-40d7-8d36-515978fa96ac@.d21g2000prf.googlegroups.com...
>I have SQL server 2000 with SQL Authentication. Can I verify user's
> login and IP when he is connecting to the server. Our network doesn't
> use Domain. All what I want is just - "User can logging only from his
> computer".
> Thanks
|||2 Will Alber
Thanks for link. Unfortunately we can't upgrate to 2005 8( But how to
retrieve this information from moment when user is trying to connect.
Maybe I need to write DLL (I know C++ well) or trigger on that event.
This is very important for me, because it touches on the security of
our network.
|||2 Tibor Karaszi
Understood. I was have one's suggestion from community. It's including
setup a middle level (ISA server - proxy) between a user and SQL
Server. Of course I can analysing IP address, but how to get SQL
login? And where I can read about installing such thing?
sql
How to verify user's login and IP with SQL Authentication?
I have SQL server 2000 with SQL Authentication. Can I verify user's
login and IP when he is connecting to the server. Our network doesn't
use Domain. All what I want is just - "User can logging only from his
computer".
ThanksI don't know of a simple way of getting hold of the IP address of the
client - I suspect if there is a means, it's not particularly nice.
You can get the name of the client's PC, using HOST_NAME(), SUSER_SNAME()
will get you the login.
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:42e7dba4-bdb1-40d7-8d36-515978fa96ac@.d21g2000prf.googlegroups.com...
>I have SQL server 2000 with SQL Authentication. Can I verify user's
> login and IP when he is connecting to the server. Our network doesn't
> use Domain. All what I want is just - "User can logging only from his
> computer".
> Thanks|||A bit of searching turned up this:
http://www.codeprof.com/dev-archive/33/19-85-338850.shtm
...I would advise considering an upgrade to 2005 if and when you can - the
fact that you can get the IP address from the connections DMV is just one of
the wonders that the DMVs/DMFs can work!
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:42e7dba4-bdb1-40d7-8d36-515978fa96ac@.d21g2000prf.googlegroups.com...
>I have SQL server 2000 with SQL Authentication. Can I verify user's
> login and IP when he is connecting to the server. Our network doesn't
> use Domain. All what I want is just - "User can logging only from his
> computer".
> Thanks|||2 Will Alber
Thanks for link. Unfortunately we can't upgrate to 2005 8( But how to
retrieve this information from moment when user is trying to connect.
Maybe I need to write DLL (I know C++ well) or trigger on that event.
This is very important for me, because it touches on the security of
our network.|||SQL Server 2005 (sp2) has Logon Triggers, from which you would validate these things (from instance
using a SQLCLR function). But 2000 doesn't have such. So you either would have to do this in the
client app when connecting or have some polling mechanism which validates and kicks out non-OK
connections.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:1676cc54-fa20-43f5-a078-326134234d62@.k39g2000hsf.googlegroups.com...
>2 Will Alber
> Thanks for link. Unfortunately we can't upgrate to 2005 8( But how to
> retrieve this information from moment when user is trying to connect.
> Maybe I need to write DLL (I know C++ well) or trigger on that event.
> This is very important for me, because it touches on the security of
> our network.|||2 Tibor Karaszi
Understood. I was have one's suggestion from community. It's including
setup a middle level (ISA server - proxy) between a user and SQL
Server. Of course I can analysing IP address, but how to get SQL
login? And where I can read about installing such thing?|||I think the easy and best solution is to turn on windows firewall (or
another firewall) and create a rule to allow connections only from the
computer you want. SQL Server is not built to act as a TCP/IP request
filter.
--
Rubén Garrigós
Solid Quality Mentors
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:42e7dba4-bdb1-40d7-8d36-515978fa96ac@.d21g2000prf.googlegroups.com...
>I have SQL server 2000 with SQL Authentication. Can I verify user's
> login and IP when he is connecting to the server. Our network doesn't
> use Domain. All what I want is just - "User can logging only from his
> computer".
> Thanks
login and IP when he is connecting to the server. Our network doesn't
use Domain. All what I want is just - "User can logging only from his
computer".
ThanksI don't know of a simple way of getting hold of the IP address of the
client - I suspect if there is a means, it's not particularly nice.
You can get the name of the client's PC, using HOST_NAME(), SUSER_SNAME()
will get you the login.
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:42e7dba4-bdb1-40d7-8d36-515978fa96ac@.d21g2000prf.googlegroups.com...
>I have SQL server 2000 with SQL Authentication. Can I verify user's
> login and IP when he is connecting to the server. Our network doesn't
> use Domain. All what I want is just - "User can logging only from his
> computer".
> Thanks|||A bit of searching turned up this:
http://www.codeprof.com/dev-archive/33/19-85-338850.shtm
...I would advise considering an upgrade to 2005 if and when you can - the
fact that you can get the IP address from the connections DMV is just one of
the wonders that the DMVs/DMFs can work!
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:42e7dba4-bdb1-40d7-8d36-515978fa96ac@.d21g2000prf.googlegroups.com...
>I have SQL server 2000 with SQL Authentication. Can I verify user's
> login and IP when he is connecting to the server. Our network doesn't
> use Domain. All what I want is just - "User can logging only from his
> computer".
> Thanks|||2 Will Alber
Thanks for link. Unfortunately we can't upgrate to 2005 8( But how to
retrieve this information from moment when user is trying to connect.
Maybe I need to write DLL (I know C++ well) or trigger on that event.
This is very important for me, because it touches on the security of
our network.|||SQL Server 2005 (sp2) has Logon Triggers, from which you would validate these things (from instance
using a SQLCLR function). But 2000 doesn't have such. So you either would have to do this in the
client app when connecting or have some polling mechanism which validates and kicks out non-OK
connections.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:1676cc54-fa20-43f5-a078-326134234d62@.k39g2000hsf.googlegroups.com...
>2 Will Alber
> Thanks for link. Unfortunately we can't upgrate to 2005 8( But how to
> retrieve this information from moment when user is trying to connect.
> Maybe I need to write DLL (I know C++ well) or trigger on that event.
> This is very important for me, because it touches on the security of
> our network.|||2 Tibor Karaszi
Understood. I was have one's suggestion from community. It's including
setup a middle level (ISA server - proxy) between a user and SQL
Server. Of course I can analysing IP address, but how to get SQL
login? And where I can read about installing such thing?|||I think the easy and best solution is to turn on windows firewall (or
another firewall) and create a rule to allow connections only from the
computer you want. SQL Server is not built to act as a TCP/IP request
filter.
--
Rubén Garrigós
Solid Quality Mentors
"mildlimit" <mildlimit@.gmail.com> wrote in message
news:42e7dba4-bdb1-40d7-8d36-515978fa96ac@.d21g2000prf.googlegroups.com...
>I have SQL server 2000 with SQL Authentication. Can I verify user's
> login and IP when he is connecting to the server. Our network doesn't
> use Domain. All what I want is just - "User can logging only from his
> computer".
> Thanks
How to verify the validity of a file prior to attempting restore?
Hello,
I would like a way to check a file before attempting to restore it. I want to be able to tell that this is a valid SQL backup file and not just some random file before I attempt a restore.
Any help would be appreciated!
hassiahLookup [RESTORE VERIFYONLY] in Books Online.|||
Arnie Rowland wrote:
Lookup [RESTORE VERIFYONLY] in Books Online.
VERIFYONLY, yes, to verify the backup integrity (look at header and more...)
Also this may help
-- First determine the number and names of the files in the backup.
RESTORE FILELISTONLY
FROM DISK = N'\\Directory\Backup_Name.bak'
I forgot to mention that I was trying to do this programmatically in .NET... c# 2.0... I guess that is why my post got moved here... anyway, the answer, from another forum here, was to use the SqlVerify method of the SMO Restore object. Worked great!
Thanks to all for their comments.
-hassiah
How to verify the validity of a file prior to attempting restore?
Hello,
I would like a way to check a file before attempting to restore it. I want to be able to tell that this is a valid SQL backup file and not just some random file before I attempt a restore.
Any help would be appreciated!
hassiah
Lookup [RESTORE VERIFYONLY] in Books Online.|||
Lookup [RESTORE VERIFYONLY] in Books Online.
VERIFYONLY, yes, to verify the backup integrity (look at header and more...)
Also this may help
-- First determine the number and names of the files in the backup.
RESTORE FILELISTONLY
FROM DISK = N'\\Directory\Backup_Name.bak'
I forgot to mention that I was trying to do this programmatically in .NET... c# 2.0... I guess that is why my post got moved here... anyway, the answer, from another forum here, was to use the SqlVerify method of the SMO Restore object. Worked great!
Thanks to all for their comments.
-hassiah
How to verify the Service Pack I applied before?
How to verify the Service Pack I applied before?http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>
|||Hi,
Execute the below command from Query analyzer:-
-- FOR SQL 2000
select serverproperty('ProductLevel')
-- For SQL 7 and old
Select @.@.version
Get the version number and look into below site for service pack .
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13956
Thanks
Hari
MCDBA
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>
http://www.aspfaq.com/
(Reverse address to reply.)
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>
|||Hi,
Execute the below command from Query analyzer:-
-- FOR SQL 2000
select serverproperty('ProductLevel')
-- For SQL 7 and old
Select @.@.version
Get the version number and look into below site for service pack .
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13956
Thanks
Hari
MCDBA
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>
How to verify the Service Pack I applied before?
How to verify the Service Pack I applied before?http://www.aspfaq.com/2160
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>|||Hi,
Execute the below command from Query analyzer:-
-- FOR SQL 2000
select serverproperty('ProductLevel')
-- For SQL 7 and old
Select @.@.version
Get the version number and look into below site for service pack .
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13956
Thanks
Hari
MCDBA
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>|||>--Original Message--
>Hi,
>Execute the below command from Query analyzer:-
>-- FOR SQL 2000
>select serverproperty('ProductLevel')
>
>-- For SQL 7 and old
>Select @.@.version
>Get the version number and look into below site for
service pack .
>http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13956
>
>Thanks
>Hari
>MCDBA
>
>"Julia" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>
>.
>sql
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>|||Hi,
Execute the below command from Query analyzer:-
-- FOR SQL 2000
select serverproperty('ProductLevel')
-- For SQL 7 and old
Select @.@.version
Get the version number and look into below site for service pack .
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13956
Thanks
Hari
MCDBA
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>|||>--Original Message--
>Hi,
>Execute the below command from Query analyzer:-
>-- FOR SQL 2000
>select serverproperty('ProductLevel')
>
>-- For SQL 7 and old
>Select @.@.version
>Get the version number and look into below site for
service pack .
>http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13956
>
>Thanks
>Hari
>MCDBA
>
>"Julia" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1728101c448ab$b78daf60$a501280a@.phx.gbl...
>
>.
>sql
How to verify the Service Pack I applied before?
How to verify the Service Pack I applied before?http://www.aspfaq.com/2160
http://www.aspfaq.com/
(Reverse address to reply.)
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx
.gbl...
>|||Hi,
Execute the below command from Query analyzer:-
-- FOR SQL 2000
select serverproperty('ProductLevel')
-- For SQL 7 and old
Select @.@.version
Get the version number and look into below site for service pack .
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13956
Thanks
Hari
MCDBA
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx
.gbl...
>
http://www.aspfaq.com/
(Reverse address to reply.)
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx
.gbl...
>|||Hi,
Execute the below command from Query analyzer:-
-- FOR SQL 2000
select serverproperty('ProductLevel')
-- For SQL 7 and old
Select @.@.version
Get the version number and look into below site for service pack .
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=13956
Thanks
Hari
MCDBA
"Julia" <anonymous@.discussions.microsoft.com> wrote in message
news:1728101c448ab$b78daf60$a501280a@.phx
.gbl...
>
How to verify the integrity of a back-up file prior to restore?
Hello,
I have some C# (.NET 2.0) code that performs back-ups and also can perform restores of back-up files. I would like to validate the integrity of a file prior to initiating a restore operation. In other words, I want to know, before I try to restore, if the file is just a random file (picture, work doc, zipped backup, etc.) or if it is a valid SQL backup file.
Any help would be greatly appreciated.
Thanks,
hassiahHi,
look at the Restore Class in SMO, it has a method for verifying the media.
Restore.SqlVerify()
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Jens,
Exactly what I needed... thanks a bunch! Sorry I didn't get back sooner.
hassiah
How to verify the integrity of a back-up file prior to restore?
Hello,
I have some C# (.NET 2.0) code that performs back-ups and also can perform restores of back-up files. I would like to validate the integrity of a file prior to initiating a restore operation. In other words, I want to know, before I try to restore, if the file is just a random file (picture, work doc, zipped backup, etc.) or if it is a valid SQL backup file.
Any help would be greatly appreciated.
Thanks,
hassiah
Hi,
look at the Restore Class in SMO, it has a method for verifying the media.
Restore.SqlVerify()
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Jens,
Exactly what I needed... thanks a bunch! Sorry I didn't get back sooner.
hassiah
How to verify the agent is up on a remote host?
Hi,
Somtimes the agent will just die on some computers...
I'd like to have a job monitoring the agent every 20 minutes or so..
Do you know of a way to tell if the agent is up or no using plain Tsql?
Somtimes the agent will just die on some computers...
I'd like to have a job monitoring the agent every 20 minutes or so..
Do you know of a way to tell if the agent is up or no using plain Tsql?
Thanks
GasparGaspar_Gonzalez@.hotmail.com (Gaspar) wrote in message news:<e9fbe762.0309092128.72828b9d@.posting.google.com>...
> Hi,
> Somtimes the agent will just die on some computers...
> I'd like to have a job monitoring the agent every 20 minutes or so..
> Do you know of a way to tell if the agent is up or no using plain Tsql?
> Thanks
> Gaspar
It's probably better to look at it as an operating system issue - how
to monitor the state of a service (I'm assuming you're not using
Windows 98). You can use WMI to query the state of any service, or the
SQLDMO JobServer.Status property for SQL Agent specifically.
You could do this from TSQL with the sp_OA% procs, but I find tasks
like this are a lot easier to implement outside MSSQL, from some sort
of monitoring station (even if that's just your own PC running a Perl
script). And then you have a solution that you can easily modify to
monitor any and all services you may need to watch.
Simonsql
How to verify that the data of one table is a subset of another ta
Hi all,
I have two databases of same schema. Data in one database is supposed to be
a subset of another database. Is there any way to verify that?
Thanks,
LarryHi,
Did you mean the data in both databases are same or just the subset. If your
objective is to compare the data then you could go
for SQLDataCompare a tool from redgate software.
http://www.red-gate.com/products/SQ...mpare/index.htm
Thanks
Hari
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message
news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...
> Hi all,
> I have two databases of same schema. Data in one database is supposed to
> be
> a subset of another database. Is there any way to verify that?
> Thanks,
> Larry|||Assume that database. [dbB].dbo.MyTable is a subset of [dbA].dbo.MyT
able.
This query should return any rows in [dbB] that do NOT exists in [db
A]. If you want to verify down to the field level, it will take some more wo
rk.
SELECT b.PKField
FROM [dbB].dbo.MyTable b
LEFT JOIN [dbA].dbo.MyTable a
ON b.PKField = a.PKField
WHERE a.PKField IS NULL
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message news:226C3EBE-F747-460E-9A
B8-71049B973AC3@.microsoft.com...
> Hi all,
>
> I have two databases of same schema. Data in one database is supposed to
be
> a subset of another database. Is there any way to verify that?
>
> Thanks,
> Larry|||Larry,
there is a utility in SQL Server 2005 for this called TABLEDIFF
(http://www.replicationanswers.com/TableDiff2005.asp). It can be useful for
single tables but if you have a number that need comparing then I'd use
DataCompare as Hari Prasad mentions.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
I have two databases of same schema. Data in one database is supposed to be
a subset of another database. Is there any way to verify that?
Thanks,
LarryHi,
Did you mean the data in both databases are same or just the subset. If your
objective is to compare the data then you could go
for SQLDataCompare a tool from redgate software.
http://www.red-gate.com/products/SQ...mpare/index.htm
Thanks
Hari
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message
news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...
> Hi all,
> I have two databases of same schema. Data in one database is supposed to
> be
> a subset of another database. Is there any way to verify that?
> Thanks,
> Larry|||Assume that database. [dbB].dbo.MyTable is a subset of [dbA].dbo.MyT
able.
This query should return any rows in [dbB] that do NOT exists in [db
A]. If you want to verify down to the field level, it will take some more wo
rk.
SELECT b.PKField
FROM [dbB].dbo.MyTable b
LEFT JOIN [dbA].dbo.MyTable a
ON b.PKField = a.PKField
WHERE a.PKField IS NULL
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message news:226C3EBE-F747-460E-9A
B8-71049B973AC3@.microsoft.com...
> Hi all,
>
> I have two databases of same schema. Data in one database is supposed to
be
> a subset of another database. Is there any way to verify that?
>
> Thanks,
> Larry|||Larry,
there is a utility in SQL Server 2005 for this called TABLEDIFF
(http://www.replicationanswers.com/TableDiff2005.asp). It can be useful for
single tables but if you have a number that need comparing then I'd use
DataCompare as Hari Prasad mentions.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
How to verify that the data of one table is a subset of another ta
Hi all,
I have two databases of same schema. Data in one database is supposed to be
a subset of another database. Is there any way to verify that?
Thanks,
Larry
Hi,
Did you mean the data in both databases are same or just the subset. If your
objective is to compare the data then you could go
for SQLDataCompare a tool from redgate software.
http://www.red-gate.com/products/SQL...pare/index.htm
Thanks
Hari
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message
news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...
> Hi all,
> I have two databases of same schema. Data in one database is supposed to
> be
> a subset of another database. Is there any way to verify that?
> Thanks,
> Larry
|||Assume that database. [dbB].dbo.MyTable is a subset of [dbA].dbo.MyTable.
This query should return any rows in [dbB] that do NOT exists in [dbA]. If you want to verify down to the field level, it will take some more work.
SELECT b.PKField
FROM [dbB].dbo.MyTable b
LEFT JOIN [dbA].dbo.MyTable a
ON b.PKField = a.PKField
WHERE a.PKField IS NULL
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...
> Hi all,
> I have two databases of same schema. Data in one database is supposed to be
> a subset of another database. Is there any way to verify that?
> Thanks,
> Larry
|||Larry,
there is a utility in SQL Server 2005 for this called TABLEDIFF
(http://www.replicationanswers.com/TableDiff2005.asp). It can be useful for
single tables but if you have a number that need comparing then I'd use
DataCompare as Hari Prasad mentions.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
I have two databases of same schema. Data in one database is supposed to be
a subset of another database. Is there any way to verify that?
Thanks,
Larry
Hi,
Did you mean the data in both databases are same or just the subset. If your
objective is to compare the data then you could go
for SQLDataCompare a tool from redgate software.
http://www.red-gate.com/products/SQL...pare/index.htm
Thanks
Hari
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message
news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...
> Hi all,
> I have two databases of same schema. Data in one database is supposed to
> be
> a subset of another database. Is there any way to verify that?
> Thanks,
> Larry
|||Assume that database. [dbB].dbo.MyTable is a subset of [dbA].dbo.MyTable.
This query should return any rows in [dbB] that do NOT exists in [dbA]. If you want to verify down to the field level, it will take some more work.
SELECT b.PKField
FROM [dbB].dbo.MyTable b
LEFT JOIN [dbA].dbo.MyTable a
ON b.PKField = a.PKField
WHERE a.PKField IS NULL
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...
> Hi all,
> I have two databases of same schema. Data in one database is supposed to be
> a subset of another database. Is there any way to verify that?
> Thanks,
> Larry
|||Larry,
there is a utility in SQL Server 2005 for this called TABLEDIFF
(http://www.replicationanswers.com/TableDiff2005.asp). It can be useful for
single tables but if you have a number that need comparing then I'd use
DataCompare as Hari Prasad mentions.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
How to verify that the data of one table is a subset of another ta
Hi all,
I have two databases of same schema. Data in one database is supposed to be
a subset of another database. Is there any way to verify that?
Thanks,
LarryHi,
Did you mean the data in both databases are same or just the subset. If your
objective is to compare the data then you could go
for SQLDataCompare a tool from redgate software.
http://www.red-gate.com/products/SQL_Data_Compare/index.htm
Thanks
Hari
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message
news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...
> Hi all,
> I have two databases of same schema. Data in one database is supposed to
> be
> a subset of another database. Is there any way to verify that?
> Thanks,
> Larry|||This is a multi-part message in MIME format.
--=_NextPart_000_0FCD_01C6EBDE.88D49CA0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Assume that database. [dbB].dbo.MyTable is a subset of =[dbA].dbo.MyTable.
This query should return any rows in [dbB] that do NOT exists in [dbA]. =If you want to verify down to the field level, it will take some more =work.
SELECT b.PKField
FROM [dbB].dbo.MyTable b
LEFT JOIN [dbA].dbo.MyTable a
ON b.PKField =3D a.PKField
WHERE a.PKField IS NULL
-- Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message =news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...
> Hi all,
> > I have two databases of same schema. Data in one database is supposed =to be > a subset of another database. Is there any way to verify that?
> > Thanks,
> Larry
--=_NextPart_000_0FCD_01C6EBDE.88D49CA0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Assume that database. [dbB].dbo.MyTable =is a subset of [dbA].dbo.MyTable.
This query should return any rows in =[dbB] that do NOT exists in [dbA]. If you want to verify down to the field level, it =will take some more work.
SELECT b.PKField
FROM [dbB].dbo.MyTable =b
LEFT JOIN =[dbA].dbo.MyTable a
=ON b.PKField =3D a.PKField
WHERE a.PKField IS =NULL
-- Arnie Rowland, =Ph.D.Westwood Consulting, Inc
Most good judgment comes from =experience. Most experience comes from bad judgment. - Anonymous
"Larry Lau" wrote in message news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...> =Hi all,> > I have two databases of same schema. Data in one database =is supposed to be > a subset of another database. Is there any =way to verify that?> > Thanks,> Larry
--=_NextPart_000_0FCD_01C6EBDE.88D49CA0--|||Larry,
there is a utility in SQL Server 2005 for this called TABLEDIFF
(http://www.replicationanswers.com/TableDiff2005.asp). It can be useful for
single tables but if you have a number that need comparing then I'd use
DataCompare as Hari Prasad mentions.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Thanks, Hari and Paul.
Is there any similar tools for SQL Server 2000?
"Paul Ibison" wrote:
> Larry,
> there is a utility in SQL Server 2005 for this called TABLEDIFF
> (http://www.replicationanswers.com/TableDiff2005.asp). It can be useful for
> single tables but if you have a number that need comparing then I'd use
> DataCompare as Hari Prasad mentions.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>|||Larry,
DataCompare works for SQL Server 2000 and SQL 2005 but TABLEDIFF is just on
SQL Server 2005.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
I have two databases of same schema. Data in one database is supposed to be
a subset of another database. Is there any way to verify that?
Thanks,
LarryHi,
Did you mean the data in both databases are same or just the subset. If your
objective is to compare the data then you could go
for SQLDataCompare a tool from redgate software.
http://www.red-gate.com/products/SQL_Data_Compare/index.htm
Thanks
Hari
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message
news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...
> Hi all,
> I have two databases of same schema. Data in one database is supposed to
> be
> a subset of another database. Is there any way to verify that?
> Thanks,
> Larry|||This is a multi-part message in MIME format.
--=_NextPart_000_0FCD_01C6EBDE.88D49CA0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
Assume that database. [dbB].dbo.MyTable is a subset of =[dbA].dbo.MyTable.
This query should return any rows in [dbB] that do NOT exists in [dbA]. =If you want to verify down to the field level, it will take some more =work.
SELECT b.PKField
FROM [dbB].dbo.MyTable b
LEFT JOIN [dbA].dbo.MyTable a
ON b.PKField =3D a.PKField
WHERE a.PKField IS NULL
-- Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience. Most experience comes from bad judgment. - Anonymous
"Larry Lau" <LarryLau@.discussions.microsoft.com> wrote in message =news:226C3EBE-F747-460E-9AB8-71049B973AC3@.microsoft.com...
> Hi all,
> > I have two databases of same schema. Data in one database is supposed =to be > a subset of another database. Is there any way to verify that?
> > Thanks,
> Larry
--=_NextPart_000_0FCD_01C6EBDE.88D49CA0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Assume that database. [dbB].dbo.MyTable =is a subset of [dbA].dbo.MyTable.
This query should return any rows in =[dbB] that do NOT exists in [dbA]. If you want to verify down to the field level, it =will take some more work.
SELECT b.PKField
FROM [dbB].dbo.MyTable =b
LEFT JOIN =[dbA].dbo.MyTable a
=ON b.PKField =3D a.PKField
WHERE a.PKField IS =NULL
-- Arnie Rowland, =Ph.D.Westwood Consulting, Inc
Most good judgment comes from =experience. Most experience comes from bad judgment. - Anonymous
"Larry Lau"
--=_NextPart_000_0FCD_01C6EBDE.88D49CA0--|||Larry,
there is a utility in SQL Server 2005 for this called TABLEDIFF
(http://www.replicationanswers.com/TableDiff2005.asp). It can be useful for
single tables but if you have a number that need comparing then I'd use
DataCompare as Hari Prasad mentions.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||Thanks, Hari and Paul.
Is there any similar tools for SQL Server 2000?
"Paul Ibison" wrote:
> Larry,
> there is a utility in SQL Server 2005 for this called TABLEDIFF
> (http://www.replicationanswers.com/TableDiff2005.asp). It can be useful for
> single tables but if you have a number that need comparing then I'd use
> DataCompare as Hari Prasad mentions.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>|||Larry,
DataCompare works for SQL Server 2000 and SQL 2005 but TABLEDIFF is just on
SQL Server 2005.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
How to verify SQL edition once evaluation is expired
Hi,
SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
service can't start. The problem is I could not use "osql -E" to get into
command prompt due the service. Therefore, I could not implement SELECT
SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
version. Is there any workaround to this issue. Any tips will be
appreciated.
Thank you in advance,
Johnny ChowJohnny,
Look through the following registry keys (regedt32)- might provide this
information:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
> Hi,
> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
> service can't start. The problem is I could not use "osql -E" to get into
> command prompt due the service. Therefore, I could not implement SELECT
> SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
> version. Is there any workaround to this issue. Any tips will be
> appreciated.
> Thank you in advance,
> Johnny Chow
>|||Hi,
I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer, it is shown
current version= 8.00.194 but when search this version number on google.com
. Some of sites said SQL 2000 server without patch and other said it is
MSDE version. How do I tell if it is MSDE or SQL server? Please correct if
am wrong, I thought MSDE never expired. I know some people will install
MSDE and SQL agent. Well this is well be hard to make distinquish version.
Any tips and information will be appreciated.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
> Johnny,
> Look through the following registry keys (regedt32)- might provide this
> information:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>|||Johnny,
Try:
HOW TO: Identify your SQL Server Service Pack version and edition
http://support.microsoft.com/defaul...kb;en-us;321185
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer, it is shown
> current version= 8.00.194 but when search this version number on
> google.com . Some of sites said SQL 2000 server without patch and other
> said it is MSDE version. How do I tell if it is MSDE or SQL server?
> Please correct if am wrong, I thought MSDE never expired. I know some
> people will install MSDE and SQL agent. Well this is well be hard to make
> distinquish version. Any tips and information will be appreciated.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>|||Thanks Jerry,
I also find a good site from Cisco, please refer to
http://www.cisco.com/en/US/products.../>
4f8e8.shtml .
I also built another sql evaluation test machine; I was able to upgrade
retail version successfully; but another machine, if I said cancel before
start to upgrade then it will gray out "upgrading your existing
installation". I believed it was a bug in the program.
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OpbgAoB1FHA.2540@.TK2MSFTNGP09.phx.gbl...
> Johnny,
> Try:
> HOW TO: Identify your SQL Server Service Pack version and edition
> http://support.microsoft.com/defaul...kb;en-us;321185
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
>
SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
service can't start. The problem is I could not use "osql -E" to get into
command prompt due the service. Therefore, I could not implement SELECT
SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
version. Is there any workaround to this issue. Any tips will be
appreciated.
Thank you in advance,
Johnny ChowJohnny,
Look through the following registry keys (regedt32)- might provide this
information:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
> Hi,
> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
> service can't start. The problem is I could not use "osql -E" to get into
> command prompt due the service. Therefore, I could not implement SELECT
> SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
> version. Is there any workaround to this issue. Any tips will be
> appreciated.
> Thank you in advance,
> Johnny Chow
>|||Hi,
I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer, it is shown
current version= 8.00.194 but when search this version number on google.com
. Some of sites said SQL 2000 server without patch and other said it is
MSDE version. How do I tell if it is MSDE or SQL server? Please correct if
am wrong, I thought MSDE never expired. I know some people will install
MSDE and SQL agent. Well this is well be hard to make distinquish version.
Any tips and information will be appreciated.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
> Johnny,
> Look through the following registry keys (regedt32)- might provide this
> information:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>|||Johnny,
Try:
HOW TO: Identify your SQL Server Service Pack version and edition
http://support.microsoft.com/defaul...kb;en-us;321185
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer, it is shown
> current version= 8.00.194 but when search this version number on
> google.com . Some of sites said SQL 2000 server without patch and other
> said it is MSDE version. How do I tell if it is MSDE or SQL server?
> Please correct if am wrong, I thought MSDE never expired. I know some
> people will install MSDE and SQL agent. Well this is well be hard to make
> distinquish version. Any tips and information will be appreciated.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>|||Thanks Jerry,
I also find a good site from Cisco, please refer to
http://www.cisco.com/en/US/products.../>
4f8e8.shtml .
I also built another sql evaluation test machine; I was able to upgrade
retail version successfully; but another machine, if I said cancel before
start to upgrade then it will gray out "upgrading your existing
installation". I believed it was a bug in the program.
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OpbgAoB1FHA.2540@.TK2MSFTNGP09.phx.gbl...
> Johnny,
> Try:
> HOW TO: Identify your SQL Server Service Pack version and edition
> http://support.microsoft.com/defaul...kb;en-us;321185
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
>
How to verify SQL edition once evaluation is expired
Hi,
SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
service can't start. The problem is I could not use "osql -E" to get into
command prompt due the service. Therefore, I could not implement SELECT
SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
version. Is there any workaround to this issue. Any tips will be
appreciated.
Thank you in advance,
Johnny Chow
Johnny,
Look through the following registry keys (regedt32)- might provide this
information:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
> Hi,
> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
> service can't start. The problem is I could not use "osql -E" to get into
> command prompt due the service. Therefore, I could not implement SELECT
> SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
> version. Is there any workaround to this issue. Any tips will be
> appreciated.
> Thank you in advance,
> Johnny Chow
>
|||Hi,
I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
current version= 8.00.194 but when search this version number on google.com
.. Some of sites said SQL 2000 server without patch and other said it is
MSDE version. How do I tell if it is MSDE or SQL server? Please correct if
am wrong, I thought MSDE never expired. I know some people will install
MSDE and SQL agent. Well this is well be hard to make distinquish version.
Any tips and information will be appreciated.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
> Johnny,
> Look through the following registry keys (regedt32)- might provide this
> information:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>
|||Johnny,
Try:
HOW TO: Identify your SQL Server Service Pack version and edition
http://support.microsoft.com/default...b;en-us;321185
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
> current version= 8.00.194 but when search this version number on
> google.com . Some of sites said SQL 2000 server without patch and other
> said it is MSDE version. How do I tell if it is MSDE or SQL server?
> Please correct if am wrong, I thought MSDE never expired. I know some
> people will install MSDE and SQL agent. Well this is well be hard to make
> distinquish version. Any tips and information will be appreciated.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>
|||Thanks Jerry,
I also find a good site from Cisco, please refer to
http://www.cisco.com/en/US/products/...8014f8e8.shtml .
I also built another sql evaluation test machine; I was able to upgrade
retail version successfully; but another machine, if I said cancel before
start to upgrade then it will gray out "upgrading your existing
installation". I believed it was a bug in the program.
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OpbgAoB1FHA.2540@.TK2MSFTNGP09.phx.gbl...
> Johnny,
> Try:
> HOW TO: Identify your SQL Server Service Pack version and edition
> http://support.microsoft.com/default...b;en-us;321185
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
>
sql
SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
service can't start. The problem is I could not use "osql -E" to get into
command prompt due the service. Therefore, I could not implement SELECT
SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
version. Is there any workaround to this issue. Any tips will be
appreciated.
Thank you in advance,
Johnny Chow
Johnny,
Look through the following registry keys (regedt32)- might provide this
information:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
> Hi,
> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
> service can't start. The problem is I could not use "osql -E" to get into
> command prompt due the service. Therefore, I could not implement SELECT
> SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
> version. Is there any workaround to this issue. Any tips will be
> appreciated.
> Thank you in advance,
> Johnny Chow
>
|||Hi,
I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
current version= 8.00.194 but when search this version number on google.com
.. Some of sites said SQL 2000 server without patch and other said it is
MSDE version. How do I tell if it is MSDE or SQL server? Please correct if
am wrong, I thought MSDE never expired. I know some people will install
MSDE and SQL agent. Well this is well be hard to make distinquish version.
Any tips and information will be appreciated.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
> Johnny,
> Look through the following registry keys (regedt32)- might provide this
> information:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>
|||Johnny,
Try:
HOW TO: Identify your SQL Server Service Pack version and edition
http://support.microsoft.com/default...b;en-us;321185
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
> current version= 8.00.194 but when search this version number on
> google.com . Some of sites said SQL 2000 server without patch and other
> said it is MSDE version. How do I tell if it is MSDE or SQL server?
> Please correct if am wrong, I thought MSDE never expired. I know some
> people will install MSDE and SQL agent. Well this is well be hard to make
> distinquish version. Any tips and information will be appreciated.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>
|||Thanks Jerry,
I also find a good site from Cisco, please refer to
http://www.cisco.com/en/US/products/...8014f8e8.shtml .
I also built another sql evaluation test machine; I was able to upgrade
retail version successfully; but another machine, if I said cancel before
start to upgrade then it will gray out "upgrading your existing
installation". I believed it was a bug in the program.
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OpbgAoB1FHA.2540@.TK2MSFTNGP09.phx.gbl...
> Johnny,
> Try:
> HOW TO: Identify your SQL Server Service Pack version and edition
> http://support.microsoft.com/default...b;en-us;321185
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
>
sql
How to verify SQL edition once evaluation is expired
Hi,
SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
service can't start. The problem is I could not use "osql -E" to get into
command prompt due the service. Therefore, I could not implement SELECT
SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
version. Is there any workaround to this issue. Any tips will be
appreciated.
Thank you in advance,
Johnny ChowJohnny,
Look through the following registry keys (regedt32)- might provide this
information:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
> Hi,
> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
> service can't start. The problem is I could not use "osql -E" to get into
> command prompt due the service. Therefore, I could not implement SELECT
> SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
> version. Is there any workaround to this issue. Any tips will be
> appreciated.
> Thank you in advance,
> Johnny Chow
>|||Hi,
I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
current version= 8.00.194 but when search this version number on google.com
. Some of sites said SQL 2000 server without patch and other said it is
MSDE version. How do I tell if it is MSDE or SQL server? Please correct if
am wrong, I thought MSDE never expired. I know some people will install
MSDE and SQL agent. Well this is well be hard to make distinquish version.
Any tips and information will be appreciated.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
> Johnny,
> Look through the following registry keys (regedt32)- might provide this
> information:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
>> service can't start. The problem is I could not use "osql -E" to get
>> into command prompt due the service. Therefore, I could not implement
>> SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find
>> out the version. Is there any workaround to this issue. Any tips will
>> be appreciated.
>> Thank you in advance,
>> Johnny Chow
>|||Johnny,
Try:
HOW TO: Identify your SQL Server Service Pack version and edition
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
> current version= 8.00.194 but when search this version number on
> google.com . Some of sites said SQL 2000 server without patch and other
> said it is MSDE version. How do I tell if it is MSDE or SQL server?
> Please correct if am wrong, I thought MSDE never expired. I know some
> people will install MSDE and SQL agent. Well this is well be hard to make
> distinquish version. Any tips and information will be appreciated.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>> Johnny,
>> Look through the following registry keys (regedt32)- might provide this
>> information:
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
>> service can't start. The problem is I could not use "osql -E" to get
>> into command prompt due the service. Therefore, I could not implement
>> SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to
>> find out the version. Is there any workaround to this issue. Any tips
>> will be appreciated.
>> Thank you in advance,
>> Johnny Chow
>>
>|||Thanks Jerry,
I also find a good site from Cisco, please refer to
http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a008014f8e8.shtml .
I also built another sql evaluation test machine; I was able to upgrade
retail version successfully; but another machine, if I said cancel before
start to upgrade then it will gray out "upgrading your existing
installation". I believed it was a bug in the program.
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OpbgAoB1FHA.2540@.TK2MSFTNGP09.phx.gbl...
> Johnny,
> Try:
> HOW TO: Identify your SQL Server Service Pack version and edition
> http://support.microsoft.com/default.aspx?scid=kb;en-us;321185
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
>> current version= 8.00.194 but when search this version number on
>> google.com . Some of sites said SQL 2000 server without patch and other
>> said it is MSDE version. How do I tell if it is MSDE or SQL server?
>> Please correct if am wrong, I thought MSDE never expired. I know some
>> people will install MSDE and SQL agent. Well this is well be hard to
>> make distinquish version. Any tips and information will be appreciated.
>> Thank you in advance,
>> Johnny Chow
>>
>> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
>> news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>> Johnny,
>> Look through the following registry keys (regedt32)- might provide this
>> information:
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
>> service can't start. The problem is I could not use "osql -E" to get
>> into command prompt due the service. Therefore, I could not implement
>> SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to
>> find out the version. Is there any workaround to this issue. Any tips
>> will be appreciated.
>> Thank you in advance,
>> Johnny Chow
>>
>>
>
SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
service can't start. The problem is I could not use "osql -E" to get into
command prompt due the service. Therefore, I could not implement SELECT
SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
version. Is there any workaround to this issue. Any tips will be
appreciated.
Thank you in advance,
Johnny ChowJohnny,
Look through the following registry keys (regedt32)- might provide this
information:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
> Hi,
> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
> service can't start. The problem is I could not use "osql -E" to get into
> command prompt due the service. Therefore, I could not implement SELECT
> SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find out the
> version. Is there any workaround to this issue. Any tips will be
> appreciated.
> Thank you in advance,
> Johnny Chow
>|||Hi,
I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
current version= 8.00.194 but when search this version number on google.com
. Some of sites said SQL 2000 server without patch and other said it is
MSDE version. How do I tell if it is MSDE or SQL server? Please correct if
am wrong, I thought MSDE never expired. I know some people will install
MSDE and SQL agent. Well this is well be hard to make distinquish version.
Any tips and information will be appreciated.
Thank you in advance,
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
> Johnny,
> Look through the following registry keys (regedt32)- might provide this
> information:
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
>> service can't start. The problem is I could not use "osql -E" to get
>> into command prompt due the service. Therefore, I could not implement
>> SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to find
>> out the version. Is there any workaround to this issue. Any tips will
>> be appreciated.
>> Thank you in advance,
>> Johnny Chow
>|||Johnny,
Try:
HOW TO: Identify your SQL Server Service Pack version and edition
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185
HTH
Jerry
"Johnny Chow" <jchow10@.gmail.com> wrote in message
news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
> current version= 8.00.194 but when search this version number on
> google.com . Some of sites said SQL 2000 server without patch and other
> said it is MSDE version. How do I tell if it is MSDE or SQL server?
> Please correct if am wrong, I thought MSDE never expired. I know some
> people will install MSDE and SQL agent. Well this is well be hard to make
> distinquish version. Any tips and information will be appreciated.
> Thank you in advance,
> Johnny Chow
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>> Johnny,
>> Look through the following registry keys (regedt32)- might provide this
>> information:
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
>> service can't start. The problem is I could not use "osql -E" to get
>> into command prompt due the service. Therefore, I could not implement
>> SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to
>> find out the version. Is there any workaround to this issue. Any tips
>> will be appreciated.
>> Thank you in advance,
>> Johnny Chow
>>
>|||Thanks Jerry,
I also find a good site from Cisco, please refer to
http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_tech_note09186a008014f8e8.shtml .
I also built another sql evaluation test machine; I was able to upgrade
retail version successfully; but another machine, if I said cancel before
start to upgrade then it will gray out "upgrading your existing
installation". I believed it was a bug in the program.
Johnny Chow
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:OpbgAoB1FHA.2540@.TK2MSFTNGP09.phx.gbl...
> Johnny,
> Try:
> HOW TO: Identify your SQL Server Service Pack version and edition
> http://support.microsoft.com/default.aspx?scid=kb;en-us;321185
> HTH
> Jerry
> "Johnny Chow" <jchow10@.gmail.com> wrote in message
> news:eoqs9kB1FHA.2076@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I went to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer, it is shown
>> current version= 8.00.194 but when search this version number on
>> google.com . Some of sites said SQL 2000 server without patch and other
>> said it is MSDE version. How do I tell if it is MSDE or SQL server?
>> Please correct if am wrong, I thought MSDE never expired. I know some
>> people will install MSDE and SQL agent. Well this is well be hard to
>> make distinquish version. Any tips and information will be appreciated.
>> Thank you in advance,
>> Johnny Chow
>>
>> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
>> news:uDUkBKB1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>> Johnny,
>> Look through the following registry keys (regedt32)- might provide this
>> information:
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
>> HTH
>> Jerry
>> "Johnny Chow" <jchow10@.gmail.com> wrote in message
>> news:eGuYQ6A1FHA.2348@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> SQL evaluation is expired on Windows 2003 server then caused MSSQLSEVER
>> service can't start. The problem is I could not use "osql -E" to get
>> into command prompt due the service. Therefore, I could not implement
>> SELECT SERVERPROPERTY('EDITION'), SERVERPROPERTY('ENGINEEDITION') to
>> find out the version. Is there any workaround to this issue. Any tips
>> will be appreciated.
>> Thank you in advance,
>> Johnny Chow
>>
>>
>
How to verify Server sees 8GB of Memory
We are running SQL Server 2000 on Windows 2000 Advanced
Server and have just upgraded our memory from 4GB to 8GB.
We have added the /3gb and /pae switches to the boot.ini,
but every memory indicator still only shows 4GB (right
clicking my computer, memory settings in enterprise
manager and memory in performance monitoring). Is this
correct or is the server not seeing the memory? Thanks.My guess would be you really have just plain WIn2000 Server and not
advanced.
--
Andrew J. Kelly SQL MVP
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:207801c49a7e$71195960$a501280a@.phx.gbl...
> We are running SQL Server 2000 on Windows 2000 Advanced
> Server and have just upgraded our memory from 4GB to 8GB.
> We have added the /3gb and /pae switches to the boot.ini,
> but every memory indicator still only shows 4GB (right
> clicking my computer, memory settings in enterprise
> manager and memory in performance monitoring). Is this
> correct or is the server not seeing the memory? Thanks.|||Chris,
you still need to run the following in QA:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144 --(6144 the number of memory for SQL
Server in MB)
RECONFIGURE
GO
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:207801c49a7e$71195960$a501280a@.phx.gbl...
> We are running SQL Server 2000 on Windows 2000 Advanced
> Server and have just upgraded our memory from 4GB to 8GB.
> We have added the /3gb and /pae switches to the boot.ini,
> but every memory indicator still only shows 4GB (right
> clicking my computer, memory settings in enterprise
> manager and memory in performance monitoring). Is this
> correct or is the server not seeing the memory? Thanks.
Server and have just upgraded our memory from 4GB to 8GB.
We have added the /3gb and /pae switches to the boot.ini,
but every memory indicator still only shows 4GB (right
clicking my computer, memory settings in enterprise
manager and memory in performance monitoring). Is this
correct or is the server not seeing the memory? Thanks.My guess would be you really have just plain WIn2000 Server and not
advanced.
--
Andrew J. Kelly SQL MVP
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:207801c49a7e$71195960$a501280a@.phx.gbl...
> We are running SQL Server 2000 on Windows 2000 Advanced
> Server and have just upgraded our memory from 4GB to 8GB.
> We have added the /3gb and /pae switches to the boot.ini,
> but every memory indicator still only shows 4GB (right
> clicking my computer, memory settings in enterprise
> manager and memory in performance monitoring). Is this
> correct or is the server not seeing the memory? Thanks.|||Chris,
you still need to run the following in QA:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', 6144 --(6144 the number of memory for SQL
Server in MB)
RECONFIGURE
GO
"Chris" <anonymous@.discussions.microsoft.com> wrote in message
news:207801c49a7e$71195960$a501280a@.phx.gbl...
> We are running SQL Server 2000 on Windows 2000 Advanced
> Server and have just upgraded our memory from 4GB to 8GB.
> We have added the /3gb and /pae switches to the boot.ini,
> but every memory indicator still only shows 4GB (right
> clicking my computer, memory settings in enterprise
> manager and memory in performance monitoring). Is this
> correct or is the server not seeing the memory? Thanks.
how to verify number of CPUs?
Good Day All,
I was wondering if there is a way, with in SQL 2000 & 20005, to
find out the number of physical CPUs? I don't care about multi-core
or hyper-threading only the number of physical CPUs.
Thanks,
JD
You can get this info in sys.dm_os_sys_info in SQL Server 2005. In 2000, you
will have to find out from an external utility through xp_cmdshell or
sp_oa's.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"JoeyD" <joeydba@.gmail.com> wrote in message
news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> Good Day All,
> I was wondering if there is a way, with in SQL 2000 & 20005, to
> find out the number of physical CPUs? I don't care about multi-core
> or hyper-threading only the number of physical CPUs.
> Thanks,
> JD
|||Thank You Jason.
On Apr 9, 11:13 am, "Jason Massie" <jason**R3mov...@.statisticsio.com>
wrote:[vbcol=seagreen]
> You can get this info in sys.dm_os_sys_info in SQL Server 2005. In 2000, you
> will have to find out from an external utility through xp_cmdshell or
> sp_oa's.
> --
> Jason Massie
> Web:http://statisticsio.com
> RSS:http://feeds.feedburner.com/statisticsio
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>
|||You can also try
EXEC xp_msver 'ProcessorCount'
This works with either SQL 2000 or SQL 2005.
Randy Dyess
Blog: http://blogs.solidq.com/EN/rdyess/default.aspx
"JoeyD" <joeydba@.gmail.com> wrote in message
news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> Good Day All,
> I was wondering if there is a way, with in SQL 2000 & 20005, to
> find out the number of physical CPUs? I don't care about multi-core
> or hyper-threading only the number of physical CPUs.
> Thanks,
> JD
>
|||Is this count showing physical CPUs or is counting CPU CORES?
I ask again because my Server guys are telling me my machine has 2
quad core cpus. sp_msver shows me 8.
thanks
On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:[vbcol=seagreen]
> You can also try
> EXEC xp_msver 'ProcessorCount'
> This works with either SQL 2000 or SQL 2005.
> Randy Dyess
> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>
|||Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"JoeyD" <joeydba@.gmail.com> wrote in message
news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
> Is this count showing physical CPUs or is counting CPU CORES?
> I ask again because my Server guys are telling me my machine has 2
> quad core cpus. sp_msver shows me 8.
> thanks
>
> On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
>
|||Thanks Tibor.
So back to my original post - is there a way to count only the
PHYSICAL CPUs via SQL Server?
Thanks much
On Apr 10, 9:58 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
>
>
>
>
>
|||I believe Intel has some utility for this. I doubt you find anything exposed in SQL Server to do
this...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"JoeyD" <joeydba@.gmail.com> wrote in message
news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
> Thanks Tibor.
> So back to my original post - is there a way to count only the
> PHYSICAL CPUs via SQL Server?
> Thanks much
> On Apr 10, 9:58 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>
|||Sorry, misunderstood that you only wanted the number of sockets and chips
being used and not physical cores.
Tibor is right, SQL Server does not have anything to tell you the number of
sockets that are being used versus the number physical cores or logical
cores.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:C74D6D66-2C84-41CA-BA9B-17E706C4C79A@.microsoft.com...
>I believe Intel has some utility for this. I doubt you find anything
>exposed in SQL Server to do this...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "JoeyD" <joeydba@.gmail.com> wrote in message
> news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
>
I was wondering if there is a way, with in SQL 2000 & 20005, to
find out the number of physical CPUs? I don't care about multi-core
or hyper-threading only the number of physical CPUs.
Thanks,
JD
You can get this info in sys.dm_os_sys_info in SQL Server 2005. In 2000, you
will have to find out from an external utility through xp_cmdshell or
sp_oa's.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"JoeyD" <joeydba@.gmail.com> wrote in message
news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> Good Day All,
> I was wondering if there is a way, with in SQL 2000 & 20005, to
> find out the number of physical CPUs? I don't care about multi-core
> or hyper-threading only the number of physical CPUs.
> Thanks,
> JD
|||Thank You Jason.
On Apr 9, 11:13 am, "Jason Massie" <jason**R3mov...@.statisticsio.com>
wrote:[vbcol=seagreen]
> You can get this info in sys.dm_os_sys_info in SQL Server 2005. In 2000, you
> will have to find out from an external utility through xp_cmdshell or
> sp_oa's.
> --
> Jason Massie
> Web:http://statisticsio.com
> RSS:http://feeds.feedburner.com/statisticsio
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>
|||You can also try
EXEC xp_msver 'ProcessorCount'
This works with either SQL 2000 or SQL 2005.
Randy Dyess
Blog: http://blogs.solidq.com/EN/rdyess/default.aspx
"JoeyD" <joeydba@.gmail.com> wrote in message
news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> Good Day All,
> I was wondering if there is a way, with in SQL 2000 & 20005, to
> find out the number of physical CPUs? I don't care about multi-core
> or hyper-threading only the number of physical CPUs.
> Thanks,
> JD
>
|||Is this count showing physical CPUs or is counting CPU CORES?
I ask again because my Server guys are telling me my machine has 2
quad core cpus. sp_msver shows me 8.
thanks
On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:[vbcol=seagreen]
> You can also try
> EXEC xp_msver 'ProcessorCount'
> This works with either SQL 2000 or SQL 2005.
> Randy Dyess
> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>
|||Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"JoeyD" <joeydba@.gmail.com> wrote in message
news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
> Is this count showing physical CPUs or is counting CPU CORES?
> I ask again because my Server guys are telling me my machine has 2
> quad core cpus. sp_msver shows me 8.
> thanks
>
> On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
>
|||Thanks Tibor.
So back to my original post - is there a way to count only the
PHYSICAL CPUs via SQL Server?
Thanks much
On Apr 10, 9:58 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:[vbcol=seagreen]
> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
>
>
>
>
>
|||I believe Intel has some utility for this. I doubt you find anything exposed in SQL Server to do
this...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"JoeyD" <joeydba@.gmail.com> wrote in message
news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
> Thanks Tibor.
> So back to my original post - is there a way to count only the
> PHYSICAL CPUs via SQL Server?
> Thanks much
> On Apr 10, 9:58 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>
|||Sorry, misunderstood that you only wanted the number of sockets and chips
being used and not physical cores.
Tibor is right, SQL Server does not have anything to tell you the number of
sockets that are being used versus the number physical cores or logical
cores.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:C74D6D66-2C84-41CA-BA9B-17E706C4C79A@.microsoft.com...
>I believe Intel has some utility for this. I doubt you find anything
>exposed in SQL Server to do this...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "JoeyD" <joeydba@.gmail.com> wrote in message
> news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
>
how to verify number of CPUs?
Good Day All,
I was wondering if there is a way, with in SQL 2000 & 20005, to
find out the number of physical CPUs? I don't care about multi-core
or hyper-threading only the number of physical CPUs.
Thanks,
JDYou can get this info in sys.dm_os_sys_info in SQL Server 2005. In 2000, you
will have to find out from an external utility through xp_cmdshell or
sp_oa's.
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"JoeyD" <joeydba@.gmail.com> wrote in message
news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> Good Day All,
> I was wondering if there is a way, with in SQL 2000 & 20005, to
> find out the number of physical CPUs? I don't care about multi-core
> or hyper-threading only the number of physical CPUs.
> Thanks,
> JD|||Thank You Jason.
On Apr 9, 11:13 am, "Jason Massie" <jason**R3mov...@.statisticsio.com>
wrote:
> You can get this info in sys.dm_os_sys_info in SQL Server 2005. In 2000, you
> will have to find out from an external utility through xp_cmdshell or
> sp_oa's.
> --
> Jason Massie
> Web:http://statisticsio.com
> RSS:http://feeds.feedburner.com/statisticsio
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> > Good Day All,
> > I was wondering if there is a way, with in SQL 2000 & 20005, to
> > find out the number of physical CPUs? I don't care about multi-core
> > or hyper-threading only the number of physical CPUs.
> > Thanks,
> > JD|||You can also try
EXEC xp_msver 'ProcessorCount'
This works with either SQL 2000 or SQL 2005.
Randy Dyess
Blog: http://blogs.solidq.com/EN/rdyess/default.aspx
"JoeyD" <joeydba@.gmail.com> wrote in message
news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> Good Day All,
> I was wondering if there is a way, with in SQL 2000 & 20005, to
> find out the number of physical CPUs? I don't care about multi-core
> or hyper-threading only the number of physical CPUs.
> Thanks,
> JD
>|||Is this count showing physical CPUs or is counting CPU CORES?
I ask again because my Server guys are telling me my machine has 2
quad core cpus. sp_msver shows me 8.
thanks
On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
> You can also try
> EXEC xp_msver 'ProcessorCount'
> This works with either SQL 2000 or SQL 2005.
> Randy Dyess
> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> > Good Day All,
> > I was wondering if there is a way, with in SQL 2000 & 20005, to
> > find out the number of physical CPUs? I don't care about multi-core
> > or hyper-threading only the number of physical CPUs.
> > Thanks,
> > JD|||Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"JoeyD" <joeydba@.gmail.com> wrote in message
news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
> Is this count showing physical CPUs or is counting CPU CORES?
> I ask again because my Server guys are telling me my machine has 2
> quad core cpus. sp_msver shows me 8.
> thanks
>
> On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
>> You can also try
>> EXEC xp_msver 'ProcessorCount'
>> This works with either SQL 2000 or SQL 2005.
>> Randy Dyess
>> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
>> "JoeyD" <joey...@.gmail.com> wrote in message
>> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>> > Good Day All,
>> > I was wondering if there is a way, with in SQL 2000 & 20005, to
>> > find out the number of physical CPUs? I don't care about multi-core
>> > or hyper-threading only the number of physical CPUs.
>> > Thanks,
>> > JD
>|||Thanks Tibor.
So back to my original post - is there a way to count only the
PHYSICAL CPUs via SQL Server?
Thanks much
On Apr 10, 9:58 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
> > Is this count showing physical CPUs or is counting CPU CORES?
> > I ask again because my Server guys are telling me my machine has 2
> > quad core cpus. sp_msver shows me 8.
> > thanks
> > On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
> >> You can also try
> >> EXEC xp_msver 'ProcessorCount'
> >> This works with either SQL 2000 or SQL 2005.
> >> Randy Dyess
> >> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
> >> "JoeyD" <joey...@.gmail.com> wrote in message
> >>news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> >> > Good Day All,
> >> > I was wondering if there is a way, with in SQL 2000 & 20005, to
> >> > find out the number of physical CPUs? I don't care about multi-core
> >> > or hyper-threading only the number of physical CPUs.
> >> > Thanks,
> >> > JD|||I believe Intel has some utility for this. I doubt you find anything exposed in SQL Server to do
this...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"JoeyD" <joeydba@.gmail.com> wrote in message
news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
> Thanks Tibor.
> So back to my original post - is there a way to count only the
> PHYSICAL CPUs via SQL Server?
> Thanks much
> On Apr 10, 9:58 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "JoeyD" <joey...@.gmail.com> wrote in message
>> news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
>> > Is this count showing physical CPUs or is counting CPU CORES?
>> > I ask again because my Server guys are telling me my machine has 2
>> > quad core cpus. sp_msver shows me 8.
>> > thanks
>> > On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
>> >> You can also try
>> >> EXEC xp_msver 'ProcessorCount'
>> >> This works with either SQL 2000 or SQL 2005.
>> >> Randy Dyess
>> >> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
>> >> "JoeyD" <joey...@.gmail.com> wrote in message
>> >>news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>> >> > Good Day All,
>> >> > I was wondering if there is a way, with in SQL 2000 & 20005, to
>> >> > find out the number of physical CPUs? I don't care about multi-core
>> >> > or hyper-threading only the number of physical CPUs.
>> >> > Thanks,
>> >> > JD
>|||Sorry, misunderstood that you only wanted the number of sockets and chips
being used and not physical cores.
Tibor is right, SQL Server does not have anything to tell you the number of
sockets that are being used versus the number physical cores or logical
cores.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:C74D6D66-2C84-41CA-BA9B-17E706C4C79A@.microsoft.com...
>I believe Intel has some utility for this. I doubt you find anything
>exposed in SQL Server to do this...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "JoeyD" <joeydba@.gmail.com> wrote in message
> news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
>> Thanks Tibor.
>> So back to my original post - is there a way to count only the
>> PHYSICAL CPUs via SQL Server?
>> Thanks much
>> On Apr 10, 9:58 am, "Tibor Karaszi"
>> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "JoeyD" <joey...@.gmail.com> wrote in message
>> news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
>> > Is this count showing physical CPUs or is counting CPU CORES?
>> > I ask again because my Server guys are telling me my machine has 2
>> > quad core cpus. sp_msver shows me 8.
>> > thanks
>> > On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
>> >> You can also try
>> >> EXEC xp_msver 'ProcessorCount'
>> >> This works with either SQL 2000 or SQL 2005.
>> >> Randy Dyess
>> >> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
>> >> "JoeyD" <joey...@.gmail.com> wrote in message
>> >>news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>> >> > Good Day All,
>> >> > I was wondering if there is a way, with in SQL 2000 & 20005, to
>> >> > find out the number of physical CPUs? I don't care about
>> >> > multi-core
>> >> > or hyper-threading only the number of physical CPUs.
>> >> > Thanks,
>> >> > JD
>|||NP Randy
Thanks to all for your help.
On Apr 10, 11:47 am, "Randy Dyess" <rdy...@.solidq.com> wrote:
> Sorry, misunderstood that you only wanted the number of sockets and chips
> being used and not physical cores.
> Tibor is right, SQL Server does not have anything to tell you the number of
> sockets that are being used versus the number physical cores or logical
> cores.
> "Tibor Karaszi" <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote in
> messagenews:C74D6D66-2C84-41CA-BA9B-17E706C4C79A@.microsoft.com...
> >I believe Intel has some utility for this. I doubt you find anything
> >exposed in SQL Server to do this...
> > --
> > Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://sqlblog.com/blogs/tibor_karaszi
> > "JoeyD" <joey...@.gmail.com> wrote in message
> >news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
> >> Thanks Tibor.
> >> So back to my original post - is there a way to count only the
> >> PHYSICAL CPUs via SQL Server?
> >> Thanks much
> >> On Apr 10, 9:58 am, "Tibor Karaszi"
> >> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
> >> --
> >> Tibor Karaszi, SQL Server
> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
> >> "JoeyD" <joey...@.gmail.com> wrote in message
> >>news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
> >> > Is this count showing physical CPUs or is counting CPU CORES?
> >> > I ask again because my Server guys are telling me my machine has 2
> >> > quad core cpus. sp_msver shows me 8.
> >> > thanks
> >> > On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
> >> >> You can also try
> >> >> EXEC xp_msver 'ProcessorCount'
> >> >> This works with either SQL 2000 or SQL 2005.
> >> >> Randy Dyess
> >> >> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
> >> >> "JoeyD" <joey...@.gmail.com> wrote in message
> >> >>news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> >> >> > Good Day All,
> >> >> > I was wondering if there is a way, with in SQL 2000 & 20005, to
> >> >> > find out the number of physical CPUs? I don't care about
> >> >> > multi-core
> >> >> > or hyper-threading only the number of physical CPUs.
> >> >> > Thanks,
> >> >> > JD
I was wondering if there is a way, with in SQL 2000 & 20005, to
find out the number of physical CPUs? I don't care about multi-core
or hyper-threading only the number of physical CPUs.
Thanks,
JDYou can get this info in sys.dm_os_sys_info in SQL Server 2005. In 2000, you
will have to find out from an external utility through xp_cmdshell or
sp_oa's.
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"JoeyD" <joeydba@.gmail.com> wrote in message
news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> Good Day All,
> I was wondering if there is a way, with in SQL 2000 & 20005, to
> find out the number of physical CPUs? I don't care about multi-core
> or hyper-threading only the number of physical CPUs.
> Thanks,
> JD|||Thank You Jason.
On Apr 9, 11:13 am, "Jason Massie" <jason**R3mov...@.statisticsio.com>
wrote:
> You can get this info in sys.dm_os_sys_info in SQL Server 2005. In 2000, you
> will have to find out from an external utility through xp_cmdshell or
> sp_oa's.
> --
> Jason Massie
> Web:http://statisticsio.com
> RSS:http://feeds.feedburner.com/statisticsio
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> > Good Day All,
> > I was wondering if there is a way, with in SQL 2000 & 20005, to
> > find out the number of physical CPUs? I don't care about multi-core
> > or hyper-threading only the number of physical CPUs.
> > Thanks,
> > JD|||You can also try
EXEC xp_msver 'ProcessorCount'
This works with either SQL 2000 or SQL 2005.
Randy Dyess
Blog: http://blogs.solidq.com/EN/rdyess/default.aspx
"JoeyD" <joeydba@.gmail.com> wrote in message
news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> Good Day All,
> I was wondering if there is a way, with in SQL 2000 & 20005, to
> find out the number of physical CPUs? I don't care about multi-core
> or hyper-threading only the number of physical CPUs.
> Thanks,
> JD
>|||Is this count showing physical CPUs or is counting CPU CORES?
I ask again because my Server guys are telling me my machine has 2
quad core cpus. sp_msver shows me 8.
thanks
On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
> You can also try
> EXEC xp_msver 'ProcessorCount'
> This works with either SQL 2000 or SQL 2005.
> Randy Dyess
> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> > Good Day All,
> > I was wondering if there is a way, with in SQL 2000 & 20005, to
> > find out the number of physical CPUs? I don't care about multi-core
> > or hyper-threading only the number of physical CPUs.
> > Thanks,
> > JD|||Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"JoeyD" <joeydba@.gmail.com> wrote in message
news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
> Is this count showing physical CPUs or is counting CPU CORES?
> I ask again because my Server guys are telling me my machine has 2
> quad core cpus. sp_msver shows me 8.
> thanks
>
> On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
>> You can also try
>> EXEC xp_msver 'ProcessorCount'
>> This works with either SQL 2000 or SQL 2005.
>> Randy Dyess
>> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
>> "JoeyD" <joey...@.gmail.com> wrote in message
>> news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>> > Good Day All,
>> > I was wondering if there is a way, with in SQL 2000 & 20005, to
>> > find out the number of physical CPUs? I don't care about multi-core
>> > or hyper-threading only the number of physical CPUs.
>> > Thanks,
>> > JD
>|||Thanks Tibor.
So back to my original post - is there a way to count only the
PHYSICAL CPUs via SQL Server?
Thanks much
On Apr 10, 9:58 am, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "JoeyD" <joey...@.gmail.com> wrote in message
> news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
> > Is this count showing physical CPUs or is counting CPU CORES?
> > I ask again because my Server guys are telling me my machine has 2
> > quad core cpus. sp_msver shows me 8.
> > thanks
> > On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
> >> You can also try
> >> EXEC xp_msver 'ProcessorCount'
> >> This works with either SQL 2000 or SQL 2005.
> >> Randy Dyess
> >> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
> >> "JoeyD" <joey...@.gmail.com> wrote in message
> >>news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> >> > Good Day All,
> >> > I was wondering if there is a way, with in SQL 2000 & 20005, to
> >> > find out the number of physical CPUs? I don't care about multi-core
> >> > or hyper-threading only the number of physical CPUs.
> >> > Thanks,
> >> > JD|||I believe Intel has some utility for this. I doubt you find anything exposed in SQL Server to do
this...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"JoeyD" <joeydba@.gmail.com> wrote in message
news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
> Thanks Tibor.
> So back to my original post - is there a way to count only the
> PHYSICAL CPUs via SQL Server?
> Thanks much
> On Apr 10, 9:58 am, "Tibor Karaszi"
> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "JoeyD" <joey...@.gmail.com> wrote in message
>> news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
>> > Is this count showing physical CPUs or is counting CPU CORES?
>> > I ask again because my Server guys are telling me my machine has 2
>> > quad core cpus. sp_msver shows me 8.
>> > thanks
>> > On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
>> >> You can also try
>> >> EXEC xp_msver 'ProcessorCount'
>> >> This works with either SQL 2000 or SQL 2005.
>> >> Randy Dyess
>> >> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
>> >> "JoeyD" <joey...@.gmail.com> wrote in message
>> >>news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>> >> > Good Day All,
>> >> > I was wondering if there is a way, with in SQL 2000 & 20005, to
>> >> > find out the number of physical CPUs? I don't care about multi-core
>> >> > or hyper-threading only the number of physical CPUs.
>> >> > Thanks,
>> >> > JD
>|||Sorry, misunderstood that you only wanted the number of sockets and chips
being used and not physical cores.
Tibor is right, SQL Server does not have anything to tell you the number of
sockets that are being used versus the number physical cores or logical
cores.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:C74D6D66-2C84-41CA-BA9B-17E706C4C79A@.microsoft.com...
>I believe Intel has some utility for this. I doubt you find anything
>exposed in SQL Server to do this...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "JoeyD" <joeydba@.gmail.com> wrote in message
> news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
>> Thanks Tibor.
>> So back to my original post - is there a way to count only the
>> PHYSICAL CPUs via SQL Server?
>> Thanks much
>> On Apr 10, 9:58 am, "Tibor Karaszi"
>> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
>> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
>> --
>> Tibor Karaszi, SQL Server
>> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>> "JoeyD" <joey...@.gmail.com> wrote in message
>> news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
>> > Is this count showing physical CPUs or is counting CPU CORES?
>> > I ask again because my Server guys are telling me my machine has 2
>> > quad core cpus. sp_msver shows me 8.
>> > thanks
>> > On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
>> >> You can also try
>> >> EXEC xp_msver 'ProcessorCount'
>> >> This works with either SQL 2000 or SQL 2005.
>> >> Randy Dyess
>> >> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
>> >> "JoeyD" <joey...@.gmail.com> wrote in message
>> >>news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
>> >> > Good Day All,
>> >> > I was wondering if there is a way, with in SQL 2000 & 20005, to
>> >> > find out the number of physical CPUs? I don't care about
>> >> > multi-core
>> >> > or hyper-threading only the number of physical CPUs.
>> >> > Thanks,
>> >> > JD
>|||NP Randy
Thanks to all for your help.
On Apr 10, 11:47 am, "Randy Dyess" <rdy...@.solidq.com> wrote:
> Sorry, misunderstood that you only wanted the number of sockets and chips
> being used and not physical cores.
> Tibor is right, SQL Server does not have anything to tell you the number of
> sockets that are being used versus the number physical cores or logical
> cores.
> "Tibor Karaszi" <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote in
> messagenews:C74D6D66-2C84-41CA-BA9B-17E706C4C79A@.microsoft.com...
> >I believe Intel has some utility for this. I doubt you find anything
> >exposed in SQL Server to do this...
> > --
> > Tibor Karaszi, SQL Server MVP
> >http://www.karaszi.com/sqlserver/default.asp
> >http://sqlblog.com/blogs/tibor_karaszi
> > "JoeyD" <joey...@.gmail.com> wrote in message
> >news:9bcf6744-eaf7-42dd-b254-2acc4c983aa2@.b1g2000hsg.googlegroups.com...
> >> Thanks Tibor.
> >> So back to my original post - is there a way to count only the
> >> PHYSICAL CPUs via SQL Server?
> >> Thanks much
> >> On Apr 10, 9:58 am, "Tibor Karaszi"
> >> <tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> >> Cores. Or, rather, logical CPUs since one core can be hyperthreaded...
> >> --
> >> Tibor Karaszi, SQL Server
> >> MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
> >> "JoeyD" <joey...@.gmail.com> wrote in message
> >>news:58b440e4-7594-4e10-9b10-eb6270222ce4@.24g2000hsh.googlegroups.com...
> >> > Is this count showing physical CPUs or is counting CPU CORES?
> >> > I ask again because my Server guys are telling me my machine has 2
> >> > quad core cpus. sp_msver shows me 8.
> >> > thanks
> >> > On Apr 9, 4:27 pm, "Randy Dyess" <rdy...@.solidq.com> wrote:
> >> >> You can also try
> >> >> EXEC xp_msver 'ProcessorCount'
> >> >> This works with either SQL 2000 or SQL 2005.
> >> >> Randy Dyess
> >> >> Blog:http://blogs.solidq.com/EN/rdyess/default.aspx
> >> >> "JoeyD" <joey...@.gmail.com> wrote in message
> >> >>news:686ba891-dccb-4499-ab86-fffbf6f908db@.k37g2000hsf.googlegroups.com...
> >> >> > Good Day All,
> >> >> > I was wondering if there is a way, with in SQL 2000 & 20005, to
> >> >> > find out the number of physical CPUs? I don't care about
> >> >> > multi-core
> >> >> > or hyper-threading only the number of physical CPUs.
> >> >> > Thanks,
> >> >> > JD
How to verify installed license
I have inherited serveral SQL 2000 servers and need to know if there is a way to verify the license that was installed, per processor or Server + Cals.
Thanks,
Skip Berry
Hi,SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType'))
SELECT CONVERT(char(20), SERVERPROPERTY('NumLicenses'))
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Don't know if you had better luck with that... but with the patches I've been using, I still get Disabled and NULL for license information.
Following this http://support.microsoft.com/default.aspx?scid=kb;en-us;291332 however, does correctly direct me to the SQL 2000 Licensing Setup applet in control panel, which WILL display what is currently being used.
(Now, all my instances are running on the default instance... not certain what you will get back if you have something other than the default instance.)
|||Which version are you using, Developer or any MSDN version ?Jens K. Suessmeyer
http://www.sqlserver2005.desql
How to verify installed license
I have inherited serveral SQL 2000 servers and need to know if there is a way to verify the license that was installed, per processor or Server + Cals.
Thanks,
Skip Berry
Hi,SELECT CONVERT(char(20), SERVERPROPERTY('LicenseType'))
SELECT CONVERT(char(20), SERVERPROPERTY('NumLicenses'))
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||
Don't know if you had better luck with that... but with the patches I've been using, I still get Disabled and NULL for license information.
Following this http://support.microsoft.com/default.aspx?scid=kb;en-us;291332 however, does correctly direct me to the SQL 2000 Licensing Setup applet in control panel, which WILL display what is currently being used.
(Now, all my instances are running on the default instance... not certain what you will get back if you have something other than the default instance.)
|||Which version are you using, Developer or any MSDN version ?Jens K. Suessmeyer
http://www.sqlserver2005.de
how to verify if db option has been changed by user / appliacation
Hi,
SQL Server 7.0 (SP4) on NT 4 (clustered)
is there a way to verify if database option (ex.: select into) has been
changed by user / application (who, when, etc..) ?
Thank you
DannyNot directly, but you can use the tools from www.lumigent.com to trail
through the transaction logs and find it out from there if your database is
fully or bulk logged.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Danny Presse" <danny.presse@.sympatico.ca> wrote in message
news:3F059A77.2B983D4E@.sympatico.ca...
> Hi,
> SQL Server 7.0 (SP4) on NT 4 (clustered)
> is there a way to verify if database option (ex.: select into) has been
> changed by user / application (who, when, etc..) ?
> Thank you
> Danny
>
>
SQL Server 7.0 (SP4) on NT 4 (clustered)
is there a way to verify if database option (ex.: select into) has been
changed by user / application (who, when, etc..) ?
Thank you
DannyNot directly, but you can use the tools from www.lumigent.com to trail
through the transaction logs and find it out from there if your database is
fully or bulk logged.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Danny Presse" <danny.presse@.sympatico.ca> wrote in message
news:3F059A77.2B983D4E@.sympatico.ca...
> Hi,
> SQL Server 7.0 (SP4) on NT 4 (clustered)
> is there a way to verify if database option (ex.: select into) has been
> changed by user / application (who, when, etc..) ?
> Thank you
> Danny
>
>
Subscribe to:
Posts (Atom)