What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0.
2001-08-09
1,435 reads
This article will demonstrate how to monitor active spids, blocked by spids,cpu,I/O,cmds and app name being issued in a real time fashion by using the cmd shell calling a T-SQL script and a resource kit utility.
2001-08-07
49 reads
SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition.
2001-08-03
3,578 reads
This document introduces SQL Server administrators and developers to the new security features of SQL Server 2000. In addition to outlining the new features, there is a detailed discussion about how to best implement security in a Microsoft Windows® 2000 domain environment as well as source code examples.
2001-08-02
1,383 reads
In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000.
2001-07-27
1,539 reads
Are you responsible for keeping your organization's database systems up and running? Are you the one they call in the middle of the night if the database server is down? If so, the SQL Server 2000 Operations Guide is for you.
2001-07-24
933 reads
Our first contest will begin July 23rd! We’ll be giving away a free Wrox book titled: SQL Server 2000 Database Design
to the individual who refers the most users to SQLServerCentral.com throughout the duration of the contest. The contest will last from July 23rd until July 29th.
To insure that each referral counts, make sure that each person you refer has your SQLServerCentral.com registered email address. Good luck!
2001-07-23
60 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
WebCast! June 27, 2001 from 9:00am to 10:30am Pacific Time. Registration closes 24 hours prior to the event start time.
2001-07-17
4,327 reads
ne of the issues you face when building Web applications is handling the errors you encounter when interacting with a back-end database. I was recently working with someone to create a new Web site with SQL Server™, ActiveX® Data Objects (ADO), and ASP. Lots of little things came up that I thought were worth sharing with MIND readers, so I'll focus this column on what I learned from this experience and the solutions to many of the problems I faced.
2001-07-13
1,579 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers