All Questions
Tagged with sql-server-2008-r2 sql-server-2005
6 questions
6
votes
3
answers
8k
views
Is there a way to execute SQL statement based on SQL Server version?
I would like to create computed index on a table if SQL Server is 2008 or newer and a simple index if SQL Server is 2005 or older:
-- check for sql server version
if (select cast(left(cast(...
- 233
3
votes
1
answer
6k
views
Migrating from SQL Server 2005 to SQL Server 2008 R2 on a different box
We currently have a SQL Server 2005 instance hosting a lot of application specific databases (ArchiveManager, SolarWinds, Kaspersky etc). We are planning to deploy a new SQL Server 2008 R2 instance on ...
user20442
2
votes
1
answer
8k
views
SQL Server : how to disable connections to a linked server?
SQL Server Linked Server to default instance - service is disabled but connection is still possible
I have a server called SWLON1 that has SQL Server 2005 and SQL Server 2008 r2 installed.
The SQL ...
- 16.6k
14
votes
3
answers
24k
views
Deny access to information schema in SQL Server
I am looking for the best way to disable access to the sys.tables / Information Schema for a user / group in SQL Server.
I found this thread from 2008
It shows a way how to deny access on [sys].[...
- 359
3
votes
1
answer
4k
views
What are the most compelling reasons to upgrade from SQL Server 2005 to SQL Server 2012?
We currently have 2 SQL Server 2005 Enterprise machines in a mirrored environment running on Dell R815 servers. These machines consist of:
Four AMD Opteron 6176 Processors (12 cores at 2.3Ghz), for ...
- 70.5k
0
votes
1
answer
4k
views
Restoring a SQL Server 2008 R2 backup on SQL Server 2005
I'm getting an error whenever I restore a testing database on SQL Server 2005 that was backed up from SQL Server 2008 R2. It seems that I cannot restore from a higher version of sql onto lower version,...
- 655