Viewing 15 posts - 1 through 15 (of 52 total)
I'm beginning to think you're right.
It does spot some variations like Tom and Thom and sometimes and internal f for a v, but if you don't have the first letter...
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
July 5, 2012 at 2:48 pm
It's in a system of 436 tables.
CREATE TABLE [dbo].[JournalDetail](
[JournalDetailPK] [char](16) NOT NULL,
[JournalHeaderPK] [char](16) NULL,
[DetailType] [char](2) NULL,
[NonInventory] [tinyint] NULL,
[InventoryPK] [char](16) NULL,
[JournalDetailDescription] [varchar](30) NULL,
[Price] [money] NULL,
[CostAbsorbed] [tinyint] NULL,
[DeliveredDateTime] [datetime] NULL,
[OriginalPK] [char](16) NULL,
[BackorderPK]...
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
April 9, 2012 at 9:16 am
By "Locking" the client seems to mean all the programs on all the users computers (that access the db) pause for tens of seconds at the same time. Their fairly...
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
November 11, 2011 at 8:44 am
Oh, thank you.
read read read
(I will undoubtedly get myself confused before sorted.)
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
November 11, 2011 at 8:27 am
But the task mangler said SQL server was using all the cpu
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
November 11, 2011 at 8:23 am
Because they wanted to know what inventory items apply or don't apply by tax.
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
October 21, 2011 at 7:42 am
Oh, here we go:
select tax.taxpk, inventory.inventorypk
from tax
join inventory on 7=7
left outer join taxapplies on taxapplies.taxpk = tax.taxpk and taxapplies.inventorypk = inventory.inventorypk
where taxapplies.inventorypk is null
I was having trouble getting a join...
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
October 20, 2011 at 7:27 am
Beneath 4 million rows in the customer lookup table. (Shhh)
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
September 17, 2011 at 7:53 am
Oh my! I got it solved....
I recreated the deleted procedure at each of the subscribers so the alter statement would work. Now the replicator is again replicating.
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
September 16, 2011 at 4:19 pm
The trick seems to be to execute distribution.dbo.sp_replmonitorhelpsubscription, which gives you all sorts of information. Some of it I don't know what do do with, but the status column is...
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
August 22, 2011 at 1:20 pm
Um, the point is, I want to know where the display gets this information so I can use it in my own code...
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
August 19, 2011 at 12:32 pm
A friend tells me:
Go into the NIC settings, on the advanced tab and make sure the Enable NetBios over TCP/IP is checked on.
I can't seem to try it as the...
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
July 12, 2011 at 1:52 pm
Yes, they can ping the server by ip address, but not name.
The XP computers that can access the database can also ping the server by ip address, but not name.
Since...
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
July 12, 2011 at 11:43 am
He had the name of the server computer wrong.
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
June 23, 2011 at 2:40 pm
Installer says it's boneheaded developer. 😛
[font="Arial"]Halfbubble ------------
You just can't do this stuff unless you're at least half a bubble off center.[/font]
June 23, 2011 at 2:09 pm
Viewing 15 posts - 1 through 15 (of 52 total)