.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

weird behavior in SSMS - backslash (\) displays as (#) in query editor

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :ASP.Net
 

I'm experiencing some weird behavior in SSMS for SS2008.  When I create a new query and type the backslash (\) key a pound(#) symbol is displayed instead in the query window.  I've never experienced this behavior in SSMS 2005 before.  This is the first time I'm using SSMS 2008.  I work with a few developers who also use SSMS 2008 and they have no idea about this either.  Any idea whaat might be causing this behavior and any idea how I can fix this?  I'm using Windows 7 and the backslash (\) symbol displays as expected in other applications (Notepad, VS2010, etc). 

Please help!

 




View Complete Post


More Related Resource Links

weird behavior in SSMS - backslash (\) is getting displayed as (#)

  

I'm experiencing some weird behavior in SSMS for SS2008.  When I create a new query and type the backslash (\) key a pound(#) symbol is displayed instead in the query window.  I've never experienced this behavior in SSMS 2005 before.  This is the first time I'm using SSMS 2008.  I work with a few developers who also use SSMS 2008 and they have no idea about this either.  Any idea whaat might be causing this behavior and any idea how I can fix this?  I'm using Windows 7 and the backslash (\) symbol displays as expected in other applications (Notepad, VS2010, etc). 

Please help!


Weird behavior

  
I've made this "Minify" class that inherits from MemoryStream and I want to use it to minimise the amount of whitespace in for example css and javascript files. To begin with I'm not doing anything complex just a simple replace.using System;using System.Collections.Generic;using System.Linq;using System.IO;using System.Text;using System.Web;using System.Text.RegularExpressions;namespace Output{    public class Minify : MemoryStream    {        private Stream stream = null;        public Minify(Stream stream)        {            this.stream = stream;        }        public override void Write(byte[] buffer, int offset, int count)        {            string content = UTF8Encoding.UTF8.GetString(buffer);            content = LimitWhitespace(content);            stream.Write(UTF8Encoding.UTF8.GetBytes(content), offset, UTF8Encoding.UTF8.GetByteCount(content));        } &nbs

MDX works fine in SSMS but not in query designer

  
Hi all,   I am trying to include this query in my query designer in SSRS. The query below is as follows:WITH MEMBER [Time].[Fiscal Month].[All].[ Subtotal] AS ' AGGREGATE( EXISTING { [Time].[Fiscal Month].[All].CHILDREN }) ', SOLVE_ORDER = 1000  SELECT NON EMPTY { { { { [Time].[Fiscal Month].[All].CHILDREN }, { [Time].[Fiscal Month].[All].[ Subtotal] } } * { { [Measures].[SKU Distinct Count] } } } } ON COLUMNS , NON EMPTY { [Sales Force].[Retailer Code].[All].CHILDREN } ON ROWS  FROM [Sales]CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL The error i am getting isThe query cannot be prepared: The query must have at least one axis. The first axis of the query should not have multiple hierarchies, nor should it reference any dimension other than the Measures dimension..Please let me know where am i going wrong.Thanks and regards,ram

EXPERT: avoiding weird refresh behavior of Eval method in a tabpanel

  
I have this control in a detailsview:<asp:DropDownList ID="ddlEventStartDay" SelectedValue='<%#Cdate(Eval("startdate")).Day %>' CssClass="textbox" runat="server">    <asp:ListItem Value="1" Text="01" />    <asp:ListItem Value="2" Text="02" />    <asp:ListItem Value="3" Text="03" />    <asp:ListItem Value="4" Text="04" />    <asp:ListItem Value="5" Text="05" />    <asp:ListItem Value="6" Text="06" />    <asp:ListItem Value="7" Text="07" />    <asp:ListItem Value="8" Text="08" />    <asp:ListItem Value="9" Text="09" />    <asp:ListItem Value="10" Text="10" />    <asp:ListItem Value="11" Text="11" />    <asp:ListItem Value="12" Text="12" />    <asp:ListItem Value="13" Text="13" />    <asp:ListItem Value="14" Text="14" />    <asp:ListItem Val

weird Rating Control behavior

  
Hi folks! :)I have Rating control on my page. The page is a subpage of nested master page. On that page is updatepanel and wizard with TemplatedWizardStep inside it and inside TemplatedWizardStep is Rating Control.Master.Page -> NestedMaster.Page -> Content.PageI allso have googlemap inside that wizard(on different step) so i need to register google initialize() for it to work.So by registering googlemap like example below Rating Control freezes. Private Sub ScriptManager1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles ScriptManager1.Load ScriptManager.RegisterStartupScript(Page, Page.GetType(), "onload", "initialize()", True) End Sub But if i include script tags in string like example below, Rating Control does not freeze. Private Sub ScriptManager1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles ScriptManager1.Load ScriptManager.RegisterStartupScript(Page, Page.GetType(), "onload", "<script>initialize()</script>", False) End Sub Everythnig works, but i wonder, WHY :) Why is Rating Control freezing in sample1?

Weird query plan problem where total is over 100%

  
Hi All, I am looking at the query plan for a stored procedure and I am seeing things like 1400% on the execution plan, the stored procedure I believe is called within a loop quite a lot of times, but I don’t quite understand why the percentages will be over 100 for one section of the execution plan. Any explanation for this ? Thanks in advance.

Query acting weird.. larger date range works in 1min 26sec and a smaller range say 1 month - 3 month

  

I have no clue why my query is acting weird

If i try to run it for 1/1/2010 9/30/2010 the query takes around 1min 26 sec and  return around a million rows

and If i run for 8/1/2010 to 8/31/2010 it takes forever to it...

basically i am getting data from 5 tables and putting it in a temp table and then updating that temp table 2-3 times with some information and then displaying it.

I am stumped as to why it works fast for a longer date range and runs the  snail for a small period of time..

I am in the verge of pulling my hair and going crazy..

any help will be appreciated.

 

Thanks

Karen


Weird Thread.CurrentPrincipal behavior

  
msdn has a code sample illustrating the use of SetPrincipalPolicy. I copy the code and the output below:

using System;
using System.Security.Principal;
using System.Threading;

class ADPrincipal
{
    static void Main(string[] args)
    {
        // Create a new thread with a generic principal.
        Thread t = new Thread(new ThreadStart(PrintPrincipalInformation));
        t.Start();
        t.Join();

        // Set the principal policy to WindowsPrincipal.
        AppDomain currentDomain = AppDomain.CurrentDomain;
        currentDomain.SetPrincipalPolicy(PrincipalPolicy.WindowsPrincipal);
           
        // The new thread will have a Windows principal representing the
        // current user.
        t = new Thread(new ThreadStart(PrintPrincipalInformation));
        t.Start();
        t.Join();

High memory usage by the SSMS.exe and no Running Query

  

Hi i am editing a stored procedure using the SSMS (I have SQL Server 2008 SP1 - Windows 2003 Server Standard). At the begining everything is ok, but around of 3 or 4 minutes of work the ssms is becoming to slow, I open the Task Manager and I see that the process SSMS.exe is using 1.2GB of RAM Memory. I have open just one script (The stored procedure that I'm editing) but the script isnt running only editing. I dont understand that high memory because i'm not retreiving data of any query and im not running any thing on my ssms. Take a look of my task manager http://i875.photobucket.com/albums/ab319/jacarmonaro/highMemory.jpg

Other thing: When I minimize the ssms window the smss.exe process come back to a normal RAM memory usage.

Please any help??

 


JAC

High memory usage by the SSMS.exe and no Running Query

  

Hi i am editing a stored procedure using the SSMS (I have SQL Server 2008 SP1 - Windows 2003 Server Standard). At the begining everything is ok, but around of 3 or 4 minutes of work the ssms is becoming to slow, I open the Task Manager and I see that the process SSMS.exe is using 1.2GB of RAM Memory. I have open just one script (The stored procedure that I'm editing) but the script isnt running only editing. I dont understand that high memory because i'm not retreiving data of any query and im not running any thing on my ssms. Take a look of my task manager http://i875.photobucket.com/albums/ab319/jacarmonaro/highMemory.jpg

Other thing: When I minimize the ssms window the smss.exe process come back to a normal RAM memory usage.

Please any help??

 


JAC

Weird application behavior -- Action required to trigger service response otherwise the application

  

Hi,

I am a WCF beginner and is trying out with a basic host service with callbacks to the client.

My code works wonders if my client app is a console.exe but when I transferred the code to a Windows Form app, the application will freeze.  But if I right click on the form window task bar, the code suddenly goes through and it would work...

Is there anything wrong with this?

The service is hosted on IIS

Here is my Service code:

 

[ServiceContract(CallbackContract = typeof
(IChatCallBack))]
 public
 interface
 IChat
 {
  [OperationContract]
  void
 Talk(string
 msg);
  }

[ServiceContract]
 public
 interface
 IChatCallBack
 {
  [OperationContract]
  void
 OnCallBack(string
 msg);
  }

 

Implementation:

 

[ServiceBehavior(
  ConcurrencyMode = ConcurrencyMode.Reentrant)]
 public
 class
 Chat : IChat
 {

  

Can we Implement in SQL MDX query SQL Signature as in normal SSMS(SQL Server Management Studio)

  

Can we implement SQL query signature in SQL MDX query? how can we implement the same


editor for xml fields in SQL server 2008 R2 SSMS?

  

Hi.

I have a question regarding possibility of editing XML fields via SQL server management studio. I know that this "feature" isnt provided in SQL server 2008, but I was wondering whether microsoft wasnt thinking ahead and maybe added this "feature" to SQL server 2008 R2?

If not, is there some workaround except for creating application for that?
I have found something called xmlspy which is used for this matter. But I dont see a reason why should someone buy that, I think this "feature" should be included in SSMS.

thanks in advance

 


TomiGaspar

Package using Recordset variable showing weird behavior

  

Hi,

I am using a recordset variable in my package... say.. User::VarRecordset(Scope: Package)

I am first filling the User::VarRecordset using a Recordset Destination. Then, I am using this Variable in a For Each Loop..

The package works fine in BIDS. Even on Making a File system Deployment, It works on My machine, and some others too.

But on Some machines, the Execution Fails, showing an Error, Package Variable "User::VarRecordset" not Found in List of Variables..

The execution results do not show any error while putting data into "User::VarRecordset" . But FOR EACH Loop Fails with that Error..

 

Unable to find any reason, why it works well on some machines and Fails on Some.

My Machine is a 32 bit one...

 

Any clue or help to this requested...

 



How to undo an edit mistake in Query Editor?

  

How to undo an edit mistake in SQL Server Management Studio Query Editor?

When edit a code in Query Editor, because of mistake, I lose part of  the code. Now I want to undo the previous action. How to deal with it?


MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

How to Encrypt Query String Parameters in ASP.NET

  
Encrypt Query String Parameters in ASP.NET.u can send secure data one page another page u can also use query string to encrypt
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend