Tag Info

New answers tagged

0

To fix this problem is very simple Fix/Workaround/Solution for Microsoft SQL Server, Error :4064 # First click on Option>> Button of “Connect to Server” Prompt. Now change the connect to database to any existing database on your server like master or msdb. Now click on connect and it will successfully log you in. Once you login in the system run ...


0

In windows authentication, you don't have to type the password, it will validate by AD. The reason for Login error could be your login does not have access to the database server. Please ask the database administrator to grant access to your login.


0

As Pablo Montilla mentioned in a comment on the question, I should have added a code sample to indicate that I was using Dapper. (I have since added the sample.) The solution was to pass an argument to Dapper's Query method to tell it not to buffer all of the results before letting me iterate over them. The default behavior of Dapper is to buffer the ...


2

I wouldn't have been able to find the solution to this problem if you hadn't decided to open the VM on azure and check the version numbers, so thank you! After I saw your post, I googled "sql 12.0.2430.0" and found a hotfix from microsoft that fixed the problem. You can find the hotfix Here The update added full support for the new Azure SQL database ...


7

It's signifying a unique constraint. In SQL Server, a unique constraint is actually implemented as an index under the covers; this is why it appears under the Indexes node as well (I can't give you a good explanation of why it is not at least listed under the Constraints node, nor why they chose an upside down key instead of just a different color). You ...


1

I haven't played with themes, but you can set per-connection properties, including the color of the connection info bar at the bottom of the query tab. And these settings are saved. If you have a query tab open, go to "Change Connection" (either the button in the button bar, or via the Query menu, top item should be Connection >, and when it pops up the ...


3

My motto is to always use the most recent version of the tools and always have tools >= highest engine you manage. There are a couple of exceptions, in addition to those others have mentioned: For SQL Server 2000, I always install the 2000 client tools. If you use DTS/SSIS you will want to have the tools relevant to the version of your packages. If you ...


2

That depends on your definition of major complication. Will it somehow cause your data to be affected in a negative way? No. Would I recommend using SSMS 2014 to administrate a production 2005 instance? No, because you're going to run into a lot of issues when using the GUI to perform many types of operations. Even if they are supported in 2005, they may ...


2

I have been using it about a year now connecting also to SQL Server 2005. There are some features that don't work, at least following two I can remember now: Connecting to profiler doesn't work. I noticed there is a patch for this, but it's not yet in the service pack. The error says "SQL Server Profiler cannot perform this action on database servers ...


0

I've added last used date and code for dropping to Raj's query. SELECT OBJECT_NAME(S.[OBJECT_ID]) AS [OBJECT NAME], I.[NAME] AS [INDEX NAME], type_desc, coalesce(last_user_seek,last_user_scan,last_user_lookup,last_system_scan,last_system_seek,last_system_lookup) as LastUsed, USER_SEEKS, USER_SCANS, ...


1

The problem was with our company firewall. The port 1433 was blocked on the firewall. After removing the outgoing and incoming restrictions on firewall the SMSS started working.


2

If you run sp_helpfile in the master database on your SQL Server 2014, this will tell you where your main database files are, eg Copy your extracted AdventureWorks .mdf file to that location, then attempt to attach. That should work. The reason you probably can't 'see' the directory you want is that SQL Server does not have access to it. Alternately, ...


1

The option is still there (although this is from SQL Server 2014): You don't normally have to restart SSMS, just open a new query window.


0

If you take a look at this Connect Item, there is a comment (on a slightly unrelated problem) suggesting that you need to restart SQL Server Management Studio before any changes to the Keyboard Shortcuts take place Posted by jaredaz on 28/08/2012 at 14:13 This problem seems to go away after restarting management studio (where in prior versions it ...


0

This happened to me when I upgraded our SQL Server from 2008R2 to 2014. db_datareader or db_datawriter or their deny equivalents perfectly work fine in 2008R2 but they doesn't work in 2014. Example to grant permission in SQL Server 2014 If you want to give user Alice the SELECT, INSERT, UPDATE and DELETE permissions to all table-valued objects in schema ...


0

the driver needs to be installed on whatever server ur on when u connect. So if your on you laptop and using managment studio to connect to sql server then the driver needs to be on you laptop


2

That dialog asks you for the installation media, pay attention. You need to specify the location from where you've run the original install. That is not an Express uninstall, you are uninstalling a licensed SSMS, so you should provide your original, licensed, CDs.


0

In case your using Sql Server 2008, Intellisense in SSMS 2008 R2 is case sensitive but T-SQL itself may not. It was marked as fixed for later versions. https://connect.microsoft.com/SQLServer/feedback/details/672196/t-sql-is-not-case-sensitive-but-t-sql-intellisense-is It have been fixed on SQL 2012. I know because I am using it. You don’t need to ...


0

The Accidental Data Destruction Protector feature of the SSMS Tools plugin will do exactly what you want. Also, it installs a New Query Template so that when you open a new script window, it has BEGIN TRAN ROLLBACK as the standard query template, which I've found super helpful. You could just get in the habit of doing that, but SSMS Tools makes it ...


1

The habits I got into very early on, after a couple whoopsie-daisy-sorry-about-your-project-tables: Begin Tran / Commit (but forgetting to commit can be just as detrimental) Write your WHERE clause first, even if it's a dummy 1=2 that will keep anything from being modified Highlight your syntax from the BOTTOM UP


1

You don't need a trigger to prevent you from doing something you shouldn't do. You should wrap your update in a TRANSACTION, and only commit if you are satisfied with the result. You shouldn't be running update statements that may alter your whole db without the ability to roll back.


4

Getting a relative path in SSMS is not that straight-forward since you are not executing the script; SSMS has loaded the script into memory and is executing its text. So the current directory/folder is the default process starting folder. You can see this by running the following in SQLCMD mode in SSMS: !! PWD However, I did find a kinda-sorta way to do ...


2

I could be wrong, but I don't think that it is possible. Please see these links for an example of what others have done (none are ideal). http://stackoverflow.com/questions/8753541/how-to-get-the-relative-path-of-file-in-sqlcmd-mode-in-ssms ...


1

You have to run the main installer, and choose to add the shared feature. The fact that it's available as a separate download as well is a bonus for people who don't want to have to download such a large ISO, but the SSMS installer is definitely part of the main installer - you just have to choose it from the "shared features" section.



Top 50 recent answers are included