Group items tagged

"Tired of querying in antiquated SQL? Well, you don't have to! LINQPad lets you interactively query databases in a modern query language: LINQ. Kiss goodbye to SQL Management Studio! LINQPad supports everything in C# 3.0 and Framework 3.5, and more: * LINQ to Objects * LINQ to SQL and Entity Framework * LINQ to XML * WCF Data Services & SQL Azure * LINQ to SQLite and MySQL Enterprise Server * Mindscape LightSpeed ORM * (Even old-fashioned SQL!)"

Changing the default SQL Server backup folder

Changing the default SQL Server backup folder

It's hard to find SQL Server 2008 Express files that are not R2 so here's the original DB

"SQL Server Session State Problems"

"To change the DB_Owner to some another "Database Principal"; simply Drill Down to your Database in Sql Server Management Studio and further more Drill Down to your_DB_Name > Schemas > db_owner > right click > select properties. You would find the name of the "Database Principal" that you want to delete. Change this to some another "Database Principal"; for Example, to "dbo"."

" When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the Database Management Studio will not allow you to save the changes."

Apparently, the reason I was recieving the Internal Server error message was that I had installed SQL Server 2008, after installing Visual Studio 2010, and because of this it corrupted the IIS Machine level configuration files ("If you install VS2010 and then install VS2008 and VS2008 SP1, the configuration files for ASP.NET in IIS only include about 1/2 of the correct .Net 4.0 configuration sections." read more here).

Samples of every connection string type for every driver

Wikipedia for SQL Server

STEP1: select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid where d.name = 'YOURDBNAME' STEP 2: kill STEP 3: exec sp_dboption 'YOURDBNAME', 'single user', 'FALSE'

MyDB Studio is a complete collection of powerful tools for MySQL Server administration.