Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sql-server-2008]

SQL Server 2008 (major build version 10.00.xxxx). Please also tag with sql-server.

SQL Server 2008 was introduced in August 2008. Current build versions include:

  1. 10.00.1600 - RTM
  2. 10.00.2531 Service Pack 1, released April 2009
  3. 10.00.4000 Service Pack 2, released September 2010
  4. 10.00.5500 Service Pack 3, released October 2011
  5. 10.00.6000 Service Pack 4, released September 30, 2014 (final)

SQL Server 2008 left mainstream support on 2014-07-08, and will leave extended support on 2019-07-09.

3877 questions
24
votes
2 answers

How to change the instance name of SQL Server Express 2008?

On my development machine I've installed SQL Server Express 2008, but it has the instance name .\SQLEXPRESS. I want it to be the default instance. I'm pretty sure that I selected the "Default Instance" option in the setup, but apparently it didn't…
Vilx-
  • 724
  • 1
  • 5
  • 12
23
votes
5 answers

Location of the mdf file of the database

I have a database Project. My problem is where can I find the .mdf and _log.ldf of my database so that I can transfer my database to another user. I am using Microsoft SQL Server 2008 Management Studio My Ssms.exe is stored in this…
Shreyas tg
20
votes
3 answers

using *tables* as Table-Valued Parameters (TVP)

MS SQL 2008 supports TVP: a useful feature for bulk uploading data to a stored proceedure for processing. Rather than create a user-defined type, is it possible to leverage an existing table definition? For example, is it possible to create a…
Pressacco
  • 463
  • 1
  • 4
  • 10
17
votes
2 answers

How to create Sql Server login for a domain account?

All, I have Sql Server 2008 installed on a server (let's say Server1) in a Domain (let's say AD). I also have a domain account called AD\Sql1. This is not an Admin account on the Domain (AD), but I want it to be an admin on the Server1. And then…
UB01
  • 937
  • 2
  • 9
  • 18
16
votes
1 answer

Performance implications of using OPENQUERY in a view

Please see this question on stackoverflow : I am using an EasySoft ODBC driver to link a SQL Server 2008 R2 Express instance to Interbase and I am having some difficulty with getting metadata from the remote server. From looking about on the…
Rich Andrews
  • 283
  • 1
  • 2
  • 7
15
votes
2 answers

How to Drop Database in Single_User Mode

How do I drop a database which shows DatabaseName (Single User) as its name? When I try to delete it, I get the following error: Alter failed for Database 'DatabaseName'. (Microsoft.SqlServer.Smo) ALTER DATABASE statement failed. (Microsoft SQL…
Prasad Kanaparthi
  • 251
  • 1
  • 2
  • 5
13
votes
3 answers

How do I determine if a table exists in a SQL Server database in SQL Server 2008?

How do I determine if a table exists in a SQL Server database in SQL Server 2008?
Amir Rezaei
  • 633
  • 1
  • 7
  • 13
13
votes
4 answers

Creating centralized DBA database

We have 200+ servers and I am thinking about creating a centralized DBA database where it logs backup, errors, space jobs and generate reports on SSRS. I am not sure where to start and I would highly appreciate your help. Thank you very much.
db7
  • 1,371
  • 4
  • 16
  • 20
12
votes
2 answers

SQL SERVER Storage of TinyInt

In SQL Server, why is a tinyint stored with 9B in the row. For some reason there seems to be an additional one byte at the end of the NULL bitmap mask. USE tempdb ; GO CREATE TABLE tbl ( i TINYINT NOT NULL ) ; GO …
ooutwire
  • 1,437
  • 10
  • 18
11
votes
1 answer

Backing up database without transaction log

When I backup a database is there a way to exclude the transaction log in that backup? Or am I thinking about this wrong and to restore the original database the content of the transaction log is required? I cannot shrink the transaction log because…
peter
  • 2,187
  • 5
  • 19
  • 38
11
votes
3 answers

Insert Missing Dates from a query

How can i insert missing dates from a query i created. The result below: Date Frequency 2014-05-18 5 2014-05-20 7 2014-05-25 7 2014-05-27 6 I want the result to have missing dates with 0 value as shown below: Date …
Arvin
  • 171
  • 4
  • 4
  • 9
11
votes
3 answers

Database starts always in recovery mode

Everytime I restart my server, the database is always in recovery mode, and it takes about 20 minutes for it to behave as normal. This always and only happens when I restart the server, so I have a few questions... I was told this could be caused…
pick4pony
11
votes
3 answers

Maximum table capacity in SQL Server 2008

I have an application which inserts more than 1 billion rows annually into a table. This table contains some varchar and bigint columns and one blob column as well. The 1 billion rows consist of history data which are kept for tracking purpose. So…
GAP
  • 121
  • 1
  • 3
10
votes
4 answers

SQL Server renaming table from another database

Is there a way in SQL Server to rename a table in another database? When you are in current database and migrating data over to another database in the TEMP table and then renaming TEMP table in that another database. I do not want to use "USE…
AAA
10
votes
2 answers

SELECT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'

Whats wrong with this statement? why it gives below error message Error Message: SELECT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views…
user164767
  • 157
  • 1
  • 1
  • 7
1
2 3
…
23 24