|
|
Browse by Tags
All Tags » management studio ( RSS)
-
|
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...
|
-
|
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...
|
-
|
For any user manage the work with short-cut is desirable, for better productivity in your work (with UI tools) I always suggest to manage it by keyboard not with the mouse. Here is another block of SQL manageability series I want to cover based on feedback...
|
-
|
As a SQL Server user Object Explorer is one component that you will never miss when you are using SQL Server Management Studio, in specific from version 2005 onwards. As it states this connects to Database Engine instances, Analysis Services, Integration...
|
-
|
How many times you have faced the problems in installing SQL Server client tools? Have you ever tried to install latest version of SQL Server tools on previous version? Recently I have run into such a problem when installing SQL Server 2008 client tools...
|
-
|
What is the most required task when a DBA required to perform upgrade from previous versions? Complete understanding of the databases that are required to upgrade. Technical reference of upgrade path from previous version to the current one. Testing of...
|
-
|
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New A tape device is not detected by SQL Server Management Studio in...
|
-
|
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...
|
-
|
Good news for the Development DBAs to have a fature of searching for a particular object within the SQL database. The newest feature to SQL Server 2008 version will be 'object search'! Until now even for me I used to refer to ThisArticle to search...
|
-
|
Do you like color-coded alert say when you are executing a TSQL script or code against a SQL Server instance, say if its a production server with 'red' indicator or 'green' when it is on testing platform! I have no doubt in stating the...
|
-
|
Few times I get such error Snap-in failed with a long CLSID string mentioned in the subject above. On this client machine previously I have SQL Server 2000 tools and recently installed 2005 version too, instantly error: Snap-in failed to initialize Name...
|
-
|
In addition to the blog post SSMS-waiting-for-an-internal-operation-to-complete I have faced additional problems such as all the menus aren't displayed within SQL Server Management Studio from the same laptop. Other users within our team has observed...
|
-
|
Interesting popup message on the down-right corner of my laptop when I'm performing SQL Server tasks against a 2005 version database using SQL Server Management Studio (SSMS), displays the message " Microsoft SQL Server Management Studio is waiting...
|
-
|
One of the Developer complained that he is unable to create one file per object using Generating SQL Scripts within Management Studio. It is one of the good feature within SQL Server 2000 using Enterprise Manager where you can differentiate the objects...
|
-
|
How can you copy the database maintenance plans from one SQL Server instance to another SQL Server instance using 2005 version. Using the Database Maintenance plans has been increased since SQL Server 2005 is released, also lot more once Microsoft fixed...
|
More Posts Next page »
|
|