The company that supplied the application built the queries into the front end. The company says it does not want anyone to have an idea of how its application works by looking at the SPs. A request for them to include a delete bit has been rejected as it was claimed that it involves rewritng […]
2003-06-16
I've actually fixed it myself. Looking in the Event Viewer on the server, it was complaining of insufficient memory. A quick reboot of the server seemed to do the trick and I can now the package again.
2003-06-16
1 reads
Hi sdidomenico, quote: Hi Frank, Please feel free to hook into any of my posts. I'm a developer with 20 years experience, but only 6 months of experience of SQL Server/ASP/ADO/VBScript/HTML and all that jazz. I'm a recovering Mainframe COBOL Flat File programmer. hmm,... an app that needs 30 minutes to run on a mainframe […]
2003-06-15
I've found that a locked bit isnt enough, I want to know who locked. Lots of times an app/connection will drop, leaving the lock bit set. We go with the userid of the user locking the record, either NT login or some internal login. To update you have to be that user, which means if […]
2003-06-12
I finally figured it out. Here is what I did. 1. Reinstalled SQL Server 6.5 on new machine and applied all service packs. Made sure that I gave the machine the same name as the old machine. Also made sure that I installed on the same drive as the old macine. During install I made […]
2003-06-09
strange. sounds like a bug somewhere. Is this ss2k? service pack? Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-03
what I do if I want to clean: - change name of SP,table,view with "delete_" string in front- after you are SURE you have talked this thru - make sure that your developers have a list of those changed names. - if no one complains for a given time period(that depends on your database type […]
2003-06-03
2 reads
Hi all Yep, had this problem too, it was a fresh install of sqkserver 2k ee then sp3, i didnt check if it was sp3 though (unfortunatly) and I didnt have the time to go back. Anyhow, the unload and lodctr.exe OP worked fine, BUT, I did have to reboot the server, a simple instance […]
2003-06-03
1 reads
SQLBill, Thanks for your note. The answer to your question is B. I'm trying to use Enterprise Manager to connect to a remote SQL Server. I am allowed to connect, via port 1433, but that isn't the issue. I have an internet access provider, COX,that is blocking traffic on port 1433 so I can't even […]
2003-06-02
1 reads
What program and are other clients having this trouble? K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-06-02
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...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
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