Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

learn more… | top users | synonyms (3)

6
votes
1answer
474 views

Database Backup and Full-Text Search

I am running SQL Server 2005 EE. When trying to perform a full database backup I receive the error message: Failed to pause catalog for backup. Backup was aborted.BACKUP DATABASE is terminating ...
5
votes
1answer
431 views

SQL Server Installer Update Cache management

Is it safe to delete the old cumulative update directories from the %ProgramFiles%\Microsoft SQL Server\110\Setup Bootstrap\Update Cache folders? At least this MSDN blog post tells to leave anything ...
4
votes
1answer
590 views

Distributed and/or Parallel SSIS processing

Background: Our company hosts SaaS DSS applications, where clients provide us data Daily and/or Weekly, which we process & merge into their existing database. During business hours, load in the ...
3
votes
1answer
261 views

SQL Server 2008 R2 Temporary Login Issue

We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling. Last night, all web applications lost the ability to login to the database for 6 ...
3
votes
1answer
722 views

SQL Server Debugging: “Unable to Step. Invalid operation”

I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up: Microsoft SQL Server Management Studio: Unable to Step. Invalid ...
2
votes
1answer
1k views

IIS 7.5 web application failing with NT Authority\Anonymous Logon

I am finding various google results, but none seem to fix my problem. I am setting up a new WINDOWS 2008 R2 box at work that is to communicate with an existing SQL 2012 box via web tools running in ...
2
votes
1answer
1k views

Get-ItemProperty : Cannot find path 'HKLM:\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.SqlServer.Management.PowerShell.sqlps'

I've tried reinstalling SQL Server 2014 and I'm still getting the following error message when trying to import-module sqlps. The same registry key exists, but is appended with 120. I'm able to use ...
2
votes
1answer
2k views

Copy User Mappings for SQL Logins using SQLCMD - MS SQL Server

Is there a way to directly copy the User Mapping from one SQL Server login to another using SQLCMD? In SQL Server Management Studio Object Explorer | (local) | Security | Logins, Right-Click a user ...
2
votes
1answer
93 views

Analyze meeting room coverage on Exchange server

We have a dozen meeting rooms, are looking to get rid of some of them, if we can prove that the remaining meeting rooms will cover our needs. We use an Exchange server. Is there any way I can query ...
2
votes
1answer
348 views

MSSQL Server 2012 Scheduled PowerShell Job fails

I have a simple PowerShell script that runs fine from the console (PSVersion 2.0). $psftpPath = "C:\Program Files (x86)\PuTTY\psftp.exe" $sftpHost = "foo.baa.com" $userName = "myusername" ...
2
votes
1answer
186 views

Excluding a SQL File Group from DPM Backup

I have numerous SQL 2012 databases that are being backed up by Microsoft's Data Protection manager (DPM) 2012. However, in each of these databases there is a specific file group that contains a large ...
2
votes
1answer
306 views

Where Does sqlpackage.exe Store Database Backups?

I have a deployment script which uses sqlpackage.exe to deploy incremental changes to a database. (The project is maintained in the database edition of Visual Studio 2012 Express.) One of the flags ...
2
votes
1answer
104 views

What does -fixcolnames do in log parser 2.2?

I'm using Logparser 2.2 to try to bring a .csv filled with Performance Counter information into a SQL database, and I'm using the following command line command: logparser "Select * into IISCounters ...
2
votes
1answer
299 views

Zend 1 on Ubuntu with MSSQL not working

Does anyone know how to solve the following issue? If not, does anyone know how to setup Zend 1 on Linux to communicate with msSQL server? We get the following error in the nginx logs when trying to ...
2
votes
1answer
443 views

SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created

I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on ...
2
votes
1answer
230 views

apache 2.2 with php 5.3 and miscrosoft sql 2008 crash

I am using Apache 2.2 with PHP 5.3 and Microsoft SQL Server 2008 on Windows Server 2008 64-bit. Every 3 to 5 hours, I get the error in the event viewer that Apache crashed for 20 seconds and then ...
2
votes
1answer
635 views

Windows Performance Monitor keeps trying to add unwanted counters

I have been running a Data Collector Set for SQL Server for a week, and everything was going just fine until I tried clicking on Action -> Save Current View and now it always tries to add the ...
2
votes
1answer
2k views

WSS Search fills 10 GB limit on SBS server 2011

I've got a SBS Server 2011 Standard SP1 that isn't very busy. 2 Users local and 2 remote. We have sharepoint that has maybe a dozen small documents at most. I've just started getting the following ...
2
votes
1answer
168 views

SQL server start-up bringing online database priority

we have hundreds of databases on one sql server instance. After restart sql server takes databases online one by one using default order from sys.databases view. This order use database_id, so first ...
2
votes
1answer
4k views

How can we recover/restore lost/overwritten data in our MSSQL 2008 table?

I am in serious trouble and I am seeking professional advices here. We are using MSSQL server 2008. We removed primary key, replaced exiting data with new data resulted losing our critical business ...
2
votes
1answer
673 views

SQL Server synchronization failed

I'm getting the error message below when trying to synchronize a SQL compact database (SQL CE 2.0) to a SQL Server 2005 database. I have double and triple checked permissions, reconfigured IIS ...
2
votes
1answer
156 views

SQL Server 2005 question about procedure cache

Server: SQL Server 2005 SP2 64 bit, 32 gigs of memory. 2 instances of SQL server running. Main instance I'm using has 20 gigs visible. We have a situation where it appears every so often our entire ...
2
votes
1answer
487 views

How to create a shared lock blocking an intent exclusive lock

As I understand it, a SELECT statement will place a shared lock on the rows that it will return. While that SELECT is running, if an UPDATE statement comes along and needs to grab an intent exclusive ...
2
votes
1answer
1k views

SQL Full-Text indexing not populating

We installed a clustered SQL 2005 installation on windows 2008 and reattached our san drives from another machine and restored to do a migration to new hardware. There have been a few minor issues, ...
2
votes
1answer
776 views

SQL Server Instance login issue

I've just brought up a new installation of SQL Server 2008. I installed the default instance as well as one named instance. I'm having a problem connecting to the named instance from anywhere ...
2
votes
1answer
208 views

Citrix server running 3rd party app experiencing SQL timeouts

We are running an app that was not developed in house on several Citrix servers. The users of this application are experiencing intermittent SQL timeouts. The error message: ...
2
votes
1answer
429 views

SQL Server Database In Single User Mode after Failover

Here is a weird situation we experienced with a SQL Server 2008 Database Mirroring Failover. We have a pair of mirrored databases running in high-availability mode and both the principal and mirror ...
2
votes
1answer
742 views

SQL Server “Long running transaction” performance counter: why no workee?

Please explain to me the following observation: I have the following piece of T-SQL code that I run from SSMS: BEGIN TRAN SELECT COUNT (*) FROM m WHERE m.[x] = 123456 or m.[y] IN (SELECT f.x FROM ...
2
votes
1answer
132 views

Web Platform Installer - Wants to instal SQL 2008 Express when I already have SQL 2008 Standard installed

I'm finding my use of the Web Platform Installer somewhat muted by it's insistence on trying to install SQL Express when I already have a full copy of SQL Server installed. Why is this happening? Is ...
2
votes
1answer
4k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
2
votes
1answer
150 views

SQL Server Bulk Insert Issue on Windows7

I’ve got an application that uses SQL Server Express 2005 SP3. This application is distributed to several hundred users, each of whom is running XP. However, our company will be moving to Windows7 ...
2
votes
1answer
249 views

SQL Server 2000 and SSL Encryption

We are a datacenter that hsots a SQL Server 2000 environment which provides database services for a product we sell that is loaded as a rich-client applicatin at each of our many clients and their ...
2
votes
1answer
533 views

Delay index build until SQL Server table load is complete with SSIS

I have a large table that I am updating. Is it possible to disable index updates on the destination table until the load is complete? It seems like a waste for it to be constantly updating the index ...
1
vote
1answer
28 views

install sql server driver on ubuntu

I want to connect to sql server database which is placed on a remote server while my php code has been installed on an ubuntu server. I found that it needs to install sqlsrv driver or mssql driver ...
1
vote
1answer
75 views

SQL/SSMS read only user who can only view a single database

I'm currently using SQL Server 2005 which has a number of databases on for individiaul clients. I need to create a single read only login for each of my clients, however I cannot allow them to see ...
1
vote
1answer
59 views

Windows Server 2012 R2 Virtual Switch

We have an Dell R510 that has Windows Server 2012 R2 Core installed. We are having a problem where the guest VMs are losing their network connections but will come back after a couple of minutes. The ...
1
vote
1answer
50 views

Port 1434 - Company Website hosting blocking us

We have a small network setup on a Windows Domain. We also have a company website that has the same domain name - but is actually not in any way on the domain - it's hosted elsewhere on a cheapo ...
1
vote
1answer
62 views

Will a SQL incremental backup work for my purposes?

We are transitioning a large amount of data, in the form of a SQL database, from one location to another and the data transfer speeds are very slow but we want to cause as short of an interruption of ...
1
vote
1answer
169 views

How do I use a domain account to connect to a MSSQL server for NPS accounting?

I'm trying to connect a Server 2008 R2 NPS to a MSSQL server for logging accounting data and I'm running into issues. I configured NPS Accounting through the "Configure Accounting" wizard and, using ...
1
vote
1answer
344 views

Activity Monitor not showing stored procedures?

This is SQL Server 2008 R2 running in Hyper-V virtual machine with 4 virtual cores. Task Manager is reporting sqlservr.exe to use at least 50% CPU, sometimes 100% for minutes. I/O is very low. The ...
1
vote
1answer
303 views

SQL Server 2008 local connection an error occurred during the pre-login handshake

I am getting an error while trying to connect to SQL locally either via a web application or SQL management Studio. Oddly, I can connect fine remotely via apps on other servers or SQL management on my ...
1
vote
1answer
277 views

BCP/xp_cmdshell access denied - but only when running procedure from outside the server

I've been attempting to run some of my team's database deployment code to a SQL 2014 server on a Windows 7 test box. Part of this code is a procedure that pulls in data from a file using BCP from a ...
1
vote
1answer
215 views

What happens to active connections to my SQL Server DB if I back up the transaction log with the NORECOVERY option?

Some background: I'm migrating my SQL Server DBs to a new machine and I wrote a few Powershell scripts to send/apply full backups and transaction logs asynchronously to the new server, but my question ...
1
vote
1answer
214 views

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server ...
0
votes
0answers
29 views

SQL server Error

I am trying to load the data from text file to database table by running a job. Sometimes its giving an error like "Failed at split file".. Can anybody suggest on this how to overcome this error.
0
votes
0answers
261 views

to overwrite a table or update it?

I've had situations where there was a large feed I was taking in that basically overwrote a table in the db. This tabled information was queried a lot. If Sql Server uses memory to store the queried ...
0
votes
0answers
66 views

AppFabric vs AD LDS

I'm helping design a solution for a huge organization which relies on a SQL cluster. If this cluster is unavailable, the entire organization will not be able to authenticate to printers. there are ...
0
votes
0answers
398 views

Getting “error: 26 - Error Locating Server/Instance Specified” all of a sudden

Alright, a little explanation. I have two separate PCs, both of which have virtually an identical installation of SQL Server 2012 Express on them. During installation for both, I had chosen the ...
0
votes
0answers
83 views

Moving WSUS Content - Issue with SQL Server

Im trying to gain some space on the main partition on the C:\ drive of a Win 2008r2 SBS server. Im following this guide . However, after detaching the Db ,moving it to the new partition E:\ i can't ...
-1
votes
0answers
26 views

How to push the SQL installation from SCCM 2012.

I need to push out SQL 2008 to a new server using SCCM 2012. I was wondering if anyone had done this? I thought it was a case of finding the device in collections and deploying a package to it. ...