SQL Server

Page 2614




  • Topics
    Replies
    Last post
  • Communiation Link Failure
    by DStevic
    2 Replies
    Last post by wesd
      • I haev an ssis package that copies mulitpple tables from one sever to another. Halfway thru one of the table copies i get: [OLE DB Source [1]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available
  • Log all performed SQL Statements
    by TheSentinel85
    10 Replies
    Last post by TheSentinel85
      • Hi there, I have a little problem concerning the replication of a SQL Server database. The situation is as follows: We have an application and a SQL server database running at location A. We now want to have a copy at a Location B of the application and the database. Location B does not need to change anything in the program or the database - it's all just read. The two locations are
  • User Specific Report
    by km6589
    2 Replies
    Last post by km6589
      • Greetings all My question is I want to be able to create a report specific to each individual user. More specifically I want to be able to create one report and once the user logs in with the appropriate credentials, I want the report to populate based on those credentials. Another important aspect is that each individual only sees their data. So once again I need to report to populate from the
  • Why can't I find the SSIS package?
    by nhsnick
    3 Replies
    Last post by nhsnick
      • Sorry to ask such a basic question on this forum. I have installed SQL Server 2005 and the SSIS service is running. However I cannot find the package to use it. I am evaluating SQL Server 2005 so I currently have a trial copy - is this the problem I want to recommend a purchase but I do not want to end up with the same issue with the organisation having bought a copy.
  • Could not find server 'drop procedure dbo' in sysservers
    by pujitha
    4 Replies
    Last post by pujitha
      • I have SQL SERVER 2005 with SP2 on windows XP professional. When I execute DROP PROCEDURE manually,it works. However when I execute inside a loop made using static cursors, it generates following error " Could not find server 'drop procedure dbo' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. " OR it gives this error " Could not find stored procedure &quo
  • SQL Server Compact table not getting data edits made in datagrid from vs05 c#
    by John G3
    6 Replies
    Last post by John G3
      • New to SQL Server Compact Edition and I am getting my feet wet with the following tutorial: http://msdn.microsoft.com/msdntv/episode.aspx xml=episodes/en/20060831MobileRB/manifest.xml I follow the tutorial exactly, but the data I edit through the Edit Dialog Form is not saved to the SQL Server table even though all of the edits appear in the datagrid. They never make it back into the table.
  • Different dynamic grouping question
    by QldRobbo1983
    3 Replies
    Last post by QldRobbo1983
      • Hi, I have a basic report that has some transaction info, eg Name Type AAA Buy AAA Buy AAA Sell BBB Buy BBB Buy BBB Buy BBB Sell Etc I want to group all the BBB's together, but I don't want to group ANY others together... Ie, I want to group the transactions together if the name is BBB, else I don't want to group at all. Is this possible
  • promotional mailing response prediction
    by millerfj
    5 Replies
    Last post by Jamie MacLennan
      • I am trying to use the time series algorithm to predict responses to promotion mailings for subscription renewals. The problem i am having is that response is largely influenced by the number of mailings that are sent out. Can anyone give me any ideas on how i can structure the dataset so that it would take into account how many promotions were sent out any help would be greatly appreciated. Fr
  • OLEDB command in SSIS
    by Nirad Pachchigar
    3 Replies
    Last post by jwelch
      • I AM working on DW building and i m using SSIS.I haev problem with data transformation OLEDB command.I have written a query to clean data in OLEDB command box ,but it takes whole lot of time because at a time it slects 6000 rows from the source and put in to destination but i have 300000 rows to process.How can i increase the size.
  • Copy Database Error using SQL SERVER 2005
    by ajliaks
    6 Replies
    Last post by Arnie Rowland
      • Hi guys, I am trying to copy an entire SQL SERVER 2000 Database from the net server called "SERVER" to any place in my laptop called "MOSHE-DELL" in order to run some tests without being connected to the net and the real DB. I am using the "Copy Database" function in Microsoft SQL Server Management Studio, but getting the Error described below: I will appreci
  • complicated sql condition query
    by Waely
    3 Replies
    Last post by oj
      • Hi, hope someone can help or suggest something to help me with the issue. I have a list of projects. this list contains all master (parent) and all subprojects(child). when I click on a project I want to be able to retreive information about that project and it's subprojects. here is my delema. I want my sql query to check if project is master or sub. if master then get all data for this pro
  • Lookup error redirection problem
    by Albert R. de Ruiter
    8 Replies
    Last post by Jamie Thomson
      • Hi, Maybe someone can assist me in solving the following error. I created a facttable with surrogate keys. In the package that processes the fact data a lookup-task is supposed to find the appropriate dimension key. If a certain dimension row is not found, this error is redirected. In this errorflow a stored procedure will add the missing row in the dimensiontable, after which another lookup ta
  • Joining on a pivot table is sluggish
    by jehhynes
    2 Replies
    Last post by jehhynes
      • I am building a table-value UDF that joins a significant-sized pivot table (ends up with 10000 rows) to another significant-size table. The query takes about 3 minutes, and I noticed that the memory allocation for the sqlserver process goes through the roof. I tried selecting the pivot table into a temp table, and joining on that, and it is real fast - about 2 seconds. However, since you
  • One-To-Many Table Relationships Causing Duplicates In Results
    by pbd22
    12 Replies
    Last post by pbd22
      • Hi. I am getting duplicate rows in my SPROC results. I think I know why - I am guessing that there are some one-to-many relationships involved in my joins. I am having problems getting rid of the duplicates. Am I right that GROUP BY on the primary key of the derived table will eliminate the duplicates I am guessing that grouping should happen on the emailAddress column of the Users table but I cou
  • Wht does this give divide by 0 error?
    by ordure
    3 Replies
    Last post by sluggy
      • I am using iif which works just fine in Access to prevent divide by zero errors but this: =iif(Fields!oh_ret.Value<>0,(Fields!oh_ret.Value-Fields!oh_cost.Value)/Fields!oh_ret.Value, "" ) Fails As Does: =iif(Fields!oh_ret.Value=0,"",(Fields!oh_ret.Value-Fields!oh_cost.Value)/Fields!oh_ret.Value ) Why How do I get around this
  • SELECT consecutive dates
    by cgkitab
    5 Replies
    Last post by SNMSDN
      • I have a table called MachineDtl in SQL Server 2000 with the following fields: Date Machine# Value 1/1/06 100001 50 1/8/06 100001 -90 1/9/06 100001 -60 1/10/06 100001 -900 1/1/06 100008 10 1/2/06 100008 12 1/25/06 100008 -1 1/26/06 100008 -1
  • TITLE: DTAEngine Tuning process exited unexpectedly.
    by zacksz
    9 Replies
    Last post by kwillmert
      • I am getting the following error when I try to use the Database Engine Tuning Advisor. TITLE: DTAEngine ------------------------------ Tuning process exited unexpectedly. ------------------------------ BUTTONS: OK ------------------------------ I have a almost identical system is running fine, but this PC I can't seem to get it to work. I have tried a clean un -install
  • Browser not opening in my application
    by Anjana Maganti
    0 Replies
    Last post by Anjana Maganti
      • hi all, in my application i have a 'export to excel ' (exporting dat to excel) facility . but it is working fine in some systems and in some systems it is not opening ..the browser is appearing and closing immediatly.. i observed that it is working absolutly fine in all windows systems and there is problem with other opearatings systems ... i have no clue why is this happening
  • Data Mining Add-Ins doesn't work with non-English regional settings
    by Marco Russo
    10 Replies
    Last post by Tatyana Yakushev
      • I tried Data Mining Add-Ins for Office 2007 - CTP December 2006. Test settings: Windows XP SP2 english with Italian regional settings, Office 2007 english (RTM), SQL Server 2005 Developer (with SP2 CTP Dec06) and Data Mining Add-ins for Office 2007 (CTP Dec06). If I keep regional settings in Italian, I get error like this: Old format or invalid type library. (Exception from HRESULT: 0x800280
  • is there a way to consolidate the WHERE statement line?
    by dvang
    6 Replies
    Last post by TimDBA
      • I have a query where I am pulling claim numbers for 10 clinics. In the WHERE statement line, I have to write the condition 10 times; once for each clinic. Is there a way to shorten or consolidate the code so I can do it faster I'd be willing to throw it into a parameter (and I have, but can't seem to make it accept multiple values and work yet!). Could somone educate me on either way
  • Different logins permission based on field level of filteration
    by hlliew
    0 Replies
    Last post by hlliew
      • Greetings, I am working on a data warehouse project and am using MS Excel - Pivot (MS Query) to connect to SQL Server 2005. I wish to retrieve a same report with different filteration based on a field for different user logins. Any solutions on SQL Server 2005 side to set the permission or something On the other hand, I did try to use stored procedure to do the filtering and it wor
  • SQL Server Migration Assistant from Oracle 8.0.5 to SQL Server 2005
    by Yohanes Bahari
    1 Replies
    Last post by Buck Woody - MSFT
      • Hi my name is Yohanes. Im a newbie in oracle. I am going to migrate my data from Oracle 8.0.5 (old server) to SQL Server 2005 (new server) for my final year project in university. I am using "SQL Server Migration Assistant for ORacle" Tools from Micosoft website. But there is an error message OleDB provider "OraOLEDB.Oracle" for linked server "168.254.1.50" returned
  • Writing to previous table
    by Simone1
    2 Replies
    Last post by richbrownesq
      • Hey guys, I am working with and SQL database and in my code each time a click a button it writes a new record to the database. Behind this button i also want to write code that will write to a field in the previous record. Can anyone help
  • Login failed for user Domainname\computername
    by Santhosh Pallikara
    7 Replies
    Last post by Raul Garcia - MS
      • Hi, I am using SQL Server 2005. The below message is added to the Application Event Viewer frequently. Failure Audit: Login failed for user "abc\xyz$". (Client: xx.xx.xx.xx) abc is my domain name and xyz is my computer name. When I look @ the SQL error logs, I find the following message: Error 18456 Severity 14 state 11 Login failed for user "ab
  • does not violate 2nf
    by xr280xr
    2 Replies
    Last post by pdxJaxon
      • Our DBA has chosen to use an autonumber column as the primary key for a linking table consisting of 2 other IDs, I'll call them x and y. Another developer is concerned that since our application only keeps track of IDs x and y, not the autonumber ID, that searches will be less efficient because if x and y were a composite key they would be indexed. Is this correct If so, couldn't you just create a