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
5
votes
4 answers

Upgrading Sql Server 2000 to 2008

At my place of employment we have been thinking about upgrading from SQL Server 2000 to the latest (2008). We know that the DTS packages will have to be dealt with since the newer server software no longer supports them. Has anyone done this…
Terry
  • 1,073
  • 1
  • 11
  • 17
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 2008 Trace Flag 4135

Does anyone have any idea what this flag does? There is no reference to it on MSDN. It is not a part of the article that lists available trace flags in 2008. There is a KB article that recommends that it is turned on to resolve a specific issue…
lnediger
  • 211
  • 1
  • 5
5
votes
5 answers

Remote connection sql server not working but if firewall disabled it does?

I have setup sql server express 2008 on a windows 2008 server. And i have done all the standard stuff in sql to allow remote connections. The strange thing is if i disable the windows 2008 server firewalll .. it works. I have opened a port as 1433…
user11655
  • 197
  • 1
  • 1
  • 5
5
votes
1 answer

Allowing a specific IP Address through a blocked port in Windows Server 2008 R2 Firewall

I have created an Inbound rule to block port number 1433 however I need to allow my static ip address to access this as I use SQL Management Studio to connect to databases on the server. I have tried adding my ip address to the "Scope - Remote IP…
Hesky
  • 151
  • 2
5
votes
1 answer

SQL Server PowerShell cannot find path error

I cannot use Set-Location to change to a database. I have loaded the SQL Server snapins. I can use Set-Location to get to SQL\Localhost\SQLEXPRESS\, and I can show the paths under the server node with Get-ChildItem. However, if I try to change to a…
Jarrett Meyer
  • 191
  • 1
  • 7
5
votes
3 answers

How does SQL Server handle simulataneous read/write requests?

Background: We have an application which uses an SQL Server 2008 database heavily. We are trying to optimize this application. It was single threaded, and we noticed through logging/ profiling of the app that the largest bottleneck was db…
Erix
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
1 answer

Store a table in a memory

Is there a way to make SQL Server to store a table with 10 attributes and 10 rows like this on memory? a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 ---------------------------------------- 138 498 365 345 500 473 498 125 134 800 448 498 362 348 500…
edgarmtze
  • 219
  • 1
  • 6
5
votes
2 answers

SQL Server Column Level Encryption - Rotating Keys

We are thinking about using SQL Server Column (cell) Level Encryption for sensitive data. There should be no problem when we initially encryption the column, but we have requirements that every year the Encryption Key needs to change. It seems that…
Mike Barlow - BarDev
  • 516
  • 5
  • 8
5
votes
2 answers

SQL Server Trial Edition to Full Edition

I installed SQL Server 2008 R2 for the 180 day trial. We tested the system and it's working fine, and I wanted to convert it to full version. The problem is, I have a volume key licence to SQL Server, and the Microsoft support says that there is no…
user67714
  • 357
  • 1
  • 4
  • 12
5
votes
4 answers

MS SQL Server 2008: How to export all the tables into CSV?

I have to migrate from MS SQL Server and now creating a new ORACLE database with the data partially got from my old tables. For that I need to get the data from dozens of tables as unicode CSV or TXT files, with fields separated by "|". The bad…
Andrew
  • 321
  • 3
  • 5
  • 11
5
votes
4 answers

Log Shipping to an Existing Database

We have a few huge databases we would like to log ship on SQL Server 2008. Unfortunately the link between primary and secondary servers is fast enough to handle log shipping but the initial backup/copy would tie up bandwidth for days, if not weeks,…
SeanDav
  • 161
  • 1
  • 3
5
votes
1 answer

Why does sp_send_dbmail fail inside SQL Agent jobs?

I have a simple query that I run to send email notifications to our AD account administrators when accounts have been disabled for more than 30 days. It works perfectly fine when I run it on my own, logged in as SA, but it fails when run inside SQL…
Ben Wyatt
  • 311
  • 1
  • 4
  • 11
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
  • 1
  • 2
  • 7
1 2 3
…
99 100