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

3
votes
1answer
57 views

How to create SQL account that can only perform certain actions?

I'm used to working on contracts where someone else is responsible for the SQL database. However, I'm now working a contract where I must set up a new SQL Server, so I set up MS SQL Server 2012 ...
0
votes
1answer
401 views

Telnet 1433 on SQL Server Failing

I work with a number of SQL servers. Some are clusters and some are standalone. Some of the standalone servers run multiple instances and some do not. What I've found is that any SQL server I have ...
0
votes
0answers
124 views

SQL PowerShell Snapin Problems

I am hoping this is an easy fix and oversight on my part. I need to be able to run the SQL cmdlets from remote machines. I have installed Microsoft® Windows PowerShell Extensions for SQL Server® 2008 ...
0
votes
1answer
74 views

SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers

We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters. We started getting alerts two to three times ...
0
votes
1answer
128 views

Why I can't execute SQL query on Amazon Redshift from VPC private instance?

I have an instance in a private subnet in an Amazon VPC. This instance uses a NAT to access the Internet. I use the Redshift JDBC driver to connect to a cluster hosted in the same region as my VPC ...
3
votes
1answer
90 views

Windows Server 2012 Forest and Domain functional levels compatibility

I'm using a Windows 2003 domain, and a currently planning for a Windows Server 2012 upgrade, so I'm looking at all software which could be hurted by a Domain (and Forest) functional level raise to ...
-1
votes
1answer
39 views

Guide to choose which is the best for VM - microsoft or vmware [closed]

i am confused between VM Ware and Microsoft Hyper V whic one is the best in terms of all. is there any comparison chart then please let me know. as to run os in vmware need to install esxi; it is ...
1
vote
1answer
29 views

Terminal Server trying to connect to 1433/tcp on client

We are facing a strange issue here. Everytime a user connects via RDP client to one of our terminal server, the server itself tries to establish a connection via 1433/tcp to the client (and even ...
1
vote
1answer
122 views

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot ...
0
votes
2answers
72 views

Why is SQL Server IO so much slower than the disk capacity?

I'm running SQL Server 2012, and doing a simple SELECT * query, I can see that my disk IO in performance monitor is < 10MB/s. If I do a backup of the database, however, I see values > 200 MB/s. ...
0
votes
1answer
18 views

SQl Server not connecting

I am using visual studio 2012 and SQL Server 2008 R2... My Connection String is Data Source=MCPL-PRINT-PC\SCMSQLSERVER;Network Library=DBMSSOCN;Initial Catalog=SCM_DB;Integrated Security=True Now i ...
-2
votes
1answer
41 views

Is is safe to upgrade SQL server 2008

I have a windows vps with sql2008 express r2 (with tools) installed, one of my clients require full-text search feature. Sql 2008 with advance services has that feature. So my question is, is it ...
0
votes
2answers
96 views

Keep Getting an Error When Running My SQL Code

I keep receiving the dreaded "An expression of non-boolean type specified in a context where a condition is expected." errorr at the bolded "dbo.v_R_System.ResourceID" in the code below in the "From' ...
0
votes
2answers
48 views

How to allow domain groups access to SQL server?

I'm sure this is a simple problem, bu I've looked for days... I have a SQL server that is part of a domain. The domain has many many users. I want to allow select permissions to anyone within a ...
0
votes
0answers
77 views

Connection Timeout Expired

Message:Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and ...
0
votes
1answer
40 views

SQL Server normalizing for performance

I have a table create table Objects ( ObjectID bigint not null primary key, ObjectRef1 varchar(50) not null, ObjectRef2 varchar(50) not null, ObjectRef3 varchar(250) not null ) All ...
-1
votes
1answer
36 views

SQL Server 2008 R2 memory consumption for no usage [closed]

I have a application that uses SQL Server 2008 R2. I have a problem of memory consumption on the client side. Whenever the client runs the application, the SQL server starts consuming memory even if ...
0
votes
1answer
346 views

How do I grant select, insert privileges in Postgres on Cygwin?

How do I grant permissions in Postgres? I followed the documentation, however it is not working. $ psql tmadev psql (9.2.4) Type "help" for help. tmadev=# grant all privileges on database tmadev to ...
1
vote
3answers
91 views

MySQL high cpu load slow quries being logged need help to understand

I'm trying to troubleshoot a high load problem on a server, Today for some reason MySQL is taking up excessive CPU time. I have enabled slow-queries and found this query and others similar. The ...
0
votes
1answer
64 views

Which Database (SQL/NoSQL) is the best fit? [closed]

I have 2 nodes, one gateway and one worker. Data must be passed from gateway to worker (without direct connection). I would like to store a Key into a database identified with an ID and a Time To ...
0
votes
1answer
54 views

RDP Access in Windows Server 2012 [closed]

Is it possible to restrict RDP access the SQL server to be only from the Terminal Services server
1
vote
3answers
57 views

SQL Server 2005 Issue

I am stuck. I've just taken over maintenance on a SQL Server...that has not been backed up in quite a while...The log file has grown to over 1.61TB...Yes, 1.61TB. It has swallowed all available disk ...
7
votes
2answers
2k 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
88 views

Server shuts down when running sql query

Sql Server 2005 Windows Server 2003 64 bit 8 processors 3 volumes with at least 100 gigs free on each I was adding an sql index for a table with millions of rows and the server shut down. Nothing ...
1
vote
1answer
56 views

SQL Databases get stuck in Unavailable State daily

Every day I notice several of my project DBs on SQL 2008 R2 (v. 10.50.2500) get into a limbo state where they are unavailable. They're not technically offline in this case. In Management Studio, ...
0
votes
0answers
30 views

Best way to export / import an older mediawiki setup

I have a client who needs to export an entire setup for mediawiki (images/site/extensions/database/ect) so I can literally take the exported version, copy it into my htdocs (or www/ folder), import ...
0
votes
0answers
26 views

how to configure sasl authentication for openldap?

I have got cyrus-sasl and openldap2.4,and i want to define two or more sasl realms which can make identical user with different passwords in different sub trees of directory pass to sasl ...
0
votes
0answers
135 views

Data Protection Manager and SQL

We are currently using Data protection manager 2012 SP1 to back up our medical records database in SQL Server 2008 R2. The database server is running Windows Server 2008 R2 as a virtual machine with ...
1
vote
1answer
343 views

centos mysql keeps crashing, what to do?

I recently got a dedicated server under CentOS with OVH. Everything has been working fine since 2 months, but starting a few days ago mysql keeps crashing and that causes various problems with my ...
-1
votes
2answers
75 views

SQL 2012 Server Database Transaction Replication performance issue [duplicate]

We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers. We had implemented ...
1
vote
1answer
71 views

Importing old mediawiki SQL dump MAMP

I've been tasked with importing an SQL database to setup up with a local mediawiki website (v1.14). We were sent a SQL file with an image file to upload to the local site. After setting up mediawiki ...
0
votes
1answer
55 views

Grant user Permission using Wild Card on MYSQL

I'd like to Grant for example an insert permission for spacific user in all databases started by WA_ for example in my server I make the following syntax but it dosent work GRANT SELECT ON ...
0
votes
3answers
48 views

SQL Instances and Servers

I have two installations of SQL on two seperate boxes (I have "Inherited" these). A SQL 2005 Installation, with instance called SQL2005 - I connect to this via SQL Studio Manager and when I connect ...
0
votes
2answers
1k views

SQL Management Studio on Windows 7 64Bit

We're scratching our heads a bit here. We have SQL Server 2000 on our internal systems and I have a new machine. My old windows XP machine had Mgmt Studio (full version). I have tried to run the SQL ...
-1
votes
1answer
175 views

SQL Server 2012 - No connection could be made because the target machine actively refused it

I've searched for the solution for this problem for days now, found a lot of stuff but none of it worked. I've got an SQL Server 2012 running on Windows Server 2012. I'm trying to connect to the SQL ...
0
votes
3answers
52 views

Connecting mySQL to MSSQL

I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives ...
0
votes
0answers
52 views

Tips on Copying 3 Database files nearing 250 GB?

We are upgrading from SQL Workgroup 2005 to SQL Standard 2012. We have plenty of databases of smaller sizes that copied over with straight windows file copy in a reasonable time frame. We have one ...
0
votes
1answer
44 views

Need to DROP TABLE from 100s of SQL backup files

I have MS SQL Server 2008 available to me. Is it possible to script (perhaps with Powershell?) the processing of all my backup files to drop a table (or two) from each one? I used 7-Zip on the command ...
0
votes
2answers
66 views

Upgraded SQL server, performance plummets

Seeking help with a new SQL server. A client of mine was running an aging SBS 2003 server (Xeon 3060, 4 gig of RAM) and a line of business application with a 25 gig SQL Database using SQL Server ...
0
votes
1answer
46 views

MySQL replication as both master and slave (replication loop?)

I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current ...
0
votes
1answer
91 views

Sql server 2008 R2 using Half of the memory [closed]

i built a new 2 cpu 8 core 40 gb ram Server for our ERP software which use Sql server 2008 R2 on Win server 2008 standart R2, in Sql There are 7 databases, 2 of them for Tests, 2 of them to keep ...
1
vote
1answer
23 views

Migrating from SQL 2008 to SQl express on the same VM

I have a windows 2008 r2 VM running SQL std 2008. I want to migrate my database from SQL server to SQL express which is a free product. Since I have one VM, I plan to install SQL express alongside SQL ...
0
votes
2answers
43 views

Export import sql database without downloading

Recently i need to change my server to another webhosting providers server. To do that just discovered that my MySQL database size is too much to download & upload with the access that I have. ...
1
vote
1answer
147 views

Plesk MS SQL Data backup restore issue

I am tiring to restore mssql backup in plesk but it showing following error please give me suggestions. Error: dbbackup failed: Unable to restore database 'admin_db' Not valid backup Cannot open ...
0
votes
1answer
44 views

SQL Server Setup RAID 5, RAID 10

I am new to setting up SQL Servers and Vms. My predecessor used Raid 5 for C Drive where the SQL installation resided and RAID 10 for both database files and database logs. I was wondering whether ...
2
votes
1answer
108 views

Does changing a Service from Automatic to Manual mean that it is unable to be started by other services/applications?

Morning all. We have a script that checks for services that are set to Automatic, but not running. It alerts us if this is the case. We've got a couple of services, like SQL Server Active Directory ...
0
votes
1answer
37 views

How to allow a SQL Login to see only ONE database

i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases. ...
0
votes
1answer
122 views

SQL Error When Running My “Find All Unused Packages” in SCCM 2007 Report Console

SQL Error When Running My "Find All Unused Packages" in SCCM 2007 Report Console Asked by: the_ratzenator I am trying to run an SCCM 2007 Report to find all unused Pacakges in my environment and I ...
0
votes
1answer
34 views

Remote servers replicating data to a Master server for reporting

I have Windows servers that are running SQL Server 200(5/8) in many remote locations on the east coast. At our corporate office, we are trying to set up a reporting server that can get as real-time as ...
1
vote
0answers
79 views

SQL Server: Worse performance on a new server

We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on ...