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
2 answers

SQL Passing a List as a SqlCommand Parameter

can i pass a List into a SqlCommand as a paramter? DELETE FROM MyTable WHERE Key IN @MyParam command.Parameters.AddValue("MyParam",MyList); i realize i could just loop over the list but i was looking for a cleaner solution.
KellCOMnet
  • 245
  • 2
  • 11
0
votes
2 answers

SQL Server Express backup/restore error: The Media Family on Device is Incorrectly Formed

Basically, I'm having this issue: http://www.sqlcoffee.com/Troubleshooting047.htm What I'm doing is running a script I found online (http://pastebin.com/3n0ZfybL) to do a full backup, then rar'ing up the file and moving it to my computer. The CRC of…
Chris
  • 183
  • 3
  • 3
  • 6
0
votes
1 answer

Amazon EC2 SQL Server Connection

I have two instances running on Amazon AWS EC2. One is running MSSQL Server 2005, the other is running a web application. I CAN connect to the database in my app using a connection string that references the Public IP of my EC2 instance running SQL…
None
0
votes
2 answers

Why would the SQL 2008 "Generate scripts..." utility generate an invalid SQL script?

I have a SQL2008 database that needs to be restored to a SQL2005 instance. I have gone through the "Generate scripts..." wizard, set it for SQL2005 compatibility, and generated a 62MB SQL script. When I run it on the SQL2005 instance, it throws all…
Deane
  • 247
  • 3
  • 9
0
votes
2 answers

Locking User account created under Windows Authentication in SQL Server

As per my project requirement i need to lock a user in SQL Server(Which is created using Windows Authentication). Is there any way to do this? Thanks for the help Santhosh
Santhosha Kaldambe
  • 113
  • 1
  • 5
0
votes
1 answer

how to check the charset and collation of mysql database?

how to check the charset and collation of mysql database? or what command to the charset and collation of mysql database? Thanks
Weiwei
  • 367
  • 1
  • 5
  • 10
0
votes
1 answer

How to log all sql going through JBoss datasource with log4j

I've looked at log4jdbc (which does not support datasources), p6spy which seems to be what I am looking for but it has not been updated since 2003 which makes me nervous and lists only JBoss 3.x (we use JBoss 5), and JAMon which seems heavyweight…
Ichorus
  • 485
  • 1
  • 6
  • 12
0
votes
1 answer

Sql Server security Issue

how to add Sql server user for specific database with backup and restore permission only ??
MZT
0
votes
2 answers

Select Distinct/Unique Rows from a Huge Table in SQL Server Without Timeout Errors

I have a table in SQL Server with around 400,000 rows. Unfortunately, this table has many duplicate rows, as there isn't a primary key. I'm using SELECT DISTINCT to get all unique rows, but as there's so many of them, I keep getting timeout errors.…
Maxim Zaslavsky
  • 211
  • 1
  • 4
  • 13
0
votes
2 answers

trying to install SQL 2008 on Windows 2008 server R2

I was trying to install MSSQL 2008 server on Windows 2008 server R2 Standard Machine, but I got this message: Program Compatibility Assistant, And that I should apply SQL server 2008 SP 1 I don't get it? Why doesn't it not work with this version I…
Nezdet
0
votes
1 answer

What do I have to do to see the generated SQL with JBoss 6?

How can I make JBoss 6.0M2 show me the SQL that it generates and sends to the database?
Aaron Digulla
  • 974
  • 3
  • 15
  • 25
0
votes
1 answer

SQL Server not liking dates in YYYY-MM-DD format

Is there a setting in SQL Server which will persuade it to accept 'yyyy-mm-dd' style dates in a query. Got queries which are running fine on most of our SQL servers one box running Microsoft SQL Server 2005 Developer doesn't like them. This is the…
domspurling
  • 263
  • 1
  • 3
  • 5
0
votes
6 answers

Massive SQL issue shutting down our site

Our website has started timing out like crazy today. All of our clients are finding it unusable. The only error we can seem to trace down as a potential problem is this: SQLAllocHandle on SQL_HANDLE_DBC failed Error ASP Description Error Category…
James P. Wright
  • 131
  • 3
0
votes
1 answer

SQL Server 2008 Restore from Backup fails with error 3241 'cannot process this media family'

I am attempting to backup a database from a SQL Server instance on one machine and restore it to another, and I am encountering the frequently discovered 'SQL Server cannot process this media family' error. Each of my instances are SQL Server 2008,…
pearcewg
  • 183
  • 3
  • 8
0
votes
1 answer

Microsoft Windows Web Server 2008 + Microsoft SQL Server 2008 Web Edition

I am a totally rookie in this area. I am about to rent a Dedicated Server, that has Microsoft Windows Web Server 2008 installed in it. The plan is to put a web application that we have developed in it. But for this web application, we need Microsoft…
Marco
  • 13
  • 2
1 2 3
…
85 86