1. are you sure you updated the SP code on the same same server..

2. you can use a profiler to capture the sp name etc...

3. did you look at the...

SQL 2005:

right click Database--> properties--options-->Scroll down to State container...

there are options.. select multi_user... and you are done.

SQL 2000:

right click Database--> properties--options--> under Access -- uncheck Restrict Acess and read...

I know you might have already done this: but a second shot..

Goto Component Services under Administrative Tools--> Click on component Services -->computers--> My computer-->Dcom Config-->msDtsServer-->Right click properties then Security, there...

check this out:

http://msdn.microsoft.com/en-us/library/ms156468.aspx

http://ismailtutumluer.wordpress.com/2007/01/16/the-report-server-cannot-open-a-connection-to-the-report-server-database-a-connection-to-the-database-is-required-for-all-requests-and-processing/

http://blogs.msdn.com/bimusings/archive/2005/08/23/455263.aspx

check books online for fn_trace_gettable

it is very helpful in tracking down and filtring information through T-SQL.

I would suggest to use '%%' in the like clause in textdata column, while filtering...

The first thing to look for would be as suggested check the allow remote connections settings also enable tcp/ip on server through configuration management.

also try this:

connect to reporting services in...

I hope this should work: Restore the database and under security check each user and their corresponfing Roles, should e highlighted. infact they might be orphaned but the roles mappings...

Try to enable "Shared memory" and "named Pipes" Protocols incase you havent ... If you have then also start TCP/IP and check to see if the service give the error.

did you mean the Free disk space available on the disk where tempdb resides is 40GB and the size of the Database you are working on is 300GB and is...

Here is the next best option you can look at: if you have more than 4Gb Physical RAM on your New SQL Server then:

Get Windows 2003 Enterprise Edition and SQL...

I Guess the answer is http://msdn.microsoft.com/en-us/library/aa366778.aspx#physical_memory_limits_windows_server_2003

so assuming the /PAE is set the max memory with the switch is 4GB, so it settles the doubt...

I guess i should start reading between...

Exactly, here is what i did.

I defined DEFAULT for the columns(infodate and servername) and then applied the insert.

GREAT, thanks and ton.

There can be many routes, my Friend.

Does this error occur when you are trying to connect/use Surface Area Configuration to your local machine?

Is SQL Developer edition installed on your machine.Or...

Try to create a new table with the same structure and move the data from old tables into new, this should hlep you reclaim the space.

Check this and see, if...

one reason might be hopping ID, i.e. your id might be present in several groups. or check this out and see if this helps:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=65711&SiteID=1