As the main article mentions, having a login name for SQL Server only lets you in the system's front door. To access a database, you need a username in that database, and to access objects in the database, your username must have appropriate...
One of my database tables contains information about companies. All the table's companies have a name, but only companies listed on the stock market have a code. I created a unique index on the company-name field and would also like to creat...
One of my tables contains meteorological measurements per minute (e.g., temperature and humidity), and I'm trying to use a GROUP BY clause to calculate a moving daily average per month for these measurements. I want to express this average in a...
Reported July 31, 2002, by...
Cesar Cerrudo discovered two vulnerabilities in Microsoft SQL Server 2000 and Microsoft SQL Server Desktop Engine (MSDE) 2000. The vulnerabilities are related to a buffer overrun and SQL injection. Microsoft released Security Bulletin MS02-038 ...
SQL Server Magazine UPDATE—brought to you by SQL Server Magazinehttp://www.sqlmag.com...
CertTutor.net UPDATE—brought to you by the Windows & .NET Magazine Network and CertTutor.net http://www.certtutor.net...
Reported July 24, 2002, by...