SqlServerKudos

SSMS

2
kudos

Kudos

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

published 9 days, 19 hours, 44 minutes ago posted by

sa 18 days, 20 hours, 45 minutes ago

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

Managing multiple instances of SQL Servers and databases is a challenging task, having a third party tool is not a problem however it is always BEST to manage the show using SQL Server Management Studio (SSMS). SQL Server tools are easy to use and help to manage multi-server management through automated multi-server jobs, event forwarding and the ability to manage multiple instances from a single-machine console. Since SQL Server 2008 R2 version (and SQL Server 2008 SP2) onwards the SSMS tool has...(read... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: #sql2k8r2cookbook, beginners, best practice, cookbook, data tier, DBA, management, SQL Server, SSMS, ucp, utility control point

1
kudos

Kudos

SQL Server Manageability Series: upgrade of client tools and error: The File %CommonDir%\dte80.olb could not be loaded #sql #ssms #sqltools

published 218 days, 13 hours ago posted by

sa 228 days, 12 hours, 37 minutes ago

$SQL Server Manageability Series: upgrade of client tools and error: The File %CommonDir%\dte80.olb could not be loaded #sql #ssms #sqltools$

For all my consulting tasks I prefer to use SQL Server 2008 R2 Management Studio provided the involved instances are on version 2005 or higher. Recently I bought a new laptop and in process get all necessary tools installed so that I can make use of this new 'beefy' machine , usually my habit is to install the SQL Server instances (versions from 2000 till 2008 R2). In this process I have successfully installed all the instances and tools, but when I have opened the SQL Server 2008 R2 Management Studio...... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: BOL, code examples, file search, installallation, Management Studio, SQL Server, SSMS, system32, Tools

1
kudos

Kudos

SQL Server DBA practices: Show or hide specific table in management studio?

published 342 days, 20 hours, 41 minutes ago posted by

sa 351 days, 22 hours, 12 minutes ago

SQL Server DBA practices: Show or hide specific table in management studio?

During a recent DBA consulting engagement one of the users at a client posed a question stating, "how do we hide certain tables on Management Studio even though the set of users do need read/write privileges on those tables?". For a moment I was thinking permissions and privileges to set out, but there is more to the question asked above. As it states the users do have required permissions on those tables. The mentioned tables consist confidential information about the monetary transactions where...(read... (more)

category: News | clicked: 2 | comment | | source: sqlserver-qa.net

tags: beginners, Best Practices, DBA, executesql, Management Studio, SQL Server, SSMS, TSQL

1
kudos

Kudos

SQL Server agent: Property pagersendsubjectonly is not available for alert system this property may not exist for this object or may not be retrievable due to insufficient access rights.

published 386 days, 23 hours, 53 minutes ago posted by

sa 395 days, 15 minutes ago

SQL Server agent: Property pagersendsubjectonly is not available for alert system this property may not exist for this object or may not be retrievable due to insufficient access rights.

Do you see this error in your environment? Is it a frequently occuring issue? In the recent time in a 64 bit environment we started to get this alert generated and DBAs complaining sometimes are unable to view the SQLAgent jobs on that remote server. If we observe the error text it clearly states " ....this property may not exist for this object or may not be retrievable due to insufficient access rights ". The first part is property may not exist for this object which means a tools problem and to...(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: access, permissions, property, rights, Security, SQL Server, SQL Server Agent, SSMS

2
kudos

Kudos

SQL Server discovery: How to find edition of SQL Server without connecting to that instance?

published 393 days, 10 minutes ago posted by

sa 402 days, 1 hour, 55 minutes ago

SQL Server discovery: How to find edition of SQL Server without connecting to that instance?

This is an interesting question in the recent times that I have seen in the forums, that how to find such information even without connecting to that SQL instance. There are plenty of ways to get information about SQL instance name using OSQL -L or find about odbc32.dll to get list of SQL names if they are registered. Also the local instance is resolved by registry entry and remote instances are resolved by UDP broadcast (port 1434), using sqlbrowser -c can help some extent to obtain the information....(... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: discovery report, installallation, instance, port, Security, SQL Server, SSMS, Tools

2
kudos

Kudos

Feature pack for SQL Server 2005 SP4 - collection of standalone packages

published 398 days, 35 minutes ago posted by

sa 407 days, 2 hours, 15 minutes ago

Feature pack for SQL Server 2005 SP4 - collection of standalone packages

With the release of SQL2005Sp4 an additional task is essential for DBAs & Developers to avoid any compatibility issues with existing code agains SP4 instance. Feature pack for SQL Server 2005 SP4 is available to download which contains the standalone packages such as SQLNative Client, ADOMD, OLAPDM etc.... as it states the feature pack are built on latest versions of add-on and backward compatibility contents for SQL Server 2005. The above link provides individual file to download for each environment...... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: ado.net, downgrade, download center, feature pack, olap, performance dashboard, SQL Server, sqlncli, SSMS, Tools

2
kudos

Kudos

SQL Server 2005 Express Edition Service Pack 4 - download and test to deploy.

published 401 days, 50 minutes ago posted by

sa 410 days, 2 hours, 31 minutes ago

SQL Server 2005 Express Edition Service Pack 4 - download and test to deploy.

When I blogged about SQL2005SP4 RTM release I had a flurry of emails asking about SQL Server 2005 Express Edition service pack 4 status. Well SQL2005 Express SP4 [ KB2463332 ] is also availabel for download now to test against your production instances (you need to apply even though you use Express edition as a WITNESS instance for database mirroring pair). As you are aware SQL Server Express or SQL Express with Advanced Services is a free & light-weight version of SQL Server 2005 which is popular...(rea... (more)

category: News | clicked: 3 | comment | | source: sqlserver-qa.net

tags: Best Practices, deployment, Documentation, downgrade, download, sp4, sql express, SQL Server, SSMS, ssmse

2
kudos

Kudos

Error 18456: Login failed for user. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.

published 414 days, 1 hour, 46 minutes ago posted by

sa 423 days, 3 hours, 27 minutes ago

Error 18456: Login failed for user. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.

This is a new error in this environment when I tried to logon, SQL Server 2008 SP1 Standard Edition 64-bit running on Windows Server 2008 R2. The complete text of the error is: Error: 18456, Severity: 14, State: 11 Login failed for user 'DOMAIN\user'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors . But there were no issues to access the database information on this instance, other than this annoying error reported via monitoring software...(re... (more)

category: News | clicked: 2 | comment | | source: sqlserver-qa.net

tags: 18456, DBA, error, Information, Login, new features, Security, severity, SQL Server, SSMS, UAC, Windows Server 2008

1
kudos

Kudos

How-to and easy way to install SQL Server client tools to your desktop

published 422 days, 2 hours, 17 minutes ago posted by

sa 431 days, 3 hours, 52 minutes ago

How-to and easy way to install SQL Server client tools to your desktop

The installation process for SQL Server has been changed since 2005 version. In addition to SQL Server 2008 release that process has been fine tuned to deliver the required tools & services to install with a number of new options and resources for completing the installation, just for simplification. The installation process may not be the same in an enterprise network as you follow on your personal desktop or laptop. In case of restricted access and privileges to install required tools, in this...(read ... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: Best Practices, BIDS, client tools, DBA, enterprise manager, installallation, SQL Server, SSMS, versioncontrol

1
kudos

Kudos

Cumulative Update package 4 for SQL Server 2008 R2 released

published 464 days, 6 hours, 19 minutes ago posted by

sa 473 days, 8 hours, 3 minutes ago

Cumulative Update package 4 for SQL Server 2008 R2 released

SQL Server 2008 R2 has got another instalment of Cumulative Update 4 package release, that contains the hotfixes that have been packaged since the release of R2 RTM release. The build number for this release will be 10.50.1746.0, by default these builds are cumulative and release contains all the security fixes that were included in the previous CU release. So it is always better to download and test each of these CU packages seperately if you are facing such issues on SQL Server 2008 R2 instance....(rea... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: best practice, cu4, cumulative update, download, encryption, Master Data Management, MDS, parallel data warehouse, SQL Server, SSMS, tde, Testing

1
kudos

Kudos

SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!

published 745 days, 4 hours, 44 minutes ago posted by

sa 751 days, 16 hours, 35 minutes ago

SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!

It is a common criteria that using Dynamic Management Views (DMVs) you can easily obtain the system & database state on a SQL instance. It may not be easy for a starter DBA to ensure what kind of DMV is used to obtain information on Recent Expensive Queries, if so for you Activity Monitor is the tool to obtain information about SQL Server processes and how these processes affect the current instance of SQL Server. [This topic is pre-release documentation and is subject to change in future releases....(re... (more)

category: News | clicked: 0 | comment | | source: sqlserver-qa.net

tags: best practice, database tuning advisor, execute plan, Management Studio, Performance, Query, SQL Server, SSMS

1
kudos

Kudos

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

published 747 days, 4 hours, 54 minutes ago posted by

sa 753 days, 8 hours, 40 minutes ago

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

No doubt that the error on subject line will get no where! This is presented when trying to open a Database Properties using SQL Server Managment Studio, going back to history on the SQL instance where this is presented is an upgraded database instance having upto date service packs (SQL Server 2008 SP1) with no cumulative update packages. Further information on full error text is below: Access Object Collector error: Database Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngin... (more)

category: News | clicked: 1 | comment | | source: sqlserver-qa.net

tags: access, dll, error, Management Studio, path, registered, sp_configure, SQL Server, SSMS, system

1
kudos

Kudos

Extended Properties in Object Explorer Details – Vote on Connect

published 862 days, 14 hours, 4 minutes ago posted by

sa 872 days, 12 hours, 41 minutes ago

Extended Properties in Object Explorer Details – Vote on Connect

After a discussion with a friend of mine, I’ve opened a suggestion on Connect to request to have Extended Properties visible in the main Object Explorer Details window. This will be especially useful for creating self-documenting database, since that window can easily provide additional information about, for example, column in a table or in a view and so on. Just image to have all the available Extended Columns in this list to be selected: If columns’ Extended Properties will contain a Descriptio... (more)

category: Management | clicked: 1 | comment | | source: sqlblog.com

tags: Connect, SSMS

1
kudos

Kudos

SQL Server 2008 Object Explorer Details

published 872 days, 14 hours, 49 minutes ago posted by

sa 879 days, 13 hours, 17 minutes ago

Ok, maybe this post contains information that anyone already knows, but since I just discovered the SQL Server 2008 Object Explorer Details’ features today, maybe other people are in the same situation. In older version of SQL Server the Object Explorer Details window was simply not useful at all since it just replicate what you can see in the Object Explorer treeview. So I never used it. This morning, doing some work for the Italian SQL Server UG, I pressed F7 instead of F8 to open the Object Explorer... (more)

category: Management | clicked: 0 | comment | | source: sqlblog.com

tags: Object Explorer, SSMS

1
kudos

Kudos

Directly Opening a Solution in SQL Server Management Studio

published 879 days, 15 hours, 22 minutes ago posted by

sa 887 days, 9 hours, 37 minutes ago

Directly Opening a Solution in SQL Server Management Studio I use Solutions a lot in SQL Server Management Studio (SSMS), and you should be aware of this simple tip: If you want to open a Solution without having to open SSMS and then jumping through all the menus, just double-click the solution name in the Windows folder. It will automatically open the Solution and SSMS at the same time. This tip, by the way, also works with any .SQL files, unless you've installed another product that has that file ass... (more)

category: Management | clicked: 0 | comment | | source: blogs.msdn.com

tags: DBA, Developer, Development, SQL Server, SQL Server Management Studio, SSMS, Tips

1
kudos

Kudos

PBM – it’s like liquid awesome!

published 879 days, 15 hours, 22 minutes ago posted by

sa 887 days, 11 hours, 50 minutes ago

Brent Ozar and Thomas LaRock do a 3 part video series on the power of Policy-based Management (PBM). Interestingly SCOM comes up several times in the discussion. They cover the basics of PBM and Thomas goes into more depth on how he’s using it in his environment. The series is about 35 minutes in total. Regardless of your PBM experience level I highly recommend watching these videos. http://thomaslarock.com/2009/08/policy-based-management-podcast-part-1/ http... (more)

category: Management | clicked: 0 | comment | | source: blogs.msdn.com

tags: Management Studio, Policy, SSMS

1
kudos

Kudos

Management Studio Error - Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'

published 886 days, 13 hours, 12 minutes ago posted by

sa 892 days, 8 hours, 13 minutes ago

Management Studio Error - Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'

Just ran into this problem last week, and couldn't find any information about this online. The only MSDN forum solution I can find only suggests uninstall and reinstall SQL Server, which I did and still failed! And I finally found the solution of this problem.... Turns out that the Microsoft.SqlServer.DataStorage.dll assembly is somehow replaced or misversioned in my GAC, due to some other installation I did in the past. What I had to is to find ano... (more)

category: Management | clicked: 10 | comment | | source: blogs.msdn.com

tags: SSMS, Troubleshooting

1
kudos

Kudos

SQL 2008 R2 Breaks SSMS Addins

published 888 days, 3 hours, 31 minutes ago posted by

sa 894 days, 9 hours, 23 minutes ago

If you are trying out SQL Server 2008 R2 CTP2 and you are a frequent user of Addin’s for SSMS like the SSMS Tool Pack or the SQL Server 2008 Extended Events Addin that I wrote, you will notice almost immediately that the Addin’s will not work and raise a couple of exceptions. This is because as previously mentioned in my blog post about the Devenus SQL.CLR Addin, SSMS Addins are not a supported feature by Microsoft, so there is no guarantee that code will work from build to build of SQL Server. Until r... (more)

category: Management | clicked: 11 | comment | | source: sqlblog.com

tags: Addins, SSMS

1
kudos

Kudos

Introducing: Extended Events Code Generator v1.0

published 915 days, 15 hours, 59 minutes ago posted by

sa 919 days, 6 hours, 59 minutes ago

Introducing: Extended Events Code Generator v1.0

SQL Server 2008 Extended Events. It's a high-performance, feature-rich, and extremely useful tracing system. Too bad it's so difficult to figure out how to use it! Or is it? Earlier this week Jonathan Kehayias announced his SSMS addin for Extended Events, which makes it super-easy to create and manage events, and even view the raw event data. It's all done via a simple UI, so if you don't have time to learn how to do all of that stuff with the Extended Events DML and DMVs, no worries. But what if you ... (more)

category: Management | clicked: 2 | comment | | source: sqlblog.com

tags: Extended Events, SSMS

1
kudos

Kudos

Code Collapse and Expand Feature in SQL Server Management Studio 2008

published 915 days, 15 hours, 59 minutes ago posted by

sa 919 days, 10 hours, 3 minutes ago

Code Collapse and Expand Feature in SQL Server Management Studio 2008 In SQL Server Management Studio 2008, whenever you have a "block" of code (BEGIN....END, etc) SSMS will put a little plus-sign in the margin and allow you to "collapse" that block of code so you only see the BEGIN, not stuff underneath. If you're working with a really large set of code, that's helpful. But I got an e-mail from a friend that said her SSMS didn't do that. I was kind of surprised, since I never had to do anything to mak... (more)

category: Management | clicked: 17 | comment | | source: blogs.msdn.com

tags: DBA, Developer, Development, SQL Server, SQL Server 2008, SQL Server Management Studio, SSMS, Tips

Welcome!

SSMS

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

SQL Server Manageability Series: upgrade of client tools and error: The File %CommonDir%\dte80.olb could not be loaded #sql #ssms #sqltools

SQL Server DBA practices: Show or hide specific table in management studio?

SQL Server agent: Property pagersendsubjectonly is not available for alert system this property may not exist for this object or may not be retrievable due to insufficient access rights.

SQL Server discovery: How to find edition of SQL Server without connecting to that instance?

Feature pack for SQL Server 2005 SP4 - collection of standalone packages

SQL Server 2005 Express Edition Service Pack 4 - download and test to deploy.

Error 18456: Login failed for user. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.

How-to and easy way to install SQL Server client tools to your desktop

Cumulative Update package 4 for SQL Server 2008 R2 released

SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!

Unable to cast COM object of type 'Microsoft.Office.Interop.Access.Dao.DBEngineClass' to interface type 'Microsoft.Office.Interop.Access.Dao._DBEngine'

Extended Properties in Object Explorer Details – Vote on Connect

SQL Server 2008 Object Explorer Details

Directly Opening a Solution in SQL Server Management Studio

PBM – it’s like liquid awesome!

Management Studio Error - Method not found: 'Void Microsoft.SqlServer.Management.UI.Grid.ColumnInfo.set_ServerVersion(Int32)'

SQL 2008 R2 Breaks SSMS Addins

Introducing: Extended Events Code Generator v1.0

Code Collapse and Expand Feature in SQL Server Management Studio 2008

Open ID Login

Standard Login

Forgot Password?

Sign up