If we have a stateful connection (RDS) and the database fails how will the application reconnect. I do not believe that our application was written using MSCS API. Therefore I don't believe that it caches the user logon and password to log back into the session. So, my question is can the application work with […]
2001-08-02
5 reads
Designing your application so that Stored Procedures are the only database objects that are accessed is generally the best practice. Agree? Disagree? Read this article by guest columnist Mindy Curnutt to see what she thinks!
2001-08-01
12,462 reads
I've recently had my machine rebuilt and reinstalled SQL 2000 and SP1. When I go into existing DTS packages I get a message DTS Designer Error |||||| and the task selection area is blank. Also only register and unregister custom tasks are available from the menu line. Any ideas?
2001-07-31
6 reads
I got the following questions from a reader and was hoping to get some responses from the world out there. At this moment in time, i'm pursuing a bachelors in computer science and i would like to know what's it like working as a DBA? what is the entry level at which u join a […]
2001-07-27
2 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
Is there any way to customize the error message of a Check Constraint? SysMessage 547 is quite complex for a simple User.
2001-07-17
2 reads
Using VB code generated from scriptpkg, I have created an ActiveX DLL which imports a given data source into a SQL 7.0 table. The Threading Model of the VB project is set to "Single Threaded" and the ExecuteOnMainThread properties (one for the Source Connection, and one for the Destination connection) within the DTS scripting is […]
2001-07-09
2 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/lsmith/storingandretrievingbinarydatainsqlserver.asp
2001-07-09
6 reads
If you’re a programmer, you know that SQL is becoming more and more prevalent. Here’s a guide to one of its basic building blocks the stored procedure.
2001-07-09
4,417 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/rsharma/droppingadatabase.asp
2001-07-05
10 reads
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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