Welcome To TechBrothersIT

TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.

Label

  • C# Scripts
  • DWH INTERVIEW QUESTIONS
  • MS Dynamics AX 2012 R2 Video Tutorial
  • Project / Work Support
  • SQL SERVER DBA INTERVIEW QUESTIONS
  • SQL SERVER DBA Video Tutorial
  • SQL Server / TSQL Tutorial
  • SQL Server 2016
  • SQL Server Scripts
  • SSIS INTERVIEW QUESTIONS
  • SSIS Video Tutorial
  • SSRS INTERVIEW QUESTIONS
  • SSRS Video Tutorial
  • TSQL INTERVIEW QUESTIONS
  • Team Foundation Server 2013 Video Tutorial
  • Team Foundation Server 2015 Video Tutorial
  • Windows 10
  • Windows Server 2012 R2 Installation Videos

SQL Server Error Messages


  1.  /REPORTING E " has mismatched quotes.  The command line parameters are invalid.  The step failed.
  2. Length of LOB data to be replicated exceeds configured maximum 65536
  3. The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)
  4. Msg 15404, Level 16, State 19, Procedure sp_replcmds, Line 1 
  5. Replication Error, can't connect to actual server, @@servername returns Null (Video Answer)
Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest
Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Total Pageviews

Sparkline

Write to TechBrothersIT

Name

Email *

Message *

Search TechBrothersIT Blog

Subscribe us on YouTube

Followers

Blog Archive

  • ►  2017 (37)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (7)
    • ►  March (16)
    • ►  February (3)
    • ►  January (8)
  • ►  2016 (318)
    • ►  September (1)
    • ►  August (2)
    • ►  July (5)
    • ►  June (25)
    • ►  May (28)
    • ►  April (96)
    • ►  March (56)
    • ►  February (33)
    • ►  January (72)
  • ►  2015 (769)
    • ►  December (108)
    • ►  November (12)
    • ►  October (21)
    • ►  September (50)
    • ►  August (30)
    • ►  July (85)
    • ►  June (23)
    • ►  May (72)
    • ►  April (76)
    • ►  March (107)
    • ►  February (151)
    • ►  January (34)
  • ▼  2014 (144)
    • ►  December (9)
    • ►  November (22)
    • ▼  October (13)
      • The database principal owns a schema in the databa...
      • DBA Posts - How to monitor SQL Server Cluster fail...
      • DBA Posts - How to find SQL Server Port number usi...
      • SSIS - How To Load Files in Different Tables Accor...
      • SSIS - How to Write Case Statement In SSIS Package...
      • SSIS - How To Create Folder with Date in SSIS Pack...
      • SQL DBA - How To Enable/Disable Database User in S...
      • SSIS - How To Build SQL Query By Using Expressions...
      • SSIS - How to Disable/Enable Task/s In SSIS Packag...
      • SQL Server Error Messages
      • SQL DBA - How to Grant Execute Permission To User ...
      • Length of LOB data to be replicated exceeds config...
      • /REPORTING E " has mismatched quotes. The command...
    • ►  September (30)
    • ►  August (19)
    • ►  July (6)
    • ►  May (6)
    • ►  April (6)
    • ►  March (12)
    • ►  February (11)
    • ►  January (10)
  • ►  2013 (91)
    • ►  December (24)
    • ►  November (14)
    • ►  October (3)
    • ►  September (5)
    • ►  August (3)
    • ►  July (28)
    • ►  June (14)
  • ►  2012 (3)
    • ►  November (1)
    • ►  October (1)
    • ►  August (1)
  • ►  2011 (9)
    • ►  March (5)
    • ►  February (4)

Popular Posts

  • SSIS INTERVIEW QUESTIONS
    Here are some SSIS interview questions that you can expect if you interview for the job of ETL Developer. I will be adding more questions ...
  • SSIS - How To Pass Parameter Value In OLE DB Source in SSIS Package
    Scenario:  Let's say we have to create a SSIS Package in which we  need to extract data from one of the table but only for date provi...
  • SSIS - Read Multiple Sheets from Excel File and Load into Table
    Scenario:  We have our source Excel file that has sale history. Each sheet will has data for a year. We can get data for any number or y...
  • SSIS - How To Create / Use Temp Table In SSIS Package
    Scenario: We have create a SSIS Package for Upsert(Insert/Update). We get csv file with millions of records with (Id,Name,Address column...
  • SQL Server DBA Tutorial
    Below are the links that provide video learning on You Tube our channel " Tech Brothers" - These videos walk you through step by ...
  • SSIS -How To Use Derived Column Transformation (Replace Null Values) in SSIS Package
    Scenario: Let’s say we are extracting data from flat file or from Database table. Few of the columns have Null values. In our destinat...
  • SSIS- How to Use Row Count Transformation (Audit Information) in SSIS Package
    Scenario: Let’s say that we receive flat file from our client that we need to load into our SQL Server table. Beside loading the data ...
  • SSIS - How To Use OLE DB Command Transformation [ Delete Rows in Data Flow Task]
    Scenario: We have a SQL table which contains our data. Every day we get a text file from our users and they want to delete records fro...
  • SSIS - How to use "Script Component As Transformation" ( InitCap In SSIS Package)
    Scenario: Let’s say we are extracting data from flat file. One of the column in source is Country Name, the data in this column is al...
  • SSIS -How to Check IF File Exists In Folder [Script Task]
    Scenario: Sometime we get requirement something like this: Your Package should check a flag (Cell Value) in table and if it is 1 then ...
Awesome Inc. theme. Powered by Blogger.