Viewing 15 posts - 39,511 through 39,525 (of 49,571 total)
Florian Reischl (4/25/2009)
The more I learn the more I konw what I do not know
Psst, Flo, there's typo in your sig.
April 25, 2009 at 1:28 pm
DKG (4/24/2009)
We used to do intigrity check every day for the system database exludeing model&tempdb
Why do you exclude model?
April 25, 2009 at 1:27 pm
You should probably also include a quick installation guide for SQL Express, in case the marker doesn't have it already installed
April 25, 2009 at 10:38 am
stankirk (4/24/2009)
OK. Well, that helps me to better understand that I don't know what I'm doing, at least.
🙂 Not intentional.
Gail, you have a big picture in mind when you say,...
April 25, 2009 at 3:53 am
Backup/restore is probably easiest. Put a backup on the CD with instructions on how to restore. You'll also have to explain how to relink the access tables, as they refer...
April 25, 2009 at 3:51 am
Does this work?
DELETE d
FROM DAO...fnb_debtor_branchmapping d INNER JOIN fnb_debtor_branchmapping_sync AS a ON d.debtor_code=a.debtor_code
AND d.branch_code=a.branch_code
April 25, 2009 at 3:42 am
Ken Simmons (4/24/2009)
April 25, 2009 at 3:29 am
GilaMonster (4/24/2009)
Please post some existing sample data from the table. The very first link that I gave you shows how to do that easily.Why can't you change the table structure?
April 25, 2009 at 3:27 am
WayneS (4/24/2009)
GilaMonster (4/24/2009)
Unless you had a trace active, no way to tell.or a DLL trigger?
SQL 2000
April 25, 2009 at 3:24 am
Unless you had a trace active, no way to tell.
April 24, 2009 at 3:02 pm
In that case, I would suggest that you drop that unique clustered index and create a primary key on the columns ([Lock_RecordId], [Lock_TableId]) (In that order!)
That at least will stop...
April 24, 2009 at 3:00 pm
Michael Valentine Jones (4/24/2009)
/********************************QUERY 2*******************************/
(@1 int,@2 tinyint,@3 nvarchar(4000))
DELETE [LOCKS]
WHERE coalesce([Lock_TableId],@1)=@2
AND [Lock_RecordId]=@3
Since column [Lock_TableId] cannot be null, there is no...
April 24, 2009 at 1:51 pm
Grant Fritchey (4/24/2009)
Yeah, it actually would be fun just to tear through the servers running the install software everywhere and then watch the phone light up like a Christmas tree.
The...
April 24, 2009 at 1:10 pm
Jeffrey Williams (4/24/2009)
Or preferably test it before you upgrade, by setting up the DB on a test server with 2005 on.
Though, I must admit, there's little that gets adrenaline pumping...
April 24, 2009 at 1:08 pm
The other thing I could suggest is that you dig out some of the queries that often get blocked as well as the queries that are typically the cause of...
April 24, 2009 at 1:05 pm
Viewing 15 posts - 39,511 through 39,525 (of 49,571 total)