Search results for query: *

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??

My report is too wide to fit completely on my screen. I was expecting a scroll bar at the bottom to allow me to scroll right to see the rest, I can't find anything regarding this....is it even possible? Is there something similar to the Freeze Panes option in excel?

After I script my procs from enterprise manager, I paste the script into query analyzer and run it. When I open the newly scripted procs, they are all missing the spacing I that was present in the source procs. Is there a way to maintain the spacing?

Thanks this is very helpful. Mike

I want to set up a job, that runs at night, when it finishes I want another job on another server to begin, and when this is complete I want a DTS package to start.... Can I do this all through DTS or Jobs? Any suggestions?

I tried these things: sp_spaceused 'EnrollmentDetail' ,@updateusage = 'TRUE' select count(*)....still different counts then I tried: Update Statistics EnrollmentDetail sp_spaceused 'EnrollmentDetail' select count(*)....still different counts When I bring this table to my local machine it...