Viewing 15 posts - 1 through 15 (of 51 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...
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]...
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...
November 11, 2011 at 8:44 am
Oh, thank you.
read read read
(I will undoubtedly get myself confused before sorted.)
November 11, 2011 at 8:27 am
But the task mangler said SQL server was using all the cpu
November 11, 2011 at 8:23 am
Because they wanted to know what inventory items apply or don't apply by tax.
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...
October 20, 2011 at 7:27 am
Beneath 4 million rows in the customer lookup table. (Shhh)
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.
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...
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...
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...
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...
July 12, 2011 at 11:43 am
He had the name of the server computer wrong.
June 23, 2011 at 2:40 pm
Installer says it's boneheaded developer. 😛
June 23, 2011 at 2:09 pm
Viewing 15 posts - 1 through 15 (of 51 total)