CODEWITHSUNDEEP
sql-serversql-server-2008ssmslinked-server
4 Leave Cover
4 Leave Cover

Reputation: 1276

create linked server without management studio

I've installed Microsoft SQL Server 2008 and only got the Database Engine, not sure what to do with it.

Is it possible to create linked server without Microsoft SQL Server Management Studio? Without the MSSMS, there is no GUI to create the linked server, so it could be script or command I guess. So how should I do it?

Upvotes: 0

Views: 233

Answers (1)

Ben Thul
Ben Thul

Reputation: 32687

Why choose? For as long as I can remember (going back to SSMS 2005), most dialogs have had a script button on them. So fill out the form and instead of hitting okay, hit the Script button and SSMS will show you the commands it would have ran. I often use this as a boostrap when I'm doing something I haven't done before. That is, I'll fill in the wizard, hit the script button, and then read the docs to see if I agree with everything it's doing.

Add linked server wizard

Upvotes: 2

Related Questions