Search Results

Search found 14350 results on 574 pages for 'sbs 2008'.

Page 221/574 | < Previous Page | 217 218 219 220 221 222 223 224 225 226 227 228  | Next Page >

• Keeping SQL out of the buffer or finding a way to improve page life expectancy?

  - by Stewart Robinson

  My SQL Server 2008 server gets flooded with dynamic SQL from one stored procedure. I am wondering whether I can tell SQL Server not to store this one stored procedure in the pool as it doesn't matter too much whether it executes quickly. Perhaps there is an equivalent of (nolock) for (nobuffer) or similar? Any ideas?

  Read the article

• Convert dependencies to point to View instead of Table

  - by jwarzech

  I currently have a SQL Server 2008 database in which I am planning to separate out some tables to other databases. I want to be able to replace all references to the separated tables from the original database using views. Is there a better way (other than manually changing all FK and SProc references) to switch all the dependencies to reference the view instead of the table?

  Read the article

• how to get time (hh:mm:ss) from sql query ?

  - by Gold

  hi i have Database with date field. i see the time like: 1900-01-01 13:38:00.000 how i can see it like: 13:38 ? (i work on sql server 2008) thank's in advance

  Read the article

• Whats going on here can't you compare if(mychar1 == 'ä' || mychar2 == 'Ä') in C++?

  - by Chris_45

  Im trying to compare these two chars but on win 32 Visual Studio 2008: if(mychar1 == 'ä' || mychar2 == 'Ä') Erromess: Debug Assertion Failed! File:f\dd\vctools\crt_bld\self_x86\crt\src\xstring Line 1575 Expression: string subscript out of range

  Read the article

• Why does visual studio think js file is a cs file?

  - by divitiae

  I have a ASP.NET solution in Visual Studio 2008 and I added a file identical to http://plugins.jquery.com/files/jquery.cookie.js.txt named jquery.cookie.js in a subfolder of my project containing other javascript files and Visual Studio is treating it as a C# file, giving me errors like CS1012: Too many characters in character literal and Semicolon after method or accesssor block is not valid. Why?

  Read the article

• Find the height of text in a panel

  - by Vaccano

  I have panel that I have customized. I use it to display text. But sometimes that text is too long and wraps to the next line. Is there some way I can auto resize the panel to show all the text? I am using C# and Visual Studio 2008 and the compact framework.

  Read the article

• Visual studio erroneous erros when building a website?

  - by Curtis White

  Visual Studio 2008 shows a lot of erroneous errors when building a website (not a web project) in the errors list. These errors are usually corrected (removed) when I rebuild the site a couple times but they cost me wasted time. Is there anyway to hide the erroneous errors?

  Read the article

• how can we back up in sql server 2008

  - by Johanna

  Hi I need the menus that help me to back up in sql server 2008? thanks

  Read the article

• Should a data warehouse developer know Powershell scripting?

  - by AEngelsrud

  I am a SQL Server (2005 & 2008) data warehouse developer (SSIS, SSAS, SSRS, SQL) and I am wondering if it would be worth the effort and time to learn Powershell scripting. Are there applicable uses from a development perspective? I understand that from a DBA view there is considerable power in Powershell for administration - does any of this translate to useful commands for a developer? Thanks!

  Read the article

• Migrated SQL Server database suddenly in "Restoring" state

  - by Pete Montgomery

  I backed up a SQL Server 2005 database and restored it to a new SQL 2008 instance. The restore was quick and successful. Everything was fine for an hour or so. Suddenly, the database is now stuck in "(Restoring...)" state in Management Studio and has a green arrow icon, and my application login is failing! Any advice? :-)

  Read the article

• Restrict varchar() column to specific values?

  - by adam

  Is there a way to specify, for example 4 distinct values for a varchar column in MS SQL Server 2008? For example, I need a column called Frequency (varchar) that only accepts 'Daily', 'Weekly', 'Monthly', 'Yearly' as possible values Is this possible to set within the SQL Server Management Studio when creating the table?

  Read the article

• Go to Matching Brace in Visual Studio?

  - by thepocketwade

  Is there a way in Visual Studio 2008 to go from a closing brace to it's opening brace? I've found a fair amount of stuff about highlighting the brace, but nothing about moving the cursor to it.

  Read the article

• How to identify the culprit in "Error converting data type varchar to numeric"?

  - by Stan

  An insert statement with a large number of values returns 'Error converting data type varchar to numeric.' How can I find which value actually triggers the error? MS SQL Server 2008 is used.

  Read the article

• What are the "directoryentry" and "directorysearch" controls in VS2008?

  - by forum

  What are "directoryentry" and "directorysearch" controls in Visual Studio 2008? How do they work? What are there real-world applications? What about their properties?

  Read the article

• How to auto-sync Header in Visual Studio ?

  - by fk2

  Do you know if there is a build-in feature or free add-in for Microsoft Visual Studio 2008 that easily generates C-Headers and keeps them in sync with their .c counterparts? I have already looked at Visual Assist X, but I'm not really willing to pay money at the moment.

  Read the article

• C# Can I publish my window form application???

  - by HoNgOuRu

  I've just finished a functional peace of code and would like to upload it to the internet as freeware. It is just a window form application. I used C# and Visual Studio 2008. I wan't to know if it is legal to do this... Thanks for reading this.

  Read the article

• Putting 3 million pages in 1 folder vs. putting in a number of sub-folders, which structure is faste

  - by silent

  If I have 3 million pages, which directory structure is better? Method 1. ~/123456789.htm (Putting all the 3 million pages into the same folder without any sub folders) Method 2. ~/789/123456789.htm (Create 999 sub-folders, each sub-folder contains about 3000 pages) For Windows Server 2008, which folder structure is faster? (For file creation, reading and deletion)

  Read the article

• Best index(es) to use for an OR Statement in SQL Server

  - by Chuck Haines

  I have a table which has a bunch of columns but the two relevant ones are: Due_Amount MONEY Bounced_Due_Amount MONEY I have a SQL query like the following SELECT * FROM table WHERE (Due_Amount 0 OR Bounced_Due_Amount 0) Would the best index to put on this table for SQL Server 2008 be an index which includes both columns in the index, or should I put an separate index on each column?

  Read the article

• How to keep ComboBox from scrolling? C#

  - by Chris

  I have a ComboBox. It is critical that the user cannot scroll by accident and change the selected value. How can I prevent the ComboBox from changing the value and text when the use scrolls? Thanks. Visual Studio 2008

  Read the article

• Why SQL Server Express 2008 install requires Visual Studio 2008 in checklist ?

  - by asksuperuser

  When installing SQL Server Express Edition 2008, checklist says "Previous version of Visual Studio 2008" and asked me to upgrade to sp1. Unfortunately sp1 for some reason refuses to install on my brand new pc (Windows 7). So why can't I just bypass this ? Why would SQL Server Express needs VS2008 to install that's insane. SQL Server install used to be as easy as 123, now it has become a nightmare like installing Oracle. Will I have to go back to Windows XP ?

  Read the article

• A Query to remove relationships that do not belong [closed]

  - by Segfault

  In a SQL Server 2008 R2 database, given this schema: AgentsAccounts _______________ AgentID int UNIQUE AccountID FinalAgents ___________ AgentID I need to create a query that does this: For each AgentID 'final' in FinalAgents remove all of the OTHER AgentID's from AgentsAccounts that have the same AccountID as 'final'. So if the tables have these rows before the query: AgentsAccounts AgentID AccountID 1 A 2 A 3 B 4 B FinalAgents 1 3 then after the query the AgentsAccounts table will look like this: AgentsAccounts AgentID AccountID 1 A 3 B What T-SQL query will delete the correct rows without using a curosr?

  Read the article

• Concatenate a table name from a variable in a FROM clause

  - by idieeasy

  I'm trying to use a dynamically generated fully-qualified table name in sql server 2008. For example, this does not work: select max([id]) from @dbName+N'.[T1]' This will give an error like: Msg 102, Level 15, State 1, Line 73 Incorrect syntax near '+'. I know that something like this works: declare @qualifiedTable varchar(200) = @dbName+N'.[T1]' select max([id]) from @qualifiedTable But I have to do this LOTS of times so I would really like to do it in line. Is it possible?

  Read the article

• WPF inherited UserControl lost VS designer support

  - by PaN1C_Showt1Me

  Hi ! I' written this UserControl: <my:MyUserControl x:Class="MyClass" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:my="clr-namespace:MyNameSpace.MyControls;assembly=MyAssembly"> </my:MyUserControl> public partial class Editor : MyNameSpace.MyControls.MyUserControl {} Everything works, the control is shown in the VS 2008 Designer, but I cannot click directly in the elements and select them as it was with UserControl. Any idea how to solve it?

  Read the article

• How to speed up saving data to database over internet?

  - by robert_d

  I am using C#, Entity Framework and SQL Server 2008 Express. I am connected to the database over internet. What is the best method to speed up saving/updating data to database? It takes 60 seconds to save 140 records to database.

  Read the article

• is it possible to add line from Database to text file in the server ?

  - by Gold

  hi i have sql-server 2008 database that in the main server. i have 10 terminals that connect to this server and work against the database. i need that every new inserting to database through any terminal - in the server this line will inserting to text file (every line) can i do it ? thank's in advance

  Read the article

< Previous Page | 217 218 219 220 221 222 223 224 225 226 227 228  | Next Page >