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

SQL Server 2008 R2 Express + Wildcard SSL Certificate

Wildcard certificates (for example, *.example.com) simply did not work in SQL Server 2008 or lower. But Encrypting Connections to SQL Server on MSDN states, plain as day, that SQL Server 2008 R2 supports wildcards certificates. Excellent. So I set…
Nicholas Piasecki
  • 282
  • 3
  • 10
5
votes
3 answers

SQL Server 2008 R2 Enterprise database has unexpected 4GB database size limit

I have SQL Server 2008 R2 Enterprise installed on a local Windows 7 x64 workstation. When I create a database on the server, it unexpectedly has a 4GB size limit (Database properties in SQL Server Management Studio say size = 3934.38 MB, space…
Jesse
  • 153
  • 1
  • 4
5
votes
4 answers

Building a Data Warehouse

I've seen tutorials articles and posts on how to build datawarehouses with star and snowflakes schemas, denormalization of OLTP databases fact and dimension tables and so on. Also seen comments like: Star schemas are for datamarts, at best. There…
Paul
  • 714
  • 2
  • 6
  • 19
5
votes
2 answers

How do I login to SQL Server without having to use "Run as Administrator" when starting Management Studio, in Windows 7?

When I start Management Studio, unless I use the "Run as Administrator" selection, I cannot login to my local SQL Server. Is this normal? I am a normal developer and don't believe I have a need for high security on my local machine. I'm running…
MedicineMan
  • 185
  • 1
  • 3
  • 8
5
votes
3 answers

Migrated SQL Server database suddenly in "Restoring" state

Edit: This is still a live prob, less than an hour after trying RESTORE ... WITH RECOVERY. I backed up a SQL Server 2005 database and restored it to a new SQL 2008 instance. The restore was quick and successful. Everything was fine for an hour or…
Pete Montgomery
  • 154
  • 1
  • 5
5
votes
3 answers

Windows Server task manager displays much higher memory use than sum of all processes' working set size

I have a 16 GB Windows Server 2008 x64 machine mostly running SQL Server 2008. The free memory as seen in Task Manager is very low (128 MB at the moment), i.e. about 15.7 GB are used. So far, so good. Now when I try to narrow down the process(es)…
Sleepless
5
votes
3 answers

SQL Server Express

If I have 50k hits per day on a site using SQL Server express, is that an issue? How easy is it to schedule backup and other tasks? I know it's all doable, but is it more of a pain? EDIT: I would also like to add that I will use the same…
TPR
  • 285
  • 1
  • 5
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
  • 6
4
votes
3 answers

How safe is SQL Server's encryption of stored procedures?

Background I am using SQL Server 2008 Enterprise on Windows Server 2003 Enterprise. I developed some stored procedures for SQL Server and the machine installed with SQL Server may not be fully under my control (may be used by un-trusted 3rd…
George2
  • 1,137
  • 6
  • 22
  • 41
4
votes
5 answers

Installing SQL Server 2008 on Windows 7 64-bit

I'm having a shocking time trying to install SQL Server 2008 on 64-bit Windows 7. When I run setup.exe, I get the following error message: Microsoft .NET Framework 3.5 installation has failed. SQL Server 2008 Setup requires .NET Framework 3.5 to…
harriyott
  • 491
  • 1
  • 6
  • 12
4
votes
1 answer

Migrate SQL 2008 database to Azure

I am migrating a SQL server 2008 R2 production database to Azure SQL database service in the cloud. Is it possible to mirror/replicate the Azure database from the 2008 R2 database? So I can just switch over to just using the new one. Instead of…
Andreas
  • 309
  • 1
  • 5
  • 17
4
votes
6 answers

attach/detach vs. backup/restore

I am using SQL Server 2008 Enterprise. I need to transfer the database (as a whole) to another server (to make a duplicate database to set up another test environment). I have two choices, (1) making a full backup at source server/restore at…
George2
  • 1,137
  • 6
  • 22
  • 41
4
votes
4 answers

Optimal SQL Server Reporting Services setup

I'd like to determine an optimal setup for SQL Server Reporting Services to use as the integrated reporting tool for SaaS web-based applications. All reports are pre-defined, so users pick a report and enter some parameters in a web-based front end.…
ddavis
  • 75
  • 1
  • 4
4
votes
1 answer

Problems with SQL Server 2008 - "The client was unable to reuse a session with SPID 62, which had ..."

I'm having problems with my SQL Server 2008 installation (10.0.2531.0 - SP1 installed). It works as a database server for small hosting environment (about 500 sites). I'm getting errors like this: The client was unable to reuse a session with SPID…
GrZeCh
  • 605
  • 4
  • 12
  • 28
1 2 3
…
99 100