Showing posts with label remember. Show all posts
Showing posts with label remember. Show all posts

Friday, March 23, 2012

How many Stored Procedure can I add to a database in SQL SERVER 2005 Express edition?

How many Stored Procedure can I add to a database in SQL SERVER 2005 Express edition?

I remember that only 32 Stored Procedure can be added to a database in SQL SERVER 2005 Express edition,
but now I can add over 32 Stored Procedure to a database from SQL Server Management Studio Express CTP!
How many Stored Procedure can I add to a database in SQL SERVER 2005 Express edition?

I'm not aware of any limitation to the number of stored procedures in any version of SQL Server, including MSDE and SQL Express. I think you might be confused with 32 nested stored procedures, which means that stored procedure A can call sp B which can call sp C, etc 32 levels deep.

Monday, March 12, 2012

How make Query Analyzer remember to be maximized?

First, if this isn't the appropriate group for this type of question,
please let me know which one is.
I'm running SQL 2000. When I start Query Analyzer, it always bring up
the query window in a non-maximized state, even though I always maximize
it each time. Is there any way to make QA remember that I want the
window to start up maximized? I know it isn't the biggest deal in the
world, but it's an irritation. Thanks for any help. p
** Posted from http://www.teranews.com **"Rav" wrote:
> First, if this isn't the appropriate group for this type of question,
> please let me know which one is.
> I'm running SQL 2000. When I start Query Analyzer, it always bring up
> the query window in a non-maximized state, even though I always maximize
> it each time. Is there any way to make QA remember that I want the
> window to start up maximized? I know it isn't the biggest deal in the
> world, but it's an irritation. Thanks for any help. p
> ** Posted from http://www.teranews.com **
>
Hi Rav
On my system (XP sp2) it will open in the same state as it was last closed.
If you always want to start a program maximized you can change the
properties on the start menu. Right clcik the Query Analyser and you will get
the properties dialog, change to the shortcut tab and you will see the run
option which has the options of "Normal window", "Maximized" or "Minimized".
Choose "Maximized" to always start as maximized.
John|||I don't think there's a way you can do to maximize Query Window everytime
you open QA.
--
Ekrem Önsoy
"Rav" <PaulR@.cais.com> wrote in message
news:ee0c8$480e048a$26520@.news.teranews.com...
> First, if this isn't the appropriate group for this type of question,
> please let me know which one is.
> I'm running SQL 2000. When I start Query Analyzer, it always bring up the
> query window in a non-maximized state, even though I always maximize it
> each time. Is there any way to make QA remember that I want the window to
> start up maximized? I know it isn't the biggest deal in the world, but
> it's an irritation. Thanks for any help. p
> ** Posted from http://www.teranews.com **|||Hi John,
I think OP asks for the Query Window in the QA, not the Query Analyzer
itself. You know, the Query Window always opens in a not maximized state.
But if you close the QA as maximized then when you open it again it opens
maximized... But the Query Window does not. This must be the one which
bothers the OP =)
--
Ekrem Ã?nsoy
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:AF2788B2-BC2A-411D-A75B-AEB91C60860F@.microsoft.com...
> "Rav" wrote:
>> First, if this isn't the appropriate group for this type of question,
>> please let me know which one is.
>> I'm running SQL 2000. When I start Query Analyzer, it always bring up
>> the query window in a non-maximized state, even though I always maximize
>> it each time. Is there any way to make QA remember that I want the
>> window to start up maximized? I know it isn't the biggest deal in the
>> world, but it's an irritation. Thanks for any help. p
>> ** Posted from http://www.teranews.com **
> Hi Rav
> On my system (XP sp2) it will open in the same state as it was last
> closed.
> If you always want to start a program maximized you can change the
> properties on the start menu. Right clcik the Query Analyser and you will
> get
> the properties dialog, change to the shortcut tab and you will see the run
> option which has the options of "Normal window", "Maximized" or
> "Minimized".
> Choose "Maximized" to always start as maximized.
> John|||Ekrem Ã?nsoy wrote:
> Hi John,
> I think OP asks for the Query Window in the QA, not the Query Analyzer
> itself. You know, the Query Window always opens in a not maximized
> state. But if you close the QA as maximized then when you open it again
> it opens maximized... But the Query Window does not. This must be the
> one which bothers the OP =)
>
Correct, Ekrem. The Query Analyzer window opens maximized just fine.
It's the initial Query window contained with that that doesn't remember
to open maximized. I saw your separate message saying that you don't
think there's a way to maximize the Query window each time I open QA.
Oh well. Thanks for the response (and to John also). p
.
** Posted from http://www.teranews.com **