Learn more about SQL Server tools


SQL Server Question and Answers

Ask a SQL Server Question

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

Audit functionality monitoring
My Audit and Compliance section is requiring us to develop a daily monitoring checklist to determine if audit functionality fails if automated alerts cannot be generated when the audit functionality fails. I'm not finding anything that specifically addre

asked 2/27/2015 12:51:30 PM
by Gary Wright
0 answers

Problem moving clustered indexes to a different File Group
I started looking at this as a follow-up to the article by Feodor Georgiev - Curing Data-Obesity in OLTP Databases - just a day or two back. So I ran a few experiments on AdventureWorks2012, adding a new File and File Group and re-creating all clustered i

asked 2/27/2015 10:13:06 AM
by Gordon
0 answers

Clarification on Always on
Hi All, I am a DBA. In our organization we are using SQL Server 2012. So far, the High Availability concepts that I have worked are Mirroring & Log shipping. Now, we are planning to implement "Always on" in our organisation, which is new to all of

asked 2/27/2015 5:39:48 AM
by K P Senthil Kumar
0 answers

Procedure or function has too many arguements specified
A while back this community gave me very helpful info on backing up sql databases and I'm here again looking for more help. Thanks ahead of time for any suggestions you might give here and I am not a SQL pro, just a lowly IT Associate, so the answer migh

asked 2/26/2015 1:08:12 PM
by Stephen
0 answers

Server Side trace causing query and ultimately connection timeouts, even several minutes after the trace is stopped?
I'm pretty flustered and don't know how to proceed.   To make a long story short, I'm trying (carefully) to get some replay traces from a pretty busy production 2005 SP4 instance.  I actually started using the default RML Util replay trace in s

asked 2/24/2015 8:10:08 PM
by dwaine wright
0 answers

how to identify the servers? like which one is production, test and development?
    I have 100 sql server instances how to identify the servers? like which one is production, test and development? in the real time environment.

asked 2/24/2015 11:51:38 AM
by sudha
2 answers

TITLE: Microsoft SQL Server Management Studio ------------------------------ Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (SQLEditors)
In Object Explorer, whenever I right click on any user-created-table inside a database and issue command like "Design" or "Edit Top 200 Rows" or when I am going to create "new database diagram" for my recently created database, I get an error stating, TI

asked 2/23/2015 10:43:00 AM
by prasiddha
1 answers

MSBI Sample Requirment
Recently, i got a simple requement with following detail. 1. I am have two excel files(Each Excel file is having  three Sheets) i.e  Excel 1---> Sheets --> 1.CompanySheet( CID,CNAME)               &nbs

asked 2/23/2015 1:37:48 AM
by Siva
0 answers

restore error in sql server database
When I want to restore sql database from I see the error: "The system cannot find the file specified.)". Any actions I should make? Please, some solutions to resolve!

asked 2/22/2015 11:08:33 AM
by keeganwalborn
1 answers

SQL server using 95% RAM
  Hi team, I have sql server using 93-95% RAM.current max memory setting for SQL Server is 43GB and Total RAM is 48GB. In task manager its showing 46.5GB for sqlsrv.exe 1 Dont know which process/query taking more memory? 2 Do we need to add mo

asked 2/20/2015 1:27:19 AM
1 answers

Unknown process taking system databases backup
I am seeing some unknown system process is taking system databases backup. There is no error and the output message as below. "Database backed up. Database: msdb, creation date(time): 2010/04/02(17:35:08), pages dumped: 1854, first LSN: 209:362:217, last

asked 2/19/2015 3:28:08 PM
by Siva
0 answers

Performance on partition table
How to assure partition table is better performance than non-partition table

asked 2/19/2015 7:36:47 AM
by Debdulal Mahapatra
1 answers

Single Result on multiple fields
Hello,  I am pretty new to using Report Builder but have figured out how to get data to show in a report when I have a 1 to 1 relationship in two different datasets.  The problem I am having is how to pull a single data point (let's say End of

asked 2/16/2015 5:02:49 PM
by Chris
0 answers

    Dear,         I want to use the profiler for tracing only the insert & delete command in SQL2008, How can I perform this task ?     Thankx

asked 2/16/2015 7:20:45 AM
by Bijo
3 answers

error 26 server not found
Being overwhelmed with all suggestions, is there a chance I could have someone connect remotely to my machine and at least tell me what I have so messed up if he is not allowed to configure with the right settings so I can get past the error 26? &nbs

asked 2/15/2015 4:11:59 AM
by Toli
1 answers

how i bold, color,underline some paragraph in text type field in sql server database
 how i bold, color,underline some paragraph in text type field in sql server database

asked 2/14/2015 10:22:45 AM
by munir ahmad
1 answers

I am new to SQL and I want to know why we are using EXEC to execute the sql statements

asked 2/13/2015 4:39:36 AM
by Anpin
1 answers

High availability for SSRS on SQL Cluster 2012?
* Hi,We are trying to determine how to provide SSRS for high availability since is not cluster aware. We have active/passive SQL Server 2012 cluster with Enterprise Edition where the other node is truly passive so only one active node is licensed.

asked 2/12/2015 7:50:18 AM
by Apollo
0 answers

OLE DB provider
Problem When trying to select data from a view through a linked server the following error can appear: SELECT *  FROM [SERVER_NAME].DATABASE_NAME.DBO.VIEW_NAME   OLE DB provider "SQLNCLI" for linked server "SERVER_NAME" re

asked 2/11/2015 11:46:27 AM
by Tim
0 answers

always on High Avaibility
I have always on faciliy. I two node. NOde a and Node b . When i do failour. my sql server angent job are fail. I do not understand why? please give me solution.  

asked 2/9/2015 3:15:19 PM
by Gary
1 answers

Sponsor Information