Search Results

Search found 106740 results on 4270 pages for 'sql server 2005 server 20'.

Page 172/4270 | < Previous Page | 168 169 170 171 172 173 174 175 176 177 178 179  | Next Page >

• Please tell me what is error in my date comparison sql query

  - by Rajesh Rolen- DotNet Developer

  Please help me to find out error in my SQL query. I have created this query to compare dates select * from Joinplans jp where cast(convert(varchar,GETDATE(),103) AS datetime) BETWEEN CASE(convert(varchar,jp.planstartDate,103) AS datetime) AND CASE(convert(varchar,DATEADD(DAY,jp.planDays,jp.planstartDate),103) AS DATETIME) It's giving me the error: incorrect near 'AS' I am using SQL Server 2005.

  Read the article

• Please tell me what is error in my date comparision sql query

  - by Rajesh Rolen- DotNet Developer

  please help me to find out error in my sql query. i have created this query to compare dates select * from Joinplans jp where cast(convert(varchar ,GETDATE(),103) AS datetime) BETWEEN CASE(convert(varchar,jp.planstartDate,103) AS datetime) AND CASE(convert(varchar,DATEADD(DAY,jp.planDays,jp.planstartDate),103) AS DATETIME) It's giving me the error: incorrect near 'AS' I am using SQL Server 2005.

  Read the article

• set datasource crystal report 10 at runtime using vb 6.0 and SQL server 2005

  - by rah.deex

  Please help... I am so confused, how to set Crystal Report 10 data source at runtime using VB 6.0. I am using SQL SERVER 2005 for database and I create the reports using stored procedure.. do You have any idea to solve my problem ? thanks before..

  Read the article

• Creating a trigger that manipultes a field in SQL Server

  - by icemanind

  Guys, I have a table called tblNames and one of my fields in this table is called 'UpFileName'. Is it possible to create an insert trigger that would automatically replace all '%20' in the UpFileName field to underscores '_'? I'm using SQL Server 2005.

  Read the article

• Move contacts from Office Communicator 2005 to 2007.

  - by Udayakumar Sree

  Please tell me how to move my contacts from Office Communicator 2005 to 2007. I have an XML file from my Application data with name "presence_*_com.xml" which contains all my contacts. Is there any way to use this file to get back my contacts into 2007 version?

  Read the article

• Where does sql server stores the stored procedure code?

  - by NoProblemBabe

  I once needed the lines of the stored procedures, to be able to trace whether i have a reference to some function, procedure or table, or sometimes to try to find something inside of the sp's code. Where does the sql server stores the procedures's code?

  Read the article

• DBA - SQL Server 2005 - Backups

  - by subhash.pant

  I am trying to figure out how SQL Server DBAs are doing their backups and verify in 2005. I use the Idera's free stored procs (which is no longer available to download btw) to backup and verify and have gotten around 65% compression. If there any other free alternative? Thanks in advance, -Subhash

  Read the article

• connecting sql server 2008 from sqlserver 2005

  - by raj

  I am not able to connecting to the sqlserver 2008 from my sqlserver 2005....Is it really not possible to connect or there is some way.. please suggest me..if there is some thing.. Thanks.

  Read the article

• SSIS 2005 - How to check a file to see if a files does not exist

  - by GordyII

  How do you check to see if a file does not exist in SQL Server Integration Services 2005? Is there a native SSIS component which will just do this for you?

  Read the article

• Visual Studio 2005 C++ Application Wants To Run As Admin

  - by workinprogress

  I wrote a simple c++ application in Visual Studio 2005 but when I compile it, the executable wants to run as admin. I tried deleting the manifest but it still wants to run as admin. I am running Windows Vista Home premium. Any help would be appreciated!

  Read the article

• Create a new table and import data from csv file into SQL Server 2005

  - by Madhu Kiran

  Hi, I have several files about 15k each of CSV data I need to import into SQL Server 2005. What would be the simplest way to import the csv data into sql server? Ideally, the tool or method would create the table as well, since there are about 180 fields in it, this would simplify things.

  Read the article

• 32bit to 64bit sql server 2008 database conversion

  - by Eric

  We are in the process of moving databases from older 32 bit hardware running sql 2005 to newer hardware with sql 2008 64 bit. My question is if the database is automatically converted to 64bit after it is reattached on the new server or if it is running in 32bit mode on a 64bit instance. Is there a way to tell?

  Read the article

• Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it fro

  - by Craig Johnston

  Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it from a file? If I don't do this, I get a "User login failed" when trying to access the database using this username from apps.

  Read the article

• How can I get all the database names in a sql server instance using tsql?

  - by Yousui

  Hi guys, How can I get all the database names in a sql server instance using tsql? Great thanks.

  Read the article

• In SQL Server, how can I execute a piece of tsql against all databases in an instance?

  - by Yousui

  Hi guys, In SQL Server, how can I execute a piece of tsql against all databases in an instance? Great thanks.

  Read the article

• How to change this mysql select into sql server select statement?

  - by Pandiya Chendur

  I use this mysql statement for concating description which has a length greater than 30.. select if (CHAR_LENGTH(description)>30,CONCAT(SUBSTRING(description,1,30), '.....'),description) as description from table How to change this mysql select into sql server select statement?

  Read the article

• In SQL Server, how to quickly get a general idea of an instance?

  - by Yousui

  Hi guys, If you are a new sql server dba and you just get an account of an instance. What would you do to know the instance and databases? How to quick get a general idea of this instance and databases? Great thanks.

  Read the article

• Visual C++ 2005 and Windows 7 64-bit

  - by Phenom

  Can Visual C++ 2005 be run in Windows 7 64-bit? I tried installing it, and came up with some problems.

  Read the article

• Sql Server xml column with Entity Framework - how to keep insignificant whitespaces

  - by Saravanan

  Sql server 2005 (even 2008) strips the insignificant whitespaces by default. To keep one can use the CONVERT funtction with the last argument as '1' (Ref. Article). How can we do the same thing in Entity Framework? thanks

  Read the article

• Where does sql server stores the stored proecdure code?

  - by NoProblemBabe

  I once needed the lines of the stored procedures, to be able to trace whether i have a reference to some function, procedure or table, or sometimes to try to find something inside of the sp's code. Where does the sql server stores the procedures's code?

  Read the article

• Connecting Visual Studio 2005 to Team Foundation Server 2008

  - by Mini

  As of now we are using vs2005. We are newly setting up TFS 2008. How do I connect TFS 2008 client to vs 2005 without upgrading it to vs2008 in my system? When I installed TFS 2008 client the options are appearing in VS2008 but not in vs2005.

  Read the article

• In SQL Server, how do I know what transaction mode I'm currently using?

  - by Yousui

  Hi guys, In SQL Server, how do I know what transaction mode I'm currently using? Such as autocommit, explicit, or implicit. And how can I change one mode to another using tsql? Great 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

• alternative to sql server 2005

  - by csetzkorn

  Hi, I got used to the xml support and recursive common table expressions of sql server 2005. I am just wondering whether any free dbs like mysql support these requirements nowadays? Thanks. Christian

  Read the article

• Filter assemblies/namespaces out of Visual Studio 2005 Documentation index

  - by PunctuallyChallenged

  Is there any way to remove certain assemblies or namespaces from the index of (or entirely from) the Visual Studio 2005 Documentation? System.Web.UI and System.Windows.Forms contain many identical class names and I'd like to eliminate those in System.Web.UI that are irrelevant to me.

  Read the article

< Previous Page | 168 169 170 171 172 173 174 175 176 177 178 179  | Next Page >