Forum Replies Created
Viewing 15 posts - 9,496 through 9,510 (of 18,923 total)
-
RE: Help getting rid of sql default tables
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...
-
RE: sp_start_job - Don''''t know how to explain this
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...
-
RE: sorting puzzel
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...
-
RE: Trigger Based on Column Name not Column #
Lol, it's always the easy ones that you seem to forget first
. -
RE: SQL Stored Procedure - From Insert to Update
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...
-
RE: SQL Stored Procedure - From Insert to Update
Mark was assuming that you were sending in the parameter!!
. -
RE: SQL Stored Procedure - From Insert to Update
ALTER PROCEDURE [dbo].[UpdatePollResult]
@PollResultID int,
@PollOptionID int,
int,
@CustomerID
-
RE: SQL Stored Procedure - From Insert to Update
Please post the tables' definition so that we can see what's really going on.
-
RE: HELP! I deleted the log files for my db. I need to restore ASAP
Ya, I'd like to hear this one!
-
RE: SQL Stored Procedure - From Insert to Update
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...
-
RE: Trigger Based on Column Name not Column #
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...
-
RE: how to use indexed view
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.
-
RE: Heap tables with lots of unused space
I can't wait to see what others have to see about this. Right now I'm drawing blanks on this one.
At least you got things straightened out to a point where...
-
RE: Help required urgently cleaning a database
Good advice Mark.
I was following the I need it yesterday comment so I put in the quickest of all solutions to type in and execute... but if the db is...
-
RE: Trigger Based on Column Name not Column #
My first comment is why the heck would you want to do that (add a column in a specific space in the table)?
But here's the answer to your problem...
Viewing 15 posts - 9,496 through 9,510 (of 18,923 total)