MS SQL

The Common Language Runtime (CLR) is the virtual machine component of Microsoft's .NET initiative. It is Microsoft's implementation of the Common Language Infrastructure (CLI) standard, which defines an execution environment for program code. The CLR runs a form of bytecode called the Common Intermediate Language (CIL, previously known as MSIL -- Microsoft Intermediate Language). Developers [...]

Run from Query Analyzer: USE master SELECT name, DB_ID(name) AS DB_ID FROM sysdatabases ORDER BY name <!-- -->

From Query Analyzer run: SP_SPACEUSED <!-- -->

To check the timeout, look in the menu Tools - Options - Advanced. However, by default it should be set to 0, which means do not timeout <!-- -->

ABORT -- abort the current transaction ALTER DATABASE -- change a database ALTER GROUP -- add users to a group or remove users from a group ALTER TABLE -- change the definition of a table ALTER TRIGGER -- change the definition of a trigger ALTER USER -- change a database user account ANALYZE -- collect [...]

  On MS SQL 2008 databases, Full-Text indexing is already enabled on the database.  For MS SQL 2005 please contact us with the request and your database name and database server name so we can enable it if needed on your specific database. You would then create your full text catalog either through SQL Management [...]

 MS SQL 2005 Will not install on Windows 2008 server and as a result you will get the following warning message. SQL Server Edition Operating System Compatibility (Warning) Messages:SQL Server Edition Operating System Compatibility Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software [...]

To download Microsoft SQL Server Management Studio (SMS) please visit: http://www.microsoft.com/express/sql/download/default.aspx and click the download link that says SQL Server Management Studio Express. If you run a VPS or a dedicated server and would like to run SQL Server 2005 Express edition, it can be downloaded for free from the same location. <!-- -->

ERROR: Error message 1 Data has changed since the Results pane was last retrieved. Do you want to save your changes now (Optimistic Concurrency Control Error) Click Yes to commit your changes to database anyway. Click No to discard your change and retrieve the current data for this row. Click Cancel to continue editing. Note [...]