Hello, I am trying to set up a linked server in SQL Server 2000 Standard to an Access 2000 database called ‘MMTestEntry.mdb’. The Access databases uses Access security. The System.MDW file is located at C:\Program Files\Microsoft Office\Office\System.mdw. My login to SQL Server is a Windows domain account, Valverde\cdunn. I have an account for Access called ‘cdunn’ with […]
2004-02-12
6 reads
This morning the server had no response (timing out queries and and enterprise manager). We shut down sql server, and proceeded to reboot the box. After that happened, and SPID is blocking one of the databases (OEN Lists) doing analysis and recovery. The message I get right now is: Recovery of database 'OEN Lists' (8) […]
2004-02-12
71 reads
Yes, RAID 10/01/1+0/0+1/SAN/etc. would be nice, but of the choices given ... RAID 5 advocates need to remember that the log needs to do flat-out writes as fast as possible. A log I/O is the single disk I/O event that a user ever has to wait on synchronously, so you basically need to optimize for […]
2004-02-10
1 reads
After creating several indexes on several tables on a different filegroup from the table data, I ran DBCC CHECKDB and got an 806 error. What are my options after DBCC CHECKDB('<databasename>', REPAIR_WITH_DATA_LOSS)errored out again?
2004-02-10
2 reads
Jeff,You didn't say what version you're using, but check the FAQ's here: http://qa.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=154 There are two links from there to Microsoft's site depending on whether you're using SQL Server 7 or 2000. I've used the procedure on Microsoft's site for 7 with success several times. 12 Gig's sounds pretty large for a TL file. How […]
2004-02-10
Do you have sysadmin priviliges? If not, as someone with sysadmin to try. Also, try this... although I don't think it will work.Use MasterEXEC sp_Helptext 'Information_Schema.Tables'
2004-02-10
you can just populate a log table with select Last_Disp , Kount=count(*) ,en_date=getdate() from dbo.vw_AZ_Leads_Dialable group by Last_Disp also its more general ,and works even if you add more Last_Disp types ,regards john ,nb sorry I was bit bussy but you are really good programmer
2004-02-10
1 reads
Microsoft has released a new tool to analyzer your SQL Servers and see how they conform to their list of common best practices. Give it a try and let us know what you think.
2004-02-10
3,515 reads
Excellent information. I too have been "thinking" about certification and the clarity provided inthis article has given me the motivation to go the next step.I wonder if there is a chance to "update" the information in the article, say every 6 mths as there is always new software / exams coming out.Again thank you for […]
2004-02-09
1 reads
Hi Bill,I think , u must describe ur database design first.i.e. how are u storing ur month in database table.Nitin
2004-02-09
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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