Viewing 15 posts - 1,156 through 1,170 (of 1,536 total)
You're asp is probably timing out when trying to execute something against the sql server. Check your server timeout options within the global.asa or the connection string on your asp....
May 26, 2004 at 10:56 am
Run profiler against your database, specify a duration and check those queries that are causing the problems.
May 26, 2004 at 10:29 am
How did you modify the location of tempdb? And are there any messages in the error log or system event log to indicate the problem?
May 26, 2004 at 10:22 am
I think that I might have it, I am trapping the object:opened, object:closed, scan:started events and it seems to pull the data I need. It only returns the objectid, but...
May 26, 2004 at 6:18 am
Unfortunately the data is accessed by users running ad-hoc queries, so that won't help. Thanks anyhow.
May 26, 2004 at 6:00 am
Thanks Salvor, I was looking to try and avoid running a trace if I could, but it looks as though thats going to be the only way to get the...
May 26, 2004 at 5:37 am
The problem is that the governor uses is not called using SQL that I have been able to trap so I don't believe that I can change the way that the...
May 25, 2004 at 1:27 pm
Make it sa so that it impersonates the SQL Agent account when executing.
May 25, 2004 at 1:25 pm
What security context are you trying to execute the job under? Make sure that the job owner is SA.
May 25, 2004 at 12:49 pm
In your view change the select for the column you want changed to
cast( <column> as datetime)
May 25, 2004 at 9:28 am
Check that the SQL Server Agent service account has sufficient permissions to access the UNC share to which you are trying to connect.
May 25, 2004 at 9:25 am
Use the following to get a list of the current connections, ordered by cpu descending. Take the top 1, run a dbcc inputbuffer against it, see what it's doing, try...
May 25, 2004 at 8:33 am
It looks as if you have set the correct configuration options, however I would check the run values on these options as they may be different from the config and...
May 25, 2004 at 8:05 am
The problem is that I have users writing ad-hoc queries on the server and I am not in a position to be able to prevent that from happening, I am...
May 25, 2004 at 5:12 am
Try
ALTER TABLE <TABLENAME>
DROP CONSTRAINT <CONSTRAINT NAME>
GO
ALTER TABLE <TABLENAME>
ADD CONSTRAINT <CONSTRAINT NAME>
DEFAULT <DEFAULT VALUE> FOR <COLUMN NAME>
GO
May 24, 2004 at 12:11 pm
Viewing 15 posts - 1,156 through 1,170 (of 1,536 total)