Problems deleting SQL.LOG file

Hi,

I can not delete this file from C/Windows/Temp directory, all other files form that foder I can delete. The error message I get is that something else is using this file. The thing is I cant find what is using it, even though I uninstaled SQL Server 2005 completely. I have tried lots of things, nothing helps. At the end I entered windows in SAFE MODE, went to Computer Management and disabled almost every service I can, that might be using it, and still cant get rid of this SQL.LOG which is 26GB now. The only thing I could do is to compress the file and now it is 6.5GB.

Txs for the help..

This file is a result of ODBC tracing. Here's the article about how to delete it.

http://support.microsoft.com/kb/268591

Thanks,
Sam Lester (MSFT)

problem with workflow in dts designer...looping?

what im trying to do is:

1) ftp a file from a server to a local directory,

2) check the file for its lastmodified date

3) depending on a constraint, perform a data import.

However, if the file is not modified, this means that the server thats supposed to ftp and update the file hasnt done its job yet, in this case i would like dts to wait a few minutes and then again go to step 1. I want this to repeat for a whole hour until the data has finally imported OR if it hasnt imported at the end of the hour it will send me an email saying it failed.

The closest I have come to this type of functionality in DTS designer is picture 1.

In picture 1 i am using the WAITFOR DELAY '000:02:00' to wait 5 seconds between every step. However To do this would require me to create about 30 iterations to span the whole hour! The activeX portion works fine its just learning the flow in dts designer that is giving me the problems.

It would be so much easier to do what I did in picture 2, but nothing runs.

here are the pics:
http://www.geocities.com/samirrahan/picture1.gif
http://www.geocities.com/samirrahan/picture2.gif

I would appreciate any help you can offer.



Thank you.I would do it differently...

Each time I successfully import a file (eg I have found a new file and processed it) I would set the next run date.

I would then set a job up to run the dts package every X minutes (5 for example) between the hours that you expect the file to turn up.

The first step of the package would be to check if it is the run date is less then or equal to today, if it is then you continue processing, if not then you halt processing.

This will solve your problem. Yes, it will mean that the package will run more often then it technically needs to, but it will only do the actual processing once.

HTH|||here is the link to my workflow pictures:
http://www.geocities.com/samirrahan/index.html

ideally i would want the dts to stop running as soon as the file import is successful. i guess i could do that on a success by rescheduling the job.

by the way on another note? do u use the designer or just a vb exe. itself? can this be alot easier if i dont use the designer?

thanks.|||I use the designer...

There is a method to change the jobs schedule using sql. Using sp_add_jobschedule and sp_delete_jobschedule what you could do is...

step 1, check for new file if fail end DTS Pakcage else step 2

step 2, ftp file

step 3, process file

step 4, execute sql task - sp_delete_jobschedule

step 5, execute sql task - sp_add_jobschedule

problem with url in microsoft server 2005

Hi,
I have a problem:

When i enter in the iis i have two virtual directory:
Reportsr$sqlexpress
ReportServer$sqlexpress

I try to run the report by browsing home.aspx and going to my
report.The url that i got is:

http://localhost/Reports$SQLExpress/Pages/Report.aspx?ItemPath=%2fReportInventory%2fReportTotalCounting

Now, i enter the parameter wanted and click on export to pdf file
it works fine :it opens the report in a pdf file ,i got a url like
this:

http://localhost/Reports$SQLExpress/Reserved.ReportViewerWebControl.axd?ReportSession=a52f1o55wy00wq454pq0jp45&ControlID=f8672382-3d09-430f-a308-9bf42b850184&Culture=1037&UICulture=9&ReportStack=1&OpType=Export&FileName=ReportTotalCounting&ContentDisposition=OnlyHtmlInline&Format=PDF

but the probem is that i think the url is encrript because i don't see the parameters i entered in that url!

what i would like to have is an url like this:

http://localhost/Reports$SQLExpress?%2fReportInventory%2fReportTotalCounting&Parameter_WarehouseID=12&rs%3aCommand=Render&rs%3AFormat=PDF

but this url doesn't work it return me to the url:
http://localhost/Reports$SQLExpress/Pages/Folder.aspx

how can i have a url that work fine so i can pass the paramerter(a url not encript)?

is there somewere where i have to set if the url is encript or not?

help me please why the url does'nt work?
thanks in advance

The Report Manager virtual directory does not have a URL access interface. If you wish to pass parameters and other directives via URL, you must use the Report Server virtual directory:

http://localhost/ReportServer$SQLExpress/Pages/ReportViewer.aspx?%2fReport1&rs%3aCommand=Render

|||

You can pass the parameter in url by accessing the report server. Try http://localhost/ReportServer$sqlexpress/... instead.

http://msdn2.microsoft.com/en-us/library/aa256630(SQL.80).aspx