Does the user who runs this ahve access to all the base tables / views / functions used by this dynamic query?

You can ask for as many clarifications as you want in the same tread.  This will keep us from having 10 conversations going at the same time!

Please do not cross-post.  I already tried to answer that question here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=323014

You forgot to drop the table #fraglist at the end of the script.  Also you don't insert anything in it so no work will be done... ever!

That doesn't work for me :

USE Documentation

exec sp_MSforeachtable 'DBCC INDEXDEFRAG (''Documentation'',''?'')'

INDEXDEFRAG requires 3 parameters... (index id or name is the missing parameter here).

And since there is not for each...

--FU means for update .

CREATE TRIGGER tr_temp_FU_updateTime ON [dbo].[temp]

FOR UPDATE

AS

SET NOCOUNT ON

UPDATE T

SET [Time of Update] = getdate()

FROM dob.Temp T inner join Inserted...

Ya that can't work... you must specify the index name or id for that command!

Looks like you'll have to fix you script.

Yes it does... try it on a test table and click generate script. 

See all the trouble it has to go through???

That's because I don't get enough sleep !

1 : Take full backup of the db (or at least that table >> bcp to text file and zip).

2 :

SET ROWCOUNT 10000

DECLARE @rc AS INT

SET @rc = 1

WHILE...

Let me ask you this.  How do you plan to restore the master DB if you don't have a full backup?

That's been asked before... many times.  And I for one who reads 1500K+ posts per month.  I would greatly appreciate that feature.  Also this is something that is already implemented...

Good idea... just have a test run on a test server to make sure this doesn't slow the production to a crawl... or run at night when noone uses the...

Totally with you on this one .

It should be in a separate procedure that only selects the data.

Don't take this personnally, but have you had any programming training at all *this will help me better answer...