Search This Blog

MSBI Tutor

Home

More…

Posts

Showing posts with the label Line Number

Show All

How to enable row number in SSMS

Get link
Facebook
X
Pinterest
Email
Other Apps

- March 04, 2021

Step 1 : Go to tools and select options Step 2 : Go to Text Editor tab and expand it Step 3 : Go to general under Transact - SQL Step 4 : Check line Numbers box as shown in bellow and click on ok

Blog Archive

2026 54

2025 23
- October 1
- September 2
- August 1
- June 1
- April 4
- March 4
- February 7
- January 3
2024 32
- December 2
- November 1
- October 2
- August 2
- June 1
- May 1
- April 6
- March 4
- February 4
- January 9
2023 31
- December 2
- November 1
- September 3
- August 3
- July 3
- May 1
- March 4
- February 1
- January 13
2022 94
- December 6
- November 13
- October 3
- September 4
- August 10
- July 12
- June 2
- May 4
- April 12
- March 9
- February 7
- January 12
2021 183
- December 12
- November 7
- October 11
- September 24
- August 10
- July 17
- June 15
- May 27
- April 25
- March 33
- February 2
2020 15
2019 31
- December 5
- August 15
- July 4
- March 1
- February 1
- January 5
2018 49
- December 3
- November 2
- October 7
- July 14
- June 21
- February 2
2017 18
2016 39
- August 19
- July 7
- June 5
- April 4
- January 4
2015 2
- March 2
2014 57
2013 2
- December 2

Show more Show less

Labels

2016
2017
2019
2021
2022
2023
2024
2025
2026
Access

Access DB
ADBC
Admin
Advanced Analytics
Agentic Era
AI
AI Agent
Analysis Services server
Annotations
ANNOUNCEMENT
ANNOUNCEMENTS
Announcing
April
art 4—Security
Aug
August
Available
Azure
Azure Maps
Backup and restore
Bad Request
BI
Big Data
Blob
Boot Camp
Cache
Cancellation
Capacity
Catlog
Certification
Challenge
Charts
CLR
command prompt
COMPARE
Compare SQL
Conditional format
Conference
Connection
Connector
Copilot
Course
cover page
Create Package
dashboard
Data
Data Analysis
Data Analytics
Data Fundamentals
data gateway
Data in a Day
Data in space
Data Lakes
Data Modeling
Data source
database
Databricks
Datamart
Dataset
Datasheets
Datasources
Date
Date Picker
Date Slicer
DAX
DB Growth
DBA
Dec
DefaultMeasure
Delete
Delete rdl
Deploying
Desktop
Direct Lake
Direct Query
Disaster Recovery
Disk space
Download
Duplicate
Dynamic
Dynamic Pivot
Dynamic Units
Dynamics 365
Early Adoption Program
Editions
Embed code
Embedded
Embedded Analytics
Enable
Enhancements
EVENTS
EXCEL
Export
Export all tables data to csv
Fabric
Fabric Career Hub
Failover Cluster
Feature
Feature Summary
Feb
Filter
Format
Framework
Fundamentals
Gateway
Generally Available
GREATEST
Hide
High Availability
History
Hybrid Cloud Flexibility
Ignite
Import
In K
In M
Incremental
Installation
IP Address
IPL
Jan
January
Job Running Status
JSON
Jul
July
Jun
June
Jupyter
Keyboard
LEARING
Learn
LEAST
Lifecycle
Line Number
Load data to excel template
Logical functions
LOGIN
Login Password
Logins
logo
Mar
March
Masking
Masterclass
May
MBAS
Metrics
MICROSOFT
Microsoft 365
Microsoft 365 Developer Program
Microsoft AI
Microsoft Azure
Microsoft Build
Microsoft Business Applications
Microsoft Fabric
Microsoft Power Platform
Microsoft Teams
Migration
Mirroring
Mobile Apps
Modern Visual
Modern Visual Tooltips
MS Teams
Multiple Audiences
MySQL
network
NON-UNICODE
Notebooks
Nov
Objects
Oct
ODATA
ODBC
ODSC
On-premises
OneDrive
Online
Oracle
Org Apps
OS
Paginated Reports
Part 1
Part 2—Governance
Part 3—Service Management
Part 5—Rollout
PASS
Pereview
permission was denied
Pivot
Policies
PostgreSQL
Power BI
Power Apps
Power Automate
Power BI
Power BI app
Power BI Mobile
Power BI Pro
Power BI Report Server
Power BI Services
Power Pivot
Power Platform
Power Query
Pre-Announcing
Premium
Preview
Pricing
Processors
Product
Protection
Public Preview
Publish
Python
RAM
Real-time
Refresh
Relational Databases
Release
Remove null records
Replace NULL
Replace null values with zero
Report
Report Builder
Report From Text
Report Rendering Time
Report Usage Statistics
REST API
Result
Retirement
Revoke
RLS
Roles
Row Level Security
RPA
San Francisco
SandDance
Scale-Out
Security
Semantic model
Seminar
Sep
Server Details
Server Reporting Services
sever
Shape Map
SharePoint
Shortcuts
Shrink DB
Singapore
Size Limit
SP
Split
SQL
SQL Agent
SQL Bits
SQL Performance
SQL Saturday
SQL Server
SQL Server 2022
SQL Server Agent
SSAS
SSAS Cube
SSIS
SSMS
SSO
SSRS
Starburst Connector
Start
Stop
Streaming
String
STRING_AGG
Subscriptions
Summary
Summit
Support
Swap
Synapse
System
Table
TABLES
Temporary Tables
Tenant
Theme
Time Intelligence
TMDL
Tooltip
Track
Transact-SQL
UNICODE
Update
Updates
USER
USERCULTURE
v-cores
Version
VIEW SERVER STATE
virtual
Virtual Training
Visual
Visual calculations
Viva Goals
Vue.js
Web Modeling
Web Permission
webinar
Wizard
Words Count
Workshop
Workspace
XML
XMLA

Show more Show less

Ssrs reports error when large number of parameters are passed

- August 08, 2016

Now where you can find this web.config file? If using SharePoint integration Mode: It’s located on the web server and has the path C:\inetpub\wwwroot\wss\VirtualDirectories\80\web.config But you have to keep on mind if there is more than one SharePoint instance and what instance are you using to deploy the reports, of example the path can be C:\inetpub\wwwroot\wss\VirtualDirectories\EPMA\web.config If using SSRS native Mode: The web.config file will be located at your SQL server and it will have the path: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer . The solution for this issue is to add a section in your web.config file inside the <appsettings/> section <appSettings> ... <add key="aspnet:MaxHttpCollectionKeys" value="9999" /> ... </appSettings> That 9999 value should represent the number of parameters that you believe it will be ...

Query execution failed for dataset DataSet_Name. (rsErrorExecutingCommand)

- August 08, 2016

An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset ‘DataSet3’. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors 1.) Go to the ReportServer Database 2.) Drilldown to Tables and select the dbo.ConfigurationInfo 3.) Open the table and change the EnableRemoteErrors to TRUE in the Value column and run Execute SQL. OR In Management Studio, you must be logon on instance of report server and enable the property EnableRemoteErrors to see more details that error. Connect Management Studio à in screen: Connect to Server, server type: Reporting Services à locate the server instance in Server Name; after...

Exception deserializing the package "The process cannot access the file because it is being used by another process."

- December 13, 2019

TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...

Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS

- December 04, 2018

Error: Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS Solution 1: 1. Right click on source task. 2. click on "Show Advanced editor". -- advanced edit option for source task in ssis 3. Go to "Input and Output Properties" tab. 4. select the output column for which you are getting the error. 5. Its data type will be "String[DT_STR]". 6. Change that data type to "Unicode String[DT_WSTR]". --Changing the data type to unicode string 7. save and close. Solution 2: Add Data Conversion transformations to convert string columns from non-Unicode (DT_STR) to Unicode (DT_WSTR) strings. You need to do this for all the string columns

Temporary enable and disable SSRS subscriptions

- August 11, 2019

--Code Snippet --To Check Subscription Status. USE ReportServer GO SELECT dbo . Subscriptions . Description , dbo . [Catalog] . Name , dbo . Users . UserName , InactiveFlags FROM dbo . Subscriptions INNER JOIN dbo . [Catalog] ON dbo . Subscriptions . Report_OID = dbo . [Catalog] . ItemID INNER JOIN dbo . Users ON dbo . Subscriptions . OwnerID = dbo . Users . UserID --Temporary disables subscriptions while data warehouse is unavailable UPDATE dbo . Subscriptions SET InactiveFlags = 1 GO --After this you can find, all the subscription where disabled until you again enable it. --Again enable subscriptions. UPDATE dbo . Subscriptions SET InactiveFlags = 0 GO