Viewing 10 posts - 3,211 through 3,221 (of 3,221 total)
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...
June 10, 2004 at 7:35 pm
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...
June 9, 2004 at 5:04 pm
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...
May 26, 2004 at 5:52 am
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...
April 10, 2004 at 5:11 pm
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"...
March 14, 2004 at 7:25 pm
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...
March 13, 2004 at 9:39 pm
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...
March 12, 2004 at 6:00 am
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)...
March 12, 2004 at 4:46 am
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...
February 25, 2004 at 7:16 am
Here is what you may need - directly from sqlserver central web site ....
------------------------------------------------------------------------
-- Name : CreateDBREINDEX.sql
-- Author : Jeff Weisbecker October 1, 2003
-- RDBMS : SQL Server...
February 17, 2004 at 7:30 am
Viewing 10 posts - 3,211 through 3,221 (of 3,221 total)