|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Cannot find a GUI to execute a queryI am not that new to Sql Server but I began using Sql Server Ent 2008 just a
month or two ago. I recall that in 2005 Express there was that option. You generate a query or you just use an older query or Stored Procedure and you open that GUI and what was the most important you had an option to assign all parameters and execute the query with parameters which would result in your having rows of the output. I cannot find it in Sql Server 2008 Enterprise. Has it been removed or I simply forgot where it is? Thanks. I think that option still exists, but I can't remember off the top of my
head how to get to it. I do know that in Management Studio, you can navigate to your sproc and then do Script to Execute in new window. That will allow you to setup your variables and execute the sproc. If you need to debug the sproc though, then you'll need the option you're looking for. I'm pretty sure it's there, just don't remember off hand where. Show quoteHide quote "AlexB" <alexblai***@comcast.net> wrote in message news:D30AAD59-39DC-4FAD-A686-A4518BAAACE2@microsoft.com... > I am not that new to Sql Server but I began using Sql Server Ent 2008 just > a month or two ago. I recall that in 2005 Express there was that option. > You generate a query or you just use an older query or Stored Procedure > and you open that GUI and what was the most important you had an option to > assign all parameters and execute the query with parameters which would > result in your having rows of the output. > > I cannot find it in Sql Server 2008 Enterprise. Has it been removed or I > simply forgot where it is? > > Thanks. Hi AlexB,
I am not sure if this is what exactly you want to know but If you right-click on a stored procedure in SQL Server 2008 Management Studio and select the option "Execute Stored Procedure" you are allowed to set the parameters (if any) for the stored procedure and the query is then constructed automatically. If the above does not answer to your question, can you provide some more details? Cheers. -- Show quoteHide quoteArtemakis Artemiou, SQL Server MVP http://aartemiou.blogspot.com This post is provided "as-is" and confers no rights. "AlexB" <alexblai***@comcast.net> wrote in message news:D30AAD59-39DC-4FAD-A686-A4518BAAACE2@microsoft.com... > I am not that new to Sql Server but I began using Sql Server Ent 2008 just > a month or two ago. I recall that in 2005 Express there was that option. > You generate a query or you just use an older query or Stored Procedure > and you open that GUI and what was the most important you had an option to > assign all parameters and execute the query with parameters which would > result in your having rows of the output. > > I cannot find it in Sql Server 2008 Enterprise. Has it been removed or I > simply forgot where it is? > > Thanks. Hi Artemakis,
Right clicking and selecting 'Execute' works when I am in a vs2005 database but the 'Execute' doesn't show up on the menu if I am in a SQL Server Express database. Do you have any insight into this behavior? Am I missing something? Any help would be appreciated. Thanks. Show quoteHide quote "Artemakis Artemiou" wrote: > Hi AlexB, > > I am not sure if this is what exactly you want to know but If you > right-click on a stored procedure in SQL Server 2008 Management Studio and > select the option "Execute Stored Procedure" you are allowed to set the > parameters (if any) for the stored procedure and the query is then > constructed automatically. > > If the above does not answer to your question, can you provide some more > details? > > Cheers. > > -- > > Artemakis Artemiou, SQL Server MVP > http://aartemiou.blogspot.com > > This post is provided "as-is" and confers no rights. > > > > "AlexB" <alexblai***@comcast.net> wrote in message > news:D30AAD59-39DC-4FAD-A686-A4518BAAACE2@microsoft.com... > > I am not that new to Sql Server but I began using Sql Server Ent 2008 just > > a month or two ago. I recall that in 2005 Express there was that option. > > You generate a query or you just use an older query or Stored Procedure > > and you open that GUI and what was the most important you had an option to > > assign all parameters and execute the query with parameters which would > > result in your having rows of the output. > > > > I cannot find it in Sql Server 2008 Enterprise. Has it been removed or I > > simply forgot where it is? > > > > Thanks. > Do you mean the Specify Values for Template Parameters option on the query
menu? Also available using Ctrl+Shift+M. -- Show quoteHide quoteRick Byham (MSFT), SQL Server Books Online This posting is provided "AS IS" with no warranties, and confers no rights. "AlexB" <alexblai***@comcast.net> wrote in message news:D30AAD59-39DC-4FAD-A686-A4518BAAACE2@microsoft.com... >I am not that new to Sql Server but I began using Sql Server Ent 2008 just >a month or two ago. I recall that in 2005 Express there was that option. >You generate a query or you just use an older query or Stored Procedure and >you open that GUI and what was the most important you had an option to >assign all parameters and execute the query with parameters which would >result in your having rows of the output. > > I cannot find it in Sql Server 2008 Enterprise. Has it been removed or I > simply forgot where it is? > > Thanks. Hi Rick,
No. I am talking about the "Execute Stored Procedure" item on the context menu that shows up if you right click on a stored procedure. The context menu item is there if I right click on a SP in a 2005 database but not there if I right click on a SP in a SQLExpress 2005 database. Show quoteHide quote "Rick Byham, (MSFT)" wrote: > Do you mean the Specify Values for Template Parameters option on the query > menu? Also available using Ctrl+Shift+M. > -- > Rick Byham (MSFT), SQL Server Books Online > This posting is provided "AS IS" with no warranties, and confers no rights. > > "AlexB" <alexblai***@comcast.net> wrote in message > news:D30AAD59-39DC-4FAD-A686-A4518BAAACE2@microsoft.com... > >I am not that new to Sql Server but I began using Sql Server Ent 2008 just > >a month or two ago. I recall that in 2005 Express there was that option. > >You generate a query or you just use an older query or Stored Procedure and > >you open that GUI and what was the most important you had an option to > >assign all parameters and execute the query with parameters which would > >result in your having rows of the output. > > > > I cannot find it in Sql Server 2008 Enterprise. Has it been removed or I > > simply forgot where it is? > > > > Thanks. > KellyP (Kel***@discussions.microsoft.com) writes:
> No. I am talking about the "Execute Stored Procedure" item on the Exactly which version of SQL Server Management Studio are you using?> context menu that shows up if you right click on a stored procedure. > The context menu item is there if I right click on a SP in a 2005 > database but not there if I right click on a SP in a SQLExpress 2005 > database. I connect with SSMS 2008 to both SQL 2008 and SQL 2005 Express instances, and the item is there on the context menu. The only thing I can think of is that you don't have EXECUTE permission on the procedure and SSMS is smart enough to check for this. -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Erland,
Thanks for responding. I am using SSMS 2005 and as far as I can tell I do have execute permissions. . Here is the version info: Microsoft SQL Server Management Studio 9.00.4035.00 Microsoft Analysis Services Client Tools 2005.090.4035.00 Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 7.0.5730.13 Microsoft .NET Framework 2.0.50727.1433 Operating System 5.1.2600 FYI, the "Execute Stored Procedure" item used to be there until one day our helpdesk removed SQL 2005 express from my desktop and loaded the SSMS 2005 client piece on my desktop. I then loaded the express db back to my PC so I could have a local db. Since then the "Execute Stored Procedure" item no longer shows up on when using the express db but does show up on all the other dbs. Show quoteHide quote "Erland Sommarskog" wrote: > KellyP (Kel***@discussions.microsoft.com) writes: > > No. I am talking about the "Execute Stored Procedure" item on the > > context menu that shows up if you right click on a stored procedure. > > The context menu item is there if I right click on a SP in a 2005 > > database but not there if I right click on a SP in a SQLExpress 2005 > > database. > > Exactly which version of SQL Server Management Studio are you using? > I connect with SSMS 2008 to both SQL 2008 and SQL 2005 Express instances, > and the item is there on the context menu. > > The only thing I can think of is that you don't have EXECUTE permission > on the procedure and SSMS is smart enough to check for this. > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Links for SQL Server Books Online: > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx > SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > > KellyP (Kel***@discussions.microsoft.com) writes:
> FYI, the "Execute Stored Procedure" item used to be there until one day These databases are on different instances, right? You talk about "the > our helpdesk removed SQL 2005 express from my desktop and loaded the > SSMS 2005 client piece on my desktop. I then loaded the express db back > to my PC so I could have a local db. Since then the "Execute Stored > Procedure" item no longer shows up on when using the express db but does > show up on all the other dbs. express db", but reasonably, this is your local Express instance. What happens if you do this in your Express instance: CREATE DATABASE testing go USE testing go CREATE PROCEDURE test_sp AS PRINT 12 go If you know find this procedure in Object Explorer, do you see "Execute Stored Procedure"? -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx Hi Erland,
Nope. Still can't see the "Execute Stored Procedure". You are also correct, I am talking about my local express instance. this is the only instance in which the command does not show up. Unfortunately this is the main one I use to develop. Show quoteHide quote "Erland Sommarskog" wrote: > KellyP (Kel***@discussions.microsoft.com) writes: > > FYI, the "Execute Stored Procedure" item used to be there until one day > > our helpdesk removed SQL 2005 express from my desktop and loaded the > > SSMS 2005 client piece on my desktop. I then loaded the express db back > > to my PC so I could have a local db. Since then the "Execute Stored > > Procedure" item no longer shows up on when using the express db but does > > show up on all the other dbs. > > These databases are on different instances, right? You talk about "the > express db", but reasonably, this is your local Express instance. What > happens if you do this in your Express instance: > > CREATE DATABASE testing > go > USE testing > go > CREATE PROCEDURE test_sp AS PRINT 12 > go > > > If you know find this procedure in Object Explorer, do you see > "Execute Stored Procedure"? > > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > > Links for SQL Server Books Online: > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx > SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > > I exactly know what's going on with your system... (too much arrogance
here?) Let me tell you about your scenario: You, had SQL Server Management Studio Express (2005) installed on your PC before and now you have SSMS (2005). As SSMS and SSMSE can't work together on the same system, SSMSE was removed to install SSMS. When you connect to a SQL Server Express Edition instance using SSMS (2005 only, but you'll see the option with SSMS 2008), you won't see "Execute Stored Procedure..." item on the popup menu as you complain, however if you used SSMSE 2005 (which you probably used to use before) then you'll see this option and it does not matter even if you are connected to a SQL Server Express Edition instance or another edition. I performed this test using a VM, SQL Server 2005 Std Edition and Express Edition on Windows Server 2003. RTM version of SSMS (2005) behaves the same as the lastest version. -- Show quoteHide quoteEkrem Önsoy "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, news:36CD8E64-D4B3-4BD5-9AE2-755A17E758EC@microsoft.com... > Erland, > Thanks for responding. I am using SSMS 2005 and as far as I can tell I do > have execute permissions. . Here is the version info: > > Microsoft SQL Server Management Studio 9.00.4035.00 > Microsoft Analysis Services Client Tools 2005.090.4035.00 > Microsoft Data Access Components (MDAC) 2000.085.1132.00 > (xpsp.080413-0852) > Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 > Microsoft Internet Explorer 7.0.5730.13 > Microsoft .NET Framework 2.0.50727.1433 > Operating System 5.1.2600 > > FYI, the "Execute Stored Procedure" item used to be there until one day > our > helpdesk removed SQL 2005 express from my desktop and loaded the SSMS 2005 > client piece on my desktop. I then loaded the express db back to my PC so > I > could have a local db. Since then the "Execute Stored Procedure" item no > longer shows up on when using the express db but does show up on all the > other dbs. > > "Erland Sommarskog" wrote: > >> KellyP (Kel***@discussions.microsoft.com) writes: >> > No. I am talking about the "Execute Stored Procedure" item on the >> > context menu that shows up if you right click on a stored procedure. >> > The context menu item is there if I right click on a SP in a 2005 >> > database but not there if I right click on a SP in a SQLExpress 2005 >> > database. >> >> Exactly which version of SQL Server Management Studio are you using? >> I connect with SSMS 2008 to both SQL 2008 and SQL 2005 Express instances, >> and the item is there on the context menu. >> >> The only thing I can think of is that you don't have EXECUTE permission >> on the procedure and SSMS is smart enough to check for this. >> >> -- >> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se >> >> Links for SQL Server Books Online: >> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx >> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx >> SQL 2000: >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >> >> Hi Ekrem,
You nailed what happened exactly. Unfortunately, moving to SSME 2008 where I work is not going to happen anytime soon. Do you know any way to get around the problem? Show quoteHide quote "Ekrem Önsoy" wrote: > I exactly know what's going on with your system... (too much arrogance > here?) > > Let me tell you about your scenario: > You, had SQL Server Management Studio Express (2005) installed on your PC > before and now you have SSMS (2005). As SSMS and SSMSE can't work together > on the same system, SSMSE was removed to install SSMS. > > When you connect to a SQL Server Express Edition instance using SSMS (2005 > only, but you'll see the option with SSMS 2008), you won't see "Execute > Stored Procedure..." item on the popup menu as you complain, however if you > used SSMSE 2005 (which you probably used to use before) then you'll see this > option and it does not matter even if you are connected to a SQL Server > Express Edition instance or another edition. > > I performed this test using a VM, SQL Server 2005 Std Edition and Express > Edition on Windows Server 2003. RTM version of SSMS (2005) behaves the same > as the lastest version. > > -- > Ekrem Önsoy > > > "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, > news:36CD8E64-D4B3-4BD5-9AE2-755A17E758EC@microsoft.com... > > Erland, > > Thanks for responding. I am using SSMS 2005 and as far as I can tell I do > > have execute permissions. . Here is the version info: > > > > Microsoft SQL Server Management Studio 9.00.4035.00 > > Microsoft Analysis Services Client Tools 2005.090.4035.00 > > Microsoft Data Access Components (MDAC) 2000.085.1132.00 > > (xpsp.080413-0852) > > Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 > > Microsoft Internet Explorer 7.0.5730.13 > > Microsoft .NET Framework 2.0.50727.1433 > > Operating System 5.1.2600 > > > > FYI, the "Execute Stored Procedure" item used to be there until one day > > our > > helpdesk removed SQL 2005 express from my desktop and loaded the SSMS 2005 > > client piece on my desktop. I then loaded the express db back to my PC so > > I > > could have a local db. Since then the "Execute Stored Procedure" item no > > longer shows up on when using the express db but does show up on all the > > other dbs. > > > > "Erland Sommarskog" wrote: > > > >> KellyP (Kel***@discussions.microsoft.com) writes: > >> > No. I am talking about the "Execute Stored Procedure" item on the > >> > context menu that shows up if you right click on a stored procedure. > >> > The context menu item is there if I right click on a SP in a 2005 > >> > database but not there if I right click on a SP in a SQLExpress 2005 > >> > database. > >> > >> Exactly which version of SQL Server Management Studio are you using? > >> I connect with SSMS 2008 to both SQL 2008 and SQL 2005 Express instances, > >> and the item is there on the context menu. > >> > >> The only thing I can think of is that you don't have EXECUTE permission > >> on the procedure and SSMS is smart enough to check for this. > >> > >> -- > >> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > >> > >> Links for SQL Server Books Online: > >> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx > >> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx > >> SQL 2000: > >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > >> > >> > Hello Kelly,
How about using SSMSE instead of SSMS (2005)? You probably know that SSMSE is a limited version of SSMS, however it can do the thing you are looking for. -- Show quoteHide quoteEkrem Önsoy "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, news:0CDF96C2-D7B5-409F-A6B1-EB541D10B86E@microsoft.com... > Hi Ekrem, > > You nailed what happened exactly. Unfortunately, moving to SSME 2008 > where > I work is not going to happen anytime soon. Do you know any way to get > around the problem? > > "Ekrem Önsoy" wrote: > >> I exactly know what's going on with your system... (too much arrogance >> here?) >> >> Let me tell you about your scenario: >> You, had SQL Server Management Studio Express (2005) installed on your PC >> before and now you have SSMS (2005). As SSMS and SSMSE can't work >> together >> on the same system, SSMSE was removed to install SSMS. >> >> When you connect to a SQL Server Express Edition instance using SSMS >> (2005 >> only, but you'll see the option with SSMS 2008), you won't see "Execute >> Stored Procedure..." item on the popup menu as you complain, however if >> you >> used SSMSE 2005 (which you probably used to use before) then you'll see >> this >> option and it does not matter even if you are connected to a SQL Server >> Express Edition instance or another edition. >> >> I performed this test using a VM, SQL Server 2005 Std Edition and Express >> Edition on Windows Server 2003. RTM version of SSMS (2005) behaves the >> same >> as the lastest version. >> >> -- >> Ekrem Önsoy >> >> >> "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, >> news:36CD8E64-D4B3-4BD5-9AE2-755A17E758EC@microsoft.com... >> > Erland, >> > Thanks for responding. I am using SSMS 2005 and as far as I can tell I >> > do >> > have execute permissions. . Here is the version info: >> > >> > Microsoft SQL Server Management Studio 9.00.4035.00 >> > Microsoft Analysis Services Client Tools 2005.090.4035.00 >> > Microsoft Data Access Components (MDAC) 2000.085.1132.00 >> > (xpsp.080413-0852) >> > Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 >> > Microsoft Internet Explorer 7.0.5730.13 >> > Microsoft .NET Framework 2.0.50727.1433 >> > Operating System 5.1.2600 >> > >> > FYI, the "Execute Stored Procedure" item used to be there until one day >> > our >> > helpdesk removed SQL 2005 express from my desktop and loaded the SSMS >> > 2005 >> > client piece on my desktop. I then loaded the express db back to my PC >> > so >> > I >> > could have a local db. Since then the "Execute Stored Procedure" item >> > no >> > longer shows up on when using the express db but does show up on all >> > the >> > other dbs. >> > >> > "Erland Sommarskog" wrote: >> > >> >> KellyP (Kel***@discussions.microsoft.com) writes: >> >> > No. I am talking about the "Execute Stored Procedure" item on the >> >> > context menu that shows up if you right click on a stored procedure. >> >> > The context menu item is there if I right click on a SP in a 2005 >> >> > database but not there if I right click on a SP in a SQLExpress 2005 >> >> > database. >> >> >> >> Exactly which version of SQL Server Management Studio are you using? >> >> I connect with SSMS 2008 to both SQL 2008 and SQL 2005 Express >> >> instances, >> >> and the item is there on the context menu. >> >> >> >> The only thing I can think of is that you don't have EXECUTE >> >> permission >> >> on the procedure and SSMS is smart enough to check for this. >> >> >> >> -- >> >> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se >> >> >> >> Links for SQL Server Books Online: >> >> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx >> >> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx >> >> SQL 2000: >> >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >> >> >> >> >> Hello Kelly,
How about using SSMSE instead of SSMS (2005)? You probably know that SSMSE is a limited version of SSMS, however it can do the thing you are looking for. -- Show quoteHide quoteEkrem Önsoy "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, news:0CDF96C2-D7B5-409F-A6B1-EB541D10B86E@microsoft.com... > Hi Ekrem, > > You nailed what happened exactly. Unfortunately, moving to SSME 2008 > where > I work is not going to happen anytime soon. Do you know any way to get > around the problem? > > "Ekrem Önsoy" wrote: > >> I exactly know what's going on with your system... (too much arrogance >> here?) >> >> Let me tell you about your scenario: >> You, had SQL Server Management Studio Express (2005) installed on your PC >> before and now you have SSMS (2005). As SSMS and SSMSE can't work >> together >> on the same system, SSMSE was removed to install SSMS. >> >> When you connect to a SQL Server Express Edition instance using SSMS >> (2005 >> only, but you'll see the option with SSMS 2008), you won't see "Execute >> Stored Procedure..." item on the popup menu as you complain, however if >> you >> used SSMSE 2005 (which you probably used to use before) then you'll see >> this >> option and it does not matter even if you are connected to a SQL Server >> Express Edition instance or another edition. >> >> I performed this test using a VM, SQL Server 2005 Std Edition and Express >> Edition on Windows Server 2003. RTM version of SSMS (2005) behaves the >> same >> as the lastest version. >> >> -- >> Ekrem Önsoy >> >> >> "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, >> news:36CD8E64-D4B3-4BD5-9AE2-755A17E758EC@microsoft.com... >> > Erland, >> > Thanks for responding. I am using SSMS 2005 and as far as I can tell I >> > do >> > have execute permissions. . Here is the version info: >> > >> > Microsoft SQL Server Management Studio 9.00.4035.00 >> > Microsoft Analysis Services Client Tools 2005.090.4035.00 >> > Microsoft Data Access Components (MDAC) 2000.085.1132.00 >> > (xpsp.080413-0852) >> > Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 >> > Microsoft Internet Explorer 7.0.5730.13 >> > Microsoft .NET Framework 2.0.50727.1433 >> > Operating System 5.1.2600 >> > >> > FYI, the "Execute Stored Procedure" item used to be there until one day >> > our >> > helpdesk removed SQL 2005 express from my desktop and loaded the SSMS >> > 2005 >> > client piece on my desktop. I then loaded the express db back to my PC >> > so >> > I >> > could have a local db. Since then the "Execute Stored Procedure" item >> > no >> > longer shows up on when using the express db but does show up on all >> > the >> > other dbs. >> > >> > "Erland Sommarskog" wrote: >> > >> >> KellyP (Kel***@discussions.microsoft.com) writes: >> >> > No. I am talking about the "Execute Stored Procedure" item on the >> >> > context menu that shows up if you right click on a stored procedure. >> >> > The context menu item is there if I right click on a SP in a 2005 >> >> > database but not there if I right click on a SP in a SQLExpress 2005 >> >> > database. >> >> >> >> Exactly which version of SQL Server Management Studio are you using? >> >> I connect with SSMS 2008 to both SQL 2008 and SQL 2005 Express >> >> instances, >> >> and the item is there on the context menu. >> >> >> >> The only thing I can think of is that you don't have EXECUTE >> >> permission >> >> on the procedure and SSMS is smart enough to check for this. >> >> >> >> -- >> >> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se >> >> >> >> Links for SQL Server Books Online: >> >> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx >> >> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx >> >> SQL 2000: >> >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >> >> >> >> >> Hi Ekrem,
Thanks for getting back to me so quick. I had thought of reverting back to SSMSE but there are some other features, like SQL Server Profiler, that I would then need to give up. Six of one hand..... I guess I can still 'Script Stored Procedure As Execute To' a new window, set the parameters manually and get the same results. GUI interface would have been nice though.... Thanks again for your help. Kelly. Show quoteHide quote "Ekrem Önsoy" wrote: > Hello Kelly, > > How about using SSMSE instead of SSMS (2005)? > > You probably know that SSMSE is a limited version of SSMS, however it can do > the thing you are looking for. > > -- > Ekrem Önsoy > > > "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, > news:0CDF96C2-D7B5-409F-A6B1-EB541D10B86E@microsoft.com... > > Hi Ekrem, > > > > You nailed what happened exactly. Unfortunately, moving to SSME 2008 > > where > > I work is not going to happen anytime soon. Do you know any way to get > > around the problem? > > > > "Ekrem Önsoy" wrote: > > > >> I exactly know what's going on with your system... (too much arrogance > >> here?) > >> > >> Let me tell you about your scenario: > >> You, had SQL Server Management Studio Express (2005) installed on your PC > >> before and now you have SSMS (2005). As SSMS and SSMSE can't work > >> together > >> on the same system, SSMSE was removed to install SSMS. > >> > >> When you connect to a SQL Server Express Edition instance using SSMS > >> (2005 > >> only, but you'll see the option with SSMS 2008), you won't see "Execute > >> Stored Procedure..." item on the popup menu as you complain, however if > >> you > >> used SSMSE 2005 (which you probably used to use before) then you'll see > >> this > >> option and it does not matter even if you are connected to a SQL Server > >> Express Edition instance or another edition. > >> > >> I performed this test using a VM, SQL Server 2005 Std Edition and Express > >> Edition on Windows Server 2003. RTM version of SSMS (2005) behaves the > >> same > >> as the lastest version. > >> > >> -- > >> Ekrem Önsoy > >> > >> > >> "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, > >> news:36CD8E64-D4B3-4BD5-9AE2-755A17E758EC@microsoft.com... > >> > Erland, > >> > Thanks for responding. I am using SSMS 2005 and as far as I can tell I > >> > do > >> > have execute permissions. . Here is the version info: > >> > > >> > Microsoft SQL Server Management Studio 9.00.4035.00 > >> > Microsoft Analysis Services Client Tools 2005.090.4035.00 > >> > Microsoft Data Access Components (MDAC) 2000.085.1132.00 > >> > (xpsp.080413-0852) > >> > Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 > >> > Microsoft Internet Explorer 7.0.5730.13 > >> > Microsoft .NET Framework 2.0.50727.1433 > >> > Operating System 5.1.2600 > >> > > >> > FYI, the "Execute Stored Procedure" item used to be there until one day > >> > our > >> > helpdesk removed SQL 2005 express from my desktop and loaded the SSMS > >> > 2005 > >> > client piece on my desktop. I then loaded the express db back to my PC > >> > so > >> > I > >> > could have a local db. Since then the "Execute Stored Procedure" item > >> > no > >> > longer shows up on when using the express db but does show up on all > >> > the > >> > other dbs. > >> > > >> > "Erland Sommarskog" wrote: > >> > > >> >> KellyP (Kel***@discussions.microsoft.com) writes: > >> >> > No. I am talking about the "Execute Stored Procedure" item on the > >> >> > context menu that shows up if you right click on a stored procedure. > >> >> > The context menu item is there if I right click on a SP in a 2005 > >> >> > database but not there if I right click on a SP in a SQLExpress 2005 > >> >> > database. > >> >> > >> >> Exactly which version of SQL Server Management Studio are you using? > >> >> I connect with SSMS 2008 to both SQL 2008 and SQL 2005 Express > >> >> instances, > >> >> and the item is there on the context menu. > >> >> > >> >> The only thing I can think of is that you don't have EXECUTE > >> >> permission > >> >> on the procedure and SSMS is smart enough to check for this. > >> >> > >> >> -- > >> >> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > >> >> > >> >> Links for SQL Server Books Online: > >> >> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx > >> >> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx > >> >> SQL 2000: > >> >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > >> >> > >> >> > >> > For now, I don't have a chance to try but I can suggest you to try
installing SSMSE 2008. I believe it works side by side SSMS 2005 because SSMS 2005 and 2008 works side by side (which was not possible before CTP 6 I guess). So you'll not have to uninstall Client Tools for 2005 version and you'll still have SSMSE 2008. How about this? -- Show quoteHide quoteEkrem Önsoy "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, news:6565AD9A-8342-4059-A4C1-5D3336BAA39E@microsoft.com... > Hi Ekrem, > > Thanks for getting back to me so quick. I had thought of reverting back > to > SSMSE but there are some other features, like SQL Server Profiler, that I > would then need to give up. Six of one hand..... > > I guess I can still 'Script Stored Procedure As Execute To' a new window, > set the parameters manually and get the same results. GUI interface would > have been nice though.... > > Thanks again for your help. > > Kelly. > > "Ekrem Önsoy" wrote: > >> Hello Kelly, >> >> How about using SSMSE instead of SSMS (2005)? >> >> You probably know that SSMSE is a limited version of SSMS, however it can >> do >> the thing you are looking for. >> >> -- >> Ekrem Önsoy >> >> >> "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, >> news:0CDF96C2-D7B5-409F-A6B1-EB541D10B86E@microsoft.com... >> > Hi Ekrem, >> > >> > You nailed what happened exactly. Unfortunately, moving to SSME 2008 >> > where >> > I work is not going to happen anytime soon. Do you know any way to get >> > around the problem? >> > >> > "Ekrem Önsoy" wrote: >> > >> >> I exactly know what's going on with your system... (too much arrogance >> >> here?) >> >> >> >> Let me tell you about your scenario: >> >> You, had SQL Server Management Studio Express (2005) installed on your >> >> PC >> >> before and now you have SSMS (2005). As SSMS and SSMSE can't work >> >> together >> >> on the same system, SSMSE was removed to install SSMS. >> >> >> >> When you connect to a SQL Server Express Edition instance using SSMS >> >> (2005 >> >> only, but you'll see the option with SSMS 2008), you won't see >> >> "Execute >> >> Stored Procedure..." item on the popup menu as you complain, however >> >> if >> >> you >> >> used SSMSE 2005 (which you probably used to use before) then you'll >> >> see >> >> this >> >> option and it does not matter even if you are connected to a SQL >> >> Server >> >> Express Edition instance or another edition. >> >> >> >> I performed this test using a VM, SQL Server 2005 Std Edition and >> >> Express >> >> Edition on Windows Server 2003. RTM version of SSMS (2005) behaves the >> >> same >> >> as the lastest version. >> >> >> >> -- >> >> Ekrem Önsoy >> >> >> >> >> >> "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, >> >> news:36CD8E64-D4B3-4BD5-9AE2-755A17E758EC@microsoft.com... >> >> > Erland, >> >> > Thanks for responding. I am using SSMS 2005 and as far as I can >> >> > tell I >> >> > do >> >> > have execute permissions. . Here is the version info: >> >> > >> >> > Microsoft SQL Server Management Studio 9.00.4035.00 >> >> > Microsoft Analysis Services Client Tools 2005.090.4035.00 >> >> > Microsoft Data Access Components (MDAC) 2000.085.1132.00 >> >> > (xpsp.080413-0852) >> >> > Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 >> >> > Microsoft Internet Explorer 7.0.5730.13 >> >> > Microsoft .NET Framework 2.0.50727.1433 >> >> > Operating System 5.1.2600 >> >> > >> >> > FYI, the "Execute Stored Procedure" item used to be there until one >> >> > day >> >> > our >> >> > helpdesk removed SQL 2005 express from my desktop and loaded the >> >> > SSMS >> >> > 2005 >> >> > client piece on my desktop. I then loaded the express db back to my >> >> > PC >> >> > so >> >> > I >> >> > could have a local db. Since then the "Execute Stored Procedure" >> >> > item >> >> > no >> >> > longer shows up on when using the express db but does show up on all >> >> > the >> >> > other dbs. >> >> > >> >> > "Erland Sommarskog" wrote: >> >> > >> >> >> KellyP (Kel***@discussions.microsoft.com) writes: >> >> >> > No. I am talking about the "Execute Stored Procedure" item on >> >> >> > the >> >> >> > context menu that shows up if you right click on a stored >> >> >> > procedure. >> >> >> > The context menu item is there if I right click on a SP in a 2005 >> >> >> > database but not there if I right click on a SP in a SQLExpress >> >> >> > 2005 >> >> >> > database. >> >> >> >> >> >> Exactly which version of SQL Server Management Studio are you >> >> >> using? >> >> >> I connect with SSMS 2008 to both SQL 2008 and SQL 2005 Express >> >> >> instances, >> >> >> and the item is there on the context menu. >> >> >> >> >> >> The only thing I can think of is that you don't have EXECUTE >> >> >> permission >> >> >> on the procedure and SSMS is smart enough to check for this. >> >> >> >> >> >> -- >> >> >> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se >> >> >> >> >> >> Links for SQL Server Books Online: >> >> >> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx >> >> >> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx >> >> >> SQL 2000: >> >> >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx >> >> >> >> >> >> >> >> >> Thank you. I'll give that a try.
Kelly. Show quoteHide quote "Ekrem Önsoy" wrote: > For now, I don't have a chance to try but I can suggest you to try > installing SSMSE 2008. I believe it works side by side SSMS 2005 because > SSMS 2005 and 2008 works side by side (which was not possible before CTP 6 I > guess). So you'll not have to uninstall Client Tools for 2005 version and > you'll still have SSMSE 2008. How about this? > > -- > Ekrem Önsoy > > > "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, > news:6565AD9A-8342-4059-A4C1-5D3336BAA39E@microsoft.com... > > Hi Ekrem, > > > > Thanks for getting back to me so quick. I had thought of reverting back > > to > > SSMSE but there are some other features, like SQL Server Profiler, that I > > would then need to give up. Six of one hand..... > > > > I guess I can still 'Script Stored Procedure As Execute To' a new window, > > set the parameters manually and get the same results. GUI interface would > > have been nice though.... > > > > Thanks again for your help. > > > > Kelly. > > > > "Ekrem Önsoy" wrote: > > > >> Hello Kelly, > >> > >> How about using SSMSE instead of SSMS (2005)? > >> > >> You probably know that SSMSE is a limited version of SSMS, however it can > >> do > >> the thing you are looking for. > >> > >> -- > >> Ekrem Önsoy > >> > >> > >> "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, > >> news:0CDF96C2-D7B5-409F-A6B1-EB541D10B86E@microsoft.com... > >> > Hi Ekrem, > >> > > >> > You nailed what happened exactly. Unfortunately, moving to SSME 2008 > >> > where > >> > I work is not going to happen anytime soon. Do you know any way to get > >> > around the problem? > >> > > >> > "Ekrem Önsoy" wrote: > >> > > >> >> I exactly know what's going on with your system... (too much arrogance > >> >> here?) > >> >> > >> >> Let me tell you about your scenario: > >> >> You, had SQL Server Management Studio Express (2005) installed on your > >> >> PC > >> >> before and now you have SSMS (2005). As SSMS and SSMSE can't work > >> >> together > >> >> on the same system, SSMSE was removed to install SSMS. > >> >> > >> >> When you connect to a SQL Server Express Edition instance using SSMS > >> >> (2005 > >> >> only, but you'll see the option with SSMS 2008), you won't see > >> >> "Execute > >> >> Stored Procedure..." item on the popup menu as you complain, however > >> >> if > >> >> you > >> >> used SSMSE 2005 (which you probably used to use before) then you'll > >> >> see > >> >> this > >> >> option and it does not matter even if you are connected to a SQL > >> >> Server > >> >> Express Edition instance or another edition. > >> >> > >> >> I performed this test using a VM, SQL Server 2005 Std Edition and > >> >> Express > >> >> Edition on Windows Server 2003. RTM version of SSMS (2005) behaves the > >> >> same > >> >> as the lastest version. > >> >> > >> >> -- > >> >> Ekrem Önsoy > >> >> > >> >> > >> >> "KellyP" <Kel***@discussions.microsoft.com>, iletisinde şunu yazdı, > >> >> news:36CD8E64-D4B3-4BD5-9AE2-755A17E758EC@microsoft.com... > >> >> > Erland, > >> >> > Thanks for responding. I am using SSMS 2005 and as far as I can > >> >> > tell I > >> >> > do > >> >> > have execute permissions. . Here is the version info: > >> >> > > >> >> > Microsoft SQL Server Management Studio 9.00.4035.00 > >> >> > Microsoft Analysis Services Client Tools 2005.090.4035.00 > >> >> > Microsoft Data Access Components (MDAC) 2000.085.1132.00 > >> >> > (xpsp.080413-0852) > >> >> > Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 > >> >> > Microsoft Internet Explorer 7.0.5730.13 > >> >> > Microsoft .NET Framework 2.0.50727.1433 > >> >> > Operating System 5.1.2600 > >> >> > > >> >> > FYI, the "Execute Stored Procedure" item used to be there until one > >> >> > day > >> >> > our > >> >> > helpdesk removed SQL 2005 express from my desktop and loaded the > >> >> > SSMS > >> >> > 2005 > >> >> > client piece on my desktop. I then loaded the express db back to my > >> >> > PC > >> >> > so > >> >> > I > >> >> > could have a local db. Since then the "Execute Stored Procedure" > >> >> > item > >> >> > no > >> >> > longer shows up on when using the express db but does show up on all > >> >> > the > >> >> > other dbs. > >> >> > > >> >> > "Erland Sommarskog" wrote: > >> >> > > >> >> >> KellyP (Kel***@discussions.microsoft.com) writes: > >> >> >> > No. I am talking about the "Execute Stored Procedure" item on > >> >> >> > the > >> >> >> > context menu that shows up if you right click on a stored > >> >> >> > procedure. > >> >> >> > The context menu item is there if I right click on a SP in a 2005 > >> >> >> > database but not there if I right click on a SP in a SQLExpress > >> >> >> > 2005 > >> >> >> > database. > >> >> >> > >> >> >> Exactly which version of SQL Server Management Studio are you > >> >> >> using? > >> >> >> I connect with SSMS 2008 to both SQL 2008 and SQL 2005 Express > >> >> >> instances, > >> >> >> and the item is there on the context menu. > >> >> >> > >> >> >> The only thing I can think of is that you don't have EXECUTE > >> >> >> permission > >> >> >> on the procedure and SSMS is smart enough to check for this. > >> >> >> > >> >> >> -- > >> >> >> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se > >> >> >> > >> >> >> Links for SQL Server Books Online: > >> >> >> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx > >> >> >> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx > >> >> >> SQL 2000: > >> >> >> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > >> >> >> > >> >> >> > >> >> > >> >  
Other interesting topics
SSMS 2008 Super Buggy
Can not create relationship; SQL server 2008 Express SQL Server Management Studio Server List Moving SQL Server Tools Installation to a New Drive statistics for performance using table valued function in a update query BCP connect error via shared memory to local instance linked server using dot net provider for mysql 5.1.3 Management Studio 2005 fails to start - How to fix? Problem profiling SQL 2000 server from 2008 profiler |
|||||||||||||||||||||||
