Not as the script stands.

sp_spaceused has an @updateusage parameter and to use that you either need to be the dbo or in the sysadmin role.

I've not used it here so...

The only way I can think of doing it would be to save the DTS package rather than use the "Run Immediately" option.  You could then edit the CREATE TABLE...

CREATE TABLE #TableSize(

 TableName SysName,

 NumOfRows Int ,

 Reserved VARCHAR(10),

 Data VARCHAR(10),

 IndexSize VARCHAR(10),

 Unused VARCHAR(10)

)

DECLARE @sNextTable SysName

SET @sNextTable=''

WHILE @sNextTable IS NOT NULL

 BEGIN

  SELECT @sNextTable = MIN(Name)

  FROM dbo.SysObjects

  WHERE Type='U'

  AND Name > @sNextTable

  IF @sNextTable IS NOT NULL

   INSERT...

Are the apps all accessed via a browser?  Could you put a block on all access attempts that don't originate from the web server or IT computers?

If the apps connect via...

Provided your index statistics are up-to-date and you have a primary key and/or clustered index on your table then the following query is the quickest way of getting a row...

Check the table and indexes.

If you don't use double-byte characters then replace an NVARCHAR, NCHAR, NTEXT columns with VARCHAR, CHAR, TEXT equivalents.

If you have these columns then not only will...

SELECT *

FROM t

WHERE CONVERT(CHAR(6),t.testdate,112) < CONVERT(CHAR(6),getdate(),112)

I would say I agree with 45%-50% of what is in this article.

For example, I wouldn't create scripts that use the fully qualified object name i.e. database.owner.object because that means...

I work with a variety of web CMSs and one of the things they share in common is a config file that allows me to switch their own internal logging...

I have got to ask what "Quand on parle du loup, on en voit la queue " means.

My French was limited to asking for bread and milk so I seem...

I seem to remember a configuration setting that sets the maximum query cost.

I'm at home at the moment so don't have access to BOL or a server to tell you...

I'm a self taught Visual C++ programmer.

I have never managed to get any of the example xp sources to compile and I believe it is down to the configuration of...

There is the job title on you contract of employment and the job title you use on your CV  I could argue that my...

I have a friend whose boss had three teenage daughters.

The stories the boss told about their antics traumatised my friend to the state that when the midwife said "it's a...

As Steve says, titles are just handy lables to hang on people however to my way of thinking there is a difference between a role that is described as analyst...