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 >>

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

2008 MSSQL BACKUP AND RESTORE THROUGH SCRIPT
  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
by SHAN PANDEY
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

SQL SERVER 2012 JOB FAILED
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

How does an SQL Program look like, for a client
Hello, I have a really stupid, yet important question to ask here. I am a Computer Sciences student, and having not learned anything about Database yet, I have a friend's father who wants me to make him a program to a database for his clients.He basicall

asked 8/17/2015 5:58:14 PM
by Patrick Y
1 answers

Table Design - monthly goals for multiple units
Hello, I need to store the monthly goals for 50+ business units by year. (UnitID, Year, Month, Goal)  These numbers should be static and new goals inserted yearly.  The data will be used in reports to display % to goal and other calculations. &

asked 8/17/2015 12:46:06 PM
by Darwin
1 answers


 
Sponsor Information






 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

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