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

automate script for coping backup files from one server(Production) to other(PPE) and restore
Hi,   I need automate script for coping backup files from one server(Production) to other(PPE) and restore.   regards, Hari

asked 7/23/2014 8:22:47 AM
by Hari Prasad
0 answers

Call DTS from Java
Please help us whether we can call DTS directly from Java. Solution which we got as below:- Create dts Create job in which we have to call dts Call job from stored procedure It pretty lengthy process and we are not sure how error hand

asked 7/22/2014 3:11:29 AM
by Yogesh
0 answers

I have a table as per below and what I need to know before I go insane is the best way to select the only the products, locations that have products in more than 1 location. When I use a query to select this it also selects PROD1 which I don't want to sel

asked 7/22/2014 1:11:21 AM
by Wayne
3 answers

Centroid of 3 circles
Hi all, I have three latitude,longitude points and the distances to a point(randomly selected one say A ).The aim is to draw the circles using the latitude and longitude as centre with given three distances as radius.Finally have to find the centroid of

asked 7/21/2014 3:53:27 AM
by Mounika
0 answers

Split polyline feature in sql server 2012
Please find the below attached image. I have one point(in blue color) and polyline(in black color). Using the below sql server 2012 comment i got the nearest path(in red color) between polyline(black) and the point(blue). DECLARE@pnt geometry,@line geo

asked 7/21/2014 1:42:10 AM
by RamRamesh
0 answers

SQl server r2 installation problem
  Hi, I got error while install  sql server 2008r2 in win7,   Error: wmi service faild, i restrat wmi in  service its working  but sql server is not going to insatll,   Please give me suggition  

asked 7/19/2014 3:43:14 AM
by laxmna
0 answers

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
hi The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. I encounter the above error message while executing import excel data into sql data table It worked fine in Mssql 2005 x86 and MS Office 2007 x86. But currently we upgr

asked 7/18/2014 9:50:55 PM
by maideen
1 answers

Automated refresh tool for SQL Server
We have a huge portfolio of databases and multiple environments. We often get application requests for refreshing a table/schema/database from production instance to development/staging instance. Is there any automation or tool available in the market

asked 7/18/2014 9:31:42 AM
by Sudarsana
1 answers

What is the background process of Transaction Log files,
Why transaction log is needed to Database? When the data is going to store(at what time) into .mdf file from .ldf file, the internal architecture?  

asked 7/18/2014 6:16:22 AM
by Niranjan
2 answers

How to identify a rebuild index job running
How to identify a rebuild index job running with status

asked 7/17/2014 6:01:42 AM
by Boopathy
1 answers

SSRS: Need to find the total of specific type of data to another field
I have to create a SSRS report like below:

asked 7/17/2014 1:24:35 AM
by Julie
0 answers

where to start from
I want to know and start working on following concepts of SQL like data mart, data warehouse, ssis, ssas and ssrs. I would like to know is there any linking between these concepts. I ever I need to start from which topic I should start first. are the

asked 7/16/2014 7:36:14 AM
by sagar
0 answers

Automated Script for LogShipping swichOver/Drill
Hi, I need automated scripts for Logshipping drill/swich over to DR from DC after checking Sync bewteen Two Database in DC & DR. Its very Urgent requirement. Please Help.   Regards, Subhamay Chatterjee Kolkata,india

asked 7/16/2014 3:01:29 AM
by Subhamay Chatterjee
0 answers

How to append large number of tables without missing any columns
Hi, I tried appending 16 tables in a database into one single table.I tried using for each loop container, but i got the truncating error. Please help me resolving this error Regards, Mounika

asked 7/14/2014 6:45:51 AM
by Mounika
3 answers

Missing Stored Packages folders in SSIS from SSMS 8.0
We have a 2008 Integration Services server that suddenly doesn't display all the folders that exist in the Stored Packages selection.  They exist; queries against SYSSSISPackages and SYSSSISPackageFolders on the server show both the packages and fold

asked 7/11/2014 4:36:31 PM
by Tim Brown
0 answers

How to find out SQL Server editions and versions can be audited and which can't
Hi. I have this issue where I want to know in which SQL Server versions and editions auditing of any level (server, database) etc is possible or not in the SQL Server by creating a database audit specification or so and also in which versions its not poss

asked 7/11/2014 4:59:23 AM
by Sonali
2 answers

We have enabled TDE in our production environment which is having only one DB in the instance. After enabling this, the weekly maintenance job reindex is generating huge logs. T-log backup size is around 50 GB in 30 mins(we are running logb

asked 7/11/2014 3:29:05 AM
by Sanjeev
0 answers

exec cmd_shell running in SQL but not in SSIS package
Hi, Below is the SQL query: USE MASTER declare @command varchar(300)set @command ='bcp "SELECT * FROM LTR_COMMENTER.dbo.LTR_TEMP_GIS_"  queryout "Foldername\Filename_'+(select substring(convert(varchar,getdate()-1,20),1,4) + substring(convert(varc

asked 7/10/2014 6:03:07 AM
by Rushabh
2 answers

Row Comparison in same table
Please help me on this. I have 3 tables Table A:- Driver Table CAT Code, Parttype, BasePartNo, LikePartNo MCN, FLOORMAT, MCNW10, MCNW10** MCN, FLRLNR, MCN444410, MCN4*4410 Table B:- Build Table CAT Code, Parttype, BasePartNo, LikePartNo1, LikePartN

asked 7/9/2014 8:52:56 AM
by Binod
0 answers

How to do stored procedure dynamically
Hi I have an issue in below stored procedure. below Store procedure is working fine. But fixed the Year. Any one know How can do the year dynamically select by user? SELECT * FROM ( SELECT salesEXE,SalesEXEName,name,gross,YearNo FROM vw_Pivot_Month_AL

asked 7/8/2014 9:32:29 PM
by maideen
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.