w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
C# SendKeys and Microsoft SQL Server Management Studio 2012 (SSMS)
See http://msdn.microsoft.com/en-us/library/system.windows.forms.sendkeys.aspx ... The SendKeys class is susceptible to timing issues, which some developers have had to work around. The updated implementation is still susceptible to timing issues, but is slightly faster and may require changes to the workarounds. The SendKeys class tries to use the previous implementation first, and if that fails, uses the new implementation. As a result, the SendKeys class may behave differently on different operating systems. Additionally, when the SendKeys class uses the new implementation, the SendWait method will not wait for messages to be processed when they are sent to another process. ...

Categories : Misc

Export from SQL Server 2012 to .CSV through Management Studio
Right click on your database in management studio and choose Tasks -> Export Data... Follow a wizard, and in destination part choose 'Flat File Destination'. Type your file name and choose your options.

Categories : SQL

SQL Server Management Studio 2012 Pivot/Cross Tab Query
Without seeing your query I am guessing but if you are trying to PIVOT the data with a CASE expression my suggestion would be to add an aggregate function around the CASE. select name, max(case when [group] = 'A' then status end) grp_A, max(case when [group] = 'A' then date end) A_day, max(case when [group] = 'A' then [count] end) A_ct, max(case when [group] = 'B' then status end) grp_B, max(case when [group] = 'B' then date end) B_day, max(case when [group] = 'B' then [count] end) B_ct, max(case when [group] = 'C' then status end) grp_C, max(case when [group] = 'C' then date end) C_day, max(case when [group] = 'C' then [count] end) C_ct, max(case when [group] = 'D' then status end) grp_D, max(case when [group] = 'D' then date end) D_day, max(case when [group] =

Categories : Sql Server

white circle in microsoft SQL server management studio 2012
The white circle usually contains a green arrow, a blue paused symbol, or a red square - indicating that the SQL Server service is either running, paused, or stopped respectively. Usually security is set-up so that only administrators can see the service status, so regular users don't have access to that information, hence why SSMS displays an empty white circle, meaning the service is in an indeterminate state, from its viewpoint - of course if you can connect to the service and run queries then it has to be running, so don't worry about this. See here: http://www.sqlservercentral.com/Forums/Topic825246-146-1.aspx

Categories : SQL

How search to find what table contains data in SQL Server 2012 Management Studio
On approach, though it's a little raw, would be to run this statement: SELECT 'SELECT * FROM ' + OBJECT_NAME(id) + ' WHERE ' + c.name + ' LIKE ''%edyvane%''' FROM syscolumns c WHERE xtype IN (35,99,167,175,231,239) which will return you a listing of SELECT statements to run against columns that are text. You would get more than one SELECT for the same table, but that really doesn't matter because this is just research. You just need to get your hands dirty and find the data.

Categories : SQL

How to deploy and attach SQL Server Management Studio 2012 Database with Winform Application?
Actually your problem in your connection string try this: 1- add a copy of your database to your debug file.(you can fine your database in "C:Program FilesMicrosoft SQL Server[your instance name]MSSQLDATA[your database Name]") 2- modify your connection string (in app config ) Server=.SQLExpress;AttachDbFilename=|DataDirectory|YourDB.mdf; Database=YourDBname;Trusted_Connection=Yes; 3-try to deploy. Note: the database version must be equal or lower of server instance version and this is manual way the better way but the better way to attache database to sql server in deployed PC

Categories : C#

Developing C# Winforms software using SQL Server 2012 in Visual Studio 2012 and running it on other system without installing SQL Server 2012
If you develop an application that use Sql Server 2012 as storage for your data then you need to install it in a way or another. There are numerous versions of Sql Server, like Sql Server Express and LocalDB. In every case you need the bits that supports your coding calls. This magazine article summarizes relevant infos on the various version of Sql Server I suppose that the right product for you is Sql Server LocalDB. A version of Sql Server that could be distributed easily with your application setup and doesn't require a complex installation procedure. However, if you don't foresee the need to escalate you application to a full Client-Server model and you need only a local storage for a single user, you could choose a single file database like Sql Server Compact Edition or SQLite or

Categories : C#

Retrieving images from ssms Database using relative path and showing image in picture box in C# visual studio 2012?
txtbEOname.Text = (String)PEO.Rows[cmbEOselect.SelectedIndex]["Name"]; String folder = Path.GetDirectoryName(Assembly.GetEntryAssembly().Location) + @"" + PEO.Rows[cmbEOselect.SelectedIndex]["IMAGE"]; pBoxOils.Load(folder);

Categories : C#

Finding a word after specific string - sql management studio 2012
The code you are looking for should first look for the string Action and then for a space character after that word. After that you have all you need to manipulate your source string. This should work: DECLARE @P_string nvarchar (100), @P_variable nvarchar (100), @idx1 int, @idx2 int SET @p_string = 'hello Action=Refer non-action=non-refer' SET @p_variable = 'Action' SELECT @idx1 = charindex(lower(@P_variable),lower(@P_string)) + len(@p_variable) + 1, @idx2 = charindex(lower(' '), @P_string, @idx1) SELECT @idx1, @idx2 SELECT SUBSTRING( @p_string, @idx1, @idx2 - @idx1) as trying EDIT After more thoroughly reviewing the requirements, I decided to tailor a rCTE structure that I use for similar purposes. Here it goes. CREATE TABLE #retention1 ( ID int, txt nv

Categories : Sql Server

Visual studio 2010 with sql server 2008 (default with vs10) and sql 2012. How can I choose from 2008 or 2012 while adding database in server explorer?
After the project is created: Open the database project's properties. Go to the Project Settings tab. Change "Target platform" to SQL Server 2008 or whichever option you need.

Categories : Sql Server

How to view data in table variables during debugging session in MS SQL Management Studio 2012?
Whilst I can't find any documetation, anywhere, that explicitly states that you cannot inspect table variables, I don't believe that it's possible. From Transact-SQL Debugger Locals and Watch. These windows display currently allocated Transact-SQL expressions. Expressions are Transact-SQL clauses that evaluate to a single, scalar expression. The Transact-SQL debugger supports viewing expressions that reference Transact-SQL variables, parameters, or the built-in functions that have names that start with @@. These windows also display the data values that are currently assigned to the expressions. (My emphasis) That is, you can only inspect scalars. As to your attempt to use the Immediate window, the Limitations on Debugger Command and Features says: The Immediate window is displ

Categories : Debugging

Visual Studio 2012 Slow To Close
Try Process Monitor by SysInternals: http://technet.microsoft.com/en-us/sysinternals/bb896645 You can set the filters in such a way that only the Visual Studio 2012 executable is monitored and you will see each and any action towards files, network or registry. This might give you the idea about what's going on behind the scenes.

Categories : Visual Studio 2012

Read write privileges between Microsoft SQL Server Management Studio and Visual Studio
I ended up solving it on my own. The problem had to do with privileges. The database was on my local machine with limited rights. SSMS was using a different account to access the file than VS.I had to go to the MDF file and LDF and add rights to some users.

Categories : SQL

SQL Server Management Studio equivalent for CTR+L keyboard Shortcut from Visual Studio
Just hit ctrl+c with no text selected - this copies the current line; likewise ctrl+x with no text selected cuts the current line.

Categories : Visual Studio

Unable to connect to local database in Visual Studio 2012 express For Web: (error 26)(C#)(SQL Server 2012)
You're getting that error because the (localDB)v11.0 is already a user instance of SQL Server. When you were using the SQLEXPRESS SQL Server instance, well, it's not. So, just get rid of the User Instance=true on the connection string.

Categories : C#

Visual Studio 2012: "Navigate To" is suddenly very slow
I had the same problem and deleting everything in c:UsersUserNameAppDataLocalMicrosoftWebsiteCache helped. Now it's quick again. I've found this soultion here.

Categories : Visual Studio 2012

Visual Studio 2012 is extremely slow at startup
What seemed to help for me was dumping my temporary internet files and deleting the contents my C:FusionLogs The following registry keys can tell you if Fusion Logging is enabled and where it logs too: HKLMSoftwareMicrosoftFusionEnableLog <-- logging set to exception HKLMSoftwareMicrosoftFusionForceLog <-- log all binds to disk HKLMSoftwareMicrosoftFusionLogFailures <-- log failures HKLMSoftwareMicrosoftFusionLogPath <-- target of logging

Categories : Performance

This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers
I just ran in to this issue as well but then was able to find the solution. You just need the newer version of SSMSE which is now 2008! Here's the MS download page: http://www.microsoft.com/en-us/download/details.aspx?id=7593

Categories : Misc

C# SQL Query Producing Different Results than Management Studio
This might be a problem with types and equality. You can try using SqlDataType when you define the parameters on the sqlcommand. When you use addwithvalue without declaring a type it could be selecting the wrong type. Then you should use the type you declared in the sql expression. cmd.Parameters.Add("@SourceId", SqlDbType.VarChar, 20); cmd.Parameters["@SourceId"].Value = SourceId;

Categories : C#

Why is 'Attach to Process' in Visual Studio 2012 to w3wp.exe so slow?
I know this is pretty old, but I think your issue is all the symbols being loaded that you don't actually need (but may want). You can greatly reduce the number of symbols attempting to load by (un)setting a couple options: Tools | Options | Debugging | General - check "Enable Just My Code" Tools | Options | Debugging | Symbols - uncheck "Microsoft Symbol Servers"

Categories : Visual Studio 2012

Visual Studio 2012/2013 Slow "List Members" Intellisense
Unfortunately the issue seems to present in VS 2013 as well - I've had a similar issue with VS2013 + ReSharper v8.0.2 and intellisense in CSS. Using VS 2012 + ReSharper 8.0.2 on the same solution is fine. My issue mainly seems to stem from the fact that I'm working on an ExtJS solution (which adds hundreds of .js & .css files) and VS 2013 seems to fall over with this. You're already using VS2012 here - is the issue present with ReSharper fully uninstalled? If not, then ReSharper's your problem. If it's VS2012, then it's something else. Check all other extensions you may have installed and try disabling them. Are you using your own T4 templates?

Categories : Visual Studio

Visual Studio 2012 Custom CompareTo Method slow when debugging
I would do the IsNumeric check like this and then proceed, from here. It is cleaner. Dim Value1 As Object Dim Value2 As Object Dim V1 As Integer Dim V2 As Integer Public Function IsNumeric(ByVal Expression As Object) As Boolean If IsNumeric(Value1) = True And IsNumeric(Value2) = True Then V1 = Integer.Parse(Value1) V2 = Integer.Parse(Value2) End If Return True End Function Let me know, if you need more help.

Categories : Vb.Net

Grid View Visual Studio 2012
Check out this YouTube ASP.NET GridView Tutorial series. The series is comprised of many parts, scroll through the list and pick out the relevant topics you need for your understanding of what you are trying to achieve with the GridView server control.

Categories : Vb.Net

Open WebMatrix SQL Server database in Microsoft SQL Server Management studio
I need more information to help you, are you having trouble determining the server or the login or what? You need to login as a user with rights on that database. Do you know the server name that it was migrated to? If you are looking for an easy to use tool to convert between mssqlce and sqlserver try this one: http://sqlcetoolbox.codeplex.com/releases/view/69910

Categories : SQL

No server appears when I try to login to SQL Server Management Studio
Make sure you start the SQL Server service, where it is installed Give machine name or IP in server name If it is SQL Express, you need to do machine-nameSQLEXPRESS

Categories : Sql Server

Error disconnecting server in SQL Server Management Studio
This is an SSMS bug. A similar thing still happens in most SSMS versions, it's just that you get a -1 error in the results pane, rather then an exception Did you patch your client tools too? The rule of thumb is to always apply service packs and hotfixes to your client tool installations too

Categories : Sql Server

Checkbox in SQL Server Management Studio
In the table, supposing you're using SQL Server, you'll use the bit type. In the application, use parameters in the commands, so you can just pass a boolean value to the corresponding parameter.

Categories : C#

Can't see EF database in SQL Server Management Studio
Based on your comments you need to modify the web.config file in your project root (not the one in your Views folder. In there you can add a section as follows: <connectionStrings> <add name="EFDbContext" connectionString="Data Source = .; Initial Catalog = ITSDB; Integrated Security = true" providerName="System.Data.SqlClient"/> </connectionStrings> The name property of the element is the DbContext name of your Data model, so if your class is defined as: public class SomeContext : DbContext { ... } Then your config should be: <connectionStrings> <add name="SomeContext" connectionString="Data Source = .; Initial Catalog = ITSDB; Integrated Security = true" providerName="System.Data.SqlClient"/> </connectionStrings> As for the conn

Categories : Entity Framework

Pre-fill parameters in SQL Server Management Studio
No this is not possible, there's nowhere to save them. But you can fill the parameters manually, execute the stored procedure and save the generated script as a .SQL file. This way you will have a saved call to the SP with prefilled parameters.

Categories : SQL

Create one to one relationship in sql server management studio
Why even do this ? You can directly add the foreign key to the branch in the Employee table. This removes an extra table and makes your schema simpler. The only case I see that would make your design ok is if each employee either always moves from branch to branch or is attached to multiple branches but both scenarios seem unlikely, especially since you say you want to model a 1-1 relationship and not an N-N relationship. Long story short, drop that BranchEmployees table.

Categories : Sql Server

Taking ownership for SQL Server Management Studio
Try logging in with the sa account and grant permissions to your Windows account. If you do not know the sa password use sqlcmd and execute the following commands: Use Master Go ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' Go Login with the sa account and GRANT permission to the account. USE Master; GRANT CREATE DATABASE TO Jommel;

Categories : SQL

Neo4j something similar SQL Server Management Studio?
It depends on what you are testing. If you are testing Cypher execution speed (which is not optimized for performance yet), then you get timings with the result set. Otherwise, you could implement an unmanaged extension that measures queries as they come in and get executed, see http://docs.neo4j.org/chunked/milestone/server-unmanaged-extensions.html .

Categories : SQL

Sql server management studio does not allow to edit a value of table
I have converted my byte array to a string If you did something like message= Encoding.UTF8.GetString(myByteArray) you likely got unprintable characters. A leading can cause your string to not print. This is the wrong way to handle binary data in a SQL database. The correct way to handle this is one of the following options (in order of preference) Store the data as a varbinary not a nvarchar this lets you store the byte[] directly with EF without doing any conversion at all. Encode the data correctly Using Base64 encoding via message= Convert.ToBase64String(myByteArray) and myByteArray = Convert.FromBase64String(message) Using hexadecimal, SoapHexBinary makes it very easy to go to and from hexadecimal strings.

Categories : C#

Can't Create New Columns in SQL Server Management Studio
Make sure that the version of Management Studio you are using is >= that of your Azure database. I think that means you should be using SQL Server 2012's version of Management Studio. If you don't have access to that, you can get the free, no-longer-license-encumbered 2012 version. Click download, then scroll to the bottom, and choose whichever SQLManagementStudio file is appropriate for your language and platform (hopefully 64-bit, and it has to be > XP). Of course, a better way to add a column is: ALTER TABLE dbo.Loo... ADD NewColumn INT; Not only do you not have to rely on potentially buggy UI disasters, you can also store that in source control, which is much tougher to do when you've run a series of points and clicks.

Categories : Sql Server

Splitting a column into 2 in SQL Server Management Studio
In SQL Server you can cast as DATE and TIME separately: SELECT CAST('6/23/2013 10:34:48' AS DATE), CAST('6/23/2013 10:34:48' AS TIME) So for your example: SELECT ItemId, CAST(DATEADD(HOUR,-4,CONVERT(DATETIME,LEFT([Date],8)+' '+ SUBSTRING([Date],10,2)+':'+ SUBSTRING([Date],12,2)+':'+ SUBSTRING([Date],14,2)+'.'+ SUBSTRING([Date],15,3))) AS DATE) 'DateOnly', LEFT(CAST(DATEADD(HOUR,-4,CONVERT(DATETIME,LEFT([Date],8)+' '+ SUBSTRING([Date],10,2)+':'+ SUBSTRING([Date],12,2)+':'+ SUBSTRING([Date],14,2)+'.'+ SUBSTRING([Date],15,3))) AS TIME),8) 'TimeOnly', [Object], SourceSite, DestSite FROM ( SELECT ItemId, CONVERT(VARCHAR(18),[Date]) [Date], [Object], SourceSite, DestSite,

Categories : SQL

Configure SQL Server 2008 Management Studio
Make sure you write correct Server Name like localSQLEXPRESS. You can find the the local host name by using command prompt. Open command prompt and use this syntax hostname press enter.

Categories : Sql Server

Visual Studio 2012/Windows Phone 8 get results from Async Web Service
There should be a callback delegate for this function GetErrortableAsync and it would be called GetErrorTableComplete. So you add a handler to this delegate. Your names might be slightly diff but should be close enough for you to find them on the service object. AddHandler service.GetErrorTableComplete AddressOf GetErrorTableCompleted service.GetErrorTableAsync(DeviceIDAsString, previousDate) Private Sub GetErrorTableCompleted(sender As Object, e As MobileService.GetErrorTableCompleteEventArgs) 'now you can access the e.Results End Sub

Categories : Vb.Net

Slow performance when using OFFSET/FETCH with Fulltext in SQL Server 2012
It's hard to advise without having your schema and data in hands. There is at least one thing that you should be able to do with those 3 sec. for first query and 47 sec. for second, which is put results of the first query into temporary table and then use it for order by ... offset fetch next: create table #tmp (Id int not NULL, Quantity int, MinPrice decimal(10,4), MaxPrice decimal(10,4), primary key clustered (Id)) insert into #tmp SELECT p.ShopId, count(1) as ProductsQuantity, MIN(LastPrice) as MinPrice, MAX(LastPrice) as MaxPrice FROM Product2 p WITH (NOLOCK) INNER JOIN CONTAINSTABLE(Product2, ProductName, 'czarny') AS KEY_TBL ON KEY_TBL.[key]=p.Id WHERE (p.LastStatus > 0 OR p.LastStatus = -1) GROUP BY p.ShopId select ShopId, ProductsQuantity, MinPric

Categories : SQL

SQL Server Management Studio: prompt for user input
I recommend writing a small application to handle this. I am not aware of any way to prompt the user for input when running sql. IMO Sql Management studio is not an environment for running scripts that require user input

Categories : SQL

Connect to SQL Server with Management Studio using Windows Authentication
The only elegant ways to connect to a SQL Server in another domain but still use Windows Authentication are: What you're already doing: runas /netonly Connecting via remote desktop and opening SSMS locally on the remote server

Categories : Sql Server



© Copyright 2017 w3hello.com Publishing Limited. All rights reserved.