Learn more about SQL Server tools


Tutorials          DBA          Dev          BI          Career          Categories          Events          Whitepapers          Q&A List          Join

SQL Server Question and Answers

Ask a SQL Server Question

Search All Questions:
SQL Server Questions And Answers
<< Previous Page        Next Page >>

4th Polynomial Trend line on SSRS CHART
I would appreciate if someone could help me to draw 4th Polynomial Trend line chart ib SSRS 2012.  FYI this feature is in Excel but I want to draw this trend line on my Column Chart. If you need any more info please feel free to let me know.  

asked 8/28/2015 3:09:10 PM
by Kris Maly
0 answers

SQL SERVER 2008 R2 Backup
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: ]

asked 8/28/2015 12:07:19 PM
by Mus
1 answers

SSIS template framework for SQL jobs
Hi, Can some help to design a SSIS template frame work that runs on each instance & capture SQL jobs & history details. we have a requirment to capture all the sql jobs and it's history through an SSIS package (package will run on all instances)

asked 8/27/2015 9:31:53 PM
by Raj
0 answers

SSIS - Data Load Collation
Hello Friends , Need help of yours immediately, I am working on a SSIS Package. Till last week it was loading  data correctly. Now the source database is upgraded and i need to connect my SSIS Package to this Upgraded Database. But with this i go

asked 8/27/2015 3:37:13 AM
by ranjan
1 answers

Cant restore cube in SSMS
Hi all, I have a cube that I cant restore in my SQL server management studio. Can you guide me how to resolve it?? what are the steps to be done? Thanks  Ranjan DS  

asked 8/26/2015 7:26:12 AM
by ranjan
1 answers

sql job failed
Hi all, I got an error when running an sql job agent, The package execution failed in execute task editor. as its showing red icon. the error msg was: MessageExecuted as user: ABC. ...sion 12.0.2000.8 for 64-bit  Copyright (C) Microsoft Corporati

asked 8/26/2015 3:16:19 AM
by ranjan
0 answers

MS_Repltrans Table just grows
Good Day, we are running Transactional Replication on SQL Server 2008R2 . Both Replication cleanup jubs are running every 5 minutes . However  we noticed the MS_replcommands table records are removed . On the other hand the records of the MS_replcom

asked 8/26/2015 2:56:41 AM
by Lian
0 answers

attribute relationship error
Hi all, When ever i tried to build a cube, i get stuck in this attribute relationship. either i shows a "yellow" icon in the hierarchy or "red" underline in the attribute column.I dont know how to rectify those errors. could you help me out in resolving

asked 8/25/2015 2:25:13 AM
by ranjan
0 answers

Excel spreadsheet drops zeroes as destination in SSIS
I have been running a SQL Server query, and it drops the trailing zeroes in an Excel 2010 spreadsheet. I want the cells to be formatted as currency but without the dollar signs.  So if I have $22.90, it shows up as 22.9.  Any suggestions

asked 8/24/2015 3:16:16 PM
by Purt
0 answers

cube creation in ssas
Hi all I need to create 3 fact table in a cube with dimensions ?? is it possible . What are the steps to do. can you guide me through it or send a link so that i can learn it.   Thanks Ranjan 

asked 8/24/2015 10:06:35 AM
by ranjan
0 answers

SSIS - update dimension tables
Hello guys,   The question I`m going to ask might be very silly but as per my knowledge i need a solution for the question which    i couldnot able to find in the google.   Question is:   I have staging database where i ge

asked 8/22/2015 5:21:30 AM
by srikanth
0 answers

Incremental Cube Load in SSAS cube
Hi all, How to increment a data from one database to another database in a cube. Thanks Ranjan DS

asked 8/21/2015 5:45:29 AM
by ranjan
0 answers

SQL SERVER 2012 Job agent
Hi all,through job agent can i transfer the data base from one warehouse to other? if i can do...how can i. what are the stepsThanksRanjan DS

asked 8/20/2015 10:17:49 AM
by ranjan
1 answers

  Dear All,   Greetings of the day,   i want to share with you my one problem i hope all of you provide me the solution. i am using cloud infra, inside this infra i make the virtual machines of windows with mssql 2008and deliver the

asked 8/20/2015 5:09:21 AM
2 answers

Protect our backed up databases with password
We are using SQL Server 2014, all our databases will be automatically backed up as per schedule. Now need to protect our backed up databases with password. We have tried below queries: BACKUPDATABASE Prod121 TODISK='C:\Prod121.BAK'WITH MEDIAPASSWORD ='p@

asked 8/20/2015 1:43:52 AM
by Ramchinni
1 answers

Reg Log Backup LSN chain
Hi, As per my Understanding SQL Server Maintain Log Backup Chain depends upon full backup/last log backup. When ever we took Full backup a new LSN chain will start and next log backups will depend on this full backup. For Ex: Full Backup---6 AM TLOG Ba

asked 8/19/2015 7:31:08 AM
by Pradeep
3 answers

Hi Xiong,   Now the task succeded. I will get u the msg what i am getting for success and for failure. -------------For failure------------------------------ MessageThe job failed.  The Job was invoked by User WUNDERWEAR\dd1.  The last

asked 8/19/2015 6:10:10 AM
by ranjan
0 answers

Sending out SSRS Report
I'm in a SQL 2K5 envirornment and I have subscription reports which go out to my users, I would like to change that so they will get an email message that will point them to a link of the report (instead of sending out serveral reports), however when they

asked 8/18/2015 8:41:22 PM
by Kevin
0 answers

if a server performance is slow? how can troubleshoot a problem?

asked 8/18/2015 5:01:49 AM
by raj
1 answers

System Database Rebuild Process
Hi Jugal, Im New to Database and i searched for the rebuild process for system databases i didn't get any usefull info, can you please write a article for the system databases rebuild process  

asked 8/18/2015 1:12:48 AM
by Ramchinni
1 answers

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?




User Groups

Author of the Year

More Info








Copyright (c) 2006-2017 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.