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

How to move only SQL reporting services from one server to another? Report Database is on separate SQL server
Hello, We are having SQL reporting services installed on application server and Report Database on SQL DB server. We are upgrading OS of Application server and need to reconfigure reporting services on new server. How to proceed so that all reports and

asked 10/24/2014 4:33:55 PM
by Shelly
0 answers

Hi Team can somebody provide me the course syllabus or topics being covered in MSBI Learning(SSIS,SSRS,SSAS)   Sincerely Suri

asked 10/24/2014 6:17:29 AM
by Suri
0 answers

To make sql server instance back to multi user mode
I have made a change at instance level, ‘Properties/Connections/Maximum number of concurrent users’ to 1, disconnect all other users from the server. Since some of the users were logged in and left for the day and I had to restore the DB, I

asked 10/23/2014 6:25:43 PM
by Jacob
1 answers

How to save ssrs trace log data to SQL Server database table?
I am working on a project which is required to create a datamart to collect data from executionlog, ssrs performance monitor counters, and ssrs trace log in order to use ssrs to generate some reports. Any suggestions are welcome, particularly for how to m

asked 10/23/2014 11:42:24 AM
by John
0 answers

relational DB

asked 10/23/2014 6:25:55 AM
by Joćo Rodrigues
0 answers

Decimal separator: Comma and Point
I have a problem with decimal separator that I can explain with this simple line: select convert(money,1.1), convert(numeric(4,2),1.1) will return  1,101.10 I realize that numeric types does not respect the language culture.  If I install th

asked 10/23/2014 6:08:34 AM
by Celso
0 answers

How to get the start time and end time of process ssis
I have an ssis package , where I includes a foreach container to loop through files and loads it in to a table. Now I want to track the process start time , end time and the status into another table. How can I achieve this.. ?

asked 10/22/2014 1:53:13 AM
by Hazeena
0 answers

import word content into sql server
hi professor for example :i have a word file and its content is formula,text,image i wanna creat DB with them for instance i had 2colmns .one for image and one for formula and can search  thanks professor 

asked 10/20/2014 10:24:19 AM
by ehsan
0 answers

Export the table content into excel file
Dear All,   Kindly suggest to me. How I can export the table content into excel file or text file or csv file. Please suggest your answer.

asked 10/18/2014 1:32:25 AM
by Rakesh Kumar Jena
0 answers

Computed Column
Hi,   I have a View with 4 columns ID, DATE, SIGNAL, VALUE. This table is updated everyday for all signal Values. What I want is a Computed colums whose value is COMPVAL= SIG1VAL+SIG2VAL-SIG3VAL. The other SIGNAL types fro 4 to 10 say should reta

asked 10/17/2014 5:43:03 AM
by Ram KV
1 answers

Can not connecting database after installing Microsoft SQL Server 2008 Management Studio Express
Greetings  !! I have Windows XP SP3 operating system (having 32-bit operating system). After downloading "SQLManagementStudio_x86_ENU" from the link ( Normal 0 false false false EN-US X-NONE

asked 10/16/2014 1:59:02 AM
by Mahi
0 answers

Excel Graph from SQL Query
  On the recent webinar "10 Ways to Improve SQL Server Automation" there was an example of moving the results of a job timing query to an excel spreadsheet with graph.  How was this done?  Would be very useful.   Thanks,   Jo

asked 10/15/2014 12:08:14 PM
by John
1 answers

Hi, for the last week i see in the sql server monitoring tool (precies) that the "BRKR TASK" consuming larg amoumt of cpu resorces and cause an Internal waits. the actual text is "Text (N/A) Handle (0x0000000000000000000000000000000000000000) Command (B

asked 10/14/2014 10:47:10 AM
by itzik paz
0 answers

Need to recover access database with superior solution to fix access database errors
I have a task regarding access database. I and my organization is using access database  to maintain my access files in well mannered way. But due to varied reasons access file showing error message   Error 3112: Your access database got corru

asked 10/13/2014 3:02:41 PM
by MarshallBurns
1 answers

sql server
sir i created db already .nd it is in use ..........now the db is full nd my client says me to extend db without loosing previous data............is it possible.............. 2nd thing i created db nd a lot of table in db .......its again in use wid an ap

asked 10/13/2014 11:04:46 AM
by Amardeep Agrawal
2 answers

Teansfer stocks between warehouse in sql server database
Hi, I am developing an inventory menagemet system. I am using Visual Studio 2012 and MS SQL Server 2012. How can i Teansfer stocks between warehouses in sql server database. Thanks

asked 10/11/2014 3:39:37 AM
by Mahmut BİLİR
0 answers

Periodcity Options in Reports
  Hi ,     I have developed small accounting system for a Trader. Now i have created all the form to enter data like Purchase , Sale , Payment , Receipt etc. And after entering the data i have also built up customized report.

asked 10/9/2014 1:02:42 PM
by Sumit Kumar Malani
0 answers

Primary Key And Unique Key Requirement
1. If we are already having Primary Key why we need Unique Key? 2. Why we allow NULL to Unique Key? 3. Why Primary Key don't allow NULL?

asked 10/9/2014 12:15:14 PM
by Lokesh Shukla
3 answers

I need to truncate a first name in my SSRS 2008R report
The data in the software has first name and I want to truncate it to first initial only.  How would I go about doing that in SSRS 2008R?

asked 10/9/2014 10:01:58 AM
by Sheila Lindergren
2 answers

SQL server - Hot and Standby
Hi, We have a requirement of hosting a web application, backend SQl Server, in two physically separate server for redundancy and high availability requirment. We have installed the application and SQL server on two separate server (two licenses).  

asked 10/8/2014 8:52:54 AM
by Rasheed Abdul
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.