Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql]

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. [mysql], [postgres], [mssql], or [oracle].

An abbreviation of "Structured Query Language," SQL is a database language used to manage data in relational database management systems.

Due to many vendor implementations of SQL (such as T-SQL for SQL Server & Sybase, PL/SQL for Oracle and PostgreSQL and MySQL) it is a fractured language and syntax that works with one vendor may not work with another.

1284 questions
2
votes
5 answers

Sharepoint High Disk I/O - WSS_Search_SBS2011.mdf

Have a low specced server I've been troubleshooting (it is above MS's minimum specifications for SBS2011) One of my next steps is disabling what I can of Sharepoint as it is not used. Here are previous steps I took to recycle IIS Worker Processes,…
HaydnWVN
  • 415
  • 2
  • 8
  • 27
2
votes
0 answers

Restricted LDAP mimic server backed on SQL

I may not be an expert on the subject, but it seems to me that 99% of any LDAP server installation is used only to provide user authentication credentials and nothing more. Given this restricted scope use, and being that exactly what I need, I would…
lvella
  • 314
  • 2
  • 13
2
votes
1 answer

Oracle- Can't access objects from other users schema

I have an oracle database with 2 users. I have created a table in one of the user accounts, but cannot access the table from the other account ("table or view does not exist"). It doesn't work when I prefix the table name with the username…
Lock
  • 1,637
  • 7
  • 26
  • 33
2
votes
1 answer

Restoring Microsoft SQL databases to a different disk partition on the same server

We have a SQL Server 2005 box running Windows Server 2003 R2 Std 64bit. We have two production databases residing on one partition (which is an iSCSI software target), that partition got apparently got corrupted and the databases are not working…
Zero Subnet
  • 699
  • 3
  • 10
  • 29
2
votes
1 answer

SQL Server (2012 Enterprise) Browser service failing

SQL Server (2012 Enterprise) Browser service failing I have a problem as described below: I have an instance of SQL Server 2012 Enterprise (thanks to MSDN) for local development on my PC. I try to start SQL server Browser Service from SQL Server…
Watki02
  • 587
  • 2
  • 12
  • 22
2
votes
0 answers

SQL Replication cannot access file

When setting up a subscriber it fails on the first sync with the message The process could not read file due to OS error 2 I have tried setting the security rights for the directory to full control for the user credential that runs the…
Cornelius
  • 131
  • 1
  • 6
2
votes
2 answers

what would need to change on IIS for SSL Enabled SQL server

I have IIS set with windows intergrated security, the intranet c# web application connects database with trust connection. Everything works fine until we enabled SSL on the database (Sql server 2008), now we have the following error Login failed for…
Richard
  • 21
  • 2
2
votes
1 answer

How should I configure my Active Directory servers so that if one goes down, users are not kicked off SQL?

Today, we shut down one of our Active Directory servers during office hours to check the loading on a UPS. Since all the server did was provide Active Directory in a separate building incase the main building caught fire, or whatever, we didn't…
Matty Brown
  • 675
  • 3
  • 13
  • 24
2
votes
1 answer

Copy a database from Denali CPT3 to SQL 2008 R2

Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a couple of databases on it. Now we have an…
primero
  • 157
  • 1
  • 7
2
votes
1 answer

How do you read an Oracle .dmp file on a Mac?

I have a ~1GB .dmp file I'd like to get the data out of and I'm on a Mac. Is there any way to do this without either buying Oracle or finding a windows machine? Can you import .dmp files into PostgreSQL or other SQL/NoSQL databases that are easy to…
Lance
  • 233
  • 2
  • 8
2
votes
2 answers

SQL query to Automatically Export to file and FTP?

I am wondering if there is such a way to automatically run SQL queries and export to file (example: csv file) and then FTP to desired location? It seems simple and would need something like this as it would be very time consuming doing this…
Jarred
  • 41
  • 1
  • 4
2
votes
2 answers

How do you migrate a SQL Membership database with encrypted passwords where the decryption key is autogenerated?

I have a server where the machine.config states the following: A decryption key was not specified, it was auto-generated. I'm moving…
Shane
  • 243
  • 3
  • 7
2
votes
1 answer

Problems creating a functioning table

This is a pretty simple SQL query I would assume, but I'm having problems getting it to work. if (object_id('#InfoTable')is not null) Begin Drop Table #InfoTable End create table #InfoTable (NameOfObject varchar(50), NameOfCounter varchar(50),…
Hoser
  • 125
  • 5
2
votes
2 answers

IIS 7.5 ApplicationPoolidentity when SQL Server is on another server

Could someone advise on best practice for setting up the Application Pool Identity for the web service under the following scenario IIS7.5 Web Service requires read/write permission to SQL database IIS and SQL are on different servers but on the…
HJM
  • 21
  • 2
2
votes
3 answers

Server RAID and Partition Config for Small SQL Environment

I've got 5 databases that run on separate servers using SQL Express. Some of these include a Citrix Datastore, Citrix Edgesite Server, an AV db, Time and Billing App, and a document management program. These all currently run on separate servers…
Untalented
  • 21
  • 1
1 2 3
…
85 86