Learn more about SQL Server tools


SQL Server Question and Answers

Ask a SQL Server Question

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

Schduled reports from 2 diffrent instances
Hello, We have 2 instances of SSRS. (SQL 2014, enterprise edition). I created a new report and add a subscription, so the report will be sent by mail to me every one hour. What happened is that sometimes I receive the mail with the report and sometimes

asked 9/2/2015 4:32:26 PM
by Michal
0 answers

Schduled reports from 2 diffrent instances
Hello, We have 2 instances of SSRS. (SQL 2014, enterprise edition). I created a new report and add a subscription, so the report will be sent by mail to me every one hour. What happened is that sometimes I receive the mail with the report and s

asked 9/2/2015 4:31:18 PM
by Michal
0 answers

I am trying to pull Bloomfield Hills out of this string CN=JAN2012,OU=SALES_Computers,OU=Sales,OU=Bloomfield Hills,DC=LakesideSoftware,DC=org i need the third occurrence of OU= for the group name
CN=JAN2012,OU=SALES_Computers,OU=Sales,OU=Bloomfield Hills,DC=LakesideSoftware,DC=org so what i'm trying to do is pull "Bloomfield Hills" out of this string I need the third occurrence of OU= for the group name      

asked 9/2/2015 2:49:26 PM
by Dave Temple
0 answers

Backup file created but no record created in msdb.dbo.backupset
Problem: Backup file created but no record created in msdb.dbo.backupset.  First time this happened there was a deadlock error thrown for the msdb database.  Happened again and did not throw an error and the TRN was not recorded in the msd

asked 9/2/2015 11:10:11 AM
by Elise5000
0 answers

About SQL Server Backup Plans
Suppose I have schedule a database backup @ 12:00 PM and backup completed @ 12:30 PM then whats the condition will come if Database Backup Type is  1. FULL, 2. DIFFERENCIAL & 3. Transaction Log.   i.e. at which point of time the data re

asked 9/2/2015 4:30:36 AM
0 answers

How to create Polynomial Order 3 or 4 Trend Line curves on Column Chart in SSRS 2012
I have created a Column Chart in SSRS. Now I want to create Polynomial Order 3 or 4 Trend Line curve on the above chart? Any help is appreceiated I tried as below: 1. Created the Column Chart and upon that created Polinomial Trend Line in Excel. 2. T

asked 9/1/2015 11:33:45 AM
by Kris Maly
0 answers

changes in measures in a cube
I need to move the measures COGS, QTY,TURNOVER from sales measure to sales and order totals measure. Parallely i need the change the names of COGS, QTY,TURNOVER. How to resolve this, do guide me.. or send me links where i can understand step by step

asked 9/1/2015 2:33:20 AM
by ranjan
0 answers

how to split one date column into two culumns and get data from the start date to last date.
Hi good people any one can help me I am stack here. I am working on SQL database I want to display three column from the table I have. I tried in many ways but it not do what is needed. Original table is like this below: Refno     &nb

asked 8/31/2015 10:24:21 AM
by Mzwenhlanhla
0 answers

fetch all variable name ,value & connection string from .dtsx files(already imported in table xml format)
hi all, i import all packages from a drive path into a table in xml format.Now  need the all variables name , values & connections strings value  from all the packages from the base table (xml format).   please update..its

asked 8/31/2015 9:01:25 AM
by Subhamay Chatterjee
1 answers

Upgrade SQL 2005 Express Edition to SQL 2008 Enterprise

asked 8/31/2015 4:59:38 AM
by Anshul Jain
0 answers

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

Sponsor Information



Get Free SQL Tips










BI Professionals


Q and A

Today's Tip







Tip Categories

Search By TipID



First Timer?


Free T-shirt



User Groups

Author of the Year

More Info








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