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

Frozen table
Hello All, Used the import wizard to upload data from an Excel file.  Took the following steps:  1.      The import froze on a specific row. 2.      Cancelled the import due to ~2minute hang

asked 7/16/2015 6:46:33 PM
by Elise5000
4 answers

The value violated the integrity constraints for the column
We have SSIS jobs to import data from an upstream which would pass through stage tables, intermediate and then to final. In intermediate table we have NOT NULL constraint on a column. It never happened before and suddenly from upstream NULL values st

asked 7/16/2015 11:09:33 AM
by Harini
1 answers

mdx help
hello I am new in mdx and I need help I create a report using ssas as data source the problem is I that for one column when there are some specific data then I want to name it 'george' like in sql case when name in ( 'george', 'john') then 'first' &

asked 7/16/2015 6:36:06 AM
0 answers

Error during installation of an SQL server Failover Cluster Instance
Hi. I really need help . Im trying to install an SQL Server instance and I got  this error. I already check user and CNO permissions .. the CNO  had "Read all properties" and "Create Computer objects" . the user that create the instance is

asked 7/13/2015 9:31:27 PM
by alex84
1 answers

SSRS Reports Scheduling and exporting
I have 4 SSRS reports that must be scheduled to run at different times and then send these SSRS reports in csv format (tab delimited) to the ftp server of the third party client 

asked 7/11/2015 10:47:12 AM
by Kris Maly
0 answers

sql licences
  We have one SQL Proc Licence We have now purchased two new ibm servers. How much SQL licences we have to purchase  What is SQL CAL . do we require SQL CAL as 25 users are working on application running on one server. Which version of SQ

asked 7/11/2015 12:48:53 AM
by p k goel
1 answers

When you run SQL Queries on SSMS we monitor on SQL Profiler but when we run SSIS Packages is there any tool exits?
When you run SQL Queries on SSMS we monitor on SQL Profiler but when we run SSIS Packages is there any tool exits?

asked 7/10/2015 8:56:46 AM
by Kris Maly
3 answers

How to transfer XML files from folder to another folder with a new name change using SQL 2008.
Hi,   Hope someone could help me on this.   Problem: I have an SQL jobs that gets the XML file  from specific folder and transfer to database. However if that XML file will come in bulk. I'm thinking if how can I transfer all of that u

asked 7/9/2015 10:16:56 PM
by Jay Lorca
2 answers

How frequently are system tables in SQL updated
Hi   I recently came across a tip in which we can find the number of rows in a table from sysindexes aystem table. I want to know how frequently is it updated. Are all the system tables up to date all the time   Regards, Harini

asked 7/9/2015 7:41:33 AM
by Harini
2 answers

Multiple Data Sources for Single SSAS Database
What is the right approach and the best way to describe the solution to this problem: multiple, identical schema, application datasources from a line-of-business-application, spread around the globe corporate need for analysis and reporting at HQ SSA

asked 7/7/2015 2:31:05 PM
by Martin Daniel
0 answers

Suscriptions mhtml problem
hello could help me, I have a problem with the signing in MHTML format, because if I have a small board sends it but if it is large not provided, I can modify these properties ? Thank you for your help  

asked 7/6/2015 11:55:09 AM
by Victor Paz
0 answers

SSRS Rendering Extention PPTX
Hello, On reporting services is the ability to view reports on multiple rendering format except for PPT / PPTX. Looking at the net there Aspose.Slides the tool does good apparently, but that is not free. So I saw that there was the possibility of developi

asked 7/6/2015 4:36:33 AM
by Aurelien
0 answers

Rows to Columns
i have the below text in one column i need to split it to mutiple columns the belwo script is not working     SELECT Name, Date_Start, Time_Start, Date_End, Time_EndFROM (  SELECT Calendar_Data FROM dbo.Calendar_Data) Calendar_DataPIVO

asked 7/3/2015 8:45:21 PM
by Ikrami Sami
0 answers

Control flow statements in Where clause
I am fetching data from a table on the basis of few parameters which are used in a where clause for filter criteria. The Parameters are number of days and customer name (@days and @customer name). Below are the things which I want to achieve.   1)

asked 7/2/2015 5:57:41 AM
by Vipinkumar Mishra
1 answers

A SQL expression which can compile a logic through a condition.
Hi Experts,   I am starter in SQL! Task: I have a requirement to Generate the Invoicing log errors (SAP ISU)  Table: ETRG , Dimension: ANLAGE(Installation) and   Key Date : ABRDATS(Schedule Billing Peroid) lOGIC---->  To retrie

asked 6/30/2015 9:10:44 AM
by bhanu chandar dake
0 answers

suppose restoring database was corrupted how to recovery it

asked 6/29/2015 2:48:23 PM
by rao
1 answers

Find Duplicate Clients based on Last and First Name
Hi all, I need to be able to find duplicate names (Last and First) to prevent entering duplicate records in a Client table. I was looking at the SOUNDEX() function, but in many post they say it is not recommended to use.  Is there any other MS-SQL

asked 6/29/2015 11:16:08 AM
by Edhy Rijo
0 answers

Stored Procedure is confusing, help!
I inherited this stored procedure and I am having issues figuring out exactly what it is doing after it is reassigning the ID. Any input is appreciated. CREATE PROCEDURE [dbo].[Delete_my_Content] @user_id as varchar(255),     --U

asked 6/26/2015 9:35:30 AM
by Jenna
0 answers

SQL Server 2014 merge replication throws PRIMARY KEY violation during the initialization of Subscriber
I am using SQL Server 2014 SP1 to set up merge replication on Windows 2008. The databases (Publisher & Subscriber) are restored from the production back up of SQL Server 2005 publisher database. The merge replication set up on SQL Server 2005 works f

asked 6/25/2015 1:07:18 PM
by Isaac
1 answers

Need to script out a sql job using t-sql or stored procedure
HI  Can any one help me in scirpting out all the sql jobs using t-sql    Regards Sandeep

asked 6/25/2015 6:05:50 AM
by Sandeep
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-2016 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.