Viewing 15 posts - 4,126 through 4,140 (of 5,394 total)
Lynn Pettis (6/21/2010)
Remember, the referees have to call what they see.
Totally agree. It this doesn't change the horrible match Italy played yesterday.
BTW, AR stands for Assistant Referee?
June 21, 2010 at 8:30 am
Jan Van der Eecken (6/21/2010)
Did anyone watch Portugal - North Korea just now? Wow, what a result, 7:0. Now you US'ers stop complaining about low-scoring games.
It's a shame I couldn't...
June 21, 2010 at 8:27 am
Paul White NZ (6/21/2010)
Gianluca Sartori (6/21/2010)
2. NZ scored in offside
I'm no expert, but it seemed to me that Giorgio Chiellini flicked the ball on to Smeltz, not an NZ player...so...
June 21, 2010 at 7:31 am
You could check for @@error <> 0 after each procedure call and use RAISERROR with a meaningful error message.
June 21, 2010 at 7:23 am
You're welcome. You could possibly post here what the issue was about, so that others can benefit from your experience.
June 21, 2010 at 7:20 am
It could be a starter to find unused tables during the time of observation.
Finding totally unused objects, unfortunately, is a bit harder than this.
Simple example: you don't see activity on...
June 21, 2010 at 6:49 am
Well, sort of.
Some of my databases have tables to list exceptions to a rule. Sometimes they're empty and stay so for years, but this doesn't mean they're unused at all.
Thanks...
June 21, 2010 at 6:40 am
stewartc-708166 (6/21/2010)
try this:
select o.name, o.type_desc, si.name, rowcnt, rowmodctr
from sys.objects o
join sys.sysindexes si on si.id = o.object_id
join sys.indexes i on i.index_id = si.indid
where rowcnt = 0 and rowmodctr = 0
I...
June 21, 2010 at 6:34 am
Unfortunately this is a really challenging task.
I had to achieve the same thing and I had to code an application to search the app sources and object text for table...
June 21, 2010 at 6:12 am
I'm sorry, there's no way to prevent the messages from printing out.
June 21, 2010 at 6:07 am
If they only knew the origins of that horn, they wouldn't be so happy to blow inside it. 😛
WARNING: not safe for work.
http://www.bastardidentro.it/misc/editor/files/BD1924-Origini2.jpg
June 21, 2010 at 5:48 am
You're welcome.
Glad I could help.
June 21, 2010 at 5:37 am
ALZDBA (6/16/2010)
there is no need for that to be changed !
Ditto. No need to change it.
I don't say it's just looking for trouble, but there's no need to change...
June 21, 2010 at 4:31 am
My fault, GETDATE() cannot be specified as default value in a stored procedure. I would change it to a default = NULL and then set it to GETDATE() if the...
June 21, 2010 at 4:21 am
I would like the stored procedure to require parameters required @From, @To, @ActivityCentre
Try changing it to something like this
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[MyProc]
@DueDate...
June 21, 2010 at 3:45 am
Viewing 15 posts - 4,126 through 4,140 (of 5,394 total)