SQL Server

Page 2123




  • Topics
    Replies
    Last post
  • Complex Math functions
    by Pikker1981
    6 Replies
    Last post by Pikker1981
      • Hi there friends, Can any of you please advice me as to how I am going to accomplish certain mathematical functions on numbers such as working out the n-th root of a number since the mathematical functions built in don't go past the square root (2nd root) Regards <!--[if !msEquation]--> <!--[if !vml]--> <![endif]--><!--[if !vml]--><!--[endif]--> <!--[endif]-->
  • Create a new user
    by Poorani
    3 Replies
    Last post by Poorani
      • hi im unable to create a new sql server authentication login It is appreciated if anyone helps me thanks in advance
  • Joining tables and entries in one to permute with number of categories in other
    by Magikk
    8 Replies
    Last post by Magikk
      • I have a table of raw data that I can sort by say Division and Category. I have 11 Divisions and 4 Categories but this might not be reflected by the data in the table because there might be no entires for every combination. However I want to generate output that presents all sets of Divisions grouped by Category, that is 11 entries for Category1, 11 for Category2, and so on. Right now I'm using a
  • a question about using reportviewer(remote) to display the reports in reporting server
    by QiSheng
    0 Replies
    Last post by QiSheng
      • when I try to use reportviewer(remote) to display some reports in reporting service,I do it as the following steps:(the effect I need is when an item,for example a hypelink item, in the report "A" displayed in a reportviewer in web page "reportA.aspx"  is clicked, a new page "reportB.aspx" displays another reportviewer showing a new report "B" 
  • SSIS Inner Join Problem
    by RickGaribay.NET
    11 Replies
    Last post by kenambrose
      • I have a Merge Join transofrmation that takes as input Table1 and Table2, which are each OLEDB Sources. Both tables have IsSorted set to true and the join key set to position 1. Table1 contains 242 rows. Table2 contains 61 rows. I connect Table1 and Table2 to my Merge Join Transformation, and slect the join key. For some reason, during transformation, the join is messed up because i
  • Incremental Update
    by Colin Macguire
    10 Replies
    Last post by Colin Macguire
      • Good afternoon, I was wondering if someone could help. I'm busy researching into SSAS's capabilities, specifically Incremental Updates, however this would be the first time I'm working on SSAS, so I don't know where to begin. I've read through the BOL July 2006, and it explains that you have to enable this option; however to me it's not very clear. I followed the steps outlined in the Book;
  • Data import from oracle to sql server 2000
    by Li556035
    3 Replies
    Last post by Arnie Rowland
      • Hi I am using sql import/export wizard in server 2000 to import data from oracle. I got an following error when I try to copy a table cross to existing table in sql server with existing data: Can not insert duplicate key row in object TABLE_NAME with unique index TABLE_NAME_I Does import funtion in sql server 2000 not allow to overwrite the data If it does, how to configure it
  • Error retrieving reports
    by venkatcali
    4 Replies
    Last post by GregSQL
      • I have a report serve at http://MyServer/reportserver My Asp .net web application is running on anothere machine http://WebappMachine/default.aspx . Here is what is happening 1.My Report server admin created a folder <<MyName>> and gave me user name and password to acess it . 2.I connect through url http://Servername/reportserver . server prompts me for Username and password . Wh
  • Trouble creating Maintenance Plan
    by GaryReno
    4 Replies
    Last post by Satya SKJ
      • I have MS SQL Server Mgt Studio Express installed, and want to create a maintenance plan for backup, reindexing, etc. However, right clicking on Maintenance Plan gives me (only) a refresh option - no new, create, edit or any other option to create the maint plan. Help - doing manual backups, etc is a pain. Gary
  • SQLECResultSet
    by van_03
    2 Replies
    Last post by Ilya Tumanov
      • Hi I am using SqlCeResult and i want to give paging on that and read in help that you can do paging on ResultSet so . I need code example so that i can understand how to implement this in resultSet. Thanks & Regards Vishal
  • Index behaviour.
    by DBLearner
    4 Replies
    Last post by pons68
      • Hi all, I have a non clustered index IDX_Col1234 on Col1,Col2,Col3,col4. Which of the following Query would benefit from the above mentioned index Query 1: ======= SELECT Col1, Col2 , Col3, Col4, Col5 FROM TABLE WHERE Col5 = @Val Query 2: ======= SELECT Col1, Col2 , Col3, Col4, Col5 FROM TABLE WHERE Col1 = @val1 AND Col2 = @val2 AND Col3 = @val3 AND Col4 = @val4 Query 3: =
  • Fail to install SQL Server 2005 (Clustering): SQL Server setup was unable add user
    by SilverHeaven
    6 Replies
    Last post by SilverHeaven
      • Hello all, I have tried to install SQL Server 2005 Standard edition with CLUSTERING. I faced a problem and everything rolls back. TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup was unable add user domain1\xyz to local group domain1\IT Security Admin-Group. For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdNa
  • BIDS interface question
    by sadie519590
    1 Replies
    Last post by Rafael Salas
      • Hi, When I open a project in BIDS, for some reason it automatically opens a new tab for each and every package in the project, which is both time consuming and a bit annoying. I don't want to open a tab for a package unless I do it myself. Is there a way to turn off this behavior Thanks
  • [DBNETLIB][ConnectionWrite (send()).] General network error. Occurs when SQL times out on new Windows 2003 sp2 server
    by garrytman
    14 Replies
    Last post by mitre
      • We just replaced an older Windows 2000 sp4 server with a new Window 2003 Standard Edition sp2 server to run our batch processing. We noticed that when the SQL command times out we now get the following error in the ADO command object error collection. [DBNETLIB][ConnectionWrite (send()).] General network error. Check you network documentation. Native Error: 11 SQL State: HY018
  • 2nd lowest with tie
    by mermaid19401
    7 Replies
    Last post by mermaid19401
      • I am working with 3 tables: STUDENTS, GRADES, COURSES Students GRADES COURSES Jean 88 Algebra I Rachel 55 Chemistry Charlie 75 History Bud 90
  • How to Extended Stopred Procedure??
    by Chirag Laxman Patel
    2 Replies
    Last post by Chirag Laxman Patel
      • Hello All, i having one DLL which return Keywords. i want to use that DLL in SQL Server Stored Proc. as i know it is possible through Extended Stored Proc. how to create that how i can pass Text Stream as input to that DLL in Extended Stored Procedure.
  • Running SQL 2000 and SQL 2005 simultaneously
    by Randall Schiestel
    1 Replies
    Last post by Jens K. Suessmeyer
      • I have seen information on the web about running two versions of SQL at the same time on the same server but was wondering any tricks of the trade regarding it. The main recommendation that I have seen is to have SQL 2000 SP4 running first as the default instance (which is my current situation on a development server) and then install SQL 2005 as a named instance on it. Should the SQL 2005 install
  • Access project connecting to SQL 2005
    by curt760
    7 Replies
    Last post by Anonymous
      • Most of our users are using MS Access project to work with our data in SQL Server 2005. The problem we have is that in order for them to access the tables they need to be given db_datareader and db_datawriter permission on the database. Our goal is not to give access to the tables themselves but to views. Therefore, we've created several views and placed them into a particular schema. Now we want
  • How do you store results from a system stored proce?
    by Louie Menard
    2 Replies
    Last post by Dinakar
      • Does anyone know how to store the results from a system stored procedure Both of the samples below don't work. Any suggestions SELECT * INTO tbl_My_Table FROM sp_Any_General_MS_Stored_Procedure SELECT * INTO tbl_My_Table FROM EXEC(sp_Any_General_MS_Stored_Procedure)
  • DTS: migrating many, multiple, new databases regularly
    by N402271
    6 Replies
    Last post by N
      • I am looking for some advice on best ways to use DTS between our various test database servers. I need to test an application against MS SQL Server 2000/2005 and Oracle 9i/10g. This includes creating new databases,logins etc on each server. And also means I need to recreate all my test data again at least twice; on Oracle and MS SQL Server(i.e I can backup and restore my databases between MS SQL a
  • Replication Sync on Windows Vista
    by Brian.Webb
    0 Replies
    Last post by Brian.Webb
      • On windows XP there is a Synchronize program in Accessories. When I run our replication scripts on a SQL Server Express on the XP machine and start the Synchronize program there are items there that allow me to replicate as well as set a schedule, etc. On Windows Vista there is a Sync Center, but replication doesn't show up here. I've searched high and low on Google and am not coming up
  • Storing comma separated values in a single column of a table
    by Subba Rao V
    8 Replies
    Last post by Arnie Rowland
      • Hi, I have a table called geofence . It has a primary key geofence_id . Each geofence consists of a set of latitudes and latitudes. So I defined two columns latitude and longitude and their type is varchar. I want to store all latitude/longitude values as a comma separated values in latitude/longitude columns So in general how do people implement these types of requirements in relational database
  • OLE DB drivers and Vista 64 bit
    by JohnSLG
    4 Replies
    Last post by JohnSLG
      • I am trying to load a Fox Pro file which I used to be able to load before I installed 64 bit Vista. I'm using ver 9 of the fox pro driver. I don't know if it's a driver problem or something else I am doing wrong. Here's the error msg: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE D
  • Problem with debugging SSIS 2005 (32bit) component under Windows Vista ultimate
    by vbRimas
    5 Replies
    Last post by Michael Entin - MSFT
      • Hi, I have a problem when i want to debug an ssis component under visual studio 2005. I'm using sql 2005 with service pack 2 and i have already install patch for visual studio under vista. When i put a breakpoint for exemple in the method " public override void PreExecute() " or in the other method. " public override void ProcessInput( int inputID, PipelineB
  • Weird problem with cube browsing
    by Helen999888
    6 Replies
    Last post by Helen999888
      • Hi, all, I have encountered a very weird problem again which does not display all memebers of the attribute hierarchy E.g. Under the attribute hierarchy, I can see all of its memembers, but when I drag this attribute hierarchy to the column(row) field of the cube browser, only a few of its members are diaplayed (E.g, year with members of many different year members, but only 3 year members are