Well go to IIS manager, go to the Report Manager/Report Server virtual directories and go to Directory Security Tab, Edit the Anonymous access and Authentication settings and enable Integrated Windows...

Are you talking about the Reporting Services Configuration Tool ? Please check if the executable file is available at :

"[DriveName]:\Program Files\Microsoft SQL Server\90\Tools\Binn\RSConfigTool.exe"

You should be really careful in structuring the insert queries as to which one needs to be executed first and what is next based on the dependencies (Relationships) defined on...

Hello John,

Thanks for pointing it out. It was my oversight to include CASE inbetween, sorry about that. I stand corrected.

Please let us know what do you mean by Merge. Are you looking at merging data? Since you specified that the structure is same. You may want to run a...

Yes exactly, your error messages states that the error is in line 3. Please select only this part of the script and try executing.

But it is not a bad idea to use CASE with a SELECT prefix as such you are not going to lose any thing.

SELECT CASE WHEN @value = 1 THEN...

If you furnish a bit of test data and the desired results that you are expecting by merging both stored procedures, it should be hard to combine your procedures into...

It is not wise to run the applications on SA password. It not only leads to problems as you mentioned but also would make the security vunerability more. If you...

Just try this.

select *

from MCommPLOrders as a

where convert(varchar, a.timeofcode, 112) = convert(varchar, getdate() -2, 112)

and (jobtypeid not like '%code%' and jobtypeid not like '%COIN%' and jobtypeid...

You can do it using sql query analyzer using the connection dialog option if you have credentials for the named instance database. You can also use New Query icon on...

Are you the output of the first sp anywhere else? If not you may just want to use this query

SELECT * FROM schedule_info WHERE _Date = @_Date and serverid IN...

After connecting to your SQL Server Named Instance run the following T-SQL

Please replace the drive and location with exact the location of your files.

RESTORE DATABASE DATA[DatabaseName] FROM DISK =...

No, the service hasn't started and it is a very weird problem I am trying to resolve. The server name is same. Any clues would be highly appreciated.

It really was as simple as that for me on one of the installations. However on a new server the installation goes fine till the last step where it says...