RE: Restoring Transactional Replication without reinitializing
I think the reason of the failure is because some transaction did not get replciated correctly. Did you try sp_repldone ? Is this on SQL 7 ?
2004-01-16
SQL Server Agent
RE: Generate Sequence Number Safely
Another approach is to use another table to hold your values. Then use a stored procedure to update the other table and get the last value. Always get your values through this stored procedure. The procedure should put an update lock on the row of the table (you can manage many keys in the same […]
2003-12-29
RE: Log file issue
Simple way to view space used vs free space is: Open EM Right-click over the database in question Choose View-->Taskpad You will see the database and Log files at the bottom of the display. Also look into backing up the transaction log more often, to manage its growth. Have a look in BOL for: DBCC […]
2003-11-17
RE: How to execute DTS code in parallel???
yes that is true although it will only try and you still need multiple connections as only one connection object can be used at a time(so with one connection object runs serially). You can still set an activex script with workflow to run several tasks in parallel this is better to use because you can […]
2003-08-21
RE: Cluster That Index! Part Two
quote: this is no comment on your article, but on your homepage. The link to your discussion forum yields a Fatal error: Call to undefined function: pg_connect() in /var/www-sql.nu/phpBB/db/postgres7.php on line 79 error. Ah, you mean at sql.nu. Yes, a while back we had a major crash and haven't brought our database online again (since […]
2003-08-12
1 reads
RE: shrinking transaction logs?
Try this: http://qa.sqlservercentral.com/scripts/contributions/26.asp Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-08-06
RE: Microsoft: Software Development / Test Engineer
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-31
RE: Discrepancy on QOD for 7-28-03
Flame on, Mr. Businessman, you can't speak like me. Yet they all remained forever in the trenches.
2003-07-30
RE: Discrepancy on QOD for 7-28-03
Of excuse me I meant DECLARE @makecomment VARCHAR(100) SET @makecomment = 'SAYSOMETHING' IF @makecomment IS NOT NULL PRINT 'I would said SQL is your first language.' ELSE --Don't bother.
2003-07-29
RE: Discrepancy on QOD for 7-28-03
quote: I'm afraid this question was my doing and English is hardly my 2nd language (although my ex-English teacher may say otherwise). I made the assumption that since I was speaking of GB the entire question, that readers would assume GB. It sounds like that was a poor assumption on my account. It has been […]
2003-07-29
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers