SQL (CM12 TR) | FAQShop

Why does SQL Server Management Studio crash as soon as I try to open a new Query window?

Why does SQL Server Management Studio crash as soon as I try to open a new Query window? I’ve installed SQL Server Management Studio on my Windows 8.1 machine. However, as soon as I either try to open a saved … Continued

“The process cannot access the file because it is being used by another process” when trying to copy a Database

“The process cannot access the file because it is being used by another process” when trying to copy a Database I am trying to make a copy of a SQL Database from a Command Prompt using the following command: C:\Program … Continued

“C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQL Server 2008R2\resources\1033\setup.rll is either not designed on Windows or it contains an error.”

“C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQL Server 2008R2\resources\1033\setup.rll is either not designed on Windows or it contains an error.” Why do I see the following dialog when trying to run SQL Server Setup: “C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQL Server 2008R2\resources\1033\setup.rll … Continued

Setspn -L fails with “FindDomainForAccount: Call to DsGetDcNameWithAccountW failed with return value 0x0000054B”

Setspn -L fails with “FindDomainForAccount: Call to DsGetDcNameWithAccountW failed with return value 0x0000054B” I’m seeing the following error when I run setspn -L from a Command Prompt on my SQL Server: setspn -L FindDomainForAccount: Call to DsGetDcNameWithAccountW failed with return … Continued

“error 0x2098/8344 -> Insufficient access rights to perform the operation” when trying to run setspn

“error 0x2098/8344 -> Insufficient access rights to perform the operation” when trying to run setspn I am trying to register a Service Principal Name (SPN) using the following command: C:\Windows\system32>setspn -A MSSQLSvc/:1433 \ However, when I run it it’s failing … Continued

Why are my Site Databases different sizes?

Why are my Site Databases different sizes? I’ve got a ConfigMgr hierarchy. Looking on the two child Primaries reporting to my Central Administration Site I see the Site Databases are vastly different sizes. Why is this?