The company I work for has recently decided to use Source Safe on all of our DTS packages. To do this we save the package down as a .dts file and check it into SS. We've ran into a bump in the road though. When saving as a .dts file, we lose all of the […]
2001-08-27
3 reads
Every once in a while the SQL ServerAgent (SQL 7) stops unexpectedly. How can I use DMO to check if the service is running, and better yet, to notify me, if it fails? TIA, Bill P.S. I have selected the "Autorestart Agent" option but it doesn't work reliably.
2001-08-24
8 reads
hello andy, what i mean by not displayed is that the value for that particular field is being shown as <"Long Text"> and nothing else will try convert ok will let u know if something clicks by using convert thanks keyur
2001-08-17
Does anybody know how can I execute SQL instruction that stored in local variable. For example @var='SELECT AuthorName from Authors'. Variable stoging gives me ability to create dynamic queries.
2001-08-12
3 reads
Recently while working on the SQLServerCentral.com site, Leon Platt ran into an interesting ADO gotcha that he demonstrates in this quick tip.
2001-08-10
3,418 reads
My ASP file doesn’t access my database." "I can’t connect to my database from my code." "I’m having problems calling and debugging stored procedures." These are some of the problems I hear every day as a Microsoft® developer support engineer.
2001-07-20
2,008 reads
Hello, I've created the alert for Memory-Pages/sec Alert Over 2 in Performance Monitor, I'm getting net send message as Pages\sec is being over 2. I'm confused and what should I do to overcome it. My production server has 523 MB Ram and I've specified SQL Server to use memory dynamically setting max as 440 MB. […]
2001-07-19
8 reads
Before I start Im a novice SQL user. I have instlled MSDE which is a cut down version of SQL 7.0 I have installed SP3. I have created a DB Projectsql, I have created a role called "Project" I have added two NT users DOMAIN\Barbie and DOMAIN\Ken to the role 'Project'. I have granted the […]
2001-07-17
2 reads
2001-07-16
2 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/lplatt/pseudowebserviceusingxmlhttp_1.asp
2001-07-16
5 reads
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