Mark:

Thank you for offering to test this for me on a 2008 SQL Server.

Below is the script that I used.

I am running Microsoft SQL Server 2008 R2 (SP2)...

Jeff:

Thank you for your reply.

I just tried it again and I am not leaving out any characters.

I get the same error.

I am running it SQL Server 2008R2.

Thanks

Howard

When I ran the following example for FUNCTION dbo.GetWeeksForMonth

--===== Return weeks in current month

SELECT WeekNo, WeekStart, WeekEnd, DaysInWeek

FROM dbo.GetWeeksForMonth(GETDATE())

I got the following error

Msg 102, Level...

Jeff, I agree with you in that I would have hoped I would have gotten more feedback in the areas that you mentioned.

Gilles, your response was also very helpful.

Thank you

Thank you for taking the time in providing me with an excellent and detailed response. This was very helpful.

Do you have a description of the services, monitoring, reports, etc. that...

Thank you to everyone who took the time to respond to my questions.

Michael:

Thank you for your response.

You are correct in that I am trying to determine if their estimate / proposal is a fair one. I should have been clearer in my...

Jack:

Based on the updated information how many hours per day and how many days per week do you believe the DBA would have to spend in maintaining the databases?

Thanks

Jack

Here are the answers to your questions.

How good is the DBA is at automating things?

Unknown at this point but supposedly very good.

Are you willing to put into place and pay...

Lynn:

Thank you for the fast response.

Here are the answers to your questions:

What do you expect them to do if alerts fire?

Resolve the issue.

What type of response time will the individual...

Jason:

Thank you again for taking the time to answer my questions.

It is greatly appreciated.

Howard

Jason:

Pardon my ignorance on this but I just want to make certain I understand you.

Are you saying that I can do the following:

Using SSMS connect to the remote SQL Server...

Jason:

Wouldn't script based routines still have to be installed as a maintenance plan?

Howard

Jason:

Thank you for the fast reply.

What are your thoughts on me installing the old SQL Server Enterprise Manager on my Windows 7 computer (if that is even possible) and handling...

Mr. Shaw:

Thank you for your help in this matter.

Howard