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 failing to read from registry
Hi, I have bunch of SSIS scheduled through Tidal. No issues in non production environments [ Microsoft SQL Server 2012 Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)].But only couple of SSIS packages (same one) fail

asked 2/4/2016 9:41:08 AM
by Mohamed
0 answers

Sql Injection re Bulk Insert
Hello Guys: Does Bulk Insert properly escape input? Or do I have to worry about SQL Injection when performing a Bulk Insert? I am using a flat file for input, and a format file. In my format file I specify the columns as SQLCHAR. Does that type indicat

asked 2/2/2016 3:31:16 PM
by John Turpin
0 answers

SQL SERVER Default Trace file
Hi all, I have some questions regarding SQL Server Trace files.. Q1. How SQL Server Manged Default Trace files? is it archived autometically ? If yes then retention period ? Q2. Can we  extented the retention period of Default Trace manually ? &n

asked 2/2/2016 8:14:25 AM
by Subhamay Chatterjee
0 answers

mysql database confusion to store user phone contact list
  My requirement:when any user will create a profile to my application from their mobile phone, their phone contact list will upload to server mysql database.Now:User table=============uid,userId, username, passwordContact table===================

asked 2/1/2016 5:12:29 AM
by arijit
0 answers

Request for solution to implement SQL Server Replication between Local Premises DB Server and Cloud DB Server which are not on a domain
Hello,   Hope you are doing fine.   I am writing this email to ask you an implementation doubt regarding replicating data between SQL Server 2014 database servers (Replicating data from Local Premises SQL Server to Cloud DB Server, which are

asked 1/29/2016 7:36:50 AM
by Nikhil Satam
0 answers

Easy SQL Query, Need Help.
Hello I recently made a CDN so I wanted to move all my current urls of images on namestyles to the new urls, they all end in the same image number and extension but I wanted to replace example.com/z/imagenumber.imageext to cnd.example.com/i/imagenumber.im

asked 1/28/2016 11:20:25 PM
by Kevin
0 answers

Can I create/modify objects on SQL Server 2014/2012 using SQL Server 2008 Management Studio on client machines?
  Our application has SQL Server 2014 as database server. But our client machines or developer machines still have SQL Server 2008. We are able to connect to SQL Server 2014 DB but we are facing issues while creating or modifying any tables or SP'

asked 1/12/2016 4:48:36 AM
by Nikhil Satam
1 answers

Database object limit
Does the sys.objects table reuse object_id numbers?  Is there a finite amount of objects per database, or, when an object is deleted does it free up the object_id to be reused?  I know ALL about primary key uniqueness, but it seems shortsited to

asked 1/7/2016 2:56:31 PM
by Elise5000
0 answers

Issue with derived column transformation
I added review date, process status columns to derived column transformation, and mapped in oledb destination, the packkage is working fine in my local, when i deployed into dev some other environment, the mapping is unmapped for those columns i dont why

asked 12/31/2015 5:47:42 AM
by Ravi chandra
0 answers

Sql server Integration services

asked 12/31/2015 5:36:13 AM
by Ravi chandra
0 answers

Same Store Procedure exection time differs every time.
Hi All,   I have created a store procedure on my production DB and executed it to check the time of execution it took 00:06 Hrs  and provided me 120,000 records again  I executed the same sp given me same set of records but the execution

asked 12/24/2015 7:29:34 AM
by Satish Vishwakarma
0 answers

SQL Server 2000, Corruption detected in the MSDB database
Good afternoon All, CHECKDB found consistency errors in MSDB; apparently there's an entire page missing. Don’t’ know if this is a red herring, but the sysdatabase MSDB database status = 1073741848, which I believe is a combo of being cleanly

asked 12/17/2015 2:16:18 PM
by Elise5000
0 answers

Duplicate Data in Dependent Paramater (SSRS)
Hi, I have an issue in SSRS. Well I created 3 DropDown  in my report. 1st is for Buyer - (Which is distinct) 2nd is for Division Manager Duplicate 3rd is for Division Manager Distinct First one is independent means data is coming from DataS

asked 12/14/2015 11:59:58 PM
by Vishal Mittal
0 answers

Error: "You can't go to the specified record"
After migrating  from Access 2007 to SQL Server 2008, I tried to enter data into a table. On getting to the end of the first record I pressed the enter key to start entering the next record but SQL Server displayed this error "You can't go to the&nbs

asked 12/12/2015 11:18:41 AM
by Laide
1 answers

How to disable windows security pop up when I connect to Report Server.
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}   How to disable windows security pop up when I connect to Report Server (SSRS).   &nb

asked 12/11/2015 8:46:31 AM
by Mark
0 answers

Replace Active x Script task in SQL Server2012
I have a DTS package to migrate to SSIS 2012 server. This DTS pacakge contains activeX script.   THis DTS pacakge does loading the data from a SQl table source to Excel file One variable was declared as gintCatalogueID with default value -1. and

asked 12/10/2015 8:05:33 AM
by Venkat
1 answers

maintenance of indexes of SQL server VLDB
Hello MSSQLTips team, Could you please help me by asnwer me or write un article how to manage indexes of VLDB database around 1TB. My case is we have a database with size of 884476.38 MB Most data (pefromarmance statistics like CPU,Memory,IO,Network) is

asked 12/7/2015 12:32:23 PM
by Konstantin Momchilov
0 answers

SSRS - GrandTotal in matrix
Expression for User = avg(fields!user.value) Whatever the value comes to 'User -1' suppose to roll over to 'Dept - 1'.     Month         Oct-15 Nov-15        Grand Total 

asked 12/2/2015 10:04:59 PM
by BP
0 answers

SQL server Import/Export Wizard Error
I thoght this is supposed to be a straight-forward task but run into a problem: I have 2 machines with SQL Server 2012 running on both and want to use SQL server Import/Export Wizard to copy tables from one to the other.  Both are using Windows

asked 12/2/2015 1:44:00 PM
by Jim
0 answers

SSRS Windows File share subscription error
Hi,   I am trying to post a file from Server A running Report server services to Server B (File share server) using an account (Say Account1). This account is part of administrators group in both Server A and Server B and has access to shared path.

asked 11/26/2015 12:45:03 AM
by Gopi
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-2016 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.