Viewing 15 posts - 256 through 270 (of 972 total)
You might check to make sure if the tools are patched for both SQL Server and Visual Studio. Only other option after that would be to remove them and reinstall...
July 15, 2014 at 12:09 pm
You may have to just repair the older version. They are supported on the same machine as I have 2005 up to 2012 SSMS and BI tools.
July 14, 2014 at 6:07 pm
The .Net program errors out with a System.TypeInitializationException
Does anyone have any idea why something like this would work in Sql Server 2005/Windows 2003 but not in Sql Server 2012/Windows 2012...
July 14, 2014 at 12:51 pm
You might check to see if the files are valid backups (RESTORE HEADERONLY FROM DISK=N'questionedfiles'. I have read at times if the backup is corrupt or in some other way...
July 14, 2014 at 12:37 pm
According to documentation, yes but I don't know that it works remotely.
July 14, 2014 at 12:29 pm
You can use PowerShell to perform this much more efficiently to stop the service and disable it at the same time:
Get-Service -ComputerName MyServer -name MSSQLSERVER | Stop-Service -PassThru | Set-Service...
July 14, 2014 at 12:12 pm
The master database contains configuration and metadata information about the instance and databases. Depending upon your configuration it contains information regarding that config.
You can query certain DMVs to obtain information...
June 29, 2014 at 8:01 pm
mp5387 (6/25/2014)
Do we need any order to restore...
June 25, 2014 at 10:45 am
You can only restore them to the same version they were backed up from. As stated in BOL:
System databases can be restored only from backups that are created on the...
June 24, 2014 at 9:41 pm
I know this is an old post but I came across it through a Bing search (don't hold it against me :w00t: ).
Anyway for those that may come across this...
June 13, 2014 at 10:03 am
Minto Minto(quendans) (6/11/2014)
On active node c drive and quorum drives are offline.On passive node both are online.Remaining other drives are in online on active node.We have kept the user and...
June 12, 2014 at 8:50 am
imani_technology (6/9/2014)
June 10, 2014 at 6:25 am
It would be best to get good understanding of how memory is used but you can also find out how to troubleshoot the same thing in RedGate ebook: Accidental DBA....
June 10, 2014 at 6:14 am
Caruncles (6/5/2014)
following the logic that "the only dumb question is the one which doesn't get asked"-- how do you start Powershell? from SSMS, cmd prompt?
It can...
June 5, 2014 at 10:56 am
I have this problem on a server for a client every few months and I find sp_whoisactive to be the best method. You can download the latest version here, [11.11]....
June 1, 2014 at 3:21 pm
Viewing 15 posts - 256 through 270 (of 972 total)