Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008]

A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here

1806 questions
20
votes
11 answers

Diagnosing Microsoft SQL Server error 9001: The log for the database is not available

Over the weekend a website I run stopped functioning, recording the following error in the Event Viewer each time a request is made to the website: Event ID: 9001 The log for database 'database name' is not available. Check the event log for…
Scott Mitchell
  • 483
12
votes
4 answers

How can I see who is connected to my db?

I was trying to rename a database and it said that it needed to be exclusively locked to perform this operation ... How can I check who is connected to it?
Alex Gordon
  • 455
  • 3
  • 14
  • 31
11
votes
2 answers

How to enable remote connections for SQL Server 2008?

How do I enable remote connections on an SQL Server 2008 installation? I have created a rule in the windows firewall to allow traffic through port 1433, but that does not seem to be enough.
Kjensen
  • 1,069
11
votes
4 answers

Is there a way I can use SQL Server management studio to find all columns that have column names that contain a certain substring?

I'm using SQL server management studio 2008. I have a huge legacy database with thousands of columns. It would be nice if I could search for all columns whose names contain a certain substring. Does anyone know how to do this? Thanks!
IsaacB
  • 335
6
votes
4 answers

Storing SQL Server System Databases On A Seperate Drive

Is it worth moving the SQL Server system databases master, model and msdb from the default install path on the main OS hard drive over to their own drive? I've already moved TempDB on to 2 separate drives one for the log file and one for the data…
Gavin
  • 253
6
votes
3 answers

Giving a user database permissions in SQL Server Management Studio

In SQL Server Management Studio, when I right click my database and click properties, a window opens showing the permissions users have on the database. I have recently added a user to active directory with the intention of granting this user…
Kyle
  • 165
6
votes
4 answers

Troubleshooting SQL connectivity issues after database migration

We have a just completed a migration from SQL 2000 to SQL 2008 R2 and have started to intermittently receive SqlExceptions with the following two error messages: A transport-level error has occurred when receiving results from the server.…
Chris Shaffer
  • 768
6
votes
6 answers

How to recover the database which is accidently deleted using sql server 2008

How to recover the database which is accidently deleted using sql server 2008?
laxman
6
votes
1 answer

SQL Server Management Studio 2008 Express installation

Is it possible to install SQL Server Management Studio 2008 Express without installing the SQL Server 2008? I have now the SQL Server 2005 and SQL Server Management Studio 2005 Express on my computer.
user34110
  • 63
5
votes
1 answer

32-bit SQL eating up RAM on 64-bit OS until SQL is brought to its knees

This may be related to other threads I've seen, but I need a solution to this specific situation. The SQL instance continuously consumes more and more RAM until after about a week it's grabbed over 3.5 GB of RAM (remember it's a 32-bit instance, and…
scubabeme
  • 51
5
votes
3 answers

How to see when stored procedures have last run

I want to see a listing of all the stored procs for each database on a server along with when the last time that store proc was run. I'm pretty good with SQL but I don't know about looking at stats like this that sql keeps so I'd appreciate a…
Brandon Moore
  • 456
  • 2
  • 6
  • 17
5
votes
2 answers

sql server: losing identity column on export/import

Recently I started dealing with SQL Server, my previous experience was in MS-Access. When I'm doing an import/export of a db, from the server to my computer or even in the server, all column with primary key loose the key. Identity is set to false…
Y.G.J
  • 317
  • 5
  • 14
5
votes
2 answers

Under what circumstances is it a good idea to re-index tables every night?

I have inherited a number of SQL Server 2005 and 2008 systems (all running in Simple recovery mode) that each currently do the following things each night from an SQL Agent task: Backup Shrink Reindex I have stopped the shrink from happening as…
Mark Hatton
  • 213
5
votes
2 answers

How can I create a read only Sql server 2008 account?

I want to be able to give read only access to my SQL Server 2008 database server. In particular two databases one called "live" and one called "stage". Essentially the guys who receive this username and password should be able to select from any of…
Stewart Robinson
  • 1,155
  • 4
  • 12
  • 24
4
votes
3 answers

Copy database from SQL Server 2000 to SQL Server 2008

I'm trying to transfer a database from SQL server 2000 to SQL Server 2008 using the copy database wizard, but I keep getting an error that tells me to check my error logs. I go check the log and there is nothing on the error. Has anyone had a…
Nick O
  • 195
1
2 3
…
14 15