I have a small application that runs on server 2003 and been running flawlessly for some time now. The server was taken down for maintenance (security patches and nortons added). When the server came back up my program ran and did its thing for 9 hours and then got this error message.Unable to load sql […]
2005-01-19
259 reads
I have a SQL app that used to be a MS Access app. The app creates snapshots of data. In the old MS Access version it would create a new mdb with each snapshot. The new app creates a new SQL DB with each snapshot, hence my Enterprise Manager DB list is rapidly becoming cluttered […]
2004-12-21
3 reads
We have a single 4 processor SQL Server 2000 Standard machine that is being used to it's capacity. We would like to upgrade to an 8 way processor box seamelesly. I've upgraded this machine before, but it is never seamless.We first get a good back up. Then we copy the database dumps to the target […]
2004-12-17
Sorry, I missed the part where you said it was a Pervasive database. I thought we were dealing with two SQL Servers.
2004-12-15
Comments posted to this topic are about the Question of the Day for 13 Dec 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=400.
2004-11-16
1 reads
hello all,I tried to integrate Sql server 2000 instance in the AC and came up with this message " sql server enterprise manager could not add server to the AC",(stored procedure sp_activedirectory_scp failed to to access registry key)Can anyone help out? pleaseAkan
2004-11-14
And in case you need it for your developers in written what Adam said, have a look at BOL for "IDENT_CURRENT". Also contains a nice example about the differences between each approach.
2004-11-06
Why am I installing it? Because it wasn't installed by default, or it was intentionally not installed. We haven't had need of it till this development round. I didn't install the server originally so aren't aware of the initial requirements or settings, all I know is that we needed it now It turns out I […]
2004-10-26
The only question I have is if you need to keep track of the cards that have been dealt. You wouldn't want a dealer playing a Second Ace of Spades in a later hand if the shuffle should not occurr between each play. If that is the case then you may want to store the […]
2004-10-26
2 reads
Apologies for being unclear, my mind was in 'generic' SQL mode, not SQL Server specific My intention was to say;How rows are physically stored does not necessarily guarantee in which order rows found by a query is returned .... unless you say ORDER BYThe fact that many skips 'order by' is in itself proof that physical structures indeed influences the […]
2004-10-26
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
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