Viewing 15 posts - 16 through 30 (of 137 total)
BTW...you can use DTS to do that easily.
-Dan
August 14, 2003 at 4:21 pm
It's not really possible, unless you right a query that looks at syscolumns, and uses a UNION to pre-pend it to the beginning of the result set.
-Dan
August 14, 2003 at 4:20 pm
I'd run a full DBCC CHECKDB to determine the extent of the corruption, but I think it sounds like some sort of hardware error. Also if you are running version...
August 14, 2003 at 4:05 pm
I would recommend using a user-defined trace, use Profiler Event "UserConfigurable:0" to watch it:
DECLARE @DebugStr NVARCHAR(100)
SET @DebugStr = @eventdate + ' ' + convert(varchar(6), @amount)
-- Log...
August 4, 2003 at 4:10 pm
Just a thought... we were using named-pipes and had network time-out issues. Named pipes doesn't support buffering the same way TCP/IP does. I would recommend using only TCP/IP...
July 23, 2003 at 9:49 am
Will there be any duplication in table names from the 2 publishers? If not, you can set up two subscriptions at the publisher to subscribe to each publisher. Server...
June 19, 2003 at 2:43 pm
BEGIN TRAN
DBCC CHECKIDENT('Table1',RESEED,1)
DBCC CHECKIDENT('Table1',RESEED)
COMMIT TRAN
This will reset to the next non-duplicate value. The RESEED option will only reset the next-in-sequence upward, so set to 1, then...
June 19, 2003 at 2:38 pm
Well....I think we isolated the problem with lock-ups to a hardware problem. We had a Dell service-tech replace the backplane, cpu board, power-distribution board, SCSI card and all the...
June 19, 2003 at 1:46 pm
The funny thing is the same query run on a non-hyperthreaded machine has no problems. Our @@LOCK_TIMEOUT is set to -1.
-Dan
June 13, 2003 at 12:19 pm
If you're using DELL, let me know...there are some major "issues" with RAID 10.
-Dan
June 12, 2003 at 11:55 am
BTW...Merge replication uses a "primary key" of sorts: It will create a GUID field of type "uniqueidentifier" on each table if none exists, and it will create a PK on...
June 12, 2003 at 11:41 am
We have done something like this in a Data Entry app. There are a couple of ways to do this that I can think of (we used the 1st...
June 12, 2003 at 11:32 am
One of our primary production boxes hasn't been rebooted since 10-27-2002 (almost 8 months). It's also a replication publisher and distributor. I haven't seen any problems that I...
June 11, 2003 at 5:54 pm
quote:
I want ALL active courses AND ALL active courses that starts with the number 10
Then...
June 11, 2003 at 4:17 pm
I would agree with Steve...
Something like this:
SELECT TOP 10 * FROM MyTable WITH (NOLOCK) WHERE Trans_ID > @LastID ORDER BY Trans_ID
You can save some CPU...
June 11, 2003 at 2:09 pm
Viewing 15 posts - 16 through 30 (of 137 total)