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 >

• 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

• How to Set Up Winform Textbox Field Focus so a User Can Go Through Them by Clicking Tab Button?

  - by peace

  UI is created in VS 2008. I'm using C# .... I need to let the user move/focus between text fields from top to bottom by clicking tab button. How can i do it?

  Read the article

• tsql source control help please

  - by rod

  Hi All, According to the following section of BOL: How to: Use Source Control with SQL Server Management Studio If you have a source control client installed you should be able to choose it in the plug-in selection. I have both source control clients for Visual Studio 2005 and 2008 (tfs2005) installed and there's no plug-in to choose in the list for me.

  Read the article

• Use a named range in an excel worksheet to propagate a listbox

  - by user223139

  So I have a number of namedRanges in an excel worksheet. I would like to use these to fill in comboboxes on a user form in the same WorkBook. I have tried: cboMember.DataSource = Globals.Sheet1.MemberRange.Value No error is given but the combo is blank. Does anybody have any ideas? I'm trying to use VSTO for VS 2008 on an excel 2003 work book.

  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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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

• 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 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

• 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

• How to connect to a database from VC++/CLI .NET 4.0

  - by abatishchev

  How to connect to a database (any natively supported by .NET) - SQL Server 2008 or Access - from a Windows Forms application written on VC++/CLI (compiler ver. 16.0 from .NET 4.0)

  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

• 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

• 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

• 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

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

  - 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

• 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

• 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 >