Viewing 15 posts - 11,176 through 11,190 (of 18,923 total)
Does the user who runs this ahve access to all the base tables / views / functions used by this dynamic query?
November 15, 2006 at 8:38 am
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!
November 15, 2006 at 8:35 am
Please do not cross-post. I already tried to answer that question here :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=323014
November 15, 2006 at 8:26 am
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!
November 15, 2006 at 8:24 am
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...
November 15, 2006 at 8:13 am
--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...
November 15, 2006 at 8:01 am
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.
November 15, 2006 at 7:57 am
Yes it does... try it on a test table and click generate script.
See all the trouble it has to go through???
November 15, 2006 at 7:45 am
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...
November 15, 2006 at 7:32 am
Let me ask you this. How do you plan to restore the master DB if you don't have a full backup?
November 15, 2006 at 7:25 am
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...
November 15, 2006 at 7:20 am
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...
November 15, 2006 at 7:12 am
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...
November 15, 2006 at 7:10 am
Viewing 15 posts - 11,176 through 11,190 (of 18,923 total)