I have two named instances in my SSMS using SS08
If i connect to both instances
Both Instances have same DB (Cars)
If i open a Querry window and create a table with following syntax(attached Code Snippet)
A Table was created in Instance SYED but not in DEVDB ?
Why so ?
How do i direct the operations/Commands to a particular Instance ?
I have two instances SYED and DEVDB (attached Image)
CREATE TABLE Rental_Cars
CarID INT NOT NULL ,
brandname VARCHAR(20) NULL ,
modelname VARCHAR(30) NULL ,
manuf_year INT NULL,
CONSTRAINT PK_Rental_Cars PRIMARY KEY CLUSTERED (CarID ASC)