Tagged Questions

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)

0
votes
3answers
39 views

Sql server transaction timeout

Is there any parameter to prevent long transactions? I would like to automatically rollback all transaction that takes more than 5 minutes. Is it possibile? I'm working on a Microsoft SQL server 2008 ...
2
votes
1answer
109 views

Error on CMDEXEC job step even with proxy account defined

I’m not yet used to managing permissions on SQL Server 2008. I’m currently trying to create a SQL Server job directly from SQL with a user that isn’t sysadmin (but has the role SQLAgentUserRole). ...
1
vote
1answer
43 views

Find out who installed SQL server - they forgot to add other logons

We have a site where one of our team of techies installed SQL Server 2012. They forgot to add our administrators group as sysadmins so only they can access SQL - everyone else gets "Access Denied" ...
0
votes
0answers
101 views

Actual minimum RAM usage of Windows 2012 Server + IIS + SQL Server 2014 Express + .NET application server

I currently have a physical server running Windows Server 2008 R2. I am planning to replace it with a cloud-hosted virtual machine running Windows Server 2012. The server needs IIS, SQL Server Express ...
3
votes
3answers
168 views

sql azure vs azure VM with SQLServer Express

Beside beeing cheaper is there any problem/advantages to use SQL Azure vs to use a VM with SQL Express? We are looking to setup a SQL server for more than 50 websites, do you have any ...
0
votes
1answer
19 views

MS-SQL Server Implicit_transaction on table

I'm trying to experiment with implicit_transaction on sql server. However, after executing: SET IMPLICIT_TRANSACTIONS ON; INSERT INTO [Interface].[dbo].[Log] ([String], [Time], [theUser]) VALUES ...
0
votes
1answer
35 views

What are the performance issues in SQL for single schema and multiple schema?

I have a critical performance scenario that, I have to use more than 100 schema in a database. Each schema having more than 50 tables and few views. I need to use join queries for communicating ...
1
vote
0answers
171 views

Kerberos Configuration Manager for SQL Server error “unable to access user principal information from the system”

When I launch the Kerberos Configuration Manager for SQL Server and try to connect to the local machine it's on, I am getting the error "Kerberos Configuration Manager for SQL Server error "unable to ...
0
votes
0answers
17 views

Password expiration in SQL/ODBC before AD

I have a script that emails users that their password expires in X days. Today a user got an alert that her password expires in 8 days. She was having problems with Excel and Access databases that ...
-2
votes
1answer
31 views

Does SQL Server Enterprise edition contain all the components that Business Intelligence edition has? [closed]

Are there any missing components that are available in BI edition but not in Enterprise edition?
1
vote
1answer
51 views

Databbase file structure on disk [closed]

I'm an interested in the fundamentals of databases for a project that I am currently working on. Specifically the physical storage on disk and how rows and indexes are stored in a file. For the most ...
1
vote
1answer
50 views

What maintenance tasks should I run on my MS-SQL 2008/2012 servers?

The servers are using database mirroring for high-availability running SQL server standard on newer hardware. The existing plans were setup by a DBA many years ago and are using the built in ...
0
votes
1answer
72 views

Sql Server 2012 Disk I/O Too high

I am running SQL Server 2012 on windows azure VM Windows server 2012. This is a live Database, about 250GB, with high usage. I applied some best practice articles for the temp-db long ago, and also ...
0
votes
1answer
39 views

How to run validate cluster test without taking cluster offline?

I'm trying to run "Validate a Cluster" wizard but when I selected Run all test it gave a warning that running storage test will result in role failure. What test can I run in Run only tests I select ...
-1
votes
1answer
61 views

Will an average PC run a 10 concurrent write intensive request with 50MB daily database server? [closed]

As I am a average programmer who have never been purchasing any hardware myself, I have to choose a computer for a prototype database server that will be used to serve 10 concurrent request per one ...
0
votes
0answers
48 views

Why is MSSQL 2008 saying @filter_clause is invalid and that articles do not exist when creating a new publication from a script?

I have a snapshot publication on a test server with a pull subscription set up on another test server (both SQL Server 2008 R2). This publication takes a snapshot of a few columns in a few tables for ...
0
votes
1answer
70 views

Windows server and ddns which binding and sql hostname do i use?

i'm trying to connect to websites on this server from outside the network. i've opened ports in router and firewall and can ping the ports using portchecker. let's pretend i want to use wordpress or ...
0
votes
1answer
52 views

Should I move to an Azure database? [closed]

I am currently using a database from an installed instance on my web server in a VM on Azure. I was thinking about moving it to an actual Azure Database so I could load balance the web server. Does ...
0
votes
1answer
238 views

MSSQL 2014 and Dynamics CRM 2013 SP1 (springwave)

Microsoft says MSSQL 2014 is not supported with MS Dynamics CRM 2013 (SP1 springwave '14). Is this because there are known problems with that configuration? Or does it just mean that Microsoft did ...
0
votes
0answers
16 views

Issues installing MSSQL extension in IIS

Hello long time lurker first time poster, I'm running PHP 5.4 on IIS and have installed the extensions mssql (SQLSRV30.exe) and activated the extension in the PHP manager. However, whenever I use ...
0
votes
2answers
163 views

Microsoft SQL Server Standard High Availability without Shared Storage

I'm a software dev with little experience managing SQL so please bear with me! We are developing a piece of software that needs to be highly available, with a significant degree of resilience. This ...
2
votes
2answers
49 views

Where is that backup file?

I want to restore a database using the most recent backup. In SSMS, it says there was a backup done this morning at 1:00 AM. Screenshot: If I select this backup, it fails, saying the file ...
0
votes
1answer
56 views

What happens when Core Cluster Group is failed over to another node? Will it take the whole cluster down? Single point of failure?

http://bit.ly/1lKJFIa "Cluster group" fail-over will cause cluster go offline. Really? Single point of failure? Am I missing something? What happens when Core Cluster resources (Cluster Group) are ...
0
votes
3answers
102 views

Windows Server SMTP Feature - Installation Ramifications

Background: I am a SQL Server DBA. I have inherited about 50 SQL Servers and need to set up various maintenance plans and alerts. To get the full benefit, I'll also need to configure Database Mail ...
0
votes
1answer
457 views

Error connecting to sql server database when running IIS from DMZ

I've been working on this for a few days now. One of our clients has a 3 tier server plan - an IIS server, an application server (where the Asp.Net MVC3 application is located) and the db server. All ...
0
votes
1answer
111 views

MSSQL: Roll back DB from backed up .MDF/.LDF

I've mistakenly deleted a table in Microsoft Server Management Studio, and the restore function was not properly configured. I have older .mdf and .ldf files of the particular db with the deleted ...
0
votes
1answer
79 views

Connect to Windows Server 2012 Essentials without creating new user login for Windows

Is it possible to connect to a Windows Server 2012 Essentials without having to create a new user login for Windows? I want to just take someones Windows 8 machine and connect it to the server to ...
0
votes
0answers
85 views

Transferring Windows server from Rackspace to AWS

I've had a Windows server hosted with Rackspace for a while. The same setup also hosts the SQL server, and has all the IIS configs, etc. Being a Windows server noob, I have no idea how I could ...
1
vote
1answer
91 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 ...
0
votes
0answers
10 views

Google app engine server not answering when queried in bulk

I've recently launched my game worldwide and we currently have problems with our google app engine server not always giving it's result messages when bulk querying. By bulk query I mean sending 100 ...
0
votes
1answer
54 views

Rebuilding MS Agent Jobs from MSDB table

This morning our DB server died. They restored backups to another server but these didn't include the many MS Agent jobs. Anyway I have managed to get a backup of the old MSDB table where all the ...
0
votes
1answer
54 views

How do I know which node in a cluster answers?

I have set up an NLB with two servers (nodes) which are running the same service. The filtering is single host, because I don’t want them to run at the same time, because there is data in the cache ...
0
votes
2answers
239 views

SQL server performance over long distance

Is it reasonable to expect decent performance from a SQL server connected via fiber private WAN - 5000 km's away. The carrier is telling us that this network is the 'best' possible, and will ...
0
votes
1answer
88 views

RAID 10 Cluster Size for SQL Dynamics AX Database

Many article read and many websites visited yet still no closer to a firm or concrete answer. We have created all our Arrays for our SQL 2012 installation with the appropriate LUN's and understand ...
0
votes
1answer
230 views

High memory usage windows 2008

I have a Windows server with 32 GB RAM, which is running sqlserver and tomcat. In resource monitor it show more than 95% memory usage, but when I searched in processes all process, each process is ...
1
vote
1answer
362 views

SQL Server 2014 Setup Fails with Error 5 - Terminal Services Unsupported?

I am installing SQL Server 2014 on a hosted virtual machine using remote desktop. When I run setup command line options display using .\setup.exe /? , I get the following error: An error occurred ...
0
votes
1answer
62 views

How to locate the cause of a excessive memory in ms sql

We are experiencing memory issues with MS Sql 2008 R2. There appears to be a memory leak that is consistently increasing in memory usage until it gets to about 1.5 gb and then stops. We have used ...
3
votes
1answer
60 views

How can I verify whether a Windows cluster has previously been successfully validated?

As part of an automated SQL Server installation process, I'd like to programmatically check whether a Windows Failover Cluster has already been validated. There are some ways to validate the cluster ...
0
votes
0answers
377 views

Intermittent Error SQL Server Error 67 and 17

We are running Windows SQL Server 2012 Standard on Windows Server 2012. There is a SQL Database with an Access Front End which we migrated from older versions of Access and SQL. The Access front end ...
-1
votes
2answers
139 views

Amazon RDS - UTC daylight savings

I haven't been able to get AWS support on the line and need an answer asap - do the SQL instances on Amazon Web Services RDS use daylight savings? I know the timezone is UTC but not sure if it uses ...
0
votes
0answers
52 views

SQL Server 2014 Standard 2014 no access and bad preformance

My company looks after a server which is running SQL Server 2014 Standard Edition. The main application database on the server is replicated out to about 20 subscribers. The server has only been in ...
1
vote
1answer
138 views

Password case sensitivity when upgrading from SQL Server 2000 to 2005

Anyone please help! Today is 3rd day that I'm banging my hand to solve this problem. So the situation is, I've inherited a project which worked on SQL Server 2000, later client decided to upgrade the ...
0
votes
0answers
56 views

Network Issues Connection to SQL database on MS server

Prior to asking this question, I followed this thread: Cannot telnet to SQL Server on port 1433 I am attempting to connect to a database on a server distinct from the computer upon which I am ...
1
vote
0answers
59 views

SQL Server Background Task Running?

I am developing a web application, which consists of a .NET application, using Entity Framework, and MS SQL 2012 back end. Every now and then we experience a slowdown in the system, which causes ...
0
votes
1answer
49 views

Perfmon % Processor Time unbalanced

I am somewhat of an accidental DBA, and I'm troubleshooting a SQL Server box where performance has been notoriously poor (as reported by the customer). I was not involved in the initial planning of ...
0
votes
0answers
23 views

Access Multiple Remote MSSQL Server DBs from Single Web Console for DBA

Purpose: Performing Queries, Generating Reports from Database Issue: At Present, I manually connect to each server, then do perform queries and generate reports. There are multiple Remote sites ...
1
vote
1answer
320 views

Can SQL server 2012 Service Pack 2 be applied to an Express Edition instance?

I need to upgrade an instance of SQL Server 2012 Express Edition (SP1) to Service Pack 2. Can the standard Service Pack 2 package be applied to an Express Edition instance, or do I need to run the ...
1
vote
0answers
123 views

MSDTC Errors: QueryInterface failed for “ITransactionDispenser”: 0x8004d01c(XACT_E_CONNECTION_DOWN)

I’m having some issues with a server where MSDTC is not working properly. This started happening about two days ago. I’ve tried a number of different things including restarting the VM and I’ve ...
0
votes
1answer
722 views

Time-out occurred while waiting for buffer latch type 3 for page (1:401831), database ID 8

I'm getting the below error while insert record into a SQL 2005 SP3 DB. Msg 845, Level 17, State 1, Line 1 Time-out occurred while waiting for buffer latch type 3 for page (1:401831), database ID 8. ...
0
votes
0answers
26 views

SQL Server Express Application Deployment Via CD

Our company has an ancient home-grown Win-32 application which uses a SQL Server Express db. We have a salesperson at a remote office who has no reliable internet and I need a way to package this app ...