Search Results

Search found 5375 results on 215 pages for 'sqlserver 2005'.

Page 49/215 | < Previous Page | 45 46 47 48 49 50 51 52 53 54 55 56  | Next Page >

• Detect non-closed connections to SQL

  - by JoeJoe

  I've inherited a very large project in ASP.net, SQL 2005 and have found where some SQL connections are not closed - which is bad. Without going thru every line of code, is there a way to detect if connections are not being closed? Performance counter? as a follow up - how does SQL reclaim unclosed connections. I'm using non-pooled connectionstring.

  Read the article

• .Net Frameworks Initialization Error

  - by mahesh

  I have develop application on VS-2005 and installed it at another machine and along with application I have installed .net frameworks 2.0 version as per demand and it works well at time of installed and after some time if I try to open it it’s throw error like “ .Net Framework Initialization Error, Unable to find a version of the runtime to run this application. Client Machine : Operating System is XP sp2 How to overcome from 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

• Stop unit tests from running

  - by Sean M. Severson

  I would like to prevent all subsequent unit tests from running when certain conditions are met in a unit test. Is this possible in Visual Studio 2005?

  Read the article

• How to export into word format using Reporting Services (SSRS)

  - by Ashish

  Using Reporting services in SQL Server 2005 in asp.net with c#, how can we export reports in word document? Thanks In Advance.!!

  Read the article

• how to copy conmanclient.exe and related files to the windows folder of device

  - by ame

  I need to debug a winCE application over the ethernet using Visual Studio 2005. I have connected to the device over the ethernet and now need to run conmanclient2.exe and cmaccept.exe before I can start debugging. However, I don't know how to copy these files over the ethernet. Please guide me. Thankyou!

  Read the article

• Protocol communication help..

  - by Gopal

  Using Visual Studio 2005 Language: c# A new to c# I have software, the software should communicate with gprs devices. So i want to write a protocol, TCP, UDP communication code. Can any one give some idea for writing a source code and some sample code also.

  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

• Import excel file into sql express 2008

  - by ck

  Hi, I've got some excel files, that were exported from tables in Access, and I want to import them into sql express 2005. I need a script that will convert nvarchar(255) columns to varchar(255) and preserve links, when importing the data into sql express. Thanks

  Read the article

• how to querry on the database without accessing the tables, correct the database but not the tables

  - by user287745

  used is c# sql vs 08 sql server 2005 express whenever and where ever an sql select statement is used, its always like select * from tablename or count statement is alsi like select count something from table name for selecting or doing anything on the tables, i would like to know which tables exits in my the database i am connected to! so like select alltablenames from database_name. please guide.

  Read the article

• Recursive only 2 level records using common sql

  - by Tony

  I have an Employee table, it's a self-referencing table, with managerId refers to primary key empID. I want to find 2 level records by a given empId. For example: if given empId=5, if empId=5 has children records, display them, as well as the children in children records. You may also provide a recursive suggestion without level limitation. The database is SQL Server 2005.

  Read the article

• Calculating age based on date of birth in SQL and C#? [closed]

  - by Raj

  Possible Duplicates: How to calculate age (in years) based on Date of Birth and getDate() How do I calculate someone’s age in C#? How to calculate the customer age automatically by using their Date of Birth using c# and SQL Server 2005

  Read the article

• changing default hierarchy of Cube dimension

  - by paranjai

  Hi , I have created Dealer dimension in SSAS 2005 and it has 3 hierarchies. By default the hierarchy created first is the default hierarchy of the dimension. Is there any way to change the default hierarchy to another hierarchy.

  Read the article

• Can I install a second SQL Server instance on the same location as the first instance?

  - by Yousui

  Hi guys, Can I install a second SQL Server instance on the same location as the first instance? Can that cause some problem? By the way, I'm using SQL Server 2005. Great thanks.

  Read the article

• SQL Server: How to tell if a database is a system database?

  - by Vinko Vrsalovic

  I know that so far (until MSSQL 2005 at least), system databases are master, model, msdb and tempdb. Thing is, as far as I can tell, this is not guaranteed to be preserved in the future. And neither the sys.databases view nor the sys.sysdatabases view tell me if a database is considered as a system database. Is there someplace where this information (whether a database is considered a system database or not) can be obtained?

  Read the article

• Linking database column to dropdown control in ASP.Net

  - by kunal

  I am using c# with asp.net and SQL Server 2005 as backend. I want to use dropdown list control in a form to populate a textbox. The dropdown control is linked to a column in the database. How can I code this in c#?

  Read the article

• Software loading error problem

  - by Gopal

  VB6 & SQL Server 2005 When i run the Windows based Software exe file, it is showing the login page, after login page - no screen is displaying, I checked the task manager, in task manager it is showing as software as running, But there is no page is appearing. Is any firewall blocking or some other issue. But software is running with out displaying anythings. How to solve this issue?

  Read the article

• mssql Is it possible to get procedure or table creation and last alter date?

  - by Woland

  mssql Is it possible to get procedure or table creation and last alter date? If it is then how do to it? Ms sql 2005 server

  Read the article

• Problem with user logins after db Restore

  - by JJgates

  I have two SQL 2005 instances that reside on different networks. I need to backup a database from instance A and restore it to a database in instance B on a weekly basis so that both databases hold the same data. After the restore, logins SIDS on database B are changed and therefore users can't log into database B and connection strings for the web application it supports are broken. Is there a work around for this? Thanks.

  Read the article

• Is it faster to compute values in a query, call a Scalar Function (decimal(28,2) datatype) 4 times,

  - by Pulsehead

  I have a handful of queries I need to write in SQL Server 2005. Each Query will be calculating 4 unit cost values based on a handful of (up to 11) fields. Any time I want 1 of these 4 unit cost values, I'll want all 4. Which is quicker? Computing in the SQL Query ((a+b+c+d+e+f+g+h+i)/(j+k)), calling ComputeScalarUnitCost(datapoint.ID) 4 times, or joining to ComputeUnitCostTable(datapoint.ID) one time?

  Read the article

• How to create Visual studio solution from make files ?

  - by Morpheus

  Hi all!! I have a source code for a project with their make files. I want to create a Visual Studio (2005) solution from it. Is there any direct way to do this? can anyone help me please. I spent hours for searching, but couldn't find a way to do this. Thanks.

  Read the article

• Find query that caused update

  - by MadMax

  We have been having problems with ghost updates in our DB (SQL Server 2005) fields are changeing and we cannot find the routine that is updating. Is there a way using an update trigger (Or any other way) to tell what caused the update?

  Read the article

• Visually designing a Visual C++ Windowed Application

  - by John

  If you want a dialog application, MSVC++ 2005 is OK, but when I create a SDI application I don't see any visual layout tools. is this possible? And are there any better resource editing/mocking tools for MFC apps?

  Read the article

• Visually designing a Visual C++ Windowed Application

  - by John

  If you want a dialog application, MSVC++ 2005 is OK, but when I create a SDI application I don't see any visual layout tools. is this possible? And are there any better resource editing/mocking tools for MFC apps?

  Read the article

• "(Empty)" text "literally" instead of "" in datacolumn from visual studio

  - by user335620

  Hi folks. I've always have a problem with big datasets created through the dataset designer in visual studio (2005). When the dataset many tables with many columns, the columns defined like "(Empty)" in the NULL VALUE property starts showing the text "(Empty)" literally. Is anyone aware of this? or is just me? Thanks in advance.

  Read the article

< Previous Page | 45 46 47 48 49 50 51 52 53 54 55 56  | Next Page >