did you check in EM configuration of the error logs to make sure the number of logs history isnt set to 0

use the rollup option on the group by statement

sorry here is the whole procedure

CREATE PROCEDURE sp_diskspace

AS

/*

Displays the free space,free space percentage

plus total drive size for a server

*/

SET NOCOUNT ON

DECLARE @hr...

i just call this on all the servers

DECLARE @hr int

DECLARE @fso int

DECLARE @drive varchar(30)

DECLARE @odrive int

DECLARE @TotalSize varchar(20)

DECLARE @freespace varchar(20)

DECLARE @MB bigint ; SET @MB = 1048576

CREATE TABLE...

hash aggreate is taking 28% on the second plan

and 0 the fast one

what indexes are on the file

I can see a need for this

but 2008 rendition has too much overhead

since there isnt going to be a sql2005 sp3

sql2008 is actually that, so we arent upgrading to sql2008 from sql2005

but it there is a new server purchase it will probably...

this if fine for views and sp's but

if you change an object

drop a field or drop a table

change foriegn keys this isnt going to be friendly

yes when you are selecting tables in the replication plan it asks you if you want to setup a filter

name <> 'name1' and age<> 25

if name <> 'name1' or age<> 25

then you would get all the records back

not just the 3

use the sp_help_revlogin 'scott'

so you get the same sid

otherwise

every time you restore a database you will have to run the

sp_change_users_login 'report'

or sp_change_users_login 'auto_fix','scott'

sql2008 is sql2005 sp3

FAST number_rows

Specifies that the query is optimized for fast retrieval of the first number_rows. This is a nonnegative integer. After the first number_rows are returned, the query continues execution and...

You could just create it in master and when you run it use:

EXEC [sqlserver].master.dbo.rr_Get_ForeignKeyTables @TableName = 'ttt', @DB = 'ddd'

if you have set up a linked server