How to troubleshoot a strange result from a stored procedure?

I am trying to tune a stored procedure that is long and running slow. As
part of testing, the results are odd from what I am expecting. The testing
is running on 2 databases which restored from the same backup with one
database set with read-only option. This will allows me to check the
original code with modified code. These databases are on my server;
therefore, it is lock down.
The stored procedure has 15 pass-in variables with default values are NULL.
If I modify the stored procedure by adding a non-essential statement such as
SELECT 1 or SELECT getdate() anywhere in the stored procedure, the procedure
return different result.
Test query: exec GetValues @.FName = 'Smith%', @.FName = default, @.Price =
default, @.CustType = default
Part of the existing stored procedure:
if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
@.CustType <> '')
select * from CustTable
where @.LastName is null or customer.FName like rtrim(@.LastName)
else
select 'No data'
When I run this on the read-only database, it returns some rows. But when I
run this on the test database with modified code, it returns no data. The
stored procedures from both database are basically same with exception of
adding a non-essential statement (SELECT 1 or SELECT getdate()). Based on
what test query, it should return no data on both databases, but the results
are different.
Is there a tool or methods to figure out the strange results from this
stored procedure? I tested with different methods but come out empty-handed
.
Please help! Thanks!Correction to part of the stored procedure:
if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
@.CustType <> '')
select * from CustTable
where @.LastName is null or LName like rtrim(@.LastName)
else
select 'No data'
"KTN" wrote:

> I am trying to tune a stored procedure that is long and running slow. As
> part of testing, the results are odd from what I am expecting. The testin
g
> is running on 2 databases which restored from the same backup with one
> database set with read-only option. This will allows me to check the
> original code with modified code. These databases are on my server;
> therefore, it is lock down.
> The stored procedure has 15 pass-in variables with default values are NULL
.
> If I modify the stored procedure by adding a non-essential statement such
as
> SELECT 1 or SELECT getdate() anywhere in the stored procedure, the procedu
re
> return different result.
>
> Test query: exec GetValues @.FName = 'Smith%', @.FName = default, @.Price =
> default, @.CustType = default
> Part of the existing stored procedure:
> if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
> @.CustType <> '')
> select * from CustTable
> where @.LastName is null or customer.FName like rtrim(@.LastName)
> else
> select 'No data'
>
> When I run this on the read-only database, it returns some rows. But when
I
> run this on the test database with modified code, it returns no data. The
> stored procedures from both database are basically same with exception of
> adding a non-essential statement (SELECT 1 or SELECT getdate()). Based on
> what test query, it should return no data on both databases, but the resul
ts
> are different.
> Is there a tool or methods to figure out the strange results from this
> stored procedure? I tested with different methods but come out empty-hand
ed.
> Please help! Thanks!|||KTN
Do you investigate how to optimize the SP or why it returns wrong result?
Have you look into an execution plan? Was the optimizer available to use
indexes? How much data do you return?
"KTN" <KTN@.discussions.microsoft.com> wrote in message
news:47DD3664-5829-40E5-92B8-A5EE1E8D9C45@.microsoft.com...
>I am trying to tune a stored procedure that is long and running slow. As
> part of testing, the results are odd from what I am expecting. The
> testing
> is running on 2 databases which restored from the same backup with one
> database set with read-only option. This will allows me to check the
> original code with modified code. These databases are on my server;
> therefore, it is lock down.
> The stored procedure has 15 pass-in variables with default values are
> NULL.
> If I modify the stored procedure by adding a non-essential statement such
> as
> SELECT 1 or SELECT getdate() anywhere in the stored procedure, the
> procedure
> return different result.
>
> Test query: exec GetValues @.FName = 'Smith%', @.FName = default, @.Price =
> default, @.CustType = default
> Part of the existing stored procedure:
> if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
> @.CustType <> '')
> select * from CustTable
> where @.LastName is null or customer.FName like rtrim(@.LastName)
> else
> select 'No data'
>
> When I run this on the read-only database, it returns some rows. But when
> I
> run this on the test database with modified code, it returns no data. The
> stored procedures from both database are basically same with exception of
> adding a non-essential statement (SELECT 1 or SELECT getdate()). Based on
> what test query, it should return no data on both databases, but the
> results
> are different.
> Is there a tool or methods to figure out the strange results from this
> stored procedure? I tested with different methods but come out
> empty-handed.
> Please help! Thanks!|||My plan is to optimize the SP and in part of doing that, I found wrong
results with adding non-essential statements such as SELECT getddate()
I looked at the execution plan for the new code is much better via using
some covering index and better query plans.
The data return is very based on the 15 pass-in variables, but mostly under
100 rows.
"Uri Dimant" wrote:

> KTN
> Do you investigate how to optimize the SP or why it returns wrong result?
> Have you look into an execution plan? Was the optimizer available to use
> indexes? How much data do you return?
>
>
>
> "KTN" <KTN@.discussions.microsoft.com> wrote in message
> news:47DD3664-5829-40E5-92B8-A5EE1E8D9C45@.microsoft.com...
>
>

How to troubleshoot a strange result from a stored procedure?

I am trying to tune a stored procedure that is long and running slow. As
part of testing, the results are odd from what I am expecting. The testing
is running on 2 databases which restored from the same backup with one
database set with read-only option. This will allows me to check the
original code with modified code. These databases are on my server;
therefore, it is lock down.
The stored procedure has 15 pass-in variables with default values are NULL.
If I modify the stored procedure by adding a non-essential statement such as
SELECT 1 or SELECT getdate() anywhere in the stored procedure, the procedure
return different result.
Test query: exec GetValues @.FName = 'Smith%', @.FName = default, @.Price =
default, @.CustType = default
Part of the existing stored procedure:
if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
@.CustType <> '')
select * from CustTable
where @.LastName is null or customer.FName like rtrim(@.LastName)
else
select 'No data'
When I run this on the read-only database, it returns some rows. But when I
run this on the test database with modified code, it returns no data. The
stored procedures from both database are basically same with exception of
adding a non-essential statement (SELECT 1 or SELECT getdate()). Based on
what test query, it should return no data on both databases, but the results
are different.
Is there a tool or methods to figure out the strange results from this
stored procedure? I tested with different methods but come out empty-handed.
Please help! Thanks!
Correction to part of the stored procedure:
if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
@.CustType <> '')
select * from CustTable
where @.LastName is null or LName like rtrim(@.LastName)
else
select 'No data'
"KTN" wrote:

> I am trying to tune a stored procedure that is long and running slow. As
> part of testing, the results are odd from what I am expecting. The testing
> is running on 2 databases which restored from the same backup with one
> database set with read-only option. This will allows me to check the
> original code with modified code. These databases are on my server;
> therefore, it is lock down.
> The stored procedure has 15 pass-in variables with default values are NULL.
> If I modify the stored procedure by adding a non-essential statement such as
> SELECT 1 or SELECT getdate() anywhere in the stored procedure, the procedure
> return different result.
>
> Test query: exec GetValues @.FName = 'Smith%', @.FName = default, @.Price =
> default, @.CustType = default
> Part of the existing stored procedure:
> if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
> @.CustType <> '')
> select * from CustTable
> where @.LastName is null or customer.FName like rtrim(@.LastName)
> else
> select 'No data'
>
> When I run this on the read-only database, it returns some rows. But when I
> run this on the test database with modified code, it returns no data. The
> stored procedures from both database are basically same with exception of
> adding a non-essential statement (SELECT 1 or SELECT getdate()). Based on
> what test query, it should return no data on both databases, but the results
> are different.
> Is there a tool or methods to figure out the strange results from this
> stored procedure? I tested with different methods but come out empty-handed.
> Please help! Thanks!
|||KTN
Do you investigate how to optimize the SP or why it returns wrong result?
Have you look into an execution plan? Was the optimizer available to use
indexes? How much data do you return?
"KTN" <KTN@.discussions.microsoft.com> wrote in message
news:47DD3664-5829-40E5-92B8-A5EE1E8D9C45@.microsoft.com...
>I am trying to tune a stored procedure that is long and running slow. As
> part of testing, the results are odd from what I am expecting. The
> testing
> is running on 2 databases which restored from the same backup with one
> database set with read-only option. This will allows me to check the
> original code with modified code. These databases are on my server;
> therefore, it is lock down.
> The stored procedure has 15 pass-in variables with default values are
> NULL.
> If I modify the stored procedure by adding a non-essential statement such
> as
> SELECT 1 or SELECT getdate() anywhere in the stored procedure, the
> procedure
> return different result.
>
> Test query: exec GetValues @.FName = 'Smith%', @.FName = default, @.Price =
> default, @.CustType = default
> Part of the existing stored procedure:
> if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
> @.CustType <> '')
> select * from CustTable
> where @.LastName is null or customer.FName like rtrim(@.LastName)
> else
> select 'No data'
>
> When I run this on the read-only database, it returns some rows. But when
> I
> run this on the test database with modified code, it returns no data. The
> stored procedures from both database are basically same with exception of
> adding a non-essential statement (SELECT 1 or SELECT getdate()). Based on
> what test query, it should return no data on both databases, but the
> results
> are different.
> Is there a tool or methods to figure out the strange results from this
> stored procedure? I tested with different methods but come out
> empty-handed.
> Please help! Thanks!
|||My plan is to optimize the SP and in part of doing that, I found wrong
results with adding non-essential statements such as SELECT getddate()
I looked at the execution plan for the new code is much better via using
some covering index and better query plans.
The data return is very based on the 15 pass-in variables, but mostly under
100 rows.
"Uri Dimant" wrote:

> KTN
> Do you investigate how to optimize the SP or why it returns wrong result?
> Have you look into an execution plan? Was the optimizer available to use
> indexes? How much data do you return?
>
>
>
> "KTN" <KTN@.discussions.microsoft.com> wrote in message
> news:47DD3664-5829-40E5-92B8-A5EE1E8D9C45@.microsoft.com...
>
>

How to troubleshoot a strange result from a stored procedure?

I am trying to tune a stored procedure that is long and running slow. As
part of testing, the results are odd from what I am expecting. The testing
is running on 2 databases which restored from the same backup with one
database set with read-only option. This will allows me to check the
original code with modified code. These databases are on my server;
therefore, it is lock down.
The stored procedure has 15 pass-in variables with default values are NULL.
If I modify the stored procedure by adding a non-essential statement such as
SELECT 1 or SELECT getdate() anywhere in the stored procedure, the procedure
return different result.
Test query: exec GetValues @.FName = 'Smith%', @.FName = default, @.Price = default, @.CustType = default
Part of the existing stored procedure:
if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
@.CustType <> '')
select * from CustTable
where @.LastName is null or customer.FName like rtrim(@.LastName)
else
select 'No data'
When I run this on the read-only database, it returns some rows. But when I
run this on the test database with modified code, it returns no data. The
stored procedures from both database are basically same with exception of
adding a non-essential statement (SELECT 1 or SELECT getdate()). Based on
what test query, it should return no data on both databases, but the results
are different.
Is there a tool or methods to figure out the strange results from this
stored procedure? I tested with different methods but come out empty-handed.
Please help! Thanks!Correction to part of the stored procedure:
if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
@.CustType <> '')
select * from CustTable
where @.LastName is null or LName like rtrim(@.LastName)
else
select 'No data'
"KTN" wrote:
> I am trying to tune a stored procedure that is long and running slow. As
> part of testing, the results are odd from what I am expecting. The testing
> is running on 2 databases which restored from the same backup with one
> database set with read-only option. This will allows me to check the
> original code with modified code. These databases are on my server;
> therefore, it is lock down.
> The stored procedure has 15 pass-in variables with default values are NULL.
> If I modify the stored procedure by adding a non-essential statement such as
> SELECT 1 or SELECT getdate() anywhere in the stored procedure, the procedure
> return different result.
>
> Test query: exec GetValues @.FName = 'Smith%', @.FName = default, @.Price => default, @.CustType = default
> Part of the existing stored procedure:
> if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
> @.CustType <> '')
> select * from CustTable
> where @.LastName is null or customer.FName like rtrim(@.LastName)
> else
> select 'No data'
>
> When I run this on the read-only database, it returns some rows. But when I
> run this on the test database with modified code, it returns no data. The
> stored procedures from both database are basically same with exception of
> adding a non-essential statement (SELECT 1 or SELECT getdate()). Based on
> what test query, it should return no data on both databases, but the results
> are different.
> Is there a tool or methods to figure out the strange results from this
> stored procedure? I tested with different methods but come out empty-handed.
> Please help! Thanks!|||KTN
Do you investigate how to optimize the SP or why it returns wrong result?
Have you look into an execution plan? Was the optimizer available to use
indexes? How much data do you return?
"KTN" <KTN@.discussions.microsoft.com> wrote in message
news:47DD3664-5829-40E5-92B8-A5EE1E8D9C45@.microsoft.com...
>I am trying to tune a stored procedure that is long and running slow. As
> part of testing, the results are odd from what I am expecting. The
> testing
> is running on 2 databases which restored from the same backup with one
> database set with read-only option. This will allows me to check the
> original code with modified code. These databases are on my server;
> therefore, it is lock down.
> The stored procedure has 15 pass-in variables with default values are
> NULL.
> If I modify the stored procedure by adding a non-essential statement such
> as
> SELECT 1 or SELECT getdate() anywhere in the stored procedure, the
> procedure
> return different result.
>
> Test query: exec GetValues @.FName = 'Smith%', @.FName = default, @.Price => default, @.CustType = default
> Part of the existing stored procedure:
> if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
> @.CustType <> '')
> select * from CustTable
> where @.LastName is null or customer.FName like rtrim(@.LastName)
> else
> select 'No data'
>
> When I run this on the read-only database, it returns some rows. But when
> I
> run this on the test database with modified code, it returns no data. The
> stored procedures from both database are basically same with exception of
> adding a non-essential statement (SELECT 1 or SELECT getdate()). Based on
> what test query, it should return no data on both databases, but the
> results
> are different.
> Is there a tool or methods to figure out the strange results from this
> stored procedure? I tested with different methods but come out
> empty-handed.
> Please help! Thanks!|||My plan is to optimize the SP and in part of doing that, I found wrong
results with adding non-essential statements such as SELECT getddate()
I looked at the execution plan for the new code is much better via using
some covering index and better query plans.
The data return is very based on the 15 pass-in variables, but mostly under
100 rows.
"Uri Dimant" wrote:
> KTN
> Do you investigate how to optimize the SP or why it returns wrong result?
> Have you look into an execution plan? Was the optimizer available to use
> indexes? How much data do you return?
>
>
>
> "KTN" <KTN@.discussions.microsoft.com> wrote in message
> news:47DD3664-5829-40E5-92B8-A5EE1E8D9C45@.microsoft.com...
> >I am trying to tune a stored procedure that is long and running slow. As
> > part of testing, the results are odd from what I am expecting. The
> > testing
> > is running on 2 databases which restored from the same backup with one
> > database set with read-only option. This will allows me to check the
> > original code with modified code. These databases are on my server;
> > therefore, it is lock down.
> >
> > The stored procedure has 15 pass-in variables with default values are
> > NULL.
> > If I modify the stored procedure by adding a non-essential statement such
> > as
> > SELECT 1 or SELECT getdate() anywhere in the stored procedure, the
> > procedure
> > return different result.
> >
> >
> > Test query: exec GetValues @.FName = 'Smith%', @.FName = default, @.Price => > default, @.CustType = default
> >
> > Part of the existing stored procedure:
> > if (@.Price is not null or @.Price <> '') and (@.CustomerType is not null or
> > @.CustType <> '')
> > select * from CustTable
> > where @.LastName is null or customer.FName like rtrim(@.LastName)
> > else
> > select 'No data'
> >
> >
> > When I run this on the read-only database, it returns some rows. But when
> > I
> > run this on the test database with modified code, it returns no data. The
> > stored procedures from both database are basically same with exception of
> > adding a non-essential statement (SELECT 1 or SELECT getdate()). Based on
> > what test query, it should return no data on both databases, but the
> > results
> > are different.
> >
> > Is there a tool or methods to figure out the strange results from this
> > stored procedure? I tested with different methods but come out
> > empty-handed.
> > Please help! Thanks!
>
>

How to trap EXECUTE failure

We are running SQL 2000 sp3a on Win2003 Server with all patches and SPs applied.

I want to run a stored procedure from a SQL Agent job. I want the stored procedure to run as a TRANSACTION to force a ROLLBACK in case of failure. However, if execute the procedure and an error of severity level 20 (I think) or greater happens I get blown out of the job immediately. Therefore I cannot call RAISEERROR or use @.@.ERROR. So, how do I assure that I can ROLLBACK the TRANSACTION?

I have searched the web and BOL and cannot find anything that addresses this specifically.

Thanks in advance for any help.Severity level 20 indicates a fatal error that the session encountered. The batch terminates and the connection is severed. The fate of your transaction is predetermined, - it will roll back. You (your spid) cannot roll it back with ROLLBACK because the batch execution will not reach that point.

how to test before putting in production

Hi all,
I have a asp .net 1.1 application running on the intranet which uses SQL Server 2000.
The application is in production and everytime I want to do some changes, i do the changes on my
development machine then I copy the application dll on the server.
The problem is that I'm using Stored Procedures for all my Select, Insert and Delete statements.
These stored procedures are live on the server so I can't do the modifications locally and test them then copy to the server.

How can I do modifications without affecting the production server and the users ?
thanks.

The simplest solution is to have a local copy of your database and test against that. You can download the MSDE from Microsoft for free.

A more complicated solution would be to create the test SPs in a different schema from dbo, and reference them that way. (I've had good luck doing that with Oracle using synonyms. Everything was referenced via synonym, and if a developer wanted to override the object, he'd create a new one with the same name as the synonym in his own schema. I'm not sure how well this would work in SQL Server.)

|||Thanks for your reply. As you said the first solution seems easier.

I still have a few questions if you don't mind:
When I download MSDE, do they have utilities to copy my whole database from SQL server to MSDE ?|||

I use enterprise manager to back up the production DB, and then restore it on MSDE.

Yes. Just change the connection string to point to the appropriate db. It you have it in your web.config, it should be easy to do.

You can do a simple copy/paste. I use SqlDiff to copy schema/procedure changes from one database to another.

|||thank you , seems good i'll try that.

how to tell which sp am i running on?

hi all,
how can i know what SPs (service packS) is my SQL server box currently
running
on
--
thanks,
--
joeySELECT SERVERPROPERTY('ProductLevel')
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joeydj" <Email me> wrote in message news:95BA09C5-60F2-466E-A1B5-1BE9776CA5D7@.microsoft.com...
> hi all,
> how can i know what SPs (service packS) is my SQL server box currently
> running
> on
> --
> thanks,
> --
> joey|||Run this
select serverproperty('ProductLevel')
Returns:
'RTM' = shipping version.
'SPn' = service pack version
'Bn', = beta version
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shah|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shahsql

how to tell which sp am i running on?

hi all,
how can i know what SPs (service packS) is my SQL server box currently
running
on
thanks,
joeySELECT SERVERPROPERTY('ProductLevel')
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"joeydj" <Email me> wrote in message news:95BA09C5-60F2-466E-A1B5-1BE9776CA5D7@.microsoft.com
..
> hi all,
> how can i know what SPs (service packS) is my SQL server box currently
> running
> on
> --
> thanks,
> --
> joey|||Run this
select serverproperty('ProductLevel')
Returns:
'RTM' = shipping version.
'SPn' = service pack version
'Bn', = beta version
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shah|||Take a look at
http://www.aspfaq.com/show.asp?id=2160
Regards
Amish Shah

How to tell what version of SQL Server.

If I am running an MSDN version of SQL Server how would I be able to tell
using Query Analyzer?
I tried @.@.Version ... but it says Enterprise Edition ... when I know I have
install MSDN copy.
-LarsPlease check it out at the following link
http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
HTH
Satish Balusa
Corillian Corp.
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...

quote:

---

> If I am running an MSDN version of SQL Server how would I be able to tell
> using Query Analyzer?
> I tried @.@.Version ... but it says Enterprise Edition ... when I know I

---

have

quote:

---

> install MSDN copy.
> -Lars
>

---

|||Still does not tell me whether server is running MSDN copy of SQL Server.
Perhaps this is not possiable.
-Lars
"Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...

quote:

---

> Please check it out at the following link
> http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
>
> --
> HTH
> Satish Balusa
> Corillian Corp.
>
> "Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
> news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
tell[QUOTE]
> have
>

---

|||There's no such thing as an MSDN version of SQL Server. The MSDN people at M
S quite simply shipped
MSDN with the edition they found most appropriate. In the beginning of SQL2K
, you had all editions
and after a while the shipments only contained the developer edition.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ls
erver
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:ukZJsub6DHA.2064@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Still does not tell me whether server is running MSDN copy of SQL Server.
> Perhaps this is not possiable.
> -Lars
> "Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
> news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...
> tell
>

---

How to tell what version of SQL Server.

If I am running an MSDN version of SQL Server how would I be able to tell
using Query Analyzer?
I tried @.@.Version ... but it says Enterprise Edition ... when I know I have
install MSDN copy.
-LarsPlease check it out at the following link
http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
HTH
Satish Balusa
Corillian Corp.
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
> If I am running an MSDN version of SQL Server how would I be able to tell
> using Query Analyzer?
> I tried @.@.Version ... but it says Enterprise Edition ... when I know I
have
> install MSDN copy.
> -Lars
>|||Still does not tell me whether server is running MSDN copy of SQL Server.
Perhaps this is not possiable.
-Lars
"Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...
> Please check it out at the following link
> http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
>
> --
> HTH
> Satish Balusa
> Corillian Corp.
>
> "Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
> news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
> > If I am running an MSDN version of SQL Server how would I be able to
tell
> > using Query Analyzer?
> > I tried @.@.Version ... but it says Enterprise Edition ... when I know I
> have
> > install MSDN copy.
> >
> > -Lars
> >
> >
>|||There's no such thing as an MSDN version of SQL Server. The MSDN people at MS quite simply shipped
MSDN with the edition they found most appropriate. In the beginning of SQL2K, you had all editions
and after a while the shipments only contained the developer edition.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
news:ukZJsub6DHA.2064@.TK2MSFTNGP11.phx.gbl...
> Still does not tell me whether server is running MSDN copy of SQL Server.
> Perhaps this is not possiable.
> -Lars
> "Satish Balusa" <sbalusa_nospam@.corillian.com> wrote in message
> news:%23RDv9cb6DHA.3860@.tk2msftngp13.phx.gbl...
> > Please check it out at the following link
> >
> > http://sqljunkies.com/weblog/sqlpartner/posts/802.aspx
> >
> >
> > --
> > HTH
> > Satish Balusa
> > Corillian Corp.
> >
> >
> > "Lars Temme" <no_spam@.L+A+R+S.T+E+M+M+E@.fsc.fiserv.com> wrote in message
> > news:OgSYCYb6DHA.1592@.TK2MSFTNGP10.phx.gbl...
> > > If I am running an MSDN version of SQL Server how would I be able to
> tell
> > > using Query Analyzer?
> > > I tried @.@.Version ... but it says Enterprise Edition ... when I know I
> > have
> > > install MSDN copy.
> > >
> > > -Lars
> > >
> > >
> >
> >
>

How to tell what SQL 2005 version I'm runing?

Hey everyone,
We have a server that is running SQL 2005 but we don't know if it's full SQL
2005 or SQL 2005 Express. Can someone tell me how I can find out?
We DON'T have SQL Server Mangement Studio installed.
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************> We have a server that is running SQL 2005 but we don't know if it's full
> SQL 2005 or SQL 2005 Express. Can someone tell me how I can find out?
> We DON'T have SQL Server Mangement Studio installed.
Anywhere?
If you're going to manage SQL Server, you should have it SOMEWHERE. If not
regular Management Studio then at least the express version (which is free).
http://tinyurl.com/j7wjl
From there you can run
SELECT @.@.VERSION;|||underprocessable|||You should be able to tell something from your services applet in control
panel / administrative tools. By default I think a SQL Express instance
will be listed as SQL Server (SQLEXPRESS).
But, what on earth could you be doing with SQL Server? If you can't even
connect to it in order to see what edition it is, how are you managing it,
how do you expect to create databases, etc.? This is why I suggested
getting at least Management Studio Express. It doesn't do everything, but
it is better than zero.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Clayton Sutton" <none@.none.com> wrote in message
news:lXM%h.208335$RF.182058@.fe02.news.easynews.com...
> Hey Aaron,
> We need to know which version we have installed so we will know how to
> back it up. If is't the Express version then NetBackup will not back it
> up with their SQL Agent. However, if it's the Express version then we
> have to us a command line to back it up. But we don't know which version
> is installed.
> Here is a screen shot of what I have installed.|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:uVOXCDPkHHA.1340@.TK2MSFTNGP04.phx.gbl...
> You should be able to tell something from your services applet in control
> panel / administrative tools. By default I think a SQL Express instance
> will be listed as SQL Server (SQLEXPRESS).
> But, what on earth could you be doing with SQL Server? If you can't even
> connect to it in order to see what edition it is, how are you managing it,
> how do you expect to create databases, etc.?

>This is why I suggested getting at least Management Studio Express. It
>doesn't do everything, but it is better than zero.
Well, this is one reason I want to know which version is installed so I will
know which Management Studio to install, the full version or the Express
version.
SQL is running on a SharePoint 2007 server. SharePoint needed SQL, however,
no one can remember if the full version or the Express version was installed
during instalation.
Clayton

> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:lXM%h.208335$RF.182058@.fe02.news.easynews.com...
>|||> Well, this is one reason I want to know which version is installed so I
> will know which Management Studio to install, the full version or the
> Express version.
Well, since Management Studio Express is free, it is not going to hurt you
to install it.
And if you had access to Management Studio (e.g. on a SQL Server
installation CD), then I guess you could look at the CD to see which edition
you have, since it's printed on the label. :-)

> SQL is running on a SharePoint 2007 server. SharePoint needed SQL,
> however, no one can remember if the full version or the Express version
> was installed during instalation.
Have you looked at the SharePoint site, or the SharePoint documentation?
Surely it is listed there somewhere. Also, did you try looking in the
services applet like I suggested earlier?|||How about connection with SQLCMD and execute below?
SELECT @.@.VERSION
GO
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Clayton Sutton" <none@.none.com> wrote in message
news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
> Hey everyone,
> We have a server that is running SQL 2005 but we don't know if it's full S
QL 2005 or SQL 2005
> Express. Can someone tell me how I can find out?
> We DON'T have SQL Server Mangement Studio installed.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it. Y
ou can find it at:
> http://www.nikoli.net/itunepod
> *******************
>
>|||Hey Aaron,
After I got in to work today I checked the services on that server and it
looks like we are running SQL Express. This is what it says: SQL Server
(SQLEXPRESS).
Thanks for your help dude! Now I will install the Management Studio.
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:%23nHfu0RkHHA.1828@.TK2MSFTNGP05.phx.gbl...
> Well, since Management Studio Express is free, it is not going to hurt you
> to install it.
> And if you had access to Management Studio (e.g. on a SQL Server
> installation CD), then I guess you could look at the CD to see which
> edition you have, since it's printed on the label. :-)
>
> Have you looked at the SharePoint site, or the SharePoint documentation?
> Surely it is listed there somewhere. Also, did you try looking in the
> services applet like I suggested earlier?
>|||Hey Tibor,
Thanks for the advice, however, I don't know how to use the sqlcmd command.
Got any tips? I tried the /? but that didn't help much.
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:edgGDLVkHHA.568@.TK2MSFTNGP02.phx.gbl...
> How about connection with SQLCMD and execute below?
> SELECT @.@.VERSION
> GO
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
>|||Sorry Aaron,
I was looking at the wrong server. Looking at the "right" server services
it says: SQL Server (OFFICESERVERS).
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Clayton Sutton" <none@.none.com> wrote in message
news:j2%%h.274750$9i2.95644@.fe06.news.easynews.com...
> Hey Aaron,
> After I got in to work today I checked the services on that server and it
> looks like we are running SQL Express. This is what it says: SQL Server
> (SQLEXPRESS).
> Thanks for your help dude! Now I will install the Management Studio.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
> You can find it at: http://www.nikoli.net/itunepod
> *******************
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:%23nHfu0RkHHA.1828@.TK2MSFTNGP05.phx.gbl...
>

How to tell what SQL 2005 version I'm runing?

Hey everyone,
We have a server that is running SQL 2005 but we don't know if it's full SQL
2005 or SQL 2005 Express. Can someone tell me how I can find out?
We DON'T have SQL Server Mangement Studio installed.
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************> We have a server that is running SQL 2005 but we don't know if it's full
> SQL 2005 or SQL 2005 Express. Can someone tell me how I can find out?
> We DON'T have SQL Server Mangement Studio installed.
Anywhere?
If you're going to manage SQL Server, you should have it SOMEWHERE. If not
regular Management Studio then at least the express version (which is free).
http://tinyurl.com/j7wjl
From there you can run
SELECT @.@.VERSION;|||You should be able to tell something from your services applet in control
panel / administrative tools. By default I think a SQL Express instance
will be listed as SQL Server (SQLEXPRESS).
But, what on earth could you be doing with SQL Server? If you can't even
connect to it in order to see what edition it is, how are you managing it,
how do you expect to create databases, etc.? This is why I suggested
getting at least Management Studio Express. It doesn't do everything, but
it is better than zero.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Clayton Sutton" <none@.none.com> wrote in message
news:lXM%h.208335$RF.182058@.fe02.news.easynews.com...
> Hey Aaron,
> We need to know which version we have installed so we will know how to
> back it up. If is't the Express version then NetBackup will not back it
> up with their SQL Agent. However, if it's the Express version then we
> have to us a command line to back it up. But we don't know which version
> is installed.
> Here is a screen shot of what I have installed.|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uVOXCDPkHHA.1340@.TK2MSFTNGP04.phx.gbl...
> You should be able to tell something from your services applet in control
> panel / administrative tools. By default I think a SQL Express instance
> will be listed as SQL Server (SQLEXPRESS).
> But, what on earth could you be doing with SQL Server? If you can't even
> connect to it in order to see what edition it is, how are you managing it,
> how do you expect to create databases, etc.?
>This is why I suggested getting at least Management Studio Express. It
>doesn't do everything, but it is better than zero.
Well, this is one reason I want to know which version is installed so I will
know which Management Studio to install, the full version or the Express
version.
SQL is running on a SharePoint 2007 server. SharePoint needed SQL, however,
no one can remember if the full version or the Express version was installed
during instalation.
Clayton
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:lXM%h.208335$RF.182058@.fe02.news.easynews.com...
>> Hey Aaron,
>> We need to know which version we have installed so we will know how to
>> back it up. If is't the Express version then NetBackup will not back it
>> up with their SQL Agent. However, if it's the Express version then we
>> have to us a command line to back it up. But we don't know which version
>> is installed.
>> Here is a screen shot of what I have installed.
>|||> Well, this is one reason I want to know which version is installed so I
> will know which Management Studio to install, the full version or the
> Express version.
Well, since Management Studio Express is free, it is not going to hurt you
to install it.
And if you had access to Management Studio (e.g. on a SQL Server
installation CD), then I guess you could look at the CD to see which edition
you have, since it's printed on the label. :-)
> SQL is running on a SharePoint 2007 server. SharePoint needed SQL,
> however, no one can remember if the full version or the Express version
> was installed during instalation.
Have you looked at the SharePoint site, or the SharePoint documentation?
Surely it is listed there somewhere. Also, did you try looking in the
services applet like I suggested earlier?|||How about connection with SQLCMD and execute below?
SELECT @.@.VERSION
GO
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Clayton Sutton" <none@.none.com> wrote in message
news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
> Hey everyone,
> We have a server that is running SQL 2005 but we don't know if it's full SQL 2005 or SQL 2005
> Express. Can someone tell me how I can find out?
> We DON'T have SQL Server Mangement Studio installed.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it. You can find it at:
> http://www.nikoli.net/itunepod
> *******************
>
>|||Hey Aaron,
After I got in to work today I checked the services on that server and it
looks like we are running SQL Express. This is what it says: SQL Server
(SQLEXPRESS).
Thanks for your help dude! Now I will install the Management Studio.
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23nHfu0RkHHA.1828@.TK2MSFTNGP05.phx.gbl...
>> Well, this is one reason I want to know which version is installed so I
>> will know which Management Studio to install, the full version or the
>> Express version.
> Well, since Management Studio Express is free, it is not going to hurt you
> to install it.
> And if you had access to Management Studio (e.g. on a SQL Server
> installation CD), then I guess you could look at the CD to see which
> edition you have, since it's printed on the label. :-)
>> SQL is running on a SharePoint 2007 server. SharePoint needed SQL,
>> however, no one can remember if the full version or the Express version
>> was installed during instalation.
> Have you looked at the SharePoint site, or the SharePoint documentation?
> Surely it is listed there somewhere. Also, did you try looking in the
> services applet like I suggested earlier?
>|||Hey Tibor,
Thanks for the advice, however, I don't know how to use the sqlcmd command.
Got any tips? I tried the /? but that didn't help much.
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:edgGDLVkHHA.568@.TK2MSFTNGP02.phx.gbl...
> How about connection with SQLCMD and execute below?
> SELECT @.@.VERSION
> GO
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
>> Hey everyone,
>> We have a server that is running SQL 2005 but we don't know if it's full
>> SQL 2005 or SQL 2005 Express. Can someone tell me how I can find out?
>> We DON'T have SQL Server Mangement Studio installed.
>> --
>> TIA,
>>
>> Clayton
>>
>> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
>> You can find it at: http://www.nikoli.net/itunepod
>> *******************
>>
>>
>|||Sorry Aaron,
I was looking at the wrong server. Looking at the "right" server services
it says: SQL Server (OFFICESERVERS).
--
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Clayton Sutton" <none@.none.com> wrote in message
news:j2%%h.274750$9i2.95644@.fe06.news.easynews.com...
> Hey Aaron,
> After I got in to work today I checked the services on that server and it
> looks like we are running SQL Express. This is what it says: SQL Server
> (SQLEXPRESS).
> Thanks for your help dude! Now I will install the Management Studio.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
> You can find it at: http://www.nikoli.net/itunepod
> *******************
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:%23nHfu0RkHHA.1828@.TK2MSFTNGP05.phx.gbl...
>> Well, this is one reason I want to know which version is installed so I
>> will know which Management Studio to install, the full version or the
>> Express version.
>> Well, since Management Studio Express is free, it is not going to hurt
>> you to install it.
>> And if you had access to Management Studio (e.g. on a SQL Server
>> installation CD), then I guess you could look at the CD to see which
>> edition you have, since it's printed on the label. :-)
>> SQL is running on a SharePoint 2007 server. SharePoint needed SQL,
>> however, no one can remember if the full version or the Express version
>> was installed during instalation.
>> Have you looked at the SharePoint site, or the SharePoint documentation?
>> Surely it is listed there somewhere. Also, did you try looking in the
>> services applet like I suggested earlier?
>|||http://msdn2.microsoft.com/en-us/library/ms162773.aspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Clayton Sutton" <none@.none.com> wrote in message
news:s3%%h.405811$mJ2.249092@.fe10.news.easynews.com...
> Hey Tibor,
> Thanks for the advice, however, I don't know how to use the sqlcmd command. Got any tips? I tried
> the /? but that didn't help much.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it. You can find it at:
> http://www.nikoli.net/itunepod
> *******************
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:edgGDLVkHHA.568@.TK2MSFTNGP02.phx.gbl...
>> How about connection with SQLCMD and execute below?
>> SELECT @.@.VERSION
>> GO
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
>> Hey everyone,
>> We have a server that is running SQL 2005 but we don't know if it's full SQL 2005 or SQL 2005
>> Express. Can someone tell me how I can find out?
>> We DON'T have SQL Server Mangement Studio installed.
>> --
>> TIA,
>>
>> Clayton
>>
>> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it. You can find it at:
>> http://www.nikoli.net/itunepod
>> *******************
>>
>>
>>
>|||select @.@.version
will give you:
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Clayton Sutton" <none@.none.com> wrote in message
news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
> Hey everyone,
> We have a server that is running SQL 2005 but we don't know if it's full
> SQL 2005 or SQL 2005 Express. Can someone tell me how I can find out?
> We DON'T have SQL Server Mangement Studio installed.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
> You can find it at: http://www.nikoli.net/itunepod
> *******************
>
>

how to tell type of replication

Hi admins,
If there's a system with running replication on it then how to tell which
type of replication is that? Where and what should I look at?
Thanks you a lot in advance for your inputsp_helpreplicationoption
See BOL for details
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <alex_remove_this_@.telus.net> wrote in message
news:Y9YAd.35482$dv1.4877@.edtnps89...
> Hi admins,
> If there's a system with running replication on it then how to tell which
> type of replication is that? Where and what should I look at?
> Thanks you a lot in advance for your input
>

how to tell type of replication

Hi admins,
If there's a system with running replication on it then how to tell which
type of replication is that? Where and what should I look at?
Thanks you a lot in advance for your input
sp_helpreplicationoption
See BOL for details
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <alex_remove_this_@.telus.net> wrote in message
news:Y9YAd.35482$dv1.4877@.edtnps89...
> Hi admins,
> If there's a system with running replication on it then how to tell which
> type of replication is that? Where and what should I look at?
> Thanks you a lot in advance for your input
>
sql

how to tell type of replication

Hi admins,
If there's a system with running replication on it then how to tell which
type of replication is that? Where and what should I look at?
Thanks you a lot in advance for your inputsp_helpreplicationoption
See BOL for details
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex" <alex_remove_this_@.telus.net> wrote in message
news:Y9YAd.35482$dv1.4877@.edtnps89...
> Hi admins,
> If there's a system with running replication on it then how to tell which
> type of replication is that? Where and what should I look at?
> Thanks you a lot in advance for your input
>

How to tell services account in SQL

I have remote servers and i need to determine which
service account is the SQL server running on ?
Anyone knows hot to do it
Thanks
AnupI know this can be done using WMI. There are probably several ways to do
this.
-Argenis
"anup" <anonymous@.discussions.microsoft.com> wrote in message
news:52db01c5235d$ebbf2330$a601280a@.phx.gbl...
> I have remote servers and i need to determine which
> service account is the SQL server running on ?
> Anyone knows hot to do it
> Thanks
> Anup|||Check this script out and yank out whatever you don't need.
http://www.eggheadcafe.com/articles/20030627e.asp
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"anup" <anonymous@.discussions.microsoft.com> wrote in message
news:52db01c5235d$ebbf2330$a601280a@.phx.gbl...
>I have remote servers and i need to determine which
> service account is the SQL server running on ?
> Anyone knows hot to do it
> Thanks
> Anup

How to tell services account in SQL

I have remote servers and i need to determine which
service account is the SQL server running on ?
Anyone knows hot to do it
Thanks
Anup
I know this can be done using WMI. There are probably several ways to do
this.
-Argenis
"anup" <anonymous@.discussions.microsoft.com> wrote in message
news:52db01c5235d$ebbf2330$a601280a@.phx.gbl...
> I have remote servers and i need to determine which
> service account is the SQL server running on ?
> Anyone knows hot to do it
> Thanks
> Anup

How to tell services account in SQL

I have remote servers and i need to determine which
service account is the SQL server running on ?
Anyone knows hot to do it
Thanks
AnupI know this can be done using WMI. There are probably several ways to do
this.
-Argenis
"anup" <anonymous@.discussions.microsoft.com> wrote in message
news:52db01c5235d$ebbf2330$a601280a@.phx.gbl...
> I have remote servers and i need to determine which
> service account is the SQL server running on ?
> Anyone knows hot to do it
> Thanks
> Anup

how to tell resources used by individual databases

I'm running SQL Server 2000 on Windows 2003. There are many databases
on this server and sometimes the processors are running very high
where sqlserver.exe is the process doing it. How can I tell the
resources used by each database at a given point in time?
Hi
Run SQL Profiler to see what queries are being executed and thier
statistics. This gives you a good idea as to what is causing your high
utilization.
Regards
Mike
"Joe" wrote:

> I'm running SQL Server 2000 on Windows 2003. There are many databases
> on this server and sometimes the processors are running very high
> where sqlserver.exe is the process doing it. How can I tell the
> resources used by each database at a given point in time?
>
sql

how to tell resources used by individual databases

I'm running SQL Server 2000 on Windows 2003. There are many databases
on this server and sometimes the processors are running very high
where sqlserver.exe is the process doing it. How can I tell the
resources used by each database at a given point in time?Hi
Run SQL Profiler to see what queries are being executed and thier
statistics. This gives you a good idea as to what is causing your high
utilization.
Regards
Mike
"Joe" wrote:
> I'm running SQL Server 2000 on Windows 2003. There are many databases
> on this server and sometimes the processors are running very high
> where sqlserver.exe is the process doing it. How can I tell the
> resources used by each database at a given point in time?
>

How to tell if SQL SP4 is installed

I have a SQL Server running and I need to know if SP4 is installed on it.
How can I tell?
Thanks,
Chrishttp://support.microsoft.com/kb/q321185/
"Chris Hedlund" <chrishedlund@.hotmail.com> wrote in message
news:ecdv41NtGHA.644@.TK2MSFTNGP03.phx.gbl...
>I have a SQL Server running and I need to know if SP4 is installed on it.
>How can I tell?
> Thanks,
> Chris
>|||Enterprise manage, right click on the server in question under the server
group, select properties and you should see product with SP version
"Chris Hedlund" wrote:
> I have a SQL Server running and I need to know if SP4 is installed on it.
> How can I tell?
> Thanks,
> Chris
>
>|||It's one thing to find the version number, but another to match it up with
the actual service pack/patch level. You can paste the below into your
Query Analyzer and run it - it should tab out correctly. If not, use this
as a reference: http://vyaskn.tripod.com/sqlsps.htm
SET NOCOUNT ON
print 'C.1 Current SQL Server Version'
print 'DM1769: CAT I'
print 'The IAO will ensure that the SQL Server version has all patches and
hotfixes applied.'
print ''
print 'SQL Server Version Table:'
print char(9) + char(9) + char(9) + 'No SP SP1 SP2 SP3 / SP3a SP4
SP5 SP5a'
print 'SQL Server 6.0' + char(9) + char(9) + '6.00.121 6.00.124' + char(9)
+ '6.00.139' + char(9) + '6.00.151'
print 'SQL Server 6.5' + char(9) + char(9) + '6.50.201' + char(9) +
'6.50.213' + char(9) + '6.50.240' + char(9) + '6.50.258' + char(9) +
'6.50.281' + char(9) + '6.50.415' + char(9) + '6.50.416'
print 'SQL Server 7.0' + char(9) + char(9) + '7.00.623' + char(9) +
'7.00.699' + char(9) + '7.00.842' + char(9) + '7.00.961' + char(9) +
'7.00.1063'
print 'SQL Server 2000' + char(9) + char(9) + '8.00.194' + char(9) +
'8.00.384' + char(9) + '8.00.534' + char(9) + '8.00.760' + char(9) +
'8.00.2039'
print 'SQL Server 2005' + char(9) + char(9) + '9.00.1399.06 '
print
'========================================================================================================================'
declare @.result varchar(255)
exec xp_msver 'ProductVersion'
"Chris Hedlund" <chrishedlund@.hotmail.com> wrote in message
news:ecdv41NtGHA.644@.TK2MSFTNGP03.phx.gbl...
>I have a SQL Server running and I need to know if SP4 is installed on it.
>How can I tell?
> Thanks,
> Chris
>