It seems that the recommended set up for the DTC is for the service on a SQL server to be configured to run using the NT AuthorityNetwork Service. I...
As Frank Kalis suggested you could always modify it yourself. It seems to be the way with fora, that one gives and takes rather than just demanding...
Satya, When I publish the report and look at its properties in the RS report manager the execution properties are set so that "Do not cache temporary...
In addition to this, if I make a change to the subreport, for example adding a field to the view then I need to go through closing the subreport for...
The properties are consistent for each of my parameters i nthe sub-report The ones that are set are as follows datatype: String Allow null value:...
That said, it hasn't actually solved the problem, although I am not sure why it seemed to work when I tried it earlier. I also meant SP1 for Visual...
Satya, Thanks, I was under the impression that my PC had had the SQL client tools service packed, however it seems not to have been the case....
I am using Visual Studio 2005 to create some reporting services reports. I am passing data from a dataset returned from a stored procedure in a top...
Shouldn't it be previous.year = current.year - 1 rather than plus 1?
However you can write it all to a holding table (possibly temporary) Then truncate the original table, SET IDENTITY_INSERT <tablename> ON reinsert...
I thinks that Ramesh is saying that They have a fact table which has had a record updated (dated 10/04/2006) He then wants the data updated...
Indeed, likewise Druer's solution only works with the specific set of data.
To get away with only using the table once, although it will give you more overhead you could insert the data into a temp table and then use that one...
Maybe also review whether the users *really* need dbo rights to the database. sp_who and sp_who2 will tell you if there is any blocking (blk and...
B D Richardson, The test you ran isn't looking at @StringValue = '' and LEN(@StringValue) = 0 what you seem to be testing is SELECT count(*)...
There is a windows user group called OLAP Administrators. Make sure that the account that runs the service is a member of this and I believe that...
If you have GO in each of your procedure scripts you can use the following code in a batch file to combine the scripts REM this will add all files...
You blame the incompetent developer who created the table...
Ooops, missed the two replies in between! yes indeed it is an extraordinary irritation and bad practice to put spaces in but it seems it can be...
Adriann, This I was unaware of, however if you run the following pieces of code you will be able to create a table that looks like it has a space in...
Separate names with a comma.
