Viewing 15 posts - 46 through 60 (of 314 total)
Kari Suresh (3/1/2011)
[p]Yes, I'm getting this error when running the report in my application.[/p]
and when you run it from the SSRS url?
March 1, 2011 at 2:47 am
Is the problem when running a report?
February 28, 2011 at 8:43 am
And I thought I was the only one..... :hehe: At least I have a few more years to decide 😛
February 28, 2011 at 8:41 am
jay holovacs (2/28/2011)
In many, or most cases, one does not consciously choose to become a master, instead the combination of aptitude, circumstance and opportunity create the path.
I like this.... 😎
February 28, 2011 at 7:15 am
IIS and ASP.Net should only require connections (and that should be done with the service account) to the internal Reporting Services databases, after that, its all down to the datasource...
February 28, 2011 at 4:27 am
In all honesty, no....
I would love to master something, but that something would be something for me, not something work based. SQL Server pays the bills and does it relatively...
February 28, 2011 at 3:08 am
Carlton Leach (2/27/2011)
Gift Peddie (2/25/2011)
grahamc (2/25/2011)
February 28, 2011 at 2:43 am
Its quite possible that your datasource is setup to impersonate the calling user - local admin. Which would (and should) not have permissions on the DB.
In the SQL Server error...
February 25, 2011 at 9:01 am
If you are doing DML statements, it is normally quite handing to have a PRIMARY KEY declared on the TEMP(#) table
February 25, 2011 at 8:11 am
Are there any errors on the remote server? Windows Log, SQL Log, etc?
February 25, 2011 at 3:37 am
homebrew01 (2/24/2011)
February 25, 2011 at 3:35 am
Well you did post in the SQL2008 area, hence the advice given.
It depends on the requirement. If you only need to cater for 3-4 departments, then I would go...
February 24, 2011 at 7:48 am
BTW you may want to do some reading on naming (best) practises....
sp_ tut tut :hehe:
February 24, 2011 at 7:39 am
Well as stated, if SQL 2008, I would be looking at the Table Valued Parameters as suggested.
Sorry, but this is your work, I am not going to do it,...
February 24, 2011 at 7:33 am
It is generally very difficult to SHRINK the TEMPDB as its almost constantly in use. If you really must bring down the size of the TEMPDB, reduce the initial size...
February 24, 2011 at 7:12 am
Viewing 15 posts - 46 through 60 (of 314 total)