what is the difference between SQL and ANSI SQL?
does select statement come under the category of Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL.
USE [master]
GO
/****** Object: Database [assist] Script Date: 11/13/2010 20:17:49 ******/
CREATE DATABASE [assist] ON PRIMARY
( NAME = N'assist', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.THIRD\MSSQL\DATA\assist.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'assist_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.THIRD\MSSQL\DATA\assist_log.LDF' , SIZE = 504KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
In the above, what do the following terms mean/usage.
GO?N' within this statement "NAME = N'assist', FILENAME = N'C:\Program Files"
I have a Linked Server which was made using SQL Server Management Studio 2008.
If the linked server destination changes, I will have to change the properties of it to direct to the right place.
But I cannot - there is no edit option!
Am i missing something, or can Linked Servers not be altered?
I saw this in logins: computername/username and I deleted it! Now I cannot log into SQL/Server Management Studio 2008. Mixed mode is not enabled, so I cannot use the sa account because it's disabled by default.
What should I do to bring the user login back now it has been deleted? I don't want to re-install everything.
by using microsoft sql server management studio