RE: Restore MDF and LDF file
Hi, Make sure the version of SQL Server is the the same as the one you are trying to attach to. That includes Service Pak updates. Good Luck.
2003-05-08
Auditing
RE: Concurrent use of Stored Procedures
This is a typical concurrency issue that you often find in 'normal' programming. Just copycatting the semaphore or mutex idea from there, I would construct a table containing one record for each concurrency limited resource. For each procedure you want only a limited number of instances to run, you add one to the value when […]
2003-05-07
RE: Can't see all users (enterprise Manager)
No - the user was newly created in the DB. Tried refresh - even left i a day, still not visible!
2003-05-05
RE: Bring Trans Rep online during production hours?
Just had a brainstorm...what about this? 1) Create subscription database at subscriber 2) Backup publisher DB 3) Load publisher DB into subscriber 4) Create Pull subsription at subscriber and start syncing 5) Perform differential backup at publisher 6) Restore differential backup on subscriber while pull subscription is in place Will all transactions be at the […]
2003-05-05
1 reads
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
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