If it's a named instance, you'll need to open UPD port 1434.

As an alternative, you can connect to the server by specifying only the server name with no instance and...

This is a well known issue. In SQL Server 2012...

You probably get a different plan in SSMS compared to the application.

See this article for more info:

http://www.sommarskog.se/query-plan-mysteries.html

To connect to a local SQL Server instance you can use one of these syntaxes:

(local)\MY_SQL_INSTANCENAME

.\MY_SQL_INSTANCENAME

Usually, from the local machine you use "shared memory" as trasport protocol for your SQL Server connections. Can you check if this is enabled in the SQL Server configuration manager?

Is...

Which issues? No sensible advice can be given if you don't provide enough details

http://sqlserverupdates.com/

Enter your email in the box on the right.

There must be at least one sysadmin user able to grant permissions to you or any other user to perform the actions you need.

Normally, when you install SQL Server, you...

Luis Cazares (8/24/2015)

---

That seems to happen when new users post links or lots of code and are in the spam filter. Seems like the posts are under review and might...

Hi all!

Long time no see... I've been away from the forums lately and I have 650 unread posts on The Thread (which I won't even try to catch up...

You need to set up something to capture the information at regular intervals and compare to previous snapshots. That something could vary between a custom SQLAgent job to a custom...

There's no way around it: some features don't work correctly or are completely missing with older versions of SSMS.

Talk with your desktop support team and let them know how...

Spam, reported

Glad I could help. The trick here is SET NOCOUNT on to suppress the "x rows affected" messages and -h -1 to suppress column headers.

?