Create and manage databases and their related components, maintain, and use stored procedures,

rafaelmunoz2
rafaelmunoz2 used Ask the Experts™
on
How do I automate and use special monitoring to perform on database used for a website? I am using MS SQL and I have to complete a project and take shoots of my steps. Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Which version of SQL Server?

Author

Commented:
SQL EXPRESS EDITION

Commented:
SQLExpress does not have the ability to run jobs, which is what is used to automate and monitor tasks in SQL Server).

What is the exact wording for the assignment?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
The exact wording is;

"Describe what maintenance tools and functions are available in SQL Server 2005.

What special monitoring should you perform on a database used for a website and why? Are there ways you can automate this type of monitoring?"

But I have to actually perform this in after a discussion. I have SQL Express, what should I do to get this done? Can it be perform with what I have now?

Author

Commented:
Ok, I see, sorry, I am getting the picture now. Thanks for your time and help...

Commented:
Cool. Glad I could help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial