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

CHANGE DATA CAPTURE WHEN TIME STAMP IS NOT PRESENT FOR THE RECORDS
Would I get some assists regardig changing data capture when time stamp is not presesnt for the records.  

asked 10/30/2014 9:29:07 AM
by Wagdi Eltayeb
0 answers

SQL Editionto use ODBC
Good afternoon, I need to buy SQL Server 2014 for my company but I am using DSN and ODBC connections, which edition should I be using, Standard or Enterprise. From what I saw in the features at Microsoft,  I should buy the enterprise. Am I correct?

asked 10/30/2014 9:07:34 AM
by Mohamed
0 answers

SQL AUDIT
Hi,         I want to audit my database that which user inserting,updating and deleting database from a website. If a user update any data then i want to see what was previous(old) value as well as new value.I used ApexSqlTool for thi

asked 10/29/2014 2:33:28 AM
by Roopesh Jain
1 answers

Generate Scripts without Replication Items
I have a database that uses Transactional Peer to Peer replication on SQL Server 2008 R2. Periodically, I need to generate scripts (schema only) to send to other offices who do not have access to my servers to utilize. Normally, I use the Generate Scripts

asked 10/28/2014 8:48:19 AM
by Patrick
1 answers

sharepoint list source error
I got below message while executing a package which takes data from sharepoint source through sharepoint list source: Error Message:Code: 0xC0047062     Source: Load STG DAPriority SharePoint List Source [1]     De

asked 10/27/2014 4:20:47 AM
by sravani
0 answers

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

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

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


 
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.