Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [tag:mysql], [tag:postgres], [tag:mssql], [tag:oracle]

learn more… | top users | synonyms

-2
votes
1answer
64 views

do all type of sql server license have SA account? [duplicate]

We are trying to upgrade our sql server from 2005 to 2012. we got some offers for different type of license from some resellers. the only thing I'm not sure now is, there's one type core license with ...
0
votes
0answers
12 views

SQL VSS Writer missing from VSSADMIN

We just installed the latest updates for patch Tuesday onto our AD FS 2.0 farm members. Everything went fine except for one of them, after the updates were installed and I rebooted the server, the ...
3
votes
1answer
677 views

Deleting MySQL rows causes lock table error

I had a couple million rows to delete but they can't be deleted at once without this error ERROR 1206 (HY000): The total number of locks exceeds the lock table size So I wrote a script to delete ...
3
votes
9answers
1k views

How can I prevent attacks on my SQL Server installation?

In the past month I've noticed in my event viewer on a sql server a lot of failure audits. Seems like a brute force attack from an ip in china trying to log in to the sa account which i have disabled. ...
0
votes
1answer
369 views

Having trouble piping between cygwin and sqlcmd

This simple command fails in bash: echo "print 'tsql'" | sqlcmd -E it works correctly in a regular old command prompt. It used to work with previous versions of cygwin. I've also tried inserting ...
2
votes
1answer
727 views

SQL Server: How to report error from a job's step of PowerShell type

I have a SQL job whose step of 'PowerShell' type does 'exit 1' if encounters an error i.e. $ErrorActionPreference='stop'; trap{"$_"; exit 1} Problem is, SQL Server doesn't pay attention to that exit ...
1
vote
1answer
640 views

When installing SQL Server, “Unhandled Exception: System.Security.SecurityException: Request failed.”

Brand new Windows Server 2008 R2 install handed over to us from Windows admin group. I try to run the SQL Server 2008 R2 install and get this error: Unhandled Exception: ...
0
votes
1answer
23 views

CUCM Nested SQL query to link devicepool and licensing

Cisco's licensing manager has a shortcoming in that it provides licensing data per enterprise instead of per cluster. I am attempting to utilize SQL queries to produce this data. Currently, i have two ...
-2
votes
0answers
18 views

SQL Server and CAL licensing [duplicate]

I have a doubt regarding the SQL Server and CAL licensing. Suppose I am the system administrator of a company planning to host a SQL server (For a web based ERP). I have 30 concurrent users who will ...
1
vote
1answer
716 views

SQL Server: “This filegroup cannot be used as a backup destination” error when attempting restore

When running a command like the following: "RESTORE FILELISTONLY FROM DISK='\\\\server\\folder\\DummyDB.bak'" I'm getting this error: Backup destination "\\server" supports a FILESTREAM filegroup. ...
0
votes
1answer
2k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
1
vote
0answers
26 views

How can I unlock a large amount of files on isilon storage if a process had them open?

Some background information : I have a couple SQL servers that have half their databases on isilon storage (I know, no bueno. I'm in the process of moving them). During the night one of those SQL ...
2
votes
1answer
1k views

Problem accessing MICROSOFT##SSEE database (Error: 18456, Severity: 14, State: 16.)

After an unexpected server shutdown due to a power failure, I can no longer connect to the internal windows database MICROSOFT##SSEE which is hosting Central Admin for my SBS 2008 server. The log ...
0
votes
1answer
30 views

SQL, website and desktop application on a Windows Azure server?

I recently started considering Azure over my current VPS host PhotonVPS for Virtual Machines. I assume that Virtual Machines are the same as VPS servers (please correct me if I am wrong about that). ...
0
votes
1answer
41 views

Upgrade from SQL 2008 to SQL 2012: do we need to change connection string?

We are seeing some terrible performance degradation having just upgraded our MVC4 application from SQL 2008 to SQL 2012. Queries run directly in management studio on the database server run somewhat ...
0
votes
0answers
29 views

SQL Server Management Studio Import Wizard

I am trying to import a small excel spreadsheet into SQL using the SQL Server Management Studio Import Wizard, which is running on the Windows server (2008 R2) itself. When clicking "Import Data" from ...
0
votes
1answer
19 views

SQL Server Backup to Azure Tool

I downloaded and tried the Microsoft SQL Server Backup to Azure tool for SQL Server 2008. My goal was to get access to the backup compression functionality built into it. I have it configured to ...
0
votes
1answer
68 views

Delete files except ones created on sundays with in last 4 weeks

I have a script that copies some files around and deletes older files from destination. right now it just deletes everything older than 10 days. to increase backup retention we need to keep files that ...
2
votes
1answer
298 views

Active Directory + IIS + SQL + ASP.NET

I have sent the following question to stackoverflow website I have installed Windows server 2008 r2 on a virtual machine, Can I install Active directory with domain controller + IIS + SQL server ...
1
vote
2answers
668 views

CPU being pushed to 100% by a process, trying to track and eliminate the problem

I am having trouble with the web servers CPU getting stuck at 25%, then 50%, then 75% until finally maxing out at 100%. Which we are guessing may be some slightly slower SQL queries stacking up, but ...
1
vote
4answers
1k views

Why upgrade from SQL 2005 to SQL 2008 R2?

have been tasked to write a document outlining the best reasons to use SQL 2008 R2 instead of SQL 2005 for my brand new BI project. We have a policy of only using two versions at a time and there are ...
0
votes
1answer
728 views

SQL server corrupt page

hi i am getting the following error when i try to select data from a table. SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:6380; actual 0:0). It ...
0
votes
1answer
69 views

Database Copy Fails, but nothing fishy in the logs

I am attempting to copy a database from a remote server (sql server 2008) to my local machine (running sql server express 2014). Everything looks great, right up until the job fails at "Execute SQL ...
0
votes
0answers
15 views

After upgrading to TFS 2012 is it safe to uninstall “Microsoft Team Foundation Server 2010 Sharepoint Configure”

After upgrading TFS from 2010 to 2012, I find that in Add/Remove Programs, there is till this software listed: Microsoft Team Foundation Server 2010 SharePoint Configure Also, I still see the ...
1
vote
2answers
68 views

How to force sqlite3 table to take next available id for auto increment in firefox sqlite3 manager?

We delete some records in a sqlite3 table (re-id record manually) and compact the db. However when adding a new record in firefox sqlite3 manager, the auto incremented id is not the next available id ...
0
votes
0answers
627 views

sql script not running from task scheduler

I'm trying to run a MS SQL Server backup from the Task Scheduler (Windows Vista, MS SQL Server Express 2005) If I run the script manually (open the cmd and execute the script) it works. If I add the ...
0
votes
2answers
145 views

Can you have two sql instances on 1 server, with an IP each for local network access?

This is partway setup, but not sure what I've been asked to achieve to 100% possible. 1 server 2 instances of SQL Server 1 internal IP for each sql instance 1 external IP for each sql instance ...
0
votes
1answer
323 views

Allocation error in Database in sql server 2008?

I have found following errors when I use DBCC CHECKDB command. I don't have idea to fix the error. please help me. CHECKDB found 124 allocation errors and 0 consistency errors not associated with ...
0
votes
1answer
41 views

Single website across multiple servers [closed]

Please forgive me if I'm using incorrect terminology. I tried searching for my question, but I'm not quite sure how to word it in terms simple enough for a search. I found this post and this post ...
6
votes
6answers
3k views

DHCP server with database backend

I have been looking around for something to replace my (ancient) ISC-DHCPd server. A DHCP server with a database backend sounds like a great idea to me, as I could then have a nice, friendly web ...
2
votes
3answers
4k views

What do I do when pg_cancel_backend doesn't work?

If I have a long-running Postgres query, and regular "kill [pid]" doesn't work, and pg_cancel_backend doesn't work, what should I do?
0
votes
2answers
223 views

MySQL database really slow with a really big table [closed]

I have a MySQL table with 150 million rows. Below is its data structure. Below is some of its data. Now, using PHP My Admin I ran the below command. SELECT `iwords` FROM `wordstable` WHERE ...
3
votes
1answer
97 views

Windows 7 WMI ODBC driver installation?

I am interested leveraging the ease of report production provided by Microsoft SQL Report Builder, but I would like WMI as an available datasource. Since SQL Report Builder relies only on SQL, I ...
0
votes
0answers
17 views

SQL Server Reporting Services 2012 Chinese Language

When running reports in SQL Server 2012 Reporting Services (SSRS), Chinese (Asian) characters show up as question marks (?). Any idea on how to have the characters display properly in reports? ...
0
votes
0answers
29 views

Any other option than HTTPS + Basic auth for reverse proxied IIS site that uses double hop authentication to SQL server

We've been struggling for a while to get, what I had assumed would be a relatively common scenario to work and would appreciate any pointers. We have 2 x Windows 2012 Servers running IIS Server SQL ...
0
votes
1answer
140 views

Do manual backups of SQL Server databases interfere with the automated backup process?

I was once told that running manual backups of SQL server databases from Managament Studio was a big no-no on production databases as it can interfere with the automated backup jobs on the server. ...
1
vote
1answer
110 views

Remove permissions on sysobjects table for db user sql 2012 like in ms sql 2000

In a bygone age in ms sql 2000, if I wanted to remove a db users ability to view the sysobjects table in Ent. Manager I'd find the user in the database, right click him, select properties and then ...
0
votes
0answers
28 views

SQL Server Table Partitioning and my data lifetime management

My application stores data on Enterprise edition sql server, and I plan to take advantage of table partitioning to manage data retention. Each partition will hold a predefined period of time (say one ...
0
votes
1answer
74 views

PORT 1433 in use by LSASS.EXE, therefore cannot start SQL Server Service

Sysinternals's TCPView shows that port 1433 is used by this OpSys process, both local and remote addresses contain my FQDN, which is a Win Server 2008-R2 fully patched, has someone faced such a ...
0
votes
1answer
34 views

DBVis SQL Query - Using Date Variables

Firstly it's been a very long time since I did any SQL and even then it wasn't at a high level. I have created a SQL query which works but I want it so the date range changes automatically, for ...
1
vote
0answers
106 views

SQL server intermittent connectivity issue every 4 or 5 days

I have a .net web application that calls sql server 2008 running on a different server. From last couple of weeks, after every 4 or 5 days, web applications connectivity to sql server becomes an ...
1
vote
0answers
74 views

Log In failed for user error 18456

I have two servers. Both of the servers have two different database that will be joined together using SQL Server Agent. However, during this activity SQL Server is throwing a Log In Failed Error. ...
1
vote
1answer
47 views

HeidiSQL, attach/register database in MSSQL server

How to attach (or register) an existing MSSQL database to a server Using HeidiSQL
4
votes
2answers
326 views

SQL Clustering or Hyper V Clustering

We will soon be implementing our Dynamics AX installation. Our aim is to have high availability and we are working closely with our implementers. We raised the question to them about SQL and Hyper-V ...
1
vote
2answers
1k views

How do I troubleshoot root cause of a hung windows (2003) server?

I have a pair of Windows (2003 Server) servers both running MS SQL Server (2008 EE) that each hang every few months. This has been occurring intermittently :( for the past 15 months pretty much since ...
0
votes
1answer
32 views

SQL 2008 R2 replication with Oracle DB Server Issue

I am configuring replication between SQL 2008 R2 & Oracle DB server. Getting below error "ORA-01830: date format picture ends before converting entire input string (Source: MSSQL_REPL_ORACLE, ...
-3
votes
6answers
1k views

How to make a huge ram drive?

At my old job when a report was needed I could sit down with someone and pull up results and get immediate feedback, and then refine my queries and ultimately have the data we needed, in the format we ...
-4
votes
2answers
81 views

Is RAM size related to SQL performance? [closed]

I have some simple code that generates 3 millions insert queries. I have two VPSes, one with 512MB RAM and one with 2GB RAM. On the 512MB RAM VPS, I can insert about 50,000 rows in 5 minutes. On the ...
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.
-1
votes
6answers
886 views

Running many databases under one instance

Is it best to have one single instance with many database or to spread the databases across a few instances?