Recent content by mjp483

Thanks, I downloaded SQL 2005 SP1 and now it works

Anyone know why this error occurs while importing data from an excel spreadsheet in SQL 2005? It imports fine in SQL 2000. I'm using the import data wizard in both. - Validating (Error) Messages Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source -...

I guess you need to write a web service to extract the rdl files.

Do you have any idea where the RDL is stored? Someone told me it was in a table..?? It's hard for me to believe the RDL isn't somewhere where I can get it.

Does anyone know an easy way to get all the rdl's from a report server in one fell swoop? I am looking for the physical file, report name, and directory where it is displayed. Ultimately, we are moving rdl's from one server to another and need to physically move the rdl's.

I'm wondering if it's possible to find reportname and it's corresponding datasource somewhere in the system tables on the report server db? Please include the SQL. Thanks, Mike

That is the assurance I was looking for...thanks.

In query analyzer I run the select statement and it returns 300 1's......

I want to run an update based on whether a condition exists. To get the condition I run a query written like IF Exists (select 1 from Table a join Table b on a.id = b.id) Update Table A The select query returns 300 or so results as 1, is there a better practice so the condition is met before...

Awesome, I didn't know it was possible.....until I tried it...awesome thanks for all your responses...

I need to run a proc, and be able to insert the results into a tmp table to work with.....the catch is...I don't have access to change or open the sproc, just run it in query anylyzer and see the result.....Any ideas..

My .ldf file (log file) is too large. I want to know how to reduce it's size nightly after a scheduled db backup. Currently I have a maintenance job that backs up the tran log, but for some reason this doesn't reduce the size of the .ldf file, which I expected. I know how to manually attcah...

I created a report with two subreports. Seperately these subreports display correctly. In designer they display correctly. When I push the report to Report server I get this error....Error: Subreport could not be shown. Any ideas?

Does anyone know how to scroll from left to right on the report servers webpage? My report is too wide to fit the screen, and there is no scroll to allow me to scroll right.

this occurs when I view it from report servers webpage....any ideas??