The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
6 views

sp_send_dbmail spamming Event Log

I have some unknown but work-relevant process on my development computer executing every 10 seconds. It calls a stored procedure in SQL Server. Part of this stored procedure is to call ...
1
vote
1answer
360 views

How to find out MS SQL Server Enterprise Edition Expiration Date?

I have MS SQL Server Enterprise 64bit Install on VMplayer, Version: 11.0.3128.0 Product LVL: SP1 Upon installed, there is no documents indicates how long this license will last. Anyone can ...
0
votes
0answers
32 views

Results view does not change with zoom feature in SQL Server Management Studio

The zoom feature in SQL Server Management Studio is not changing the results window. I have come across many posts that say the zoom controls both the query window and the results window. What do I ...
0
votes
1answer
181 views

Upgraded to windows 10 and now can't connect to sql server 2012

I upgraded to Windows 10 on my laptop. I have opened SQL Server Management Studio, but it can't connect to the server. I have looked at a few other questions, but nothing seems to work. I get the ...
0
votes
0answers
17 views

MS SQL 2012 Express hangs on add DB when you click the files tab

I'm running SQL Express 2012. Sometimes when I'm restoring a DB and click on the files tab to link the DB to the actual files, the management studio just hangs. I manage a large number of small DB's, ...
0
votes
1answer
19 views

Copy columns between tables in different servers

Recently I moved to SQL Server 2012 from SQL Server 2005. Current scenario worked without any problem in SQL Server 2005. 1)Connect to server A 2)Open table X 3)Copy 3 columns(Clicking ...
1
vote
1answer
63 views

How to debug unattended installation of MS SQL Server 2012?

How can I diagnose and debug a configuration file for an unattended installation of MS SQL Server 2012? What I'm doing -- I'm building an installer for a product. The product requires MS SQL Server ...
0
votes
3answers
15k views

SQL Server not working after upgrading windows 10 from windows 8.1

My Sql server 2012 has stopped working and now its not letting me login. Here is the error: https://drive.google.com/file/d/0ByGXmosQgHUqdGw4alFSb3otVkk/view?usp=sharing TITLE: Connect to Server ...
0
votes
0answers
48 views

How to column-level encrypt in Dynamics CRM 2015?

I know that Dynamics CRM 2015 comes with encryption on for specific fields. EmailServerProfile IncomingPassword EmailServerProfile OutgoingPassword Mailbox Password Queue ...
1
vote
0answers
23 views

How do I connect a SQL Server synonym to an Excel data model?

I have a SQL Server (12.0.411) database with a view that is referenced by a synonym. I want to load the data from the view into Excel's data model using the synonym. In Excel (Microsoft Office ...
0
votes
0answers
51 views

Why does SSMS incorrectly report an invalid object name when the object does exist?

Why does SSMS incorrectly report an invalid object name when the object does exist? e.g. the table BinCollectionDay is in the current database And even better, how do I stop the incorrect ...
0
votes
1answer
264 views

Trying to change the color of database and variable names

I am customizing the colors and can't for the life of me find the option to change the color of database/table and variable names ..they are stuck that odd teal color, Ive changed the color of ever ...
2
votes
1answer
615 views

Broken dropdowns in SQL Server Configuration Manager on Windows 8.1

I recently installed a new virtual VMWare machine for development purposes. The machine has Windows 8.1 (64 bit), Visual Studio 2013 and Microsoft SQL Server 2012 Standard Edition, all with latest ...
0
votes
0answers
123 views

Changing Microsoft SQL Express Server 2012 Shared Feature Directory

I know that in order to change any directory location, when installing SQL Server 2012, there mustn't already be present other SQL products on the system, otherwise the directory text boxes and browse ...
1
vote
0answers
31 views

SSMS2012 Help going to Chrome rather than MSIE

Running Win7 Ent 64bit From within SSMS 2012 SP2, when I hit F1 (or Help, View Help), I am taken to Google Chrome rather than MSIE11. By every indication I can find, MSIE11 is my default browser, not ...
1
vote
2answers
6k views

How do I download SQL Server 2012 Express?

I feel like an idiot asking this question, but I can't seem to find the magic combination. (Or maybe Microsoft's website is broken. I'm not sure which.) Anyway, here's what I'm trying. Open SQL ...
16
votes
2answers
3k views

Floating or vertical results pane in SQL Server Management Studio

I have a multi monitor configuration and would like to be able to have my query editor on one monitor and the results pane on another. Can this be achieved? Either by having the results pane ...
1
vote
1answer
176 views

Missing arguments in SQL 2012 command line installation

I am new to SQL installation through command line. We are developing an application and using Installation Shield. I need to install SQL server on clients pc, so I am using command line silent ...
2
votes
1answer
251 views

Freshly installed wiki still shows red links for pages that have been created?

I just set up MediaWiki for a test run on my laptop. Windows 7, PHP 5.4, SQL Server 2012 SP2, IIS 7, MediaWiki 1.23.6. The installation went smoothly once I got everything in order and I can create ...
0
votes
0answers
85 views

Unauthorized attempt to view reports in SSRS

I have a problem in my environment with unauthorized attempt to access a report from my SQL Server Reporting Services. I have a IIS server with one website. Application Pool for this website is ...
0
votes
0answers
17 views

Excel 2013 Collapsing issue while fetching from Cube

I am working with Excel 2013, using PivotTables. The fields in PivotTable are published into hieararchy so there are folders on top and field-values on bottom of hieararchy. What I am having troubles ...
0
votes
0answers
21 views

Error:ObjectSet 'Database Collation ObjectSet' already exists

Error: ObjectSet 'Database Collation ObjectSet' already exists Getting this error while importing policies in SQL server 2012. I refreshed multiple time but no use. Please help me.
0
votes
0answers
31 views

SQL Server 2012 change query result position [duplicate]

Traditionally in SQL Server while executing a query the result is displayed below the query dividing the screen horizontally. Is there any settings that can be done to displays the result to the side ...
1
vote
0answers
93 views

Cannot install SQL Server 2012

I'm trying to install SQL Server 2012 and got this message: SQL Server Setup has encountered the following error: The resource 'Microsoft.SQL.Chainer.PackageData.Package.xml' failed to load from ...
0
votes
0answers
94 views

SSMS and SSDT requires administrator

I connect to a client's Server (Server 2012R2) via RDP. I always get the UAC prompt when I start the SQL tools, managemant studio (SSMS) and data tools (SSDT). If I press cancel in the UAC dialog the ...
23
votes
6answers
79k views

Move database from SQL Server 2012 to 2008

I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server. The 2008 server cannot restore backups created by a 2012 server (I have tried). I cannot find any options ...
1
vote
2answers
16k views

SQL Server 2012 fails to install or remove

Got an odd problem here. Installed programs is showing SQL Server 2012 installed, but fails to remove itself when running the uninstaller. To add insult to injury, it also won't let install the ...
0
votes
3answers
6k views

Error message on SQL Server 2012 install

I am trying to install SQL Server 2012 Standard Edition on my Windows Server 2012. The installation keeps failing, and I have tried everything that I can come up with, but nothing helps. The error ...
0
votes
2answers
5k views

SQL Server 2012 configuration manager not opening in windows 8.1

I run SQLServerManager11.msc in apps to search but nothing happen. Need Help. It is install and showed in control panel.
0
votes
1answer
2k views

Execute Backup-SqlDatabase cmdlet remotely

When I run the following script line locally on an SQL Server machine, it executes perfectly: Backup-SqlDatabase -ServerInstance $serverName -Database $sqldbname -BackupFile ...
0
votes
1answer
1k views

SQL 2012 in Hyper-V. Why are my queries slow until I drop and create any spatial index?

I have a spatial application that queries several tables (layers) each time the user pans/zooms the map. When I moved the SQL server into Hyper-V, I noticed that there was a several second delay when ...
1
vote
1answer
1k views

SQL Server Express “hangs”, on startup

I recently installed SQL Server 2012 "Express", and, also, Visual Studio 2012. I was working with it, and all worked ok. At some point, a few hours ago, SQL Server Express, however, started ...
0
votes
1answer
1k views

Assign login to SQL user without login

Environment: SQL Server 2012 Express Edition and Microsoft SQL Server Management Studio. All users are local SQL users, NOT Windows authentication. I attached a database file which came from another ...
1
vote
1answer
2k views

SQL Server 2012 installation on Windows 8.1 Single Language

I tried to install SQL Server 2012 with SP1 on Windows 8.1 Single Language, but it terminates straight after starting with this helpful error: I've read that you need SQL Server 2012 SP2 on Windows ...
1
vote
0answers
236 views

Changing font color in SSMS for different database elements?

I'm trying to change font color of different database elements, for database name to show up one color, table name to show up another and table aliases to be separate color. Is it even possible? ...
1
vote
1answer
3k views

Impossible to Start SQL Server browser

I installed SQLserver Express 2012 on a Win7 machine. The lan is made out of 2 PCs (Win7 and Win XP). I cannot access the SQL server from the Win XP machine. I cannot start SQL server browser. I ...
0
votes
1answer
753 views

List of Services for SQL Server 2012 Express

I recently installed VS2013 Preview onto a clean OS and I'm trying to figure out if SQL Server Express 2012 got installed. Unfortunately, when I look in Control Panel->Administrative Tools->Services, ...
1
vote
1answer
5k views

Windows Server 2012, SQL Server 2012 and .NET Framework 4.0

We want to start developing on the newer versions of Windows Server 2012 and SQL Server 2012. At the moment we are using Visual Studio 2010 with the .NET Framework of 4.0. We are not creating desktop ...
0
votes
2answers
4k views

SQL Server 2012 Maintenance Plan can't modify

Click on any created Maintenance Plan: TITLE: Microsoft SQL Server Management Studio Value cannot be null. Parameter name: component (System.Design) BUTTONS:OK Create a new Plan I get this error: ...
1
vote
2answers
3k views

MS SQL Server 2012 Express Setup crashes with .NET error

I'm trying to install MS SQL Server 2012 Express on a virtual machine at a client. It's fresh install of Windows Server 2008 R2 Enterprise SP1. I added the "File Services" and "Application Server" ...
1
vote
1answer
32 views

Default text for SQL scripts

In MS SSQL Server Management Studio 2012, is it possible to get new scripts to contain some default text? I want to encourage colleagues to comment their scripts more consistently, so I'd like ...
0
votes
1answer
5k views

Unable to install SQL Server 2012

When I am trying to install a new instance of SQL server 2012 on my server, I get the following error message when I try to run the iso (before any gui appears): The operating system on this ...