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
0
votes
3 answers

Error in connecting SQL Server

I have a LAN network consisting of 2 laptops where my friend's laptop is acting as a server and my laptop is acting as a client...I could detect my friend's instance i.e PC/SQLEXPRESS an d so can he.... I have created a login name and password in…
sujitanand
0
votes
1 answer

MySQL on a laptop for remote workers - MyISAM keeps corrupting

We have an application that is used by remote, mobile workers. It intalls WAMP (Server2Go) on a laptop and uses MySQL to store data locally. All tables are MyISAM. Once a day, the workers sync the database to our central server via HTTP scripts…
Jonathon
  • 57
  • 1
  • 7
0
votes
2 answers

MySql and SQL Server resources utilization comparision

Does Apache with MySql will use less system resources (RAM, CPU utilization) if we develop a web application instead of IIS with Sql Server? My friend told that MYSQL consume very less when compared to SQL Server. I have both PHP and ASP.NET skills.…
Koti
0
votes
2 answers

Restoring Database on SQL Server 2005 Issues

I have created a backup of my production database and whenever I try to restore it on my local machine I get the following error: The media family on device C:\projects.......name_of_the_database_.bak is incorrectly formed. SQL SERVER …
user21004
  • 153
  • 1
  • 7
0
votes
2 answers

This database is not enabled for publication

USE GlobalSales; GO EXEC sp_helpmergepublication GlobalSales EXEC sp_helppublication GlobalSales EXEC sp_helppublication_snapshot GlobalSales GO -- Execute this batch at the Publisher. DECLARE @publication AS sysname; DECLARE @subscriptionDB AS…
senzacionale
  • 328
  • 1
  • 6
  • 16
0
votes
1 answer

SQL Server 2005 Express Edition - Replication Support

We move from sql 2008 standard to express. I know publication/subscription is not allowed in sql 2008 express. I would like to know if is any other option for replication in express version? Regards
senzacionale
  • 328
  • 1
  • 6
  • 16
0
votes
2 answers

How to encrypt data at rest

How can you encrypt data at rest on Sql Server Web Edition? TDE is apparently not an option, but I don't know what else is available. Any recommendations?
Brandi
  • 177
  • 1
  • 6
0
votes
1 answer

multiple clustered sql server

Is it possible to have more than 2 servers? (mirror principle) for multiple cluster?
001
  • 491
  • 1
  • 11
  • 21
0
votes
1 answer

How to clean up an improperly installed SQL server

I have a Win2003 64 bit server. Trying to install SQL 2005 Standard. The install tells me a previous install is still pending. I've rebooted to no avail. There is no SQL version listed in Add/Remove. I've removed the support files, native client…
Joe
0
votes
2 answers

Cannot drop a table in SQL 2005

I have a SQL Server 2005 SP3 box that one of my developers created a temp table on that we cannot seem to remove because it somehow got brackets in the name of the table? SELECT Name, object_id FROM sys.objects WHERE Name LIKE…
David Mathis
  • 898
  • 2
  • 9
  • 21
0
votes
6 answers

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?
Andy
  • 199
  • 1
  • 6
0
votes
3 answers

MYSQL Installation Problem

I was downloaded the MYSQL from this link http://dev.mysql.com/downloads/mysql/ But i cannot able to find the Installation file... How to create database & Table in mysql? It will work like SQL server or ? Need Help
Gopal
0
votes
2 answers

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 wheel if I don't have to. It could be used to check…
mellerbeck
  • 21
  • 2
0
votes
1 answer

Credentials work for SSMS but not (ODBC) LogParser script

Via SSMS I'm able to connect and navigate the server/db in question. but trying to connect via a logparser script the same credentials fail. I'm trying to execute this from the same box on which the server's running. the username is owner/dbo of the…
justSteve
  • 859
  • 1
  • 7
  • 19
0
votes
1 answer

SQL Server 22005: Top 1 * for a unique column?

I have data in a table (below), and I need to select the most recent update from each user. Here the data has been sorted by date, so the 'SomeData' column of the most recent unique value of each user. Top 1 SomeData isn't going to work because it…
Echilon
  • 105
  • 3
1 2 3
…
85 86