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 Server database recovery issue

In SQL Server 2005 when I try to attach my database (MDF) it shows 'not a primary database', but this database has one MDF and one LDF only. How can I fix it?
user433177
0
votes
1 answer

Why is sql server changing the value of the minimum and maximum memory?

I have a SQL Server 2008 R2 x64 instance. I tried to change the Minimum and Maximum memory to 60 MB and 2000 MB using Management Studio (Server Properties->Memory). When I close and reopen Management Studio I see those values still there. However,…
Juan Tarquino
  • 113
  • 3
0
votes
1 answer

SQL Server: job with PowerShell step with robocopy doesn't end

I have a multiple steps SQL job set up in that basically generates transactions logs and then copies them using robocopy. Robocopy steps are of type “PowerShell” and look like following: $src=(Invoke-Sqlcmd -Database 'msdb' -Query "select…
Ariel
  • 423
  • 5
  • 15
0
votes
1 answer

Raid Caching configuration suggestions

I'm wondering if there's the optimal Cache setting for the following Raid controllers and raid setups. (OS: windows 2008 R2, App: II7, DB: SQL Server 2008 R2 Enterprise) PERC 6/i: (The default setting seems to be: No Read Ahead/Write-back) 2 Disks…
BlueFox
  • 169
  • 2
  • 5
0
votes
1 answer

Index rebuild stored procedure fails while calling temporary table

SQL Server 2008 Enterprise on Windows Server 2008 Enterprise Cluster that is used to support SharePoint 2007 and 2010. We have a weekly index rebuild job that first checks the index fragmentation, and if there is greater than 10% fragmentation then…
Ddono25
  • 165
  • 3
  • 13
0
votes
1 answer

Sql server 2005 linked server to 2008 error A severe error occurred on the current command

I am able to query few tables on the linked server but few tables are giving me this error. Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. Msg 0, Level 20, State 0, Line…
Ved
  • 133
  • 1
  • 4
0
votes
2 answers

SQL 2008 R2: How to determine who restored the database?

Our database was recently restored. It caused some real grief. Is there an audit mechanism to determine who executed the most recent restore? Thanks.
Jerry Nixon
  • 103
  • 2
0
votes
2 answers

Running sql server 2000 backup file on sql server 2008

I restored sql server 2000 .bak file to sql server 2008 by --RESTORE FILELISTONLY --FROM DISK = 'D:\DBHarshal\full backup august 6.BAK' --ALTER DATABASE EPICSms --SET SINGLE_USER WITH --ROLLBACK IMMEDIATE RESTORE DATABASE EPICSms FROM DISK =…
hrishi
0
votes
3 answers

Cannot complete sql server 2005/sql express 2005 installation in my system

I am trying to install sql server 2005 in my system after uninstalling a previous version of corrupted sql server 2005. But while starting to install sql server services during installation process an error is occurring. The error is as follows:…
Harun
0
votes
4 answers

sqlldr job not running through Autosys

I have a shell script that if run manually or via Cron executes fine and loads a delimited file using sqlldr to the database successfully. However via Autosys the script executes, sqlldr says it was successful, however the data is never actually…
Frank
0
votes
1 answer

SQL authentication not authenticating in MS SQL Server 2008

When I try to connect to the SQL Server running on localhost using Windows Authentication in SQL Server Management Studio, I am able to connect but when I try to connect using SQL authentication, it says Login failed even though I know the user with…
Arunabh Das
  • 103
  • 1
  • 4
0
votes
1 answer

MySQL 5.1 Slow SHOW DATABASES (phpMyAdmin)

We have about 200 databases and since upgrading from 4.1 to 5.1 we've noticed that PHPMyAdmin takes a while to load the left navigation sometimes. Is there anything we can do to make this quicker? Thanks!
Kristopher Ives
  • 384
  • 1
  • 3
  • 14
0
votes
1 answer

MS Reporting Services

We are setting up a two MS 2008 servers to handle our web application. On server A, we are running MS SQL 2008 Web Edition with our database. On server B, we are running IIS, MS SQL 2008 Web Edition with just MS Reporting Services. When I trying…
MCEWR
0
votes
1 answer

SQL 2005 Replication Error - Upgraded SP3

I recently upgraded my SQL 2005 server to SQL 2005 SP3. I have replication from SQL 2005 to SQL 2005 both are standard edition. During the upgrade I experienced no issues and the replication that was already setup continue to work great. I recently,…
Brennan Mann
  • 133
  • 1
  • 3
0
votes
2 answers

Problem connecting to database after a RESTORE. SQL Server 2005 and Classic ASP

I have some Selenium test scripts which I'm using to test a Classic ASP web app, but I'm having problems after restoring the database (SQL Server 2005) with a backup file before every test is run. Immediately after the successful RESTORE (from a…
bartonlee
1 2 3
…
85 86