Tag: sql server

Community

Configuring and Managing SQL Mail

Perhaps one of the more compelling hands-off administration abilities of SQL Server is the SQL Mail capability. SQL Mail lets you send, receive and process mail from within SQL Server. The most common use of this is setting up the SQL Agent process to alert you to server conditions. Since many wirel

Community

Access 2000 – Useful Changes

The main difference you will notice when you open Access 2000 is the Objects Bar (see the next section for more details on this feature). Additionally, there are several welcome enhancements to the database window. A set of New Object shortcuts let you quickly create a new object or use the appropri

Community

Finding the Lost Identity

The IDENTITY property provides auto-generated values for a numeric column in your table based on initial (seed) and increment arguments that you supply. The first row that users insert into the table contains the value you supply as the seed argument in the identity column. As users insert new rows

Community

Devphiles

Devphiles Education-We are on the cutting edge in such areas as Active Server Pages, XML, DHTML, SQL, Java and Visual Basic. Our experts are holding the classes themselves. We conduct tests, and tailor individual trainingprograms. Basic training is available online while the more advanced classes ar

Community

Expanding Hierarchies

Microsoft has expanded the information about expanding hierarchies in SQL Server Books Online (BOL) since SQL Server 6.x. But the BOL solution merely displays the output; you can’t join the results with other views, tables, or results. My T-SQL coding solution fills this gap. Also, the solution I pr