I have a database A. I have taken a backup of database A called A.bak. I created a new database B. Now, I right click and Restore B from A.bak. In the Restore Dialog, I checked overwrite existing database and change the LogicalFileName from C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER2012\MSSQL\DATA\A.mdf to C:\Program Files\Microsoft SQL Server\MSSQL11.SQLSERVER2012\MSSQL\DATA\B.mdf and did […]
Is there an easy way to determine what traces have been set up by sp_trace_create on SQL Server 2000? How about for SQL Server 2005, 2008, 2012, or 2014?
I am trying to restore the backup taken from a SQL Server 2012 to SQL Server 2008 R2, and it giving an error Specified cast is not valid. (SqlManagerUI) If you have any solution to this please give comment thanks.
How can I export my 2012 database with data to a .sql file so I can import it to a 2008 server? I’ve never been able to export the data only the structure.
I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that server. The problem happens when trying to design the package. I have added an […]
I am getting an error using SQL Server 2012 when restoring a backup made with a previous version (SQL Server 2008). I actually have several backup files of the same database (taken at different times in the past). The newest ones are restored without any problems; however, one of them gives the following error: System.Data.SqlClient.SqlError: […]
I’m installing SQL Server 2012 at the moment and when I was about to run the installation, this error pops up: On clicking the first failed test, which is “Reporting Services Catalog Database File Existence”, this is what i get: On clicking the second failed test, which is “Reporting Services Catalog Temporary Database File Existence”, […]
Back in the old days, I used to write select statements like this: SELECT table1.columnA, table2.columnA FROM table1, table2 WHERE table1.columnA = ‘Some value’ However I was told that having comma separated table names in the “FROM” clause is not ANSI92 compatible. There should always be a JOIN statement. This leads to my problem…. I […]
I use SQL Server and I have 3 Application servers. When a table in my database have changed I need to those application servers refresh there local cached data. I use a trigger to known change and send a message via Service broker queue. Then I create a stored procedure and assign it to activate […]
I’m looking to copy a SQL Server 2012 Standard database to my localdb instance. I’ve tried the wizard which complains that localdb isn’t a SQL Server 2005 or later express instance. I also did a backup/restore but upon the restore in my localdb I get the following error… Running this… RESTORE DATABASE CSODev FROM DISK […]