Any way to have a cursor variable reference an *existing* cursor?

(SQL Server 2000, SP3a)
Hello, all!
I have an open global cursor that is created dynamically by stored procedure
A. I'd like
to reference this cursor from stored procedure B. I know the dynamic name o
f the cursor,
but I know of no way to get a "handle" of this cursor so that I can use it f
rom stored
procedure B in a cursor variable.
I had hoped that maybe I could somehow divine the "handle" from sp_describe_
cursor, but I
can't seem to "set" my cursor variable from any of this information. Someth
ing like (once
I retrieve the cursor_handle or something):
set @.MyCursor = cursor @.cursor_handle
Does anyone know of any mechanism I can use to accomplish this?
Thanks!
John PetersonI had hoped that something like this would work:
declare @.CursorName nvarchar(4000) select @.CursorName = 'cur'
execute
(
'
declare ' + @.CursorName + ' cursor forward_only read_only for
select name from sysobjects
'
)
declare @.Cursor cursor
declare @.Query nvarchar(4000)
select @.Query = 'set @.Cursor = ' + @.CursorName
execute [dbo].[sp_executesql] @.Query, N'@.Cursor cursor varying output', @.Cursor =
@.Cursor
output
execute('deallocate ' + @.CursorName)
But, alas, I get this error:
Server: Msg 181, Level 15, State 1, Line 1
Cannot use the OUTPUT option in a DECLARE statement.
Server: Msg 137, Level 15, State 1, Line 1
Must declare the variable '@.Cursor'.
Which I don't fully understand. But, after some fiddling, it's clearly some
thing with the
[sp_executesql] line. No amount of massaging will get this to work -- my gu
ess is that
the structure of [sp_executesql] won't permit a cursor variable to be handle
d. :-(
I'd appreciate any other suggestions!
Regards,
John Peterson
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:uxudcE99DHA.3488@.tk2msftngp13.phx.gbl...
> (SQL Server 2000, SP3a)
> Hello, all!
> I have an open global cursor that is created dynamically by stored procedure A. I
'd
like
> to reference this cursor from stored procedure B. I know the dynamic name of the[
/color]
cursor,
> but I know of no way to get a "handle" of this cursor so that I can use it
from stored
> procedure B in a cursor variable.
> I had hoped that maybe I could somehow divine the "handle" from sp_describe_cursor
, but
I
> can't seem to "set" my cursor variable from any of this information. Something li
ke
(once
> I retrieve the cursor_handle or something):
> set @.MyCursor = cursor @.cursor_handle
> Does anyone know of any mechanism I can use to accomplish this?
> Thanks!
> John Peterson
>

Any recommendation for a good DBA tool.

Hi All
I looking for a good DBA tool to view the REAL TIME performance of my
databases especially the stored procedures. Anyone with recommendations
please help? Thank you in advance.Hi, Maybe Spotlight from Quest Software
"MittyKom" wrote:

> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>|||I'm currently evaluating Quest Spotlight for SQL Server. I've evaluated a
few different offerings and I like this one the best. Additional
performance tools can be purchased as a suite (Quest Central) or as
indiviual components.
HTH
Jerry
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:302F5C4A-ED69-4175-A26C-C4E84BDF64A4@.microsoft.com...
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>|||What you want to get from the performance. I use Profiler to mornitor any
SP or ad hoc query that run more than 1 minues. If I found one, then I will
try to optimize the SQL statement. Why am I doing this? because I am a new
DBA, and most of our database design were done by a consultant firm. And I
found that a lot of SP were done terriblely.
Perayu
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:302F5C4A-ED69-4175-A26C-C4E84BDF64A4@.microsoft.com...
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>

Any recommendation for a good DBA tool.

Hi All
I looking for a good DBA tool to view the REAL TIME performance of my
databases especially the stored procedures. Anyone with recommendations
please help? Thank you in advance.
Hi, Maybe Spotlight from Quest Software
"MittyKom" wrote:

> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>
|||I'm currently evaluating Quest Spotlight for SQL Server. I've evaluated a
few different offerings and I like this one the best. Additional
performance tools can be purchased as a suite (Quest Central) or as
indiviual components.
HTH
Jerry
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:302F5C4A-ED69-4175-A26C-C4E84BDF64A4@.microsoft.com...
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>
|||What you want to get from the performance. I use Profiler to mornitor any
SP or ad hoc query that run more than 1 minues. If I found one, then I will
try to optimize the SQL statement. Why am I doing this? because I am a new
DBA, and most of our database design were done by a consultant firm. And I
found that a lot of SP were done terriblely.
Perayu
"MittyKom" <MittyKom@.discussions.microsoft.com> wrote in message
news:302F5C4A-ED69-4175-A26C-C4E84BDF64A4@.microsoft.com...
> Hi All
> I looking for a good DBA tool to view the REAL TIME performance of my
> databases especially the stored procedures. Anyone with recommendations
> please help? Thank you in advance.
>

Any one tell export Sql Database in access hole object

hi All
I want to export my mssqlserver 2000 database with all relation ship and all
default value and all data save in sqlserver Database (I want to export hole
data base object ) in MS Access database is it possible
if it is possible from mssqlserver please tell me if it is possible from any
other third party tool then please tell me
thanks in advanced
from
khurram
I am not aware of tool that does a complete transfer of all objects from SQL
Server to MS Access. You can certainly use SQL Server DTS to move data to
Access. You might want to post this to an Access group as well.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"khurram alam" <khurram.alam@.eintelligencesoft.com> wrote in message
news:O1N0qQnZEHA.3988@.tk2msftngp13.phx.gbl...
hi All
I want to export my mssqlserver 2000 database with all relation ship and all
default value and all data save in sqlserver Database (I want to export hole
data base object ) in MS Access database is it possible
if it is possible from mssqlserver please tell me if it is possible from any
other third party tool then please tell me
thanks in advanced
from
khurram
|||Hi,
You can either use Upsizing wizard or SQL DTS to upgrade objects/data from
Access to SQL server.
The details about the tools and steps are detailed in the below
knowledgebase article.
http://support.microsoft.com/default...b;en-us;237980
Thanks
Hari
MCDBA"khurram alam" <khurram.alam@.eintelligencesoft.com> wrote in message
news:O1N0qQnZEHA.3988@.tk2msftngp13.phx.gbl...
> hi All
> I want to export my mssqlserver 2000 database with all relation ship and
all
> default value and all data save in sqlserver Database (I want to export
hole
> data base object ) in MS Access database is it possible
> if it is possible from mssqlserver please tell me if it is possible from
any
> other third party tool then please tell me
> thanks in advanced
> from
> khurram
>

Antivirus on a 2003 Cluster

Hi all
I am trying to work out if it is ok to install an antivirus product onto my
Windows 2003 SQL Cluster.
According to Symantec I can:
http://service1.symantec.com/SUPPORT... er=savce_9.0
but Microsoft don't seem too keen on the idea:
http://support.microsoft.com/default...;EN-US;Q250355
Has anyone managed to install antivirus onto a cluster with no problems or
is it best just to leave my servers as they are?
Thanks
Kristi
You can install, just exclude the MSCS directory and where you put your SQL
Data.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
"Krissi" <krissi@.hotmail.com> wrote in message
news:42636498$1@.quokka.wn.com.au...
> Hi all
> I am trying to work out if it is ok to install an antivirus product onto
> my
> Windows 2003 SQL Cluster.
> According to Symantec I can:
> http://service1.symantec.com/SUPPORT... er=savce_9.0
> but Microsoft don't seem too keen on the idea:
> http://support.microsoft.com/default...;EN-US;Q250355
> Has anyone managed to install antivirus onto a cluster with no problems or
> is it best just to leave my servers as they are?
> Thanks
> Kristi
>
|||Trend Micro with Server Protect have a good solution.
"Krissi" wrote:

> Hi all
> I am trying to work out if it is ok to install an antivirus product onto my
> Windows 2003 SQL Cluster.
> According to Symantec I can:
> http://service1.symantec.com/SUPPORT... er=savce_9.0
> but Microsoft don't seem too keen on the idea:
> http://support.microsoft.com/default...;EN-US;Q250355
> Has anyone managed to install antivirus onto a cluster with no problems or
> is it best just to leave my servers as they are?
> Thanks
> Kristi
>
>
|||Agreed, that is what I recommend and use, but you still need to exclude
directories
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
"LUCA MOTTERLE [MCP]" <LUCAMOTTERLEMCP@.discussions.microsoft.com> wrote in
message news:E2242F94-D213-430C-85C4-DF8712B455D3@.microsoft.com...[vbcol=seagreen]
> Trend Micro with Server Protect have a good solution.
> "Krissi" wrote: