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

1
vote
0answers
16 views

SQL & BITS Errors on prereq for SCCM 2012

Hey anyone that can help, I've been stumped by this problem for a while now and I've no idea what to do. I've installed SQL 2008 to run with SCCM '12. I've set Log On As a domain account with ...
0
votes
1answer
19 views

How to backup SQL database without users and stored procedures

I have a database which i need to take backup monthly / or by running an script. I need to backup the data and structure only. I don't want to backup stored procedures and users for example... I have ...
0
votes
1answer
77 views

Clone database or copy data from RDS MSSQL DB to local database

Is there anyway I can clone an amazon RDS MSSQL DB to my ec2 instance local DB? And this has to be done through powershell also. Basically I need backup of RDS MSSQL DB in sql or bak extension, but ...
0
votes
1answer
17 views

SQL Server 2008: Delete database while Rollback is in progress

I am trying to remove a test database in which a database modification failed. The resources being consumed by the rollback action in SQL are affecting production databases (users reporting slow ...
0
votes
1answer
23 views

SSRS Report fails with conversion error but runs fine in ssms?

I have an issue with a report that was written before my time (I warn you it's got a lot of code and the error makes no sense). Basically its a stored procedure that creates a table variable and then ...
0
votes
2answers
319 views

Generic sql query email alert program

Has anyone ever ran across a program that in a generic manner will execute a sql query and then based on criteria email out alerts. Going to create such a framework but don't want to re create the ...
1
vote
0answers
23 views

MSSQL application failing to connect to database server

We run a very old application that connects to an MS SQL server 2008 database using the SQL server native client 10. Sometimes if there has been a power failure with the server the clients will stop ...
0
votes
2answers
138 views

SQL Server Express and SharePoint

We have a client that would like to use SQL Server Express with SharePoint instead of forking out a minimum or $7000 for SQL Standard. I know SQL Standard is the best option here, but the price tag is ...
1
vote
1answer
15 views

Why Sql browser local connection works when turned off

I recently get to interesting issue with Sql server browser. I have Win 2008 R2 datacenter server running multiple instances of Sql server and Sql browser. The instances are running under dynamic port ...
0
votes
1answer
1k views

Sending Email from SQL Server Agent scheduled job

I've scheduled a job in SQL Server Agent that sends the result of a query in an email. If I execute the stored procedure from SSMS, it works fine. But the SQL Server Agent is not able to send emails. ...
1
vote
1answer
12 views

SP_UsageAndHealth Database, What Is It and Can I Shrink It?

I have a SharePoint 2013 server whose SP_UsageAndHealth database started growing out of control this morning. It's grown from about 50GB to a terrabyte and a half in the space of a couple of hours. ...
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
18 views

Asphostportal IIS6 vs IIS7

I have two shared accounts at asphostportal. One uses IIS 6 and one uses IIS7. On both I have websites in Classic ASP. On the IIS 6 account, when I make an error in code and upload it then try to ...
13
votes
2answers
12k views

Third-party SSD solutions in ProLiant Gen8 servers

I was wondering if anyone had any specific experience using Intel DC3700 SSDs (or similar) in the HP (DL380p) Gen8 servers? I'm upgrading a set of database servers that use direct-attached storage. ...
0
votes
1answer
1k views

SQL Server doesn't allow to execute subquery as dynamic SQL

I tried to make a dynamic SQL which gets all tasks for some users The procedure [GetAllSubExecutorsByUserId] returns IDs of all subalterns of curent user I write these IDs into a temporary table, and ...
1
vote
2answers
1k 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. ...
0
votes
0answers
38 views

postgres sql returning "more than one row returned by a subquery used as an expression

Postgres sql is returning: more than one row returned by a subquery used as an expression The data base format is: rpt_rec_num | wksht_cd | line_num | clmn_num | itm_val_num ...
0
votes
0answers
10 views

Sql Express DB on Server 2008 R2 is there a product to test for coding errors

This is mostly an annoyance and not a huge problem. The issue is tied to the execution time for server requests for small data pulls. If I ask thee software to create a list of any 200 clients ...
0
votes
0answers
34 views

hMailServer --> find all bounced back emails

I've been assigned to clean up some of our obsolete client's email from database. So the process was to send all client an email and see which one bounces back. now the problem is I can't find where ...
0
votes
0answers
30 views

Import outdated MySQL dump using console

I have a mysql dump file created by outdated MySQL version. I have no access to that server (console). If i use this command on my current server: mysql -u user -p dbname < dump.sql I get this ...
0
votes
1answer
9 views

SQL User Bulk Removal

After I removed an AD Group from the general security area, it's still mapped to about 18 Databases (This is a QA box) how can I get rid of all the account without having to go through each DB one by ...
4
votes
2answers
6k views

Converting Filemaker to SQL or another database system

Currently at work we have a Filemaker database running on Filemaker Server 7 on a Windows Small Business Server 2003. I would like to change from using Filemaker to a different database, one with a ...
0
votes
1answer
284 views

How to rebuild 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
0answers
66 views

SQL Listener on Azure can't connect

I'm having an issue trying to create an SQL listener on a VM hosted in Azure. I have followed the instructions from MS on this link and everything seemed to go through fine. The listener created ...
0
votes
1answer
21 views

Can SQL Server 2008 R2 be used to allocate resources by specific program?

Recently, I have come into a scenario where I have been brought in to help manage a hosted system where we host our own product for our customer. Each customer is given a unique user to a specific ...
0
votes
2answers
40 views

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
2
votes
1answer
4k views

MySQL table does not exist

I am getting following error in err file. 110803 6:51:26 InnoDB: Error: table `ims`.`temp_discoveryjobdetails` already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm ...
1
vote
1answer
773 views

Unexplained CPU and Disk activity spikes in SQL Server 2005

Before I pose my question, please allow me to describe the situation. I have a database server, with a number of tables. Two of the biggest tables contain over 800k rows each. The majority of rows ...
1
vote
0answers
23 views

X3250 Server: stuck at firmware screen

The server is initialize, then it is stuck at the IBM System X Server Firmware screen (before F1, F12 appears, etc). You can see in the attached image. ...
21
votes
3answers
13k views

Is there a MySQL equivalent of SHOW CREATE TABLE in postgres?

Is there a MySQL equivalent of SHOW CREATE TABLE in postgres? Is this possible? If not what is the next best solution? I need the statement because I use it to create the table on an remote server ...
2
votes
1answer
3k views

ERROR 1 (HY000): Can't create/write to file (Error code :13)

Iam trying to create a mysql table in linux with changing data directory to another location. The selected forlder having full permission. But I got an error 'Can't create/write to file'. I googled ...
3
votes
1answer
70 views

SQL Server 2008 Restored Database allows differential backup when no full exists

I restored a backup file (it's used as a template for new databases) as a new database. Normally as part of this process, I take a full backup after the restore, but this time I was called away on ...
0
votes
0answers
12 views

Does SQL Azure Data Sync conflicts get logged?

I have successfully synced my SQL Azure DB with my on-premise DB. The log shows the following: Sync completed successfully in 1884.76 seconds. Upload: 405323 changes applied Download: 0 ...
0
votes
1answer
174 views

Sql 2008 r2 wildcard certificate

I have installed wildcard certificate in Certificates(Local Computer)\Personal in sql server. We are using Windows 2008R2 server and 2008 R2 SQL. Certificate is issued by StartCom. With certificate ...
-2
votes
1answer
42 views

sql server: best practice for log backup in full recovery mode [closed]

I have a development sql 2014 environment. I need to put all db in full recovery mode in order to test availability groups, so I need to manage logs to avoid excessive growth. I don't need to keep log ...
-1
votes
1answer
1k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
0
votes
1answer
50 views

SQL Server - Cant connect to instance with either windows auth or SA account

I have just installed SQL Server 2012 and I cannot connect to the new instance using any method. The instance is MSSQLServer I have attempted \MSSQLSERVER, .\MSSQLSERVER, localhost\MSSQLSERVER and ...
0
votes
0answers
23 views

MSSQL 2005 - Server Service unable to start while installing

I am trying to install MSSQL 2005 Express on an VM running Windows Server 2012. I get to the point where it installs everything but fails to start the service. I have tried checking the Log-On ...
0
votes
2answers
9k views

how to get mysql.sock file, mistakenly deleted from “/mysql/tmp/”

I was stuck with a PDO Exception PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in lock_may_be_available() (line 167 of ...
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
2answers
246 views

How to increase performance on ASP.NET/IIS/SQL website

We have a small internal ASP.NET website running on IIS8 and SQL2014 express. The server is an onsite dedicated server 2012 R2 VM that has both IIS and SQL server on it. The server CPU usage rarely ...
1
vote
1answer
54 views

Will a SQL incremental backup work for my purposes?

We are transitioning a large amount of data, in the form of a SQL database, from one location to another and the data transfer speeds are very slow but we want to cause as short of an interruption of ...
0
votes
0answers
8 views

SQL alwaysON and WSFC

I have a WSFC configured on 2 (hardware)nodes with SQL AlwaysOn group. The problem is, if the node Where I have created the cluster goes down the cluster is not available for second node and here ...
1
vote
1answer
807 views

How to filter columns in SQL Server replication?

I need to replicate some data from two tables in one database to another databases. I used snapshot replication. The issue is that I would like to replicate only some selected columns and the others ...
3
votes
0answers
45 views

Update SQL Service Pack Named Instance

I have an existing SQL 2008 R2 on SP3. Have another instance in use that is SQL 2008 R2 SP1 I need to update the named instance with sp1 to sp3 but i'm not getting any options. It tells me my version ...
0
votes
1answer
95 views

Is there a way to kill a range of session ids (connections) in ms sql server?

i was wondering if there is a way to kill a range of SQL Connections on an Microsoft SQL DB. If i want to kill a single session id i can use kill [session-id]; go;. If i want to kill all sessions i ...
0
votes
0answers
31 views

SQL 2014 Collation Policy job failing

I have setup a new SQL 2014 server and created a policy to make sure all DBs have the same collation. I created a DB names test and gave ##MS_PolicyTsqlExecutionLogin## permission to it and all ...
0
votes
1answer
79 views

How to attach a database created by sql 2008 to sql 2012 when full text catalog missing? [closed]

I have an already created mdf file which was created by sql server 2008.But when I attach this mdf file to sql server 2012 it asks me to add necessary full text catalogs. I have no idea what to ...
0
votes
1answer
33 views

Concurrent MySQL processes

I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours). My ...
0
votes
1answer
502 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 ...