Search Results

Search found 4906 results on 197 pages for 'sqlexpress 2005'.

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

• Get row where date column = today - SQL server noob

  - by Chin

  In sql 2005, instead of building a query from dateparts year, month and date, is there an more succinct way of writing the where clause? many thanks

  Read the article

• How to get size of file uploaded to SQL-Server?

  - by MadBoy

  Is there a way to tell how to get a file size that is uploaded to database? SELECT [ID] ,[File] FROM [dbo].[Reports] I would like to be able to tell user the size of File which is VarBinary(max) field in MS SQL 2005/2008. How to do that? Maybe the only way to do is to create another column and when inserting file i should also insert it's size in additional column?

  Read the article

• SQL Server checking if you have access to a database

  - by J Harley

  Good Morning, I have connected to my SQL Server 2005 - and have managed to list all of the databases on that server. Now I would like to run a check on each database to see if I have permission to view that database.. How would I go about this? Many Thanks, Joel

  Read the article

• Update thousands of records in a DataSet to SQL Server

  - by MSIL

  I have half a million records in a data set of which 50,000 are updated. Now I need to commit the updated records back to the SQL Server 2005 Database. What is the best and efficient way to do this considering the fact that such updates could be frequent (though concurrency is not an issue but performance is)

  Read the article

• sql - ModifyDate column - Is using a Computed Column a correct way to implement this?

  - by hamlin11

  I just want to have a "ModifyDate" column automatically populated for me when a record is either inserted or updated. Should I be using triggers or is it OK to use a Computed Column? (Using SSMS2005 and SQL Server 2005 Express)

  Read the article

• Anyone know a program to automatically dump a bunch of test (dummy) data into a sql database?

  - by naspinski

  I am running SQL Server 2005 and I want to dump some dummy data into a large table with about 50 columns (I did not design it :P) - anyone know a tool to do this automatically? I want the rows to have all sorts of different data, and I would rather not write a script if there is already a tool out there - thanks.

  Read the article

• MS SQL checking if you have access to a database

  - by J Harley

  Good Morning, I have connected to my SQL 2005 server - and have managed to list all of the databases on that server. Now I would like to run a check on each database to see if I have permission to view that database.. How would I go about this? Many Thanks, Joel

  Read the article

• How to parse a date from an SSIS Excel filename

  - by user327045

  I want to use the foreach container to iterate through a folder matching something like: "Filename_MMYYYY.xls". That's easy enough to do; but I can't seem to find a way to parse the MMYYYY from the filename and add it to a variable (or something) that i can use as a lookup field for my DimDate table. It seems possible with a flat file data source, but not an excel connection. I'm using Visual Studio 2005. Please help!

  Read the article

• Sql server like for Integer

  - by Prashant

  I have a column which is integer and I want to search all numbers starting with 1500. I know I could use something like left(accountid,4)= 1500. But is that an optimum solution or is there a better approach? I am using Sql Server 2005.

  Read the article

• Import/Export table definistrions using SQlServer Management Studio

  - by fireBand

  Hi, How to import/export table definitions from my dev database to production database(recreate the whole database). I have Sql server 2005, Sql Management studio with power shell. Thanks in advance.

  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

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

• 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

• 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

• 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

• 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

• 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

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