dt_verstampxxx

What is this stored proc used for? It returns version iunformation and has
public permissions. We are looking to remove all public perms where possible.
When I run the following on by SQL 2000 system:
USE pubs
EXEC sp_helptext 'dt_verstamp007'
GO
The result is:
/*
** This procedure returns the version number of the stored
** procedures used by the the Microsoft Visual Database Tools.
** Version is 7.0.05.
*/
create procedure dbo.dt_verstamp007
as
select 7005
Hope this helps.
Dan Guzman
SQL Server MVP
"Jeff Ericson" <JeffEricson@.discussions.microsoft.com> wrote in message
news:66B7E3A3-6D0D-4268-99B3-9D41659E747F@.microsoft.com...
> What is this stored proc used for? It returns version iunformation and
> has
> public permissions. We are looking to remove all public perms where
> possible.

dt_verstampxxx

What is this stored proc used for? It returns version iunformation and has
public permissions. We are looking to remove all public perms where possible.When I run the following on by SQL 2000 system:
USE pubs
EXEC sp_helptext 'dt_verstamp007'
GO
The result is:
/*
** This procedure returns the version number of the stored
** procedures used by the the Microsoft Visual Database Tools.
** Version is 7.0.05.
*/
create procedure dbo.dt_verstamp007
as
select 7005
Hope this helps.
Dan Guzman
SQL Server MVP
"Jeff Ericson" <JeffEricson@.discussions.microsoft.com> wrote in message
news:66B7E3A3-6D0D-4268-99B3-9D41659E747F@.microsoft.com...
> What is this stored proc used for? It returns version iunformation and
> has
> public permissions. We are looking to remove all public perms where
> possible.

dt_verstampxxx

What is this stored proc used for? It returns version iunformation and has
public permissions. We are looking to remove all public perms where possibl
e.When I run the following on by SQL 2000 system:
USE pubs
EXEC sp_helptext 'dt_verstamp007'
GO
The result is:
/*
** This procedure returns the version number of the stored
** procedures used by the the Microsoft Visual Database Tools.
** Version is 7.0.05.
*/
create procedure dbo.dt_verstamp007
as
select 7005
Hope this helps.
Dan Guzman
SQL Server MVP
"Jeff Ericson" <JeffEricson@.discussions.microsoft.com> wrote in message
news:66B7E3A3-6D0D-4268-99B3-9D41659E747F@.microsoft.com...
> What is this stored proc used for? It returns version iunformation and
> has
> public permissions. We are looking to remove all public perms where
> possible.

dt_ procs and the public role

In a SQL 2k instance (latest SP) some of my user databases show the public role with execute on a variety of stored procs named dt_* (i.e. dt_addtosourcecontrol). However, not all the user databases do this, some do not grant the public role execute on these procs .

So, can someone explain what generates these permissions and is it acceptable to remove them? If I have a database that does not grant public access, should I be concerned? I don't see any reference to these procs in BOL.

TIA,

Moblex

This seems to be a Visual Studio generated procedure, so you should ask this question on a Visual Studio forum. Here's a related thread

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=562892&SiteID=17

that I found with the following search query:

http://search.live.com/results.aspx?q=dt_addtosourcecontrol&mkt=en-us&FORM=LVSP&go.x=10&go.y=13

Thanks
Laurentiu