I forgot to ask about the statistics- How should I update the current month filegroup ' FG_MSG' statistics? Do you have the script for that as well? Thanks

Thanks a bunch! I will try this and let you know how it works-

Part of the filegroup name.

Thanks for the script, but it did not point to the current month. How do you only run on current month?

Yes, that will be first option. My main concern is on view that how should I automate the view process. Instead of adding a new table in view manually, I...

PHEW- Ok

1. Import the table [message]from server a to server b

--Trying to get [server a].[message table] DATA via ssis package to [server b]. [message table]

2. If the job takes more...

Thanks guys for the response. Ok the logic behind this process is the import job ususally takes 5 seconds to finish, but some times this job can take 15 to...

I am sorry if you are confused with the steps. Let's go with your first suggested question-

How to end a script after 20 seconds?

Thanks!

The page is invalid, can't access.

I do send the attachment all the time using the following script-

----(you need to configure the db mail and create a profile)

EXEC msdb.dbo.sp_send_dbmail

...

Thanks. I will try doing that. But look at this site and advise me. I am confused where to start- There are no steps.

http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm

Thanks, but can we alter without rebuilding it?

Yeah like server side tracing. I want to create a job which runs in perticular time to trace the activity.

my manager is adamant to setting up a size for the datafile.

Can anyone please send me the script to set up the size for data file. He wants the auto...