All Questions
Tagged with sql-server-2005 sql-server-2012
42
questions
1
vote
1answer
114 views
Could anyone please help me understand MSSQL Compatibility Level?
I have a task to upgrade a database from SQL Server 2005 to SQL Server 2012.
So I took backup of the old database and simply restored it onto SQL Server 2012 (SP3).
Executed query on New database:
...
2
votes
0answers
245 views
Unexplainable behavior of SQL Server under Windows Authentication
The versions affected are SQL Server 2005, 2008, 2008 R2.
If we grant CONNECT SQL to public server role, any AD account can log in to server.
So we'll have all the AD members on the server without ...
-1
votes
1answer
573 views
How to raise an alert when a table reaches a certain size? [closed]
I would like to set up an alert when the disk space used by a table reaches a certain size.
I am aware we can set up an alert for file group\log file\database reaching a certain threshold. It would ...
1
vote
3answers
259 views
SSIS while upgrading SQL server
I want to upgrade SQL server from 2005 to 2012 (I'm thinking of in-place upgrade).
Today I have several SSIS packages that works with other servers.
The SQL version in those servers is mainly 2005.
...
0
votes
1answer
65 views
migrating DBs from SQL server 2005 to SQL server 2012
We are planning on migrating from SQL server 2005 to SQL server 2012,the DB's are huge and cannot be backed up so we are doing a detach and attach method. I read online SQLServer 2005 to 2012 cannot ...
2
votes
2answers
3k views
Express edition core limits ambiguity
We have an application that uses MSSync to download data from a server into a client's SQL Server Express 2005. The client's have a dual core with hyperthreading so, a total result of 4 cores.
I have ...
0
votes
1answer
45 views
Server and Database role memberships required to add columns and constraints
I have a user with the following server and database role memberships:
securityadmin (server)
public (server)
db_owner (database)
db_accessadmin (database)
db_securityadmin (database)
When running ...
0
votes
1answer
153 views
SQL 2012 THROW in SP That needs to be run on SQL 2005 and 2012
Let me start of by saying that I know SQL 2005 doesn't support the THROW feature.
I need a SP to be run on SQL Server 2012 and 2005. I would like to use the following section of code to allow SQL ...
2
votes
1answer
103 views
SQL Server 2005 still running after in place upgrade to sql 2012
We upgraded a default instance from SQL Server 2005 to 2012 today. But Components of SQL Server 2005 are still on the server. These includes the MSQL1. folder (it has all the data and log files), Mgmt ...
1
vote
0answers
252 views
Server error in reports application
I have a server with SQL Server 2005 installed with the latest service packs. SQL Server 2012 express was been installed on same machine and seems to have broken the Reporting services service. When I ...
3
votes
1answer
694 views
SQL Server Service Broker - CHECKDB found consistency errors, how could this happen?
I encountered a weird SQL Server Service Broker consistency problem, namely I have a queue that holds messages (status=1, Ready to receive) which are lying there for a very long time.
In the ...
2
votes
1answer
692 views
Script file execution through Power shell
We are trying to automate few things, one of them is to deploy patch in one go on selected DBs of SQL Server, as per my knowledge Powershell is an option. But I have zero taste buds of Power shell.
...
1
vote
1answer
54 views
Batch process to delete table from SQL Server backup files
I have a set of full backups from a same SQL Server database saved in different files. For example:
01.my-database.bak
02.my-database.bak
03.my-database.bak
I want to delete a specific table from ...
1
vote
2answers
1k views
Role to view SQL server job log
We have a monitoring tool that can check if Microsoft SQL Server jobs have run successfully. What I want to do is create a user that has as little permission as possible but it must be able to watch ...
2
votes
2answers
648 views
Upgrading a database from SQL Server 2005 to 2012 uncovered a syntax error
I recently upgraded from SQL Server 2005 to 2012. During validation however, a bug was discovered.
A certain trigger was coded as follows:
CREATE TRIGGER [dbo].[trigger] on [dbo].[foo]
FOR UPDATE, ...
2
votes
1answer
391 views
SQL Server 2012 - Dropping Snapshots takes hours [closed]
We recently did a SQL Server upgrade from 2005 to 2012. We have a nightly job that drops a snapshot of an active database. The snapshots gets created again later in the day. Before upgrading, in SQL ...
2
votes
0answers
84 views
SQL Server migration from 2005/2008 to 2012 [duplicate]
We need to upgrade two SQL Servers for our projects to SQL Server 2012.
Since we’re not db-admins or familiar with such migrations, I wanted to ask you if you could tell me what we have to be aware of ...
2
votes
1answer
2k views
The query processor could not produce a query plan
I'm getting this message:
Msg 8624, Level 16, State 17, Line 1
Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support ...
1
vote
1answer
513 views
Difference in architecture between SQL Server 2005 and SQL Server 2012 [closed]
I've been asked to identify the architecture differences between Microsoft SQL Server 2005 and 2012. I've been pointed out to http://technet.microsoft.com/en-us/library/bb545450.aspx but I haven't ...
0
votes
2answers
967 views
SQL Server 2005 to 2012 Replication, cannot access replicated data
I have created publication (snapshot, small table with 10 rows) on MS SQL Server 2005. Then, I created push subscription on MS SQL Server 2012. When I try to select data form table, process takes ...
1
vote
2answers
5k views
Transaction Log Shipping across multiple SQL Server versions
I'm lead to believe that TLS is only appropriate/supported across the same versions of SQL Server.
What I'm trying to do is to maintain a reporting (read only) version of a production transactional ...
0
votes
3answers
80 views
Lost my SQL Server 2005 host, SQL Server 2005 database import into SQL Server 2012?
My SQL Server 2005 host died, but the database related LUNS were on a SAN and still exist. Is there a way to use my SQL Server 2012 host to recover that database or import it in some way?
1
vote
0answers
65 views
New database server hardware and software inserts slower than old setup [duplicate]
We are upgrading our database hardware and software. The previous server is about 5 years old and is running SQL Server 2005 while the new one is SQL Server 2012. Every hardware component is faster in ...
3
votes
2answers
8k views
Backup name in Maintenance plan
I used to have SQL Server 2005 installed on my server. In my maintenance plan, the backup name format was like this: mydatabase_backup_yyyymmddhhss.bak.
Now I am using SQL Server 2012 but I am ...
0
votes
1answer
87 views
XML Network Call to Application from SQL Server 2005
We don't really have a DBA here, just a semi-experienced SQL Developer and me. I've only got about a year's experience myself and we're the only programmers for our small business.
We're trying to ...
5
votes
3answers
13k views
SQL Performance issue after migration from SQL Server 2005 to SQL Server 2012
Yesterday we migrated a SQL Server 2005 database to SQL Server 2012. We made a full backup and restored it on the new server.
Problem now is that the database on SQL Server 2012 is much slower than ...
0
votes
1answer
282 views
What is the MS_PerfDashboard schema in msdb?
We just migrated an old reporting server (running on 2005) to 2012 and some of the database performance monitoring jobs have started failing. I looked into them and found that they use a couple of ...
5
votes
1answer
601 views
Why are zero length spaces being returned from a Union All against an empty table in SQL Server 2005 but not SQL Server 2012
Supporting an existing VB6 app with a SQL Server 2005 back end and we're migrating our database server to SQL Server 2012. Created a backup of the production database and restored it into a dev ...
3
votes
1answer
1k views
System table missing in SQL Server 2012
I restored a SQL Server 2000 database to 2005 then to 2012. I am not able to see system tables that existed in SQL Server 2000 now.
Why?
5
votes
3answers
3k views
One of the Database Ownerhas been Removed and corresponding property changes in sql server
A database has been created on SQL 2008 by a user named user1 ,on dec 2013.Today ,we are going to remove that user(/owner) from the server.What will be the owner property of the database show then?
0
votes
1answer
698 views
dbcc checktable/checkdatabase errors after database restore
Following on from this question Error when creating an index in SQL Server 2012 we have been having problems restoring our live database back to test.
Our current production database is SQL 2005 ...
5
votes
4answers
5k views
Create a secondary read-only copy of DB in a different server
We have users that query our prod database (mostly ODBC through MS-Access) to create some customs reports. We want to copy our data to a second server (replicate / log shipping / ???) so the load on ...
5
votes
1answer
388 views
Transfer logins to another server
I moved a database from SQL Server 2005 to SQL Server 2012. Is there any way of restoring all the logins on the new server?
3
votes
2answers
3k views
Restoring differential backup from SQL Server 2005 to SQL Server 2012
We are migrating a client to a new server. Their old server has SQL Server 2005. I have attempted to perform a differential backup however I received an error about the LSN chain being broken.
Please ...
2
votes
2answers
5k views
32-bit ODBC driver on 64-bit SQL Server [closed]
I am unable to use an ODBC 64-bit driver with SSMS 2012 running on a SQL Server 2012 64-bit instance. However, I believe that the 32-bit driver works.
My question is can I use SSMS 2005 32-bit to ...
asked Feb 10 '13 at 21:31
l--''''''---------''''''''''''
2352 gold badges6 silver badges18 bronze badges
0
votes
1answer
7k views
How can I install a provider for linked server?
I have a provider for a linked server called PervasiveOLEDB.11.0 installed on a sql server 2005 machine. It always me to have a connection to a pervasive sql database.
I would like to use this same ...
asked Feb 7 '13 at 22:03
l--''''''---------''''''''''''
2352 gold badges6 silver badges18 bronze badges
2
votes
1answer
637 views
Inside SQLOS – Scheduling
Using SQL Server 2012 Enterprise Edition SP1 running on Windows Server 2008 R2 SP1
For each logical processor core on SQLOS has a scheduler assigned to it. Those scheduler can be viewed as status “...
12
votes
1answer
7k views
Upgrade SQL Server 2005 to SQL Server 2012
I have a test environment set up with the following:
Virtual Machine (Hyper-V)
Windows Server 2008 R2 SP1(x64-bit)
Windows SQL Server 2005 Developer Edition SP4 (x64-bit)(default instance name)
1 ...
3
votes
4answers
3k views
SQL Server Concise List Of Trace Flags [closed]
I did my 5 minute research and have not come up with a concise list, or even a list really except for Trace Flags (2012) which is a bit lacking.
Looking at this query which uses 8691, I was wondering ...
3
votes
1answer
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 ...
1
vote
1answer
2k views
Is it possible to do an in-place upgrade of SQL Server 2005 Standard to SQL 2012 Enterprise?
At the moment, I have a SQL 2005 Standard box. I'd like to upgrade it to SQL 2012 Enterprise in-place. When I say in place, I mean an install similar to Office 2010, e.g. it removes the older (Office ...
2
votes
1answer
977 views
SQL Server 2012 data striping
Is data striping possible like mentioned here data striping in older SQL Server 2005
in the newest version of SQL Server like SQL Server 2012?
I know this is possible in 2008 and 2008R2.
