Viewing 15 posts - 9,496 through 9,510 (of 18,926 total)
I would hardly call that advice.
My gut is also telling me that this is likely a joke, but this solution could certainly help someone someday, so I'll play along and...
August 10, 2007 at 3:54 pm
Of course you could get out of your way and change the xtype of the system table... then you would be able to drop them... but I would assume that...
August 10, 2007 at 3:52 pm
What problem are you having in getting those results ordered?
August 10, 2007 at 3:50 pm
I'm just curious here. What script did you run that deleted those tables???
I tried reproducing the issue on a test DB and I couldn't drop the System tables. The best...
August 10, 2007 at 3:47 pm
1 - Do the jobs do their job when starting the master proc as a job?
2 - Who is the owner of that job, the procs and under what account...
August 10, 2007 at 3:07 pm
What do you mean unsorted?
If the query has no order by in it, then the server will render the results in the best / fastest way he knows how. If...
August 10, 2007 at 3:03 pm
Lol, it's always the easy ones that you seem to forget first
.
August 10, 2007 at 2:45 pm
I can also enter my car without using the door but why the (?& would I want to do that???
You might consider taking a course on SQL, it would really...
August 10, 2007 at 2:43 pm
Mark was assuming that you were sending in the parameter!!
.
August 10, 2007 at 1:17 pm
ALTER PROCEDURE [dbo].[UpdatePollResult]
@PollResultID int,
@PollOptionID int,
int,
@CustomerID
August 10, 2007 at 1:06 pm
Please post the tables' definition so that we can see what's really going on.
August 10, 2007 at 12:48 pm
Ya, I'd like to hear this one!
August 10, 2007 at 12:24 pm
You need to tell which row(s) to update. That's why Mark was using the PollID in the update statement. That ID must be sent as a parameter and not changed...
August 10, 2007 at 12:14 pm
I'm here assuming that you are using Enterprise manager so here's a short list of what can break :
1 - Production DB
2 - System stop for EM to alter a bigger...
August 10, 2007 at 11:29 am
Can you post DDL, actual data of the tables and required output from the view. That'll be the quickest way for us to provide an answer for ya.
August 10, 2007 at 10:44 am
Viewing 15 posts - 9,496 through 9,510 (of 18,926 total)