This query should return to you the name of the table and the query name:

You might want to create a cursor using:

SELECT so.name, sob.name as 'Stored Procedure name' FROM sysobjects...

Sounds enticing, but and it is a BIG BUT:

a.  your site does not have a privacy statement

b.  does not state what the user is downloading - is it a...

Try this one and determine if it answers your question

(copied from a previous post by some one whose name I am sorry to say I have forgotten to that person...

First in my proc each column in the table that I want to select I have named as Mx where x is either 1,2,3,4,5 - for example M6.

Then created this stored...

Use Books on Line (BOL) - it is the help file when clicking help for Query Analyzer - look up "Setting Data Base Options" then scroll down to "Quoted Identifier"...

greene

try this

--insert into TableName (db, fileID, filesize)

Use Master

 exec sp_MSforeachdb @command1 =

  "select db_name(dbid), sf.fileid, sf.size

  from sysdatabases sd, ?..sysfiles sf

  where db_name(dbid) = '?' "

Note the differences...

Would check database and LOG file sizes periodically and use the following proc to learn what individual tables are doing i.e, what size each table is using within the data...

Within Windows NT4, Windows 2000 in fact even in Windows 95 & 98 (they also exist in dot net but for the life of me can not recall their namespace)...

Did a default install of MSDE on local machine and default install of SQL 2000 on a network server.  Default = accepting all of MS setting for all variables and...

Here is what you may need - directly from sqlserver central web site ....

------------------------------------------------------------------------

--  Name   :  CreateDBREINDEX.sql 

--  Author :  Jeff Weisbecker  October 1, 2003

--  RDBMS  :  SQL Server...