you are in aright track.

But it would be better if you take differential every one hour and and set up clean up task to delete old differential backups so that...

As far as I know there is no revert or rollback operation for the SP's

The only thing is the old backup and restore along with the system databases.

Every time...

Enable logging in advanced options you can click text or flat file thats it.

here is the link

http://www.mssqltips.com/tip.asp?tip=1755

Change data capture--excellent feature in sql server 2008

what is the schema of your SP its not sys. right.

if you give the name with sys. spname it creates in system store proc.

Give the user sysadmin role who is executing that SP should solve your problem.

Change the schedule because if there is parallel things running that might be stopping

It happen to me the same thing and I changed the schedule it worked fine.

If you are selecting a column column and it have an index then you should use the same column in the where clause. then only it uses the index.

Don't use the dbcc commands unless you really need to

Thats going to change your plan every time.

Run through sp_executesql and don't do the dbcc freeproccache and rerun it takes...

I changed the MAXDOP setting to 1 that resolved CXPACKET waits this also brought my cpu down to normal.

Added a new data file to avoid the the pagelatch_up waits.

Tuned store...

Hi Parti,

My best suggestion in that case just use the import/expoert wizard f you are using sql 2005 and above.

Select the file path --> map columns--> check datatypes-->finish

Go simple!

I...

My best preference for e-mail is use the below query and set this as a job in execute t-sql maintainance plan tasks, so you have job logging and results...

If you right click on the store proc --> properties, under programmability.

See for exec as to check user or sql agent atleast then run the trace

I think...

It should be in tools tab in SSMStudio.

Look for it or turn on your activity monitor and right click on any SPID click trace it opens profiler aoutomatically.

SELECT c.Email

FROM AAService.dbo.Customers c WITH (NOLOCK)

group by c.Email having ...