Sweet SQL Lass: "I can't take this database offline!" An anguished cry, which I have heard twice today. The problem is, if you try to take a database offline, it will not actually complete until the current transaction has ended (or been forcibly killed), as there is a lock on the database.
UPDATE: For working example using AdventureWorks visit : SQL SERVER – Simple Example of Cursor – Sample Cursor Part 2 Simple Example of Cursor | Journey to SQL Authority with Pinal Dave
Using Extended Properties on Database Objects In using extended properties, you can add text, such as descriptive or instructional content, add input masks, and add formatting rules as properties of objects in a database or of the database itself. For example, you can add an extended property to a schema, a schema's view, or to a column in the view. Because extended properties are stored in the database, all applications reading the properties can evaluate the object in the same way.
Reporting Services is a collection of server and client applications used for business reporting. You can install server components on a single computer or on multiple computers. New Installation (Reporting Services)
parsing - How to strip all non-alphabetic characters from string in SQL Server
Introduction Migrate MySQL to Microsoft SQL Server
6 Reference Manual :: 220.127.116.11 GRANT Syntax
By Bill Graziano on 6 August 2007 | 6 Comments | Tags: Identity, INSERT Identity columns are commonly used as primary keys in database tables. How to Insert Values into an Identity Column in SQL Server
Best approach to remove time part of datetime in SQL Server
ADO Connection Strings Overview Generally, one of the first steps when you are trying to work with databases is open it.
Caché - World's fastest high performance object database
asp.net - Entity Framework v2 doesn't support sql 2000
public static StreamWriter AppendText( string path ) Parameters path AppendText Method
Also available on tomjewett.com: color tutorial, demo application, and video; for Web accessibility resources and consulting, please see The Enabled Web. This third edition of dbDesign is a general update, both to meet legal requirements for U.S. “Section 508” accessibility and to bring the code into compliance with the latest World Wide Web Consortium standards. Database Design - Introduction
By Sean Baird on 12 September 2000 | 21 Comments | Tags: Identity Kim writes: "with an identity column you can SELECT @@identity after inserting a row. How do you get the value of a uniqueidentifier column after an insert? Uniqueidentifier vs. IDENTITY
Understand Lambda Expressions in 3 minutes What is a Lambda Expression? A lambda expression is an anonymous function and it is mostly used to create delegates in LINQ.
The Visual Studio 2010 IDE does not support connecting to SQL Server 2000, including not allowing connections from the ADO.NET Entity Framework designer. However, the ADO.NET Entity Framework 4 runtime continues to offer support for running with SQL Server 2000 databases. Using Entity Framework 4 with SQL Server 2000 Databases
sql - Is there common street addresses database design for all addresses of the world
internationalization - What is the "best" way to store international addresses in a database
Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database « Journey to SQLAuthority UPDATE : SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database This is very long query. Optionally, we can limit the query to return results for one or more than one table.
Foreign Keys between databases - Microsoft SQL Server answers
Filtering SQL Server Columns Using Column Level Permissions Problem I have a table where some of the columns should not be queryable by all users. How can I filter the data appropriately so that not everyone can select the data?
Best practices for storing postal addresses in a database (RDBMS)
Alter Schema – Move object to another schema
Time and Date
Cross-database foreign key references are not supported. Workaround? in SQL Server Programming Asked By Charles Law on 07-Jan-08 11:53 AM