Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: SSMS
128 results found
Help! I Can’t Connect to Analysis Services in
SSMS
A few months ago, I installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS as well. While playing around with SSAS, I tried to open up SQL Server Management Studio (SSMS) and connect up to Analysis Services. The screenshot below shows how I
Author:
briankmcdonald
Date: 11/2/2010 Section:
Blog
tags :
Analysis Services
,
Brian K. McDonald
,
Connecting to SSAS using SSMS
,
no connection could be ma
,
SSAS
SQL Server “Denali”: SQL Server Developer Tools, codename ‘Juneau”
Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next version of SQL Server, codenamed " Denali ". Its purpose is to provide a single development environment for all database-related project types by br
Author:
jamserra
Date: 7/6/2011 Section:
Blog
tags :
Juneau
,
SQL Server
,
SQLServerPedia Syndication
,
SSDT
,
Visual Studio 2010
,
Denali
Displaying Line Numbers in
SSMS
You know what bugs me? Receiving an error message when running a query in SSMS, but not knowing the whereabouts of line 87. Well, I discovered an option that definitely warrants a blog post. In SSMS, you can display line numbers. In the SSMS toolbar, clic
Author:
ShawnHarrison
Date: 8/15/2011 Section:
Blog
tags :
errors
,
SSMS
Manage Reporting Services using
SSMS
Sometimes you’ll want to manage reporting services functionality through SQL Server Management Studio (SSMS). This would be the case if you want to manage Jobs (subscriptions), Security or Shared Schedules. To connect to your reporting services instance,
Author:
briankmcdonald
Date: 6/29/2010 Section:
Blog
tags :
Report Server
,
Reporting Services
,
Brian K. McDonald
,
SSMS
MDX and DMX Templates
One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA. Many of you probably use the T-SQL templates to quickly build common statements, but struggle with the syntx for their counterparts in these
Author:
AdamJorgensen
Date: 11/23/2009 Section:
Blog
tags :
DMX
,
SSAS Development
,
Templates
How do I get SSAS, SSIS, and SSRS to show up under Server type in
SSMS
?
I installed the 2008 developer edition and want to start working with SSAS. I don't see SSAS (or SSIS or SSRS) in the server type dropdown. I checked and the services are running. Do I have to configure something to make them visible to SSMS? I'm running
Author:
Christian
Date: 12/20/2010 Section:
Forum
tags :
configuration
,
setup
,
ssas
,
ssms
Dump MDX OLAP Query output to a relational table from
SSMS
I found two simple ways to dump MDX query output to a table and then dump the table data to excel file or text file as per need. The two methods are: 1. Using OPENROWSET Syntax : OPENROWSET('provider_name', 'datasource'; 'user_id'; 'password', {[ catalog.
Author:
artuladhar
Date: 5/16/2012 Section:
Blog
tags :
dump
,
file
,
MDX data
,
OLAP
,
output
,
query
,
Table
Import and Export Wizard in
SSMS
-- Step by Step
In this article I will show you how to use the import export wizard in SSMS. This article has two parts – 1. Importing data from an external source(Excel) into the sql server database 2. Exporting data from sql server database into an external source (Exc
Author:
indupriya
Date: 7/14/2010 Section:
Article
tags :
SSMS
,
Import and Export wizard
SQL Server Agent - Creating an instance of COM component with CLSID
Today, one of my team members faced an issue that I was not able to give the answer right away. The problem was, in SSMS while he was connected to DEV JOBs, he couldnt edit steps, as image below: First we started for privileges/permissions issue. But that
Author:
marcoadf
Date: 1/25/2012 Section:
Blog
tags :
@@version
,
2008
,
Creating an instance of the COM component with CLSID
,
r2
,
Server
,
version
Ups and Downs of Cases in
SSMS
2008
Recently I was working with client and they were discussing the pet peeves of some of the new intellisense features in SSMS. Now, Intellisense is a powerful tool to help developers be more efficient, but for professionals who haven’t had it for the last 1
Author:
AdamJorgensen
Date: 11/3/2009 Section:
Blog
tags :
SQL Server 2008
,
SSMS
,
T-SQL
Error when browsing cube in BIDS or
SSMS
: “An error 0xE0040200 occurred. No further information was provided.”
While working on an SSAS project today, I was scripting out some MDX calculations in the cube (year to date, month to date, previous year’s month to date, and previous year to date). I wrote the calculations and they looked perfect, but when I tried to br
Author:
DustinRyan
Date: 4/4/2011 Section:
Blog
tags :
error
,
SSAS
Fully Qualified Stored Procedures
The other day while working at a client site, we were creating SSIS packages that would execute using TSQL in order to load a database. We wanted to eliminate having a bunch of different shared data sources and then having to create configuration files fo
Author:
SMcDonald
Date: 11/3/2010 Section:
Blog
tags :
fully qualified
,
Pragmatic
,
Sherri McDonald
,
SSIS execute SQL Task
,
stored procedure
,
Harding coding
Clearing
SSMS
History
I've read a article about Clearing SSMS History and thought of sharing with community. The following is a series of manual steps that you need to follow to clear out the SSMS history: Close all open instances of SSMS on your workstation Depending upon you
Author:
meganathank
Date: 3/8/2011 Section:
Blog
tags :
SSMS History
Shortcut to enable Fullscreen in
SSMS
Today I was experimenting with the query results in Sql server management studio and saw this shortcut in he View menu of the SSMS. So in order to show full screen I tried the shortcut -- Shift + Alt + Enter. The same shortcut works to come out of the ful
Author:
indupriya
Date: 1/12/2011 Section:
Blog
tags :
Full screen shortcut
,
keyboard shortcuts
,
SSMS
Automatically open a New Query window in
SSMS
If we are used to the Query Analyser of SQL Server 2000, we might find it frustrating that the query window does not automatically come up when you start SSMS. You have to either press Ctrl+N or Click on New Query to start it up. Here is a way to start up
Author:
indupriya
Date: 7/29/2010 Section:
Blog
tags :
Query window
,
SSMS
The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my CASE statements. The error received was: None of the result expressions in a CASE specification can be NULL. It was a long T-SQL script (and a long
Author:
JoseChinchilla_SQLJoe
Date: 11/16/2011 Section:
Blog
tags :
case
,
case statement
,
Error
,
sqlserver
,
syntax
,
T-SQL
Improve your
SSMS
Interaction
Ever wanted to liven up your life some with some color in your day to day DBA duties. There are a few things you can do to make your SSMS an even better tool for your day to day and help keep you out of trouble. You can choose colors fro your connections
Author:
AdamJorgensen
Date: 2/20/2010 Section:
Blog
tags :
Cool Features
,
DBA
,
SSMS
Stop Splashing with -NoSplash
Many times when I'm teaching a class or working with a group, they express frustration at the load time for SSMS or BIDS. This is easily optimized by Using the NoSplash Command. All you need to do is Right Click on the application for either BIDS or SSMS
Author:
AdamJorgensen
Date: 11/23/2009 Section:
Blog
tags :
Configuration
,
Visual Studio
,
BIDS
SSIS: parallel processing not supported by analysis services processing task
I'm processing all the Dimensions related to the Cube through SSIS. I process the Cube separately once all the Dimensions have been processed. I use the SSIS component "Analysis Services Processing Task": - In the editor, I add the required Dimensions wit
Author:
amrit
Date: 3/22/2011 Section:
Forum
tags :
Enterprise Edition
,
Parallel Processing
,
SSAS
,
Standard Edition
,
Warning
,
SSIS
There is not enough space on the disk.
I haven't seen this exact error before, but I have seen similar issues about a year ago. At any rate, I see that you searched for low disc space, but did you happen to see what the space availability is for in the path your ReportServer and ReportServerTe
Author:
briankmcdonald
Date: 7/11/2011 Section:
Forum
tags :
administration
,
Brian K McDonald
,
disc space
,
sqlbigeek
,
ssrs
Good SQL Formatting tool
I know this thread is a bit old but one of the best free tools for SQL Server is SSMS Tools Pack ( http://ssmstoolspack.com ). Provides formatting, snippets, query execution history (which is a lifesaver if you've ever executed a query by accident and did
Author:
sqlchicken
Date: 2/21/2011 Section:
Forum
tags :
ssms
,
tools
SSMS Add-in for Analysis Services
A nice new little add-in available for SSMS on Codeplex . It helps with repetitive tasks involved with SSAS such as processing and deployment. As the site says, the goal for the Analysis Services Helper is to fill in gaps in the toolset inside SSMS, and d
Author:
jamserra
Date: 6/21/2011 Section:
Blog
tags :
SSMS
,
SSAS
Automating the Processing of a Measure Groups Index Using SSIS
In a recent post ( Processing a Measure Groups Index Using SSMS ), I showed you how to utilize SQL Server Management Studio to process just the index of a measure group. In this post, I am going to show you how you can script the processing index out and
Author:
briankmcdonald
Date: 12/7/2010 Section:
Blog
tags :
Brian K McDonald
,
Process Measure Group Index Using SSIS
,
SSIS
,
XMLA
,
SSAS
Why can't I make a data driven subscription?
The other day I was trying to create a data driven subscription for a specific report and I couldn't. For some reason after I applied my stored credentials to the data source in Report Manager, I could only create a New Subscription, but not a Data Driven
Author:
SMcDonald
Date: 11/21/2011 Section:
Blog
tags :
Data Driven Subscriptions
SSAS customized error processing
Sometime you want to load cube data irrespective of referential integrity issues. Suppose you are processing measure group data before corresponding dimensions then SSAS will throw error "The attribute key cannot be found" so question arises that in this
Author:
sirfnet
Date: 1/11/2011 Section:
Blog
tags :
custom error
,
SSAS error processing
,
SSAS tutorial
,
SSAS
Page 1 of 6 (128 items)
<< Prev
1
2
3
4
5
6
Next >>
Go to page:
[Go]