How about if you attach the Query Result instead of sending direcly to Email message..

Or if you have any SQL Server 2005 Server from wher u can send the...

Micheal

I guess COALESCE works backward , as i test too .

Good finding , i usaully overlook this point before while using COALESCE function.

Cheers

I am providing you a sample Trigger that i guess will help you

CREATE TRIGGER [dbo].[utr_AUDIT_UPDATE_tablename]

ON [dbo].[tablename]

AFTER INSERT,UPDATE AS

DECLARE @user-id varchar(20),

@AppID varchar(50),

@OldValue varchar(50),

...

I can see one possiblility of releasing space while rebuilding indexes if there is some updtion(deletion) happen and data pages have free space or while rebuiling indexes fill factor is...

If you already have Default instance then install new instance as named instance .

Can you check whether user that execute SSIS packagee and database mail procedure is member of DatabaseMailUserRole (Database Role) in MSDB database. if not just add the user and try...

By Default Tempdb's size when Server starts is same as of Model database , but you can change as per your need to any amount but not less than the...

Snapshot is useful when the Database is not big and you need some database or few tables in database for reporting perpose this is one of typical use of snapshot....

Can you try a shot to execute XP_cmdshell alone like

Exec xp_cmdshell 'dir c:\' to verify whether it's Problem from this SP's Permissions or SSIS Permissions for User. Have you...

Snapshot Agent will send all the tables, SP etc taken in Publication daily and override the existing data at Subscriber , So as per your Question snapshot will not send...

There are 2 viable methods

1. BCP , if ur file is at different server and u can access this file on ur ur server then u can use UNC...

How did you created databases , using script or from EM .

Try to segregate IF (UPDATE(DDELIVERED) OR UPDATE(DMOVEIN) OR UPDATE(DMOVEOUT)) to 3 IF conditions , as i have same kind of triggers in my environment where i use different IF...

Thanks George

It's not possible to upgrade to 2005 as company want to wait and then plan to upgrade to 2008 and also most applications works on SQL Server Authentication...

Thanks a lot Sophead.

I think u were talking about -T3608 Switch .

Really appriciate your reply.