Andy, Thank you for the help. So if I understand you correctly the identity column must just be manually recreated on the subscription database and it should work fine? What about all the table relationships, is that taken over as well when creating the replication DB? Regards Raino Botha
2003-08-21
1 reads
Before my dba/webdev days I was a "Configuration Manager" at Nordstrom.com. That title didn't do to well in 2K, let me tell you. Bob: What exactly is it that you do here? Calvin: Can you see? I take the source code from the developers and deliver it to QA. Then I take the source code […]
2003-08-20
1 reads
Yes. Outlook 2000 is installed on the box as SQL Server 2000 running.
2003-08-20
1 reads
quote: Your to quick in a morning Frank, was about to edit it haha, another typo. And in english !!! So, you're smoking and thump your cigarettes out of the car window??? I guess that's not political correct anymore. Feel ashame, you !!! Cheers, Frank
2003-08-20
yep! Sometimes, I will even cover my rear further by doing something before the transaction, such as: select * into tempdb..orders from orders Sometime I'll take a prior full backup of the database. It really all depends on the circumstances. Cheers, - Mark
2003-08-20
Hi, I have seen no major differences in restore times between LiteSpeed and Native restores. My experience with restores (LiteSpeed or Native), is that there are two major factors which will cause varying results in restore times: 1-Restoring on a system where the database and log devices do not already exist will generally be twice […]
2003-08-20
If you can shut down the database I've always found that the quickest solution is immediately after a full backup to use sp_detach_db, delete the physical log file and then use sp_attach_db. EXEC sp_detach_db '<DB_Name>', 'true' EXEC sp_attach_db @dbname = N'<DB_Name>', @filename1 = N'<Path_T0_Physical_Data_File>' By attaching only the data file a blank log file of […]
2003-08-19
1 reads
quote: I'm not sure about that. There are tendencies, especially in accounting, to present the annual balance sheet as fast as possible after 12/31. They call it 'fast-close' Many companies put unreasonable demands on accountants, especially the big accounting firms that prey upon, excuse me, hire kids right out of school. Same with engineers and […]
2003-08-19
...and the value of @@rowcount after the update should be 100. is it? What is the value of @@trancount? From (another) QA window, can you: select count(*) from genderpercentage where percentagefemale = 1 or: select count(*) from genderpercentage (nolock) where percentagefemale = 1 Cheers, - Mark
2003-08-19
The destination file doesn't have to exist. In my testing I created one from the DTS package. Cheers, - Mark
2003-08-19
1 reads
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers