Learn more about SQL Server tools

solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips

   Got a SQL tip?
            We want to know!

SQL Server Question and Answers

Ask a SQL Server Question

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

Transactional Replication and Async database mirroring
Hi All,I need your help on this.I have the Asynch mirroring with transactional replication(push subscripton with remote distributor) set up in test environment.When principal server goes down, i manually force the service on to the mirror server.Replicati

asked 6/17/2014 8:52:51 AM
by shwetha
0 answers

MySQL group_concat. Is ther an ms t-sql equivalent?

asked 6/16/2014 4:32:26 AM
by Jim
1 answers

Backup Error in Logshipping

The backup data at the end of "\\DREPMSHARE\SQL_LogShip_ITWEPMSQLSVR\FDM_ITWHFM_REP\ FDM_ITWHFM_20140605223002.trn" is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use

asked 6/13/2014 4:33:24 PM
by Girish
1 answers

please sir/madam solve my query about procedure that i don't understand to procedure so i wanna create a procedure for many tables so please sir give me a solution with a suatable example....

asked 6/13/2014 8:21:52 AM
by Nitin Sharma
2 answers

Coalesce BookingHour and BookingMinutes and show BookingHour as minutes
WIthin the same statement, is it possible to"translate" the BookingLengthHour into Minutes and COALESCE both columns together so that both display in one column as minutes? If not, how might I accomplish this? Both BookingLengthHour and BookingLengthM

asked 6/10/2014 1:14:14 PM
by Jon Lellelid
1 answers

Exhibit an SVG image stored in the database
Hello,   Have searched high and low, but not found a good solution yet. We have in our database a column that stores an svg stream (ex: <svg viewbox><polygon ...></svg>).   We would like to use that svg stream to exibhit th

asked 6/9/2014 4:35:51 PM
by Mateus
0 answers

create powershell script for NIC Health check and Group policy
anybody create powershell script for NIC Health check and Group policy elated  plz do needful

asked 6/7/2014 6:36:36 AM
by chandu
0 answers

  There are two tables : Table1 : id empid 1 49 2 50 3 51 4 52 5 54  Table 2 : empid date 49 08/27/13 50 08/27/13 51 08/27/13 52 08/27/13 49 10/05/12 49

asked 6/6/2014 11:16:44 AM
by Deepak
2 answers

Architecture/Design to maintain multiple version of application database
We have a Silverlight based application which currently supports only one production version. Idea is to support three concurrent versions of the same application and user will switch to the newer versions based on their interest or they can still continu

asked 6/6/2014 8:39:10 AM
by Saikat
1 answers

SQL Server Job issue -- It's an emergency
Hi,One of our Production Servers contains a job (Daily run) which gets the Data from another Server and dump into local DB. From last couple of days, it is failing with the reason "Unspecified error occurred on SQL Server. Connection may have been termina

asked 6/6/2014 7:29:28 AM
by Ajaykumar
1 answers

Adding counter to name
Trying to add a counter to names only when IDs are the same. My query adds counter to all names regardless if IDs are the same or not. I have includes both results of my query and the ideal one. --Drop table ##ProvCREATE TABLE ##prov ( id VARCHAR(1)

asked 6/4/2014 4:22:50 PM
by Helal
1 answers

Policy Based Management - Server Permission Checking
(Please disgrard my typing) I am trying to determine the best way to proceed on a project.  Basically I have some predefined server permissions that I need to check for.  i.e., Alter\Create View Server State My List is fairly long and consists

asked 6/2/2014 3:47:52 PM
by Swoozie
2 answers

Creating Repayment database
Hi experts, please note that I am a beginner in banking programming, and I want to create a table that calculate the repayment amounts.       As shown in the below table, the cardno 5140560000001142 has a trnamt of 1239 so that means th

asked 6/2/2014 11:55:22 AM
by Sofian
0 answers

Update sql server tables using inner join

asked 6/2/2014 2:59:07 AM
by Guruvayurappan sivaguruswamynathan
1 answers

SQL Server 2012 Standard Edition Failover Cluster Windows 2012 R1 --> Windows 2012 R2
My current production environment is SQL Server 2012 R1 Standard Edition on a Failover Cluster in Windows 2012 R1.  I am new to SQL Server, 15 years Oracle DBA.   My system administrator is upgrading the operating system to Windows 2012 R2 and

asked 5/30/2014 5:49:45 PM
by Keith Brockman
2 answers

How are all you SSRS admins handling the increased permissions requirements in 2012?
We are migrating from SSRS 2008 R2 integrated with SharePoint 2010 to SharePoint 2013. In our test migrations, everything works great except for end users being unable to create subscriptions. Turns out this was an intentional design change on the part o

asked 5/30/2014 3:36:35 PM
by Eric Riehl
1 answers

Severity 017
I am a new DBA and I recently got an alert message saying I got insufficient resource, how do I find the root cause of this or the query causing this and how do I troubleshoot this problem, can anyone give me a step by step guide please? DATE/TIME: 

asked 5/29/2014 3:28:18 PM
by tigist
0 answers

Login valid but database unavailable
Hi,   I have received an error message. Here is the error code: Error: 18456, Severity: 14, State: 38 Do you have any idea for this? Best    

asked 5/28/2014 11:06:47 AM
by Drivers123
2 answers

SSRS Localization
Hi ,  Is there a way we can localize the prompts (names) in the rdl for a specific language.  Say i have an option to chose languages from a dropdown in the report , the report should change the language once i chose "Spanish" from english.&nb

asked 5/28/2014 2:26:22 AM
by arpitha prasad
0 answers

Blank cells SSRS report
Have multiple cells in different columns of SSRS report that I would lik to show as NA Is there a way to do this globally for the report?

asked 5/27/2014 1:41:52 PM
by Joe Munch
0 answers

Sponsor Information

Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | today's tip | first timer?
Some names and products listed are the registered trademarks of their respective owners.