Search Results

Search found 5101 results on 205 pages for 'ssms 2005'.

Page 133/205 | < Previous Page | 129 130 131 132 133 134 135 136 137 138 139 140  | Next Page >

• SQL Monitoring Overview

  - by andy

  Hi I currently loook after 20 odd databases in SQL server 2005 and need a tool for monitoring the performance and keep me informed if a database is running slow. Is there anything I can run within Managment studio of any other good third party tool (Pref free) that can do the job. Thanks

  Read the article

• In a star schema, are foreign key constraints between facts and dimensions neccessary?

  - by Garett

  I'm getting my first exposure to data warehousing, and I’m wondering is it necessary to have foreign key constraints between facts and dimensions. Are there any major downsides for not having them? I’m currently working with a relational star schema. In traditional applications I’m used to having them, but I started to wonder if they were needed in this case. I’m currently working in a SQL Server 2005 environment.

  Read the article

• automatically refresh datasource in different instances of windows forms C# application

  - by sh00

  I have different instances of an [.NET 3.5] C# win forms application that run on different machines. All instances use the same SQL 2005 db. I need to send an alert and to refresh grids [contained in user controls] when another instance of the application changes smth in db. Which is the best way ? Thank you very much.

  Read the article

• Get remote PC's date time?

  - by David.Chu.ca

  Is there any class available to get a remote PC's date time in .net? In order to do it, I can use a computer name or time zone. For each case, are there different ways to get the current date time? I am using Visual Studio 2005.

  Read the article

• Customizing Mail Message in SSIS Event Handler

  - by Eric Ness

  I want to add an email notification to an SSIS 2005 package event handler. I've added a Send Mail task to the event handler. I'd like to customize the email body to include things like the error description. I've tried including @[System::ErrorDescription] in the MessageSource field, but the mail message doesn't include the value of ErrorDescription only the name of the variable.

  Read the article

• MSSQL Server high CPU and I/O activity database tuning

  - by zapping

  Our application tends to be running very slow recently. On debugging and tracing found out that the process is showing high cpu cycles and SQL Server shows high I/O activity. Can you please guide as to how it can be optimised? The application is now about an year old and the database file sizes are not very big or anything. The database is set to auto shrink. Its running on win2003, SQL Server 2005 and the application is a web application coded in c# i.e vs2005

  Read the article

• How to make Listbox's texts center aligned in desktop application using c#.net

  - by Rajesh Rolen- DotNet Developer

  Please tell me how can i align center to my listbox's text in desktop application. i am using c#.net in visual studio 2005 I am using window forms..

  Read the article

• How to use Custom Namespace for a Google Merchant Center Item Feed

  - by Jon

  I have declared the namespace that i am using: <?xml version='1.0'?> <entry xmlns='http://www.w3.org/2005/Atom' xmlns:g='http://base.google.com/ns/1.0' xmlns:c='http://base.google.com/cns/1.0'> here is a typical xml node i have: <c:gold_type type="string">White Gold</c:gold_type> Yet, when i submit my feed only the Google Namespace xml nodes work. Any ideas?

  Read the article

• Cleaning up a SQL SP with Regex

  - by Douglas Osborne

  1) If I am running a find and replace in SQL 2005 - what would be the regular expression to find tab and space sequences ( or space and tab sequences ) and replace them with just tab? 2) If I have a line which begins with a space - is there a regular expression to convert that leading space to a tab? 3) What would be the regular expression to remove all of the spaces before a CR/LF in a SQL statement? TIA for the help - I know this will be trivial to most of you, Doug

  Read the article

• Visual Source Safe(VSS) can not work !!

  - by Nahid

  I m working on Microsoft Visual Stdio 2005. I am working on ASP.NET. I added project to VSS. I found this project correctly, but other user can't access this. show this error message. and this web project cannot working in vss

  Read the article

• How would I duplicate the Rank function in a Sql Server Compact Edition SELECT statement?

  - by AMissico

  It doesn't look like SQL Server Compact Edition supports the RANK() function. (See Functions (SQL Server Compact Edition) at http://msdn.microsoft.com/en-us/library/ms174077(SQL.90).aspx). How would I duplicate the RANK() function in a SQL Server Compact Edition SELECT statement. (Please use Northwind.sdf for any sample select statements, as it is the only one I can open with SQL Server 2005 Management Studio.)

  Read the article

• What's the difference between "Stop Debugging" and "Terminate All" in Visual Studio?

  - by Khnle

  As the title asks, what's the difference between "Stop Debugging" and "Terminate All" in Visual Studio (I know those options are available in 2008, but not sure if it's called the same or something different in 2005 or 2010) ?

  Read the article

• JSP UI Builder like ASP .NET forms creator in Visual Studio

  - by bdhar

  I have come across a Web UI form editor in Visual Studio 2005+ which helps in creating the aspx forms. Similarly is there any creator for web forms for JSP?

  Read the article

• dataset getxml for one of the tables

  - by user181421

  Hello, C# 2005. I have a dataset with 3 tables, and I would like to get the xml for just one of these tables. Any idea? TY

  Read the article

• Select all rows where a varchar column converts to a decimal

  - by Blankman

  I have a varchar column that has generally has a decimal value, but some times there is some garbage text characters in that field. Is it possible to filter in the WHERE clause for rows that sucessfully convert to a decimal value? I am using sql-server 2005

  Read the article

• While try to open the project - getting error.

  - by Gopal

  Using Visual Studio 2008 I have .net file name like UPS.Tek, version - Visual Studio 2005 C# files are UPSReport.cs (Visual C# Source File) UPSConn.Cs (Visual C# Source File) UPSBase.cs (Visual C# Source File) ...., When i try to open the C# files individually in VS 2008, the C# files are opening But When I try to open this UPS.Tek in Visual Studio 2008, It showing error as "make sure the application for the project type .csproj is installed" How to solve this error.

  Read the article

• Add chapters to m4a (mp4) files

  - by luca

  I used ChapterTool from Apple, but it's broken and discontinued since 2005.. Is there any other similar command line tool, or library (I'm writing in ruby..) ?

  Read the article

• What's the best practice or design pattern for user registration ?

  - by Space Cracker

  We have a big portal that needs user registration to allow them use its services. It's already done in .NET and SOL Server 2005. we are in the phase now of discovering all the problems of the current registration system to build a new robust flexible one that can be extended easily and can be more usable for all services. Could any help me find best practices and design patterns to help me rebuild this using good architectural practices?

  Read the article

• begin time and start time query

  - by shanks

  I have following data and using SQL Server 2005 UserID UserName LogTime LogDate 1 S 9:00 21/5/2010 1 S 10:00 21/5/2010 1 S 11:00 21/5/2010 1 S 12:00 21/5/2010 1 S 14:00 21/5/2010 1 S 17:00 21/5/2010 Need Output as:- 1 S 9:00 10:00 21/5/2010 1 S 11:00 12:00 21/5/2010 1 S 14:00 17:: 21/5/2010 I had used ROW_NUMBER function in query but its showing error

  Read the article

• Passing a DataTable into a Stored Procedure. Is there a better way?

  - by punkouter

  Can A datatable somehow be passed into SQL Server 2005 or 2008 ? I know the standard way seesm to be passing XML to a SP. And a datatable can easily be converted to XML somehow to do that. What about passing a .NET object into a SP ? Is that possible ? I remember hearing about SQL and CLR working together in 2008 somehow but I never understood.. Maybe that means you can refer to .NET objects within a Stored Procedure ?

  Read the article

• How to Implement Excel COMBIN function in SQL

  - by Umar Siddique

  How can i implement Excel COMBIN function in SQL 2005, either in a store procedure or in a function. About COMBIN function in Excel follow this Link. Thanks.

  Read the article

• trusted SQL Server connection

  - by dan_vitch

  When I attempt to make a connection from my console app to my sqlExpress. I get the following error: The user is not associated with a trusted SQL Server connection. I have: Switched users Switched passwords Switched Servers Switched Databases I always get the same error. I am using VS 2010 and Sql Server 2005 Here is my current connection string SqlDatabase sqlDatabase = new SqlDatabase(@"Server=localmachineName\SQLEXPRESS;database=database1;user id=username password=mypassword;");

  Read the article

• Instead of buying VS 2010 what options will you use for .net development in the future?

  - by Eric Neunaber

  Given the recent release of VS 2010 I was shocked to see the pricing structure for the different versions of the product. I was lucky enough to receive free versions of VS 2005 and 2008 from attending various MS events. For the hacking I do at home I'm not sure I'm going to spend the money to purchase the IDE and wanted to see what others were using. Like SharpDevelop MonoDevelop Expess Editions

  Read the article

• Error while using Script Manager

  - by Darshna Raghani

  "Only one instance of a Script Manager can be added to the page. " Such Error occurs when I use Script Manager in my vb.net 2005 application. What should I Do?

  Read the article

• .vbproj the project is not supported by this installation

  - by harold-sota

  I have visual studio 2008 installed in my pc when i try to open a .Net 2005 Solution with multi-projects, there are project in vb and c#. The only web project on this solution display the following message: .vbproj the project is not supported by this installation I try to open the web project separately from the solution and I not have problem. How I can open the web project from the solution. Any ideas?

  Read the article

< Previous Page | 129 130 131 132 133 134 135 136 137 138 139 140  | Next Page >