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
Questions tagged [sql-server-2008]
1806 questions
0
votes
1 answer
Data transfer between servers extremely slow
I have an application running on a Live environment with a Web Server which is running Windows Server 2008 R2 with a QuadCore Xeon processor with 8GB of ram and a Database Server with the same configuration but with an additional disk with 2TB of…
Sabry
- 1
0
votes
1 answer
SQL Express 2008 uninstall not complete
How do I get rid of SQL Express 2008 after it's been uninstalled. It's all over my file system and all over the registry on 2008 R2 server sp1.
Steve
- 1
0
votes
2 answers
Maintaining SQL Log Files
I get an email today stating that we have a log file that's grown to 278GB, and asking if anyone is maintaining it. I already know the answer to that is no because we don't have a dba (other than myself. I know a fair amount about sql, but I'm a…
Brandon Moore
- 456
- 2
- 6
- 17
0
votes
1 answer
SQL Server NIC Power Saving
We have a server running Windows Server 2008 which is dedicated to hosting a SQL Server 2008 Database.
Whilst auditing the server OS we have noticed that the NIC Power saving feature is enabled. Could this cause any stability of performance issues…
0
votes
2 answers
Updating my UAT database to recent copy of live (MS SQL Server)
I have one sql server instance with two databases :
myDB_LIVE
myDB_TEST
both point to separate mdf and ldf files and are backed up each night. I want to take a copy of LIVE and put it in TEST. I would even like to do this as a regular job, what is…
NimChimpsky
- 460
- 2
- 5
- 18
0
votes
5 answers
How much memory should I put in our SQL server 2008 server?
Possible Duplicate:
Can you help me with my capacity planning?
Currently our SQL server 2008 machine has 24 gb of memory.
After analyzing some reports (PAL) and performance counters, I came to the conclusion that the server could use some more…
Erik Dekker
- 103
- 3
0
votes
1 answer
Can I downgrade SQL Server 2008 R2 Standard To Web Edition?
We are running a SQL Server 2008 R2 Standard Evaluation version. The client has decided they don't want to pay for full SQL Server standard and feel the Web edition is suitable. Can I downgrade SQL Server 2008 R2 Standard Evaluation to Web…
GraemeMiller
- 143
- 5
0
votes
1 answer
SQL Server filestream access from another computer using system account
I have a SQL Server 2008 set up to use filestream. SQL Server runs under a domain account with SPN set and delegation enabled.
Accessing filestream from another computer using a domain account works.
But accessing filestream from another computer…
Andrew J. Brehm
- 1,611
- 7
- 37
- 57
0
votes
1 answer
how can connect from client to sql server 2008 via proxy
I have SQL Server 2008 in dedicated server and all port of SQL Server is blocked with firewall.
I have VPS with CCProxy on it.
I opened all ports in dedicated server for my VPS server IP.
I set proxy in internet option (Windows 7) and proxy is work…
Meh Man
- 131
- 4
0
votes
1 answer
Can't install SQL Profiler, it's greyed out in the feature selection list
I got a problem when trying to install Management Tools - Complete on my MSSQL 2008 R2. At the Feature selection screen the Management Tools - Complete is greyed out and can't be interacted with. In the description pane here's what it says
This…
Munky
- 13
- 4
0
votes
1 answer
sql server 2008 r2 can connect with connection manager but noway else
I have installed (3 times on 3 machines) sql server 2008 r2 can connect with connection manager but other program cannot connect.
I can connect to remote sql servers with heidisql or with my dbcontroles in visal studio or embarcadero delphi xe2. But…
JJvP
- 1
0
votes
1 answer
SBS2003 -> 2011 Migration - Some Sharepoint Calendar Items not Showing in Calendar View but Show in All/Current Events
Bascially I've followed the Microsoft guide on SBS 2003 -> 2011 Migration. Performed it over the weekend to try and give zero downtime for users. It's pretty much worked fine except this issue. (I haven't imported the users into 2011 console/format…
Robin Gill
- 2,513
- 14
- 13
0
votes
1 answer
Connecting to a SQL Server instance via connection string does not work
Why does this work to connect to my remote SQL Server database:
var srvConn = new ServerConnection("sql01");
srvConn.LoginSecure = false;
srvConn.Login = "unittests";
srvConn.Password = "mypwd";
…
rboarman
- 237
- 1
- 5
- 15
0
votes
1 answer
Database server migration and SQL Server 2008 licensing
Possible Duplicate:
Can you help me with my software licensing issue?
We currently have a dedicated server that hosts a number of websites and also has SQL Server 2008 Enterprise running on the same machine housing the databases for those…
bijt
- 1
0
votes
1 answer
SQL Server 2008 R2:error
insert into [ULGP_CARES TEST].[dbo].[person](date_of_birth)
select [Dtest].[dbo].[ContactBase].[BirthDate]
from [Dtest].[dbo].[ContactBase]
where
[Dtest].[dbo].[ContactBase].[FirstName]=[ULGP_CARES…
user87
- 1