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

SSIS Package erroe
I have one ssis package that contains 10 dataflow task when i run package, whole package takes 2 hours. if there is error come in 5th dataflow task then packge run again, is it possible next time i run package from 5th package, is posible yhen how we do,

asked 8/13/2014 2:12:53 AM
by Abhi
2 answers

SQL Scenario
need to Solve the following scenario.               SOURCE:   ID NAME 101 ABC 102 DEF 101 AMERICA 103 AFRICA

asked 8/12/2014 5:00:25 AM
by Vipin jha
2 answers

Log in Time half hourly interval wise

asked 8/12/2014 12:46:16 AM
by Pankaj
1 answers

is it possible to take automatic/scheduled backup of my server on about any other server.

asked 8/8/2014 9:20:59 AM
by serkaddis
1 answers

Transaction Log usage Information
When we execute DBCC SQLPERF(logspace) to see the transaction log usage. In output there is a column as "Status". What is this Status all about??? What is the use of it?

asked 8/8/2014 5:32:49 AM
by Vimal Kumar Prajapati
4 answers

Not able to connect Analysis Service 2012
In my productuion server instance Analysis service 2012 SP2 is not working properly. Sometime we are not able to connect to analysis service and gets the error    Cannot connect to 'Servername'   Additional Information   Element

asked 8/7/2014 12:49:28 PM
by Rajendra
0 answers

More than 100 connections on "sleeping" status on SQLSERVER
Hi All, I have a big trouble here, well at my server. I have an ASP .net web (framework 4.x) running on my server, all the transactions/select/update/insert are made with .NET Application. Well my problem is that after being using for a while (a couple

asked 8/7/2014 7:07:19 AM
by Subhamay Chatterjee
1 answers

Import GML file into existing DB structure with 80 tables which are in relations with 3 main tables
Hello, I need to insert really big gml file into existing DB structure. It contains about 75-80 features (future tables) and they are in relations (some of them with some others), and almost all are connected with 3 main tables which stores geometry. Th

asked 8/7/2014 4:55:56 AM
by Aleksandar Millutinovic
1 answers

In our production environment while performing the backup (by using the ola hallengren scripts) for the user databases i.e., completes within 20mins, at that particular time if we hit any query which is of only 1or2records in a table it is taking long time i.e., it is displaying the time-out. Can you please suggest me on this as this is very critical issue.

asked 8/6/2014 2:00:15 AM
by sarfraz
0 answers

How to do Excel File Schema Validation without using Script Task
Hi, I am not sure whether to ask SSIS related queries in this forum.  I would like to understand is there a way to do Excel file schema validation without using Script task in SSIS.  

asked 8/4/2014 2:41:50 PM
by claudiarani
0 answers

How to send alert mail on field value change in Table with Old value and New value
Dear All,   I have a "Customer" Table which contain a field "creditlimit", now I want a mail alert on change at this field which contain both value old one and changed one.. Is its possible without trigger.   Thanks in Advance

asked 8/4/2014 3:49:36 AM
by Irshad Ahmad
0 answers

session Time out When Bulk Update(XML) is going on SQLSERVER
Hi All, When Bulk Upadate is running on my Production Database(its took 9-10 hours) ,there is several Exclusive locks on Database.in this time my Application can,t logged in ,Its shows session Time out. I don't understand what is the reason. I can't kill

asked 8/2/2014 1:06:37 PM
by Subhamay Chatterjee
1 answers

I want to convert an integer to short date
    i am trying to pull out a report on the date format come out as an interger  .please see the screen below. *** NOTE *** - If you want to include code from SQL Server Management Studio (SSMS) in your post, please copy the code from SS

asked 7/31/2014 9:17:58 AM
by Fundiswa
3 answers

Scripts to find query taking full table Scan
Hi All,   can anyone provide me the script so we can find out at database level finding all the query which using full scan   Regards, Subhamay Chatterjee

asked 7/31/2014 3:31:04 AM
by Subhamay Chatterjee
1 answers

Sharepoint in SSRS
  Hi, I have an SSRS report with two datsets 1 of sharepoint and another of  sql.When I am previewing the report in SSRS,I am able to view the report, but after deploying the report,when I am trying to access in IE,I am getting th

asked 7/30/2014 9:02:15 PM
by Abhi
2 answers

embed images in email in sql server
I Created a table with Image datatype column.I want to read the image datatype column and send the images to email.

asked 7/30/2014 9:43:08 AM
by Saravana
1 answers

Free Stand alone SQL Server version???
I installed Visual Studio express 2010 and it came with a diluted version of SQL Server called SQL Server Express 2008 I believe. Does any one know of a free stand alone version of SQL Server that lets you do pretty much everything? In other words somethi

asked 7/29/2014 4:04:40 PM
by Valhalla
1 answers

Daily Report needs to compare to GMT datetime
 I need the below query to run every day and collect data from yesterday 5am to today 5am.   I run it manually now and change the dates.   What date and time functions would accomplish this ?? Select a,b,c,d FROM DBtable WHERE (

asked 7/29/2014 12:37:43 PM
by Pete
1 answers

How to update existing stored procedure in sql server 2012

asked 7/29/2014 3:06:50 AM
by May Thandar
2 answers

OpenrowSet export data to excel.
  I am using below query in sql server 2005 with connection string of Excel 2007. With the below query the data is exported to excel but the thrid column "Revenue" is inserted as text rather as Number. INSERT INTOOPENROWSET('Microsoft.ACE.OLE

asked 7/28/2014 7:29:27 AM
by Abhishek
1 answers

Sponsor Information