Generally once a week is sufficient. Also you may want to script out ur logins whenever u create/delete/modify any login;...

i dont think i understand ur last post properly but what is the error u're getting in creating a maintainance plan for backup? or writing a plain job with backup...

LOL:-D. Glad u got it going finally.

Check Paul Randall's blog on sqlskills.com, microsoft blog and other places including this site. there must be something related there. May be he or Gail or other experts can help...

txdave35 (6/16/2009)

---

Surely, there has got to be a way to do this. We have added new databases to our SQL server, and they want me to add these databases...

can u post the full query? coz i cant find the table name in your query.

see if this can be of some help!!

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

case when salary >= 10000 and salary < 20000 then count(employeeid)

you need to change this everywhere.

cant find exact details but may be you can club details from the technet sites and present it to users.

http://technet.microsoft.com/en-us/library/cc966418.aspx

There are few more technical papers there which might help.

I dont have sample data so cant test for logical accuracy. but the below code runs fine.

Select Emp.name,Count (ManagerInfo.EmployeeID) from Employee Emp

Join EmployeeDepartment

On Emp.EmployeeID=EmployeeDepartment.EmployeeID

Join DepartmentManager

On EmployeeDepartment.DepartmentID=DepartmentManager.DepartmentID

Join Employee...

Try seperating the reporting database on a seperate server if you can afford to have one. Also since it's being built from OLTP databases, it need not reside on a...

check if the table 'ManagerInfo' exist?

Also see if the owner is different from you or dbo, in which case u'll need to prefix the owner name

like owner.ManagerInfo

shipra20 (6/16/2009)

---

Thnanks for the reply.But when i try to write the following it gives me error as my server name is with a slash. Can i use ip adress instead...

right click on the job and click disable.

There are some good scripts for database and table size monitoring on this site. Pls navigate to the scripts section to find those.