Search results for query: *

Thanks y'all. A linked server system similar to what LeighMoore suggested is what I'm using. The only drawback I can see is a single point of failure risk. If the one SQL server which runs the master SPROCs goes down, all reports for all of the clients will go down too. This isn't much of...

That's an interesting idea, but I don't think it would work. It sounds like you would update the datasource before running the report. I would be concerned about the situation where two users from different databases tried to access the report at the same time... there might be a horrifying...

Hi all, I'm new to RS, and my project is to get RS running on the web using the URL method. My problem is that I have more than one SQL server running, all with identical databases (with different data, o'course). I've made different Data Sources on the Report server which point to the...

Yeah, I think fixing the SQL is the only way to go. :( I tried I puting the object which does the SQL connection into a thread, and then overriding the Finalize() method of the object. This Finalize() was automatically called when I called the thread.abort(). Inside the Finalize() method I...

I was thinking perhaps a javascript.OnClose() could call a script which would cancel any sproc calls... or maybe the sproc call could be in a spawned thread which could be accessed somehow and commanded to stop whatever sproc calls are running. Those are just general ideas, though... I have no...

It would be helpful if there were a way to cancel a sproc call using VB. I'm having a problem with a bad sproc which causes deadlocks if a user runs a page, gets impatient and closes the browser, and then runs the page again. :( However, I can also see a use for cancelling a sproc call in...

I turned off the autoclose on the database, and the log files look normal now. Thanks all, I think that fixed it. If it were a problem, that is. :) It doesn't seem healthy to have so many starts in a row. -k

I'll turn off the auto-close and see what happens. Either way it seems inefficient to leave it on... the only situation auto-close seems worth it would be on a desktop development environment where the computer is used for other things than SQL servin'. -k

Interesting, thanks.

Yeah, but so often in such a short time? Maybe it's the Internet User badgering the SQL server when it's trying to sleep, but that seems like an odd thing for it to do. -k

I found the problem myself, it seems that SQL Server Service Manager strobes the network for other servers when it starts... or even when a new IP connection is started (such as starting up the wireless card on a laptop.) This is normal, the abnormal thing around here is the touchiness of my...

Hi all, I got curious and started looking at log files on a couple of my servers. I notice that when a server is started, the databases are also logged as starting too, one after another. That makes sense. But then sometimes a particular database will be logged as starting lots of times...

I'm not an admin, but I would check to see if you still have security rights to the file. Someone might have changed the security of the file, or the security of your login user, or the group you belong to. -k

Hi all, I'm a developer with a local SQL2000 server running, I recently saw my memory getting eaten up by SQL and assumed it was the old Slammer virus. (My SQL server had no service packs installed.) I installed the latest SP4 for x86, and the SQL server is ok now, except that a co-worker's...

Alright, I'll try to convince the network administrator to try that. Thanks.

Isn't the form action another ASP file? Why not collect the stop time in that file? -k

Are there any security drawbacks to that approach?

I'm trying to get ASP to read and write files on another computer on the network. I'm trying to use a mapped drive. I read the thread on this forum which shows how to do it and it works for one day, but quits. It works again if I change the drive letter, but that will run out in less than 26...

That second code fragment is an interesting idea. I'll try those two out and see what happens. Thanks, -k

After about 2 years of faithful service, a quick form I made has stopped working for 3 users (as far as I know). The one user I could get a hold of said she was using IE 6.2 with service pack 2. When she filled out the form, the javascript said she did not have anything in one required field...