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
0
votes
1 answer

Starting Up SQL Server 2008 in IIS

I'm a complete noob at windows servers and IIS so please be patient with me. I originally set up a website using php/mysql. I have the website running PHP with FastCGI through IIS already, but the SQL Server part is tripping me up. I'm shocked…
Explosion Pills
  • 221
  • 1
  • 2
  • 10
0
votes
2 answers

Trouble installing SQL Server 2008

Greetings, As a developer I want to have SQL Server 2008 installed on my laptop. However when trying to install the management tools (basic and complete) it keeps whining about Another version Microsoft Visual Studio 2008 has been detected on this…
Levisaxos
  • 101
  • 1
0
votes
1 answer

SQL2008R2 Partitioning query

We have a complex query that returns results in 45 secs when run from the 01-05-11 to the 31-05-11, but when it is extended to the 01-06-11 it runs indefinately... THe tables are partition by month... I think the indexes are aligned as they where…
Chris Wood
  • 133
  • 5
0
votes
1 answer

SQL Server 2008 with DPM 2010 & log shipping

We are currently evaluating Data Protection Manger 2010 and need advice on the best SQL backup strategy for a 5GB database on SQL Server 2008. Log shipping is setup on this so synchronization to DPM isn't possible, should more Express Full Backups…
PMC
  • 151
  • 6
0
votes
1 answer

How to implement Peer to peer database replication between two sites?

I am looking for SQL Server database solution which can replicate data between two sites vice versa (not just one way) I’ve looked into SQL Server failover cluster (MSCS) but then since I have two different sites (Production and DR) it would be to…
Senior Systems Engineer
  • 1,275
  • 2
  • 33
  • 62
0
votes
2 answers

How do I give HOSTNAME\Administrator access to MSSQL01 MySQL service?

I got this far... but there are no Computers listed... while there are 3 other domain members: DC (Domain Controller), VCENTER and BACKUP. I wish to give both VCENTER\Administrator and BACKUP\Administrator full administration rights to the MSSQL…
ujjain
  • 3,983
  • 16
  • 53
  • 91
0
votes
2 answers

SQL Server: best account for dbo user?

What is the best account for dbo user? I mean that if I use personal AD account for database owner, and if this account is removed from AD (e.g if I leave my job), these databases are not accessible. I have heard that there is also problems using…
jrara
  • 209
  • 2
  • 6
  • 14
0
votes
5 answers

Oracle to SQL Migration

I'm currently starting a project for an Oracle to SQL 2008 migration. Since I'm currently reading the official SSMA Guide to Migrating from Oracle to SQL Server 2005 i'd like advice and pointers from personal experience. Guides and articles with…
Paul
  • 714
  • 2
  • 6
  • 19
0
votes
1 answer

How do I change the system wide collation of a SQL Server 2008 instance

see also How do I change the system wide collation setting in SQL Server 2005 Is there an easier way to change the system wide (temp db) collation setting in SQL Server 2008 other then a full restore? If I do a full reinstall is there a quicker way…
Ian Ringrose
  • 870
  • 1
  • 6
  • 12
0
votes
1 answer

Linked server sql server 2008 r2

We have two SQL servers and we've setup a them as linked servers. The queries works just fine if I connect remote desktop to one of them and execute query. If I try to execute query from third machine (in same domain as first two) which uses linked…
dunno
  • 61
  • 1
  • 2
0
votes
1 answer

SQL Server Connection Timeouts

Our SQL Server 2008 has been working for quite a while, but then we suddenly got connection timeouts. We couldn't find an answer to the problem and ended up enabling Named Pipes just to get our applications working, but this is not a great solution…
Jacques
  • 195
  • 1
  • 2
  • 15
0
votes
1 answer

MS-SQL Server 2008 size limitation on data

I recently discovered that MS-SQL Server 2008 imposes an upper limit of 8000 bytes for a column (for character data). I need to store data that occusionally could surpass this limit. Is there a way to do this? The data are character strings. …
user76678
  • 349
  • 3
  • 5
  • 16
0
votes
2 answers

Cannot install SQL 2008 RC2

I can't run SQL server after installing it. Its looking in e:, but I do not have an e-drive. I have tried resetting my registry key as shown here all the answers here Log file: 2011-05-19 21:22:39.63 Server SQL Server is starting at normal…
Daveo
  • 21
  • 1
  • 8
0
votes
1 answer

unable to connect to remote SQL Server from win server 2008 R2

I have setup an APP server on Win Server 2008 R2 and my SQL server( SQL server 2008 R2) on a separate server Windows Vista. When I host my ASP.net application on App server and trying to connect to SQL server it doesnt connect. Not sure if I have…
Sai
0
votes
3 answers

Memory settings for multi-instance failover clustering

When using multi-instance failover clustering (used to be called active-active) in SQL Server 2005 and 2008, I'd like to know what you configure the min and max server memory to. For a two-node multi-instance cluster (with two instances, one on each…
Paul Randal
  • 7,194
  • 1
  • 36
  • 45
1 2 3
…
99 100