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
2answers
164 views

omd nagios monitoring servicestate mssql / Failed to open service

I'm trying to monitor mssql service in OMD nagios, but with no success so far. Communication port: 1433 instance name is like: MSSQL$instance Here's my check: check_command check_nt!SERVICESTATE!-l ...
1
vote
1answer
30 views

Execute Trigger as Login

Is it possible to impersonate a login when running a trigger? I able able to run execute as 'username' but not execute as login='username' I can usee execute as as such with EXECUTE AS login='smr' ...
0
votes
1answer
21 views

How to re-create the symmetric key on Amazon RDS

We have some column encrypted by symmetric key. Now we want to upload our database to Amazon RDS (SQL Server). Can we do that? If yes, how?
0
votes
1answer
39 views

Password Manager Pro backend database MS SQL vs PostgreSQL [closed]

I'm looking to manage users passwords through the programme Password Manager Pro. Reading the documentation it explains that you can use ether your own MS SQL database or use their default PostgreSQL ...
0
votes
2answers
76 views

MSSQL-Server: rebuild vs reorganize Index and Update Statistics

We had a database which was very slow (MS SQL SERVER). Now we figured out, that the indexes were never rebuild oder reorganised. (At the moment it is not clear if this really was the problem but we ...
-2
votes
1answer
21 views

Install SQL Express 2005 over 2012

I have a Amazon EC2 Windows 2012 with SQL Server Express 2012, but I need SQL server 2005, What I need to do to get it done? Thank you
0
votes
1answer
49 views

SQL Server 2012 Express - silent installation.

I am failing to silently install SQL Server 2012 Express (Advanced). I followed the guidance and this is my command: Setup.exe /q /ACTION=Install /FEATURES=SQL,Tools /INSTANCENAME=MSSQLSERVER ...
0
votes
2answers
265 views

SQL Server Transaction Log maximum file size

I have several databases, all in Simple recovery mode. There have been previous concerns about the log file sizes and I have shrunk them all using Management Studio's Shrink task. I have also placed a ...
0
votes
1answer
54 views

what happens to sql server if the active directory server goes down?

What happens to sql server if the active directory server goes down and the sql agent services is logged on as a windows user.
-2
votes
1answer
39 views

sql server 2005 on server 2003 slow performance [closed]

We are running a Windows Server 2003 r2 x64 with SQL Server 2005 (Production Server) on it. Our software provider usually access to our server to fix/update/add features to our systems ...
0
votes
1answer
116 views

Sql Server Transaction Log Backup Fails

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error "Error: ...
0
votes
1answer
709 views

sqlcmd is not recognised as an internal or external command, operable program or batch file SQL2014

I have written an installer that is supposed to install SQL Server Express 2014, create an instance, and then use sqlcmd to connect to the instance and build the database from a schema. It works by, ...
0
votes
0answers
27 views

MSSQL High Availability Advice Required

I'm looking to implement a high availability SQL installation using MSSQL2012 or 2014 and there is 1 part of this I'm not sure about. I plan to have a SQL cluster at site a, and a secondary SQL ...
0
votes
1answer
53 views

How to view the SQL Server transaction log on AWS RDS?

Is it possible to see the T-SQL Query log in AWS RDS? is there a UI for that in the console, or i need to use the CLI or SQL Management Studio?
0
votes
2answers
23 views

How to view datetime when a SQL Server DB was created?

I need to see when a Database was created in SQL Server, and who created it if possible. Is there a command to get that data?
0
votes
3answers
66 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
229 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
47 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
175 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 ...
4
votes
3answers
413 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
26 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
40 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
234 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
20 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
33 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
52 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
63 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
102 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
50 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
63 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
56 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
86 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
56 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
295 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
18 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
214 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
51 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
66 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
123 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
652 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
133 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
92 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
91 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
106 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
71 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
59 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
393 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
103 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
235 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 ...