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 (4)

1
vote
0answers
24 views

SQL Server 2012 licensing Downgrade [duplicate]

Our vendor is requiring us to upgrade existing accounting software db from sql 2000 to sql 2008 and my boss wants unlimited connection to db. Can i use sql 2012 per core instead of sql 2008? from my ...
1
vote
1answer
55 views

HeidiSQL, attach/register database in MSSQL server

How to attach (or register) an existing MSSQL database to a server Using HeidiSQL
6
votes
2answers
8k views

Login failed for “IIS AppPool\ASP.NET v4.0” - SQL Server Web

I'm trying to migrate a website from SQL Server 2008 Express to SQL Server Web, and the website is having trouble accessing the database. In truth, Express was only ever used by running the website ...
1
vote
1answer
27 views

Why does SSMS Restore Database to another database not copy the current state of the “From” database?

When copying a database by using the Restore Database functionality in SSMS, why is it not a copy of the current state of the Database? After performing the Restore From Database Bar to Database Foo, ...
6
votes
4answers
13k views

What's your best practice Recovery Model for SharePoint databases

Paul Randal asked some really nice questions about best practices for SharePoint SQL databases. Today, while helping a customer to maintain SharePoint installation he asked me a question about best ...
2
votes
1answer
58 views

Shrinking Database using the AUTO_SHRINK ON , helpful or is it consuming to many resources?

I have multiple databases which are constantly growing. So from time to time, I truncate the log table and shrink the biggest databases. For the biggest one (>40gb) it takes quiete some time. So I ...
0
votes
0answers
462 views

Connecting to MSSQL server using sqlcmd and odbc driver on RHEL 6 fails

I spent the last hour trying to connect to a mssql server using sqlcmd through odbc driver. I was talking to the db guy but he doesn't seem to have a clue what is going on.. Maybe you can help me out ...
1
vote
1answer
146 views

MS Sql Server getting overloading with 'Suspended' queries, mostly reads. Any way to fix this?

I have a Microsoft Sql Server that handles a moderate amout of traffic for a company software suite made up of multiple clients in java and c#. It is getting overloaded with 'Suspended' queries. They ...
0
votes
0answers
95 views

IIS7.5 Not connecting to MS SQL Server 2008 with PHP5.2.9 via php_mssql driver

Ok this is going to be somewhat involved. I have three servers: First I have a box running Linux with Apache and PHP 5.2.17. We shall call this "LB" for Linux Box. Second I have a Server Running ...
0
votes
1answer
114 views

Connectivity between Web Server and SQL Server inside Amazon VPC

I have a Webserver and a SQL Server inside an Amazon VPC. Previously, a Webserver outside the VPC could connect to the SQL Server fine. Now, sometime, when running SQL Scripts (the deployment script ...
0
votes
1answer
68 views

Website can not connect to ODBC (no rights?) “Error: 80004005”

Background I am trying to migrate a website using MSSQL from MS Windows Server 2003 to a Server running MS WS 2008. It's been a while since I tried the last time (because I gave up on this problem) ...
0
votes
1answer
595 views

How to get php_mssql.dll working properly on IIS 7.5 and PHP version 5.2.17?

First of all I'll give a very brief introduction of what I'm trying to make. I need the mssql php functions to work on the webserver. I know that such functions were deprecated in PHP 5.3 and above. ...
2
votes
4answers
112 views

Building a ASP.NET & SQL Server Machine(s); need some help

I currently have an asp.net web application running on an xp machine w/ iis 5.1 and sql server 2005 on our network. This application processes large excel files (50MB+), handles 100's of 1000's of ...
2
votes
1answer
82 views

What is the location of the SQL Server Fallback Certificate?

We are required to use encryption with SQL Server, so we have enabled ForceEncryption. According to the documentation, if a certificate is not provided, SQL Server will generate its own internal ...
0
votes
2answers
147 views

SQL server 2008 Enterprise Edition - Dual X5670 Processors Support

Would SQL server 2008 Enterprise Edition fully support Dual X5670 Processors which is equal to 24 core at total. thank you.
2
votes
1answer
215 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 ...
4
votes
3answers
122 views

What are the dangers of using parallelism on sql server?

At a customer of ours, the sql server is configured to 1 for degree of parallelism. The server has 8 cpu's, so what would be reason to limit this degree to 1?
2
votes
3answers
2k views

Microsoft SQL server backup : restoring data to one table

Is there an easier way to restore data to single table in an MSSQL server, rather taking down the database and restoring the entire database?
0
votes
0answers
117 views

Cannot generate SSPI context and VPN

I am the developer of a time recording tool written in vb.net using odbc. Using this tool from home via vpn (cisco) everything is working for ME and one other person. My collegue could connect too but ...
1
vote
1answer
71 views

Intermittent performance issues on Azure Web Application with ASYNC_NETWORK_IO errors

Our web application is suddenly experiencing intermittently slow performance (slow page loads, slow ajax calls going from <1 sec to over 20 secs). The only clue is when the application slows, we ...
0
votes
0answers
80 views

Inconsistent server connectivity with System.Net.HttpWebRequest

I have a production database server (Windows Server 2008 / SQL Server 2008) which has a .NET CLR Assembly referenced on it with a CLR function called dbo.fnu_RequestUrl. The purpose of this function ...
4
votes
1answer
175 views

Network traffic to server keeps dropping out

I have a production server that is responsible for controlling a factory. The server runs a number of control applications and a SQL server. The problem I have is that one of the applications that ...
0
votes
3answers
132 views

How can I get alerted when SQLServer is unavailable

I have setup alerts to let me know when SQL Server shuts down normally. Now I want to add email alerts when it shutdown abnormally (system or process crash) What is the easiest way to setup this ...
1
vote
1answer
76 views

Downgrade SQL Express 2008 R2 SP2 (x86) to SP1

I'm looking to update vCenter from 5.0 to 5.1U1. In order to do the update, I need to downgrade the current SQL Express 2008 R2 SP2 to SP1 according to VMware compatibility matrix. Can I just ...
4
votes
8answers
2k views

What should be excluded from a virus scan on a Microsoft based server (IIS, MSSQL, etc.)?

I want to keep antivirus software from affecting performance on a TFS installation -- what should be excluded from antivirus scanning? IIS? MSSQL? Am I opening myself up for possible attacks by ...
0
votes
0answers
18 views

MSSQL 2008 query VERY slow on live server compared to dev server - not sure how to debug?

Running SQL 2008 R2 on both servers. When we run a fairly large query against the developer server, it takes a few seconds. The live server takes around 1.5 minutes, even with no one else connected to ...
0
votes
0answers
104 views

Error:Microsoft SQL Server Native Client 10.0 error '80040e37'

I migrated a website attached to a MSSQL database from Windows 2003 running on IIS6 to a Windows 2008 R2 running on IIS7.5 but I get the error: Microsoft SQL Server Native Client 10.0 error ...
0
votes
3answers
42 views

Separate SQL Server Instance or just new database?

I'm going to deploy an app whose requirement is just 'db_owner' for a database. The database itself must be created separately by the DBA. Based on how the application will work (and its simple ...
0
votes
2answers
99 views

Less than 10% Free Space on Database Server

2-weeks ago one of our web servers CPU Usage started bottle-necking lot at 100% for long periods of time when an application runs and requests "sqlserver.exe"..When this app runs and does its ...
1
vote
1answer
18 views

SQL Server 2005 DROP LOGIN syntax error

This snippet of code (it's just a repeater, not the actual code I'm going to run) throws a syntax error on the DROP LOGIN command: declare @obso_user varchar(16) set @obso_user = 'BEN_VA\20362781' ...
0
votes
0answers
36 views

Unable to connect to SQL Server over SSL

I am unable to connect to a SQL Server over SSL. This is the current setup: A server at my location sends data to an external service (SQL Server 2008) using SSL. We are using Websense and an ASA for ...
1
vote
4answers
44 views

SQL Express connection issue [closed]

I have installed a instance of sql-express for an MDT deployment solution (XYZ-Deployment) I've got to the stage where I add a database share and when I go to add it, I get the following error ...
-1
votes
1answer
617 views

MSDTC Port 135 open bi-directionally

I have two servers, a web application server and an SQL Server database running on its own server. I have a firewall between these two servers. Do I have to open port 135 on both the SQL Server and ...
1
vote
3answers
107 views

How to use the join statement in MSSQL correctly? [closed]

I am pretty new to SQL and I already read something about joins , but coudn't find out. I painted my scenario here : I want to update the Firstname of Table1 into Temp1 where the CreateTS of the ...
1
vote
0answers
27 views

Server network communication stalls

I'm running SBS 2008 as a file server, SQL server, IIS7 Server, and Exchange server, and very recently I am getting some very confusing stalls on it. During these "stalls," file services will cause ...
0
votes
2answers
41 views

SQL2008R2Std Maximum RAM per instance

In this page : http://msdn.microsoft.com/en-us/library/ms143685%28v=sql.105%29.aspx It's written that SQL 2008R2 Standard supports 64GB of RAM, but is it per instance? For SQL2012 (here : ...
1
vote
1answer
28 views

32 and 64 bit MSSQL on same server

Is it possible to install a 32bit instance of SQL Server and a 64bit instance on the same 64-bit server? I have ODBC drivers that are 32bit, and need to use these as linked servers in SQL Server, so ...
1
vote
0answers
29 views

Why is $job.LastRunOutCome always “Failed”?

I am using sqlps to run a backup job "Backup Something". Set-Location "SQLSERVER:\sql\$hostname\default\jobserver\jobs" $job = Get-ChildItem | Where-Object {$_.Name -eq "Backup Something"} ...
0
votes
1answer
3k views

How does SQL Server calculate the sample size when sp_updatestats is run without explicitly setting a sample size?

The SQL Server documentation for sp_updatestats states that: If 'resample' is not specified, sp_updatestats updates statistics by using the default sampling. How exactly does SQL Server ...
1
vote
1answer
88 views

Licensing and Editions of Microsoft BizTalk and SQL for Development, QA, Stage vs Production [duplicate]

My question is similar to this one, but I am gearing mine more toward which edition to use. In the past places I've worked, these decisions were made by other teams, and now I'm being asked to ...
0
votes
0answers
277 views

How do I permanently add additional connection parameters in SQL Server Management Studio

In the "Additional Connection Parameters" tab of the login form for SQL Server Management Studio (most recent versions), one may specify custom connection string parameters. See ...
0
votes
1answer
45 views

MSSQL: Restore a DB to the latest file in a backup set

I have a MSSQL 2008R2 DB in SIMPLE recovery mode that is periodically backed up with BACKUP DATABASE MyDB to DISK = 'Z:\MyDB.cbak' WITH COMPRESSION This runs periodically, creating multiple ...
1
vote
4answers
158 views

Why is it so hard to get servers with Lot of Ram, but few cores?

SQL server has a very high per core license cost, but for a lot of workloads benefits more from lots of RAM. his is now even more of the case with in-memory tables. Even if a server with 4 cores ...
2
votes
1answer
121 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
59 views

SQL Service Accounts and which to use

I've done lots and lots of searching and I cant seem to find a simple answer, I assume it is because everyone's circumstances differs however; We need to setup a few SQL servers for production and I ...
1
vote
1answer
29 views

Azure SQL Data Sync between SQL Azure and Azure VM

I used two have 2 SQL Azure databases and they were automatically synced using this service: http://www.windowsazure.com/en-us/documentation/articles/sql-database-get-started-sql-data-sync/ Now one ...
1
vote
6answers
1k views

Performance of MSSQL Server Express Edition

Our Company has several SQL Server Enviornments, some of them work with MS-SQL Server 2005 Express Edition others with Standard or Enterprise Edition. In a discussion today a DBA said MSSQL Express ...
2
votes
1answer
46 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 ...
0
votes
0answers
41 views

What is a good set of performance counters to measure scalability bottlenecks

We're moving our enterprise product to the cloud (IAAS) and are determining how many users we can support on a single VM. Our product uses SQL Server, SharePoint and a bunch of WCF services. What ...
0
votes
0answers
39 views

Running MS SQL Server DB for Ubuntu PHP site

I'm going to be developing a php site (actually more of a application), but the standards and restriction of what I'm building make MS SQL Server the most appropriate DB solution (will also be running ...