Re: dt_verstampxxx

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 01/07/05 

Date: Fri, 7 Jan 2005 08:12:00 -0600

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.

Relevant Pages

  • Re: full-text contains * issue
    ... You may also want to consider using a stored proc for this situation as it ... EXEC usp_FTSearchPubsInfo '' ... > no data but was concatenation of the fields I wanted to index. ... > This is the SQL ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Create table and drop table owner defaults
    ... But the simple way is thru dynamic SQL. ... EXEC @sql; ... When I have the Create table in a Stored proc, the default user is the userid of the person logged in but when I go to drop the table, it defaults to dbo. ...
    (microsoft.public.sqlserver.programming)
  • RE: Trouble connecting user with MS Access adp to SQL Server 2000
    ... It sounds like JT or the group "Power users" was never added as a SQL ... Execute this statement as a stored proc for SQL. ... Exec sp_grantlogin ...
    (microsoft.public.sqlserver.security)
  • Re: Full text catalog just not populating
    ... exec sp_defaultdb N'NT Authority\System', N'master' ... means either the network guys in my company who don't know SQL but are admins ... > needs this login to log into SQL Server and you can either add back this ... >> fetching U ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Inserting/deleting data in table in multiuser environment
    ... Add a field to the table in the SQL DB? ... Capture the value to a variable before you send it to the stored proc, ... I did create a table in a front-end to just copy data from that table on SQL ... the stored procedure will be running each time with report generation anyway. ...
    (microsoft.public.access.modulesdaovba)