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

Send bulk mail with attachment
Hi All, I am trying to have a store procedure to send a bult amount of mail with attachment.I have a table name contact in which I have id,name,contact number,address,email_add,status.I have a fix message and a fix attachement to send to each email id.

asked 6/27/2014 7:12:51 AM
by Satishchandra Vishwakarma
4 answers

Weird SSRS when export to Excel
Hi Jeremy,   I learnt a lot from your website,  http://www.mssqltips.com. Recently I'm working on a SSRS report and ran into an issue. Here is the data set: district branch route customer total fail d1 b1 r1 n4 1 0

asked 6/26/2014 3:14:43 PM
by Jiaxin Qu
2 answers

Create folder using sql table data (id )and download image and move image to associate reference folder(id) in my local system
I ahve one sql table with fields Matter_number - data type nvarchar body - datatype image Now , i want to create folder using matter_number dynamically and move the image to specific folder create by matter_mumber in my local system. Wheni run the SSI

asked 6/26/2014 2:17:45 PM
by Heren
0 answers

Recovery of backup files failing - Error 3201
I can no longer restore any of the databases generated by my maintenance plans from SQL Server Agent. As far as I can tell this happened after a new Domain Controller was installed.  The error message is : -----------------------------------------

asked 6/25/2014 9:18:14 AM
by David Scott
1 answers

Update part of a SQL field
Hello,I have a field and the data is in the format below:12-FLA-2-02I am trying to update just the first part of the data before the first dash which is 12 to another field that has a single numeric value and should match the 12 before the first dash abov

asked 6/23/2014 2:48:58 PM
by Larry
2 answers

Hi All, My production Databse is configured with logshipping which is running on 2005. Now my boss told that, to upgarde sqlserver to 2008R2. So,how can i do this? please provide me some document or link,explain the matter it's very urgent.   Reg

asked 6/22/2014 12:30:44 PM
by Subhamay Chatterjee
1 answers

Customized parameter selection in ssrs
hi, hope you can help with this query. I have a multi value parameter that selects sampling points from a table. Because the list selection is quite long, the user would like to add leading text in the parameter selection box to enable a quick find. &nb

asked 6/18/2014 3:59:09 PM
by Rene Voller
0 answers

logshipping real time issues in sql server

asked 6/18/2014 1:39:54 PM
by Phani Chandrika Pathakota
1 answers

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

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.