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

0
votes
0answers
5 views

Reporting SQL Vulnerability [migrated]

My first post here so i'll hopefully keep it simple. I have just finished building a CMS targeted at a certain industry and built a test site to see how everything works. Anyway I wrote a program ...
-1
votes
0answers
14 views

BLOB vs filepath on SQL server

I'm trying to determine if I should use BLOBs or filepaths to images on my SQL server. I've got a program that's used for auditing my office's products internally. One request for an update to the ...
-3
votes
0answers
21 views

SQL server backup started taking too long [on hold]

I have a database backup job which was taking 8 minutes but last couple of days it's started to taking about 45 minutes. There is no change in the server configuration. Enough disk space available. ...
0
votes
1answer
21 views

Constant error: “Grid edit, checkbox, Edit, Copy and Delete features are not available.”

For the last few weeks I have been getting the same message when logging on to phpMyAdmin, which prevent me from making any updates to or deleting specific lines. I get the following notice: ...
0
votes
1answer
30 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 ...
17
votes
6answers
28k views

GRANT SELECT to all tables in postgresql

Is there a one-liner that grants the SELECT permissions to a new user postgresql? Something that would implement the following pseudo-code: GRANT SELECT ON TABLE * TO my_new_user;
-2
votes
1answer
25 views

0.5 TB SQL Server Database, is it possible to store in a standalone server? [closed]

We are facing the task of storing of 0.5 TB of data in a SQL Server 2008 Server. Is it possible to do it in a standalone server? Later we also want to query for generating statistics of the data (a ...
2
votes
1answer
842 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
678 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: ...
-1
votes
1answer
28 views

Moving SQL Server 2008 R2 Logs Causing Access Denied Error

I have just tried moving the log location for the SQL server 2008 R2 logs as I have a fairly small System disk due to the massive size of the Winsxs folder, and now I am getting the following error in ...
1
vote
1answer
738 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
16 views

AuthDBDUserPWQuery with multiply tables

I have a MySQL authentication for SVN server. Configuration file looks like this: <Location /svn/project> ... AuthDBDUserPWQuery "SELECT Password FROM SVNUsers WHERE Nickname = %s" ...
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 ...
0
votes
1answer
10 views

Crossserver SQL Procedures Failing Mid Process

Really need help understanding whats happening. We have two LANs at work with a shared subnet between them acting as a bridge (migration from A > B underway) we recently migrated the server subnet ...
0
votes
1answer
21 views

Sql server 2008 r2 services won't start

We lost power couple of times and I suspect that the UPS didn't keep the server on. I checked the log and it shows that there were couple unexpected shutdowns. I was try to login to sql server ...
0
votes
0answers
35 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
44 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
42 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
73 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
26 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 ...
0
votes
1answer
38 views

Is an HP Proliant 350e Gen8 server appropriate for Primevera and Sage applications? [duplicate]

I want to buy a server to accommodate both the Primevera and Sage applications? Would a HP Proliant 350e Gen8 do? Are there any concerns about this platform?
1
vote
1answer
120 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. ...
-2
votes
1answer
68 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
44 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
729 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
390 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 ...
0
votes
1answer
48 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 ...
1
vote
0answers
48 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
36 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
50 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
35 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
23 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
76 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
327 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
711 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
746 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
104 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
20 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
85 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
724 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
152 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
352 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
50 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
4k 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
454 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
105 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 ...