Explore the FAQs

SQL Server

Using Triggers to "protect" data

Question:

There's a leak in database security, how can I protect myself from foulplay through a hole that is there by design ? Read More
SQL Server

Permissions

Question:

I created a new table in my SQL Server database but in DWMX I cannot get the tables to appear, why ? Read More
SQL Server

Creating a view

Question:

How do I create a view in SQL Server 2000 ? Read More
SQL Server

OLE and OLEDB Provider Error Codes (0x800xxxxx)

Question:

Where can i get a complete list of OLE / OLEDB Error codes and descriptions ?

Answer:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q168354&GSSNB=1

Read More
SQL Server

How do I add UK Dates to SQL Server?

This FAQ shows you how to set SQL Server to allow UK Date format using a simple stored procedure call.

 

Read More