• I am getting following error for SQL server 2005/2008

    Hi, I have SQL server 2005 and SQL server 2008, both are installed on the same machine. Now I want to pass the server name like mymachine\\mssql2008 to one of my own stored procedure. This procedure tries to get the fully qualified table name of a particular table of some database which is on SQL...

    Brijeshkumar5 pointsBadges:
  • How to create an XML File from typed XML data stored in Multiple Rows and is referring to same XSD

    I want to create a single XML file from typed XML data stored in Multiple Rows and it is referring to a single XSD I want to use this XSD to find the position of the respective elements present in various rows. I am using SQL Server 2008 and I am using an XML Datatype field to store Nodes of XML

    VinayVerma510 pointsBadges:
  • machine name/sqlexpress2008r2 is giving error

    Dear friends, I have just installed sql server. I created an instance name, but was not able to connect to the server. However, if I put the /SQLEXPRESS2008R2 before the machine name I am able to connect to the DB. However, when using the same connection string in the VB.Net, its giving some error....

    georgesmith55 pointsBadges:
  • Career change RPG/ILE to ASP.net

    After almost 30 years of RPG (from the old RPG I days) I am making the change to .Net. I felt that ASP.net would offer more of a challenge and reflect more of today's business needs. I am still working for the same company so no real risk in the move. My question is what do you think will be the...

    ToddN200011,245 pointsBadges:
  • Select Statement & Where Clause ….

    On an ASP web page there is a Text Box with default Values for different records. The records are stored in a SQL2008 table called dbo.SOFTWARE and have been type in manually over time and contains many duplicates. The field is called 'BUSINESS_UNIT'. On the same page i have created a Combo Box...

    JKJK45 pointsBadges:
  • Compression in SQL Server 2008

    how can i use compress backup option  in sqlserver 2008r2 

    Sanjaygutta5 pointsBadges:
  • How to add two timings in SQL Server 2008

    DECLARE @TIME1 VARCHAR(10),@DURATION VARCHAR(10) SET @TIME1='10:00' SET @DURATION='00:25' SELECT CONVERT(TIME(0),@TIME1)+CONVERT(TIME(0),@DURATION) I need to add two timings ...suppose if the @time1 is '10:00' and the duration is '15' mns then it should show 10:15 ... Any help highly...

    Muralihan5 pointsBadges:
  • conversion of SQL Server 2008 stored procedure to Oracle 10g

    Can u please give tips on Differences between datatypes, functions, limits,statements etc in both oracle 10g and SQLserver2008 . I need this help for converting Store procedures from SQLserver2008 to oracle 10g

    Oracle10gSQLserver20085 pointsBadges:
  • table size strange in SQL SERVER

    Hi, I have 2 tables in SQL SERVER * TbUrl INDEX SPACE 12,531 MB ROW COUNT 247505 DATA SPACE 1.965,891 MB CREATE TABLE [TbUrl](     [IdUrl] [Int] IDENTITY(1,1) NOT NULL,     [IdSupply] [Int] NOT NULL,     [Url] [varchar](512) NOT NULL,     [UrlCod] [varchar](256) NOT NULL,    ...

    ens1z10 pointsBadges:
  • Two SQL (2005 and 2008) on the same machine.

    We are planning to install some CRM software and it can only use 2005, however we will be upgrading to SQL 2008, is it possible to run 2 SQL versions (2005 and 2008) and is it a good idea from backup, maintenence and running. Will there be issues?

    HOK5 pointsBadges:
  • Order by clause in SQL Server subqueries

    why the "order by" clause in sub queries must be associated with "top" clause in sql server..??

    Karthikharve5 pointsBadges:
  • Query Optimizer not Selecting Index on a Computed Column – Performs Table Scan

    Hi Denny, we are using the checksum function much like the description in your blog to create a interger column to represent a nvarchar(max) column and use this column to filter our query by.  The computed column is not persisted and there is a non-cluster index on it (the only index on the...

    Steve005 pointsBadges:
  • How do I create jobs using steps in SQL Server 2008 R2 Management Studio

    How do I create jobs using steps in SQL2008 r2 Management Studio? I am really having a problem with the syntax when using operating-system commands and transact-SQL commands. Examples would be great.

    Stingeree5 pointsBadges:
  • Using the PIVOT function

    Hi there, I'm pretty new to SQL and I'm trying to use the PIVOT function in Sequel Server 2008 R2. I've followed a whole bunch of examples and tutorials but just can't quite get my syntax right. I have a database of applications. Fields include ApplicationID, Status Description and StatusID, and...

    ChristinaSym15 pointsBadges:
  • problem in connect visual studio 2010 to SQL 2008

    when i am connecting the sql in my visual studio windows application to open a database file a error occurred you don't have the permission to open this file   contact the file owner or administrator to obtain the permission

    Prsaini5 pointsBadges:
  • Reg:Problem with SSAS

    Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I need to first migrate the...

    48102145 pointsBadges:
  • sys.conversation_endpoints build up

     It Seems that there is a lot of problems with SB cleanup? I have SQL 2008 r2 running on two different servers. The target system processes the millions of records in the queues but will not clean out the sys.conversation_endpoints, or the sys.conversation_endpoints tables. This is part of the...

    Shellz5 pointsBadges:
  • connecting to SQL server with mdf files

    What is the best way to connect a website on a VPS to sql server 2008 R2 express, using MDF files as databases. The VPS is running on server 2008 R2. I installed the same environment on the development computer. IIS gets a connection because it sees the users that are in the ASPNETDB.MDF file....

    Makoelaw5 pointsBadges:
  • Use of database backup from lower version to higher version of sqlserver

    I am using sqlserver 2000, have a database of 2GB. I want to shift at higher version 2008. What I have to do TO upload my Old version-2000 database backup  into  sqlserver 2008

    Vineet2820 pointsBadges:
  • Challenge improving query performance on large tables

    Hi, Here's the structure of the db I'm using: * Table frs_ArticlesBDFournisseur which contains article main data.One row per article/color. Key is Refrefart (int). Size is over 220000 rows at the momemt. Only index is the PK (clusterred). * Table frs_ArticlesBDFournisseurTaille contains all the...

    Sport200025 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following