The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
389 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 ...
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 ...
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
59 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
216 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
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 ...
0
votes
1answer
764 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
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 ...
1
vote
0answers
33 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
0answers
94 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 ...
1
vote
0answers
240 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? ...
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 ...
0
votes
0answers
29 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
0answers
51 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 ...
0
votes
0answers
60 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
0answers
132 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 ...
0
votes
0answers
87 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
104 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 ...