asked on
Create and manage databases and their related components, maintain, and use stored procedures,
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
Microsoft SQL Server 2005Microsoft SQL Server
Last Comment
ptjcb
Which version of SQL Server?
ASKER
SQL EXPRESS EDITION
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?
What is the exact wording for the assignment?
ASKER
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?
"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?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Ok, I see, sorry, I am getting the picture now. Thanks for your time and help...
Cool. Glad I could help.