Gianluca

The only reason that I decided to run bwoulfe's code instead of yours is that his already had the code to email the report.

You stated "To get a notification, you...

I did not write this proc. I had found it on the internet and it appears to be available to anyone who wishes to use it.

USE Master

GO

IF OBJECT_ID('dbo.usp_MyStoredProcedure', 'P') IS...

bwoulfe

I downloaded the script from http://www.heydba.net/2011/05/get-dbcc-checkdb-output-tool-for-sql-server-2005/ and got it to work in SSMS.

I am running SBS 2011 with SQL Server 2008R2.

However, when I place the scipt in a...

Jeffrey:

Thank you for your response.

For question 2 - if you already have the plan open in the editor to modify, then trying to modify again won't do anything.

==> The plan...

Problem solved.

Below is a link that lead me to the solution which is a registry change.

http://stackoverflow.com/questions/6825306/change-the-default-save-location-for-sql-management-studio-2008

The register key is DefaultFileOpenLocation.

I changed this registry key and it worked.

Thanks to...

Thank you for your reply.

This appears to be exactly what I was looking for except that I cannot get it to work.

I changed <PropertyValue name="ProjectsLocation">%vsspv_visualstudio_dir%\Projects</PropertyValue>

to

<PropertyValue name="ProjectsLocation">\\server01\c$\d-drive\jcc_membership\howard\member\sql_queries</PropertyValue>

but it did not seem...

Thanks to all for the fast response to my question.

It was extremely helpful.

I also came across the following t-sql that displays "SQL Server 9.00.5000.00 - SP4 (Express Edition).

SELECT 'SQL Server...

Jeff:

Yes, this is an SQL 2000 post.

I incorrectly posted it to the wrong forum.

I apologize for that.

Howard

Craig:

Thanks for everything. You have been a great help.

Howard

Craig:

Thanks. The script worked just fine.

Am I correct that your original script that listed the counts in error cannot also correct the count?

Put another way, is there a way to...

Ron:

Yes, Craig's code satisfied my requirements?

If it is okay, I would like to add one additional question based on Craig's solution and that is how can I change the script...

Craig:

That is it! Works perfectly.

Thanks for your help as I would not have ever figured this out on my own.

I am sorry that I did not provide you with the...

I have quickly created a script that creates two tables, inserts values, and then runs the query that contains the count(*).

I hope that this will help. If not, please let...

I am copying your script and pasting it into Query Analyzer and running it there.

I made the change as you suggested (see below) but now I get the following error:

Server:...

Craig:

Thank you for the fast response.

I get the following errors when I run your query.

Server: Msg 156, Level 15, State 1, Line 8

Incorrect syntax near the keyword 'FROM'.

Server: Msg 156,...