Anyone here familiar with stored procedures?

Hi there! I would like to return a default status value (-101) if the -100 and 200 conditions are not met. Is there any way I can go about it?

ALTER PROCEDURE spServiceFormGet (@.TicketNo int, @.Name char(50))
AS
IF NOT EXISTS (SELECT SolutionID FROM ServiceForm where SolutionID = @.TicketNo)
RETURN -100
IF EXISTS (SELECT SolutionID, SolvedBy FROM ServiceForm
WHERE SolutionID = @.TicketNo AND SolvedBy LIKE @.Name
OR SolutionID = @.TicketNo AND SolvedBy IS NULL)
SELECT * FROM serviceform where SolutionID=@.TicketNo
RETURN 200
ELSE <-- something like that
RETURN -101 <-- something like that

Thanks,
-Gabian-Gabian,
Do a google search on MSSQL Output Variables.

You should return a @.outputStatus variable here.

ScAndal|||I am not sure I understand what a return code is buying you in this case - Is there more to the proc than you are posting?

If there is no solutionid matching the ticket (first test) than you know there will be no solutionid matching a ticket AND a name...

Why not just execute the select with the (ticketid, name) filter and interogate the result set for records. If the count = 0 - you know there are no solutionid's matching this ticketno and/or name ??|||Thanks for answering guys, I've got it!

-Gabian-sql

Anyone have sp_oacreate and SQL2005 issues?

We use a few in house built COM objects that we call from stored procedures
quite often during the day. They are called from linked servers - so all
COM stuff is run on a dedicated box. Both servers are running SQL 2005 SP2.
The server that does all the COM object (sp_oacreate) work will lockup on a
daily basis and we have to restart sql service to fix. Also, we see SPIDs
on the COM box stuck in Rollback status and have to restart SQL to fix. Has
anyone seen any of these issues while migrating to SQL 2005?
Thanks,
Chuck Lathrope
www.sqlwebpedia.comChuck,
This is what you mean: - http://support.microsoft.com/kb/937277/en-us
which talks about sp_OAMethod not sp_OACreate.
Chris
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:120gcwua7do0w$.106toy5xoolnq.dlg@.40tude.net...
> We use a few in house built COM objects that we call from stored
> procedures
> quite often during the day. They are called from linked servers - so all
> COM stuff is run on a dedicated box. Both servers are running SQL 2005
> SP2.
> The server that does all the COM object (sp_oacreate) work will lockup on
> a
> daily basis and we have to restart sql service to fix. Also, we see SPIDs
> on the COM box stuck in Rollback status and have to restart SQL to fix.
> Has
> anyone seen any of these issues while migrating to SQL 2005?
> Thanks,
> Chuck Lathrope
> www.sqlwebpedia.com|||On Thu, 19 Jul 2007 13:02:00 -0600, Chris Wood wrote:
> http://support.microsoft.com/kb/937277/en-us
That looks very promising! I have been searching net on sp_oacreate and
never saw this. Thanks. I will ask my PSS engineer if I can get the hotfix.
-Chuck|||Hi Chuck,
Since you are on SP2, i doubt this hotfix will help you, as the SP2
build is 3042, and the above issue is fixed in 2232
HTH,
Dinesh

any way to debug stored procedures without buying visual studio?

Hi.

I am under the understanding that having the sql server 2005 db is not
enough (like 2000 was) to debug stored procedures.. that I need to
purchase (costly) visual studio 2005.

Can someone suggest a free or lower cost alternative?

sorry to be so cheap.. its the times I think.Jeff Kish (kishjjrjj@.charter.net) writes:

Quote:

Originally Posted by

I am under the understanding that having the sql server 2005 db is not
enough (like 2000 was) to debug stored procedures.. that I need to
purchase (costly) visual studio 2005.
>
Can someone suggest a free or lower cost alternative?
>
sorry to be so cheap.. its the times I think.

PRINT and SELECT is what I use, even in SQL 2000. I used to use the
T-SQL debugger occasionally, but I gave up on it. There were so many stars
that had to be aligned for it to work.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Feb 2, 3:18 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

Jeff Kish (kishjj...@.charter.net) writes:

Quote:

Originally Posted by

I am under the understanding that having the sql server 2005 db is not
enough (like 2000 was) to debug stored procedures.. that I need to
purchase (costly) visual studio 2005.

>

Quote:

Originally Posted by

Can someone suggest a free or lower cost alternative?

>

Quote:

Originally Posted by

sorry to be so cheap.. its the times I think.

>
PRINT and SELECT is what I use, even in SQL 2000. I used to use the
T-SQL debugger occasionally, but I gave up on it. There were so many stars
that had to be aligned for it to work.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

~
T-Sql debugger is some what okay, I used very long back.
I'm very comfortable with Print and Select commands to debug a stored
procedure.

~NR|||On Fri, 2 Feb 2007 10:18:24 +0000 (UTC), Erland Sommarskog
<esquel@.sommarskog.sewrote:

Quote:

Originally Posted by

>Jeff Kish (kishjjrjj@.charter.net) writes:

Quote:

Originally Posted by

>I am under the understanding that having the sql server 2005 db is not
>enough (like 2000 was) to debug stored procedures.. that I need to
>purchase (costly) visual studio 2005.
>>
>Can someone suggest a free or lower cost alternative?
>>
>sorry to be so cheap.. its the times I think.

>
>PRINT and SELECT is what I use, even in SQL 2000. I used to use the
>T-SQL debugger occasionally, but I gave up on it. There were so many stars
>that had to be aligned for it to work.

Thanks. I'll give it a try.
The debugger had been fairly nice to use when I had triggers and sp's
to debug.

I assume that it is a simple matter to invoke the procedure (I know
how to compile it) to get things to run?

Regards,
Jeff|||Jeff Kish (kishjjrjj@.charter.net) writes:

Quote:

Originally Posted by

The debugger had been fairly nice to use when I had triggers and sp's
to debug.
>
I assume that it is a simple matter to invoke the procedure (I know
how to compile it) to get things to run?

Not sure that I understand the question, just run it from Query Analyzer.

Triggers are a good point for the debugger. If you are not aware of that
there is a trigger, the debugger can make you aware, if you stick to F11.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Any way logging or tracking method for dropped tables

Most of my tables is dropped after they are created. I cannot tell when this
happen. This include stored procedures as well. I checked the maintenance job
and none are dropping tables or stored procedures.
The funny part is my tables and stored procedure which is published out as
articles remain and not dropped as others. Why?
Is there any logs or tracking that can be put in place to find out who
deleted my tables?
Paul,
I'm using SQL Server 2000 so I guess I would need to use the log explorer
tool. Are there any recommendation which I can try first?
Another question which hopefully can narrow down my suspect here is..Do you
think replication dropped the tables?
Cheers,
Philip
"Paul Ibison" wrote:

> If you're on SQL Server 2005 you could set up ddl triggers to log who/what
> is performing the drops. Alternatively a 3rd party log explorer tool will
> have the info in it.
> HTH,
> Paul Ibison
>
>
|||Replication by default will drop tables on the subscriber, but never on the
publisher so i'd look elsewhere. The reason replicated objects haven't been
dropped is probably because once they're published, they have to be removed
from the publication to be allowed to be dropped, so that distinguishes them
from your other objects. (this is a bit of guesswork, but it makes sense).
Lumigent Log Explorer will audit DDL commands to help you figure out who did
the drop (http://lumigent.com/products/le_sql_faq.html#_I_do_not). If it
happens regularly then you could use profiler yourself to monitor for these
drops.
HTH,
Paul Ibison

Any stored procedures to check a database's free space and its allocated space ?

Can anybody tell me are there are stored procedures or system tables show me
:
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
Thanks.cpchan
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
INSERT into Drivetable Exec xp_fixeddrives
SELECT * FROM DriveTable
2) sp_helpdb 'pubs'
3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Hi,
For database execute the below procedure with out parameter,
sp_spaceused
For transaction log ,
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#XViSBr$DHA.3184@.TK2MSFTNGP09.phx.gbl...
> cpchan
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> 1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
> INSERT into Drivetable Exec xp_fixeddrives
> SELECT * FROM DriveTable
> 2) sp_helpdb 'pubs'
> 3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
show
> me
>|||Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#Rs09Fr$DHA.2448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> For database execute the below procedure with out parameter,
> sp_spaceused
> For transaction log ,
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> MCDBA
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
show
> me
>

Any stored procedures to check a database's free space and its allocated space ?

Can anybody tell me are there are stored procedures or system tables show me
:
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
Thanks.cpchan
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
INSERT into Drivetable Exec xp_fixeddrives
SELECT * FROM DriveTable
2) sp_helpdb 'pubs'
3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Hi,
For database execute the below procedure with out parameter,
sp_spaceused
For transaction log ,
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#XViSBr$DHA.3184@.TK2MSFTNGP09.phx.gbl...
> cpchan
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> 1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
> INSERT into Drivetable Exec xp_fixeddrives
> SELECT * FROM DriveTable
> 2) sp_helpdb 'pubs'
> 3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
> > Can anybody tell me are there are stored procedures or system tables
show
> me
> > :
> >
> > (1)The hard disk space allocated to a database.
> > (2)The hard disk space used on a database
> > (3)The hard disk space allocated to a database's transaction log
> > (4)The hard disk space used on a database's transaction log
> >
> > Thanks.
> >
> >
> >
>|||Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#Rs09Fr$DHA.2448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> For database execute the below procedure with out parameter,
> sp_spaceused
> For transaction log ,
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> MCDBA
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
> > Can anybody tell me are there are stored procedures or system tables
show
> me
> > :
> >
> > (1)The hard disk space allocated to a database.
> > (2)The hard disk space used on a database
> > (3)The hard disk space allocated to a database's transaction log
> > (4)The hard disk space used on a database's transaction log
> >
> > Thanks.
> >
> >
> >
>

Any resources about Stored Procedures & Scope Identity?

i am a beginner looking for such resources, MSDN is one but can be a little difficult to understand

For general and extensive information go tohttp://www.sqlservercentral.com/

However, if you have a specific problem or question, post it here and someone will know the answer.

Kind regards

Scotty

|||

Books On Line (free download) from MS is the best resource.

|||There are some good stored procedure tutorials athttp://www.codeproject.com/database/hkstoredproc.asp (Everything you wanted to know about Stored Procedures)

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 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 idea what the purpose of this SPROC might be? (no prizes, sorry!)

I've been asked to document an application and I'm going through all
the Stored Procedures and trying to work out what they're supposed to
do.

Can anyone give me an idea of what the Stored Procedure
wsBookingListsGetAll below is trying to achieve? Is it incomplete? I
can't see any reason to pass in the Parameter, and what is the UNION
SELECT 0 all about?

Many thanks

Edward

CREATE Procedure wsBookingListsGetAll
@.DebtorIDvarchar(15)
As
set nocount on

SELECT
fldBookingListID
FROM
tblWsBookingList
UNION
SELECT 0

return

GO

/* Table def */
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[tblWSBookingList]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[tblWSBookingList]
GO

CREATE TABLE [dbo].[tblWSBookingList] (
[fldDebtorID] [char] (15) COLLATE Latin1_General_CI_AS NOT NULL ,
[fldBookingName] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL
,
[fldAddressCode] [char] (15) COLLATE Latin1_General_CI_AS NOT NULL ,
[fldEmail] [varchar] (250) COLLATE Latin1_General_CI_AS NOT NULL ,
[fldFirstName] [varchar] (100) COLLATE Latin1_General_CI_AS NOT NULL ,
[fldLastName] [varchar] (100) COLLATE Latin1_General_CI_AS NOT NULL ,
[fldBookingListID] [int] IDENTITY (1, 1) NOT NULL ,
[fldInvoiceNumber] [varchar] (15) COLLATE Latin1_General_CI_AS NULL ,
[fldPayeeID] [char] (15) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]
GOHi Edward,

It is obvious the SP is returning list of booking list ids. Maybe there are
two scenarios:

1). Incomplete: The SP parameter was intended to filter the list by debtor
id but the code was never completed.
2). Obsolete: In the past the parameter was used properly in the SP but
something required to return the full list all the time and the condition
was dropped from the SQL code. Since the parameter may be passed from the
client application, the developer did not bother to change properly the
client code to drop the parameter, but rather did the change only in the SQL
code and did not comment the change.

As for the union with SELECT 0 it seems like the return list required a
placeholder for some special value (maybe in the client application the list
needs to show "Not Selected" which will be mapped to the 0 value).

Probably the best would be to look at the places where this SP is called and
that will help you to figure out the reasons.

Regards,

Plamen Ratchev
http://www.SQLStudio.com

Any IDE for developing Soterd Procedures and User Defined Functions

hi there:
I wonder is there any IDEs for developing Stored procedures and
probably user defined functions.
I heard about a few, but not for MS SQL server 2k so far,
I would really aprecaite the help
Regards
Andrea
Hi Andrea,
what do you mean by IDE ? QA is a great IDE to do your coding,
furtheron having Intellisense support within (from www.promptsql.com)
makes you IMHO very productive.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de

Any IDE for developing Soterd Procedures and User Defined Functions

hi there:
I wonder is there any IDEs for developing Stored procedures and
probably user defined functions.
I heard about a few, but not for MS SQL server 2k so far,
I would really aprecaite the help
Regards
AndreaHi Andrea,
what do you mean by IDE ? QA is a great IDE to do your coding,
furtheron having Intellisense support within (from www.promptsql.com)
makes you IMHO very productive.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
--

Any IDE for developing Soterd Procedures and User Defined Functions

hi there:
I wonder is there any IDEs for developing Stored procedures and
probably user defined functions.
I heard about a few, but not for MS SQL server 2k so far,
I would really aprecaite the help
Regards
AndreaHi Andrea,
what do you mean by IDE ? QA is a great IDE to do your coding,
furtheron having Intellisense support within (from www.promptsql.com)
makes you IMHO very productive.
HTH, jens Suessmeyer.
--
http://www.sqlserver2005.de
--

Any hierarchical functionatility in Management Studio in 2005

I am thinking, if there is the functionality that can hierachically group the tables, views, and stored procedures into different sections within each database, it will be much clearer and logical for maintain the database objects.

For example, to create containers in the console tree of Management Studio or Enterprise Manager, or even apply the namespace/subnamespace features to the tables/views/stored procedures of each database.

A clearer explanation:

Inside each database, all the tables, stored procedure and views are at the same level, if new folders/containers can be created to segmen all these database objects into different groups, it will be much more clear.

An even advanced feature is to apply namespace concept to the database objects, so that it will truly hierachical besides the appearnce in the console tree.

|||

This probably isn't exactly what you're looking for, but ...

You can use SCHEMAs to put tables, procedures, types, etc. into separate namespaces.

From SSMS, you can

Create a new schema from the "Database/Security/Schemas" node in Object Explorer|||

This functionality does not currently exist. You can submit this suggestion through https://connect.microsoft.com/SQLServer.

Cheers,

Dan