Viewing 15 posts - 14,251 through 14,265 (of 18,923 total)
Did you try re-rebooting? I saw that as a solution to a similar problem, but I can't find the actual thread now.
August 18, 2005 at 11:32 am
Please do not cross post, end the discussion at this thread :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=211707
August 18, 2005 at 11:27 am
What happens if you shortent the range of the search to let's say 2000 to 2001 so that the # of rows returned is different?
August 18, 2005 at 11:26 am
Yup but now he doesn't have to come back to the forum for these types of question, so that's 15 minutes everytime, assuming I saved him more than one question,...
August 18, 2005 at 11:21 am
Upgrade
!!
No I don't know any other software than that.
What happens if you convert your db (a backup on another server) to 8.0 and document...
August 18, 2005 at 10:20 am
I rebuilt that query with the wizard in 30 secs... he had to at least take 1-2 minutes to type the question and wait 7 minutes for the answer (assuming...
August 18, 2005 at 10:17 am
I bet I can wizard that query before he hits post (and then starts waiting 2 minutes for an answer).
August 18, 2005 at 10:12 am
You might find this usefull :
--This will grant permission to the db_executor group for every stored proc in the system that he has no access permission to without changing...
August 18, 2005 at 10:11 am
There's where the view wizard can be your best friend in EM
.
August 18, 2005 at 10:08 am
I'm surprised it even worked in the 2000 version.
You should ALWAYS, read ALWAYS specify the owner of the object (access, vb, sql...). And yes they'll need the permissions accorded...
August 18, 2005 at 10:06 am
Can you send the number of rows from that, time, and the plans too :
set statistics io on
set statistics time on
dbcc dropcleanbuffers
go
Select * from dbo.fn(null, null)
go
dbcc dropcleanbuffers
go
Select * from...
August 18, 2005 at 10:04 am
You're jumping to conclusion without us answering the question yet, we still need this :
Schema, Sample Data, Required Results
August 18, 2005 at 9:59 am
How about going the other way around.. create a table, add column CallingJob
Then when you start the job, first update that column, then the proc will be able to access...
August 18, 2005 at 9:58 am
I have a double edge, I think fast and type faster. Now you may have more experience but that doesn't atomatically translates in speed
August 18, 2005 at 9:56 am
Well how many rows are returned with each versions??
August 18, 2005 at 9:55 am
Viewing 15 posts - 14,251 through 14,265 (of 18,923 total)