SQL Server

Page 1347




  • Topics
    Replies
    Last post
  • How to find duplicate rows in Flat File ?
    by Antony Kumar
    7 Replies
    Last post by Phil Brammer
      • In the FLAT FILE source, I have to find the duplicate rows based on the two fields say, "bill number" & "invoice date". The rows within flat file has like "bill number" which is duplicated on the same "invoice date". If duplicate rows found then move the duplicate rows into another Flat File. If not found then move the rows int
  • AutoNumber in T-SQL Select Statement
    by subhendude
    5 Replies
    Last post by subhendude
      • I want to return a resultset of select statement like this 1 aaa 2 bbb 3 ccc 4 ddd 5 eee This numeric field is not stored in DB but it comes. Just like Oracle SQL RowID pseudo column. What will be the sql query
  • RUN NET START/STOP MSSQLSERVER FROM SSIS PACKAGE
    by Zadoras
    6 Replies
    Last post by jaegd
      • HELLO, I want to create a package which start and stop the SQL server's services... i know i can achive this via NET COMMAND.... but i coudnt find in which task (SSIS) I can place that command .. I also came across that I can achieve this using Execute Process task but for this I have to define executable file.... actually i dont want ne thing outside from my SSIS package CAN I ACHIEVE T
  • Restore DB in SQL server 2005 Express edition
    by ugp
    3 Replies
    Last post by Madhu K Nair
      • i have created a database in MS SQL server 2000. How can i get this DB to MS SQL server 2005 version. i have successfully backup the DB that was in SQL server 2000. how can i restore it in SQl server 2005 express edition
  • data retrival time
    by Rocky729
    3 Replies
    Last post by Tengiz Kharatishvili MSFT
      • How can i speed up the return time from search between 2 different server I am currently using SQL 2000 and SQL 2005 With the same query, the searching time is much faster to select between database within the same server instead of two different one. Is there something that i can do in the server configuration to speed up the searching time Thanks in advance
  • Leading zeros are trimmed automatically
    by BobInIndy
    1 Replies
    Last post by Jens K. Suessmeyer
      • I am reposting this from the VB IDE forum, becaue I received no response Using VS05 SP1 Pro/SQL Express... There are two tables, UserIDs and Recordings (which has a foreign key relating it back to UserIDs). I created a Stored Procedure via Server Explorer that returns the user ID for a given Foreign Key in Recordings table. If the UserID is "0001", then "0001&qu
  • Unexpected BIGINT conversion behavior
    by MichaelT
    12 Replies
    Last post by Matt Masson - MSFT
      • I've recently been struggling with moving a bigint data result from a query into an SSIS variable through the Execute SQL Task. Now, I could just be doing this incorrectly, but I couldn't get it to work at all if I made the variable int64 in SSIS. So here's what I found: 1. bigint from the query into int64 SSIS variable doesn't work at all. It fails. 2. bigint from the query into string
  • 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
  • Database in suspect mode- No Backup Available
    by WADEZIE
    14 Replies
    Last post by WADEZIE
      • Database is in suspect mode and I cant get it out. Customer does not have a backup......... getting Errors starting Analysis of database 'SBM01' (7) is 100% complete (approximately 0 more seconds) ex_raise2: Exception raised, major=79, minor=87, severity=22, attempting to create symptom dump Error: 7987, Severity: 22, State: 1 A possible database consistency prob
  • strange problem while rendering a report
    by Karenros
    6 Replies
    Last post by Karenros
      • I have 2 reports called fundfacts_Full and FundFacts_half and both of them run using the same stored procedure called rpt_FundFacts. When i run the dataset for both the reports i get 19 records and but when it renders the Fundfact_Full report it shows 18 records. Where as in the fundfact_Half it shows 19 records too. Can some pls tell me whats going on and why its acting strange, i havent
  • Multiple OR LIKE conditions in Sproc
    by Chris Via
    1 Replies
    Last post by Arnie Rowland
      • I have a ListBox controls that contains about 5 items. A stored procedure is executed based on selections of other controls ont he screen, but I cann't figure out how to properly get the dynamically selected conditions passed to the sproc from C#. If a user selects 3 of the five items, the sproc needs to build something like this: WHERE Region LIKE Item1 OR Region LIKE Item2 OR Regio
  • Language setting of Management Studio
    by Ricky Wang
    2 Replies
    Last post by Ricky Wang
      • After I install SQL Server 2005, the default language of the interface of Management Studio is Chinese-Traditional. How do I switch to English Thanks for any reply
  • Database Activity Monitoring. Any tool known tool for Ms SQL Server 2005 or 2000?
    by LeanCino
    4 Replies
    Last post by LeanCino
      • Hi all, Does anyone knows if exists any tool (from microsoft or other vendor) that allows us to monitor all the activity that is generated in SQL server I mean Network appliances or servers that monitor database activity and log activity that is external to the database server, and can generate alerts based on unusual behavior or policy violations. Often rely on a local agent to monitor act
  • ISNULL() with performance
    by Hi Its Me
    3 Replies
    Last post by richbrownesq
      • isnull(startweight) = case startWeight when NULL then 0 else startWeight end I have read some where that using function on column while selecting a bunch of data makes the query slower because the function needs to work on each row of the table.. SO I was just thinking like is the value of above 2 would be same perfrmance wise and value wise Which o
  • Comparing strings in MDX
    by Sean ORegan
    4 Replies
    Last post by Sean ORegan
      • Hello gurus, Is there an equivalent to the TSQL LIKE '%mystring%' function in MDX e.g. to filter a Product dimension to only those products containing 'IPOD' or whatever Thanks
  • Issue with Logging using SQL Server
    by Thiago Guimarães
    7 Replies
    Last post by Boris Livshits
      • Hi All, I'm trying to implement the SQL Server logging in my package but Im receiving a very weird error message. Follow below: "Error at Consumer_Common_Transportation [Log provider "SSIS log provider for SQL Server"]: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Descri
  • Exporting SQL Server data to Excel errors
    by lslmustang
    9 Replies
    Last post by desibull
      • I thought this should be easy... but, so far it has not been. I want to export data from SQL Server using a query to an Excel spreadsheet. I'm using SQL Server ODBC for the source connection and a Connection To Excel as my destination source. The spreadsheet exists and has the first row with column names. My mappings and query work fine. I don't have any warnings before trying to execute. BUT it w
  • Perfomance Issue
    by Shipin Anand
    14 Replies
    Last post by Chris Howarth
      • ;with cte as ( select rank() over (partition by username order by guid ) as rank from MyTable where siteurl='myurl' and VisitedDateTime between '2007.02.05' and '2007.09.30' and IsFiltered=0 group by username,guid ) select count(rank) from cte where rank=2 this query is taking 6 seconds to execute .. 'MyTable' table is properly indexed.. 1 million rows are returned by common t
  • Creating a Database from multiple databases accross multiple servers
    by TomFrancis
    7 Replies
    Last post by oj
      • Hi, I'm trying to create a database that takes specific information from a number of databases on different servers to make some reporting that we have much easier. I'm pretty new to SQL so I'm not sure of the best way to proceed. I read an article that suggested I use the OPENROWSET command. The problem is, the version of SQL that came with one of the programmes we use is limited an
  • Passing Parameter to another Report using Jump to URL option in Reporting Services 2005
    by rupamp
    14 Replies
    Last post by Adam Tappis - IMGroup
      • Hi, I tried to pass parameter from one report to another report. I can send the parameter using following option: I used jump to url option and write the following expression: ="javascript:void(window.open('http://hpsi-dev/Reports/Pages/Report.aspx ItemPath=%2fNextGen+Reports%2fMAUA%2fSales+Order+Detail&rs:Command=Render&SalesOrderNumber="+Fields!SalesOrderNumber
  • want to block all other db activity while my archive process is running...
    by db042188
    2 Replies
    Last post by Arnie Rowland
      • i'd like to block all other processes that interact with my database while my archive process is running on that database. Can this be done
  • Schema changes when DROPS are necessary
    by SQLScott
    4 Replies
    Last post by Hilary Cotter
      • We have a database that we are preparing to set up Merge replication on. We often make schema changes via T-SQL, many of these changes are made to tables on which an ALTER TABLE statement will not do (rather the creation of a temporary table, copying of the data, deleting the original table then renaming the temp table). My question is how this will affect Merge replication. I have not been
  • Batch updates with SQL CLR
    by Graham Bull
    1 Replies
    Last post by Mark Giesen
      • Unfortunately batch updates (i.e. setting SqlDataAdapter.UpdateBatchSize to >1) are not possible with ADO.NET using a context connection. Does anyone know why it's not possible Will it be implemented or allowed in a future version of .NET Here's what I'm currently doing: I have a C# stored procedure, using a context connection, that updates all the records in a table (typically a million recor
  • Derived Column can't add 8-byte integers
    by MichaelT
    5 Replies
    Last post by MichaelT
      • I'm having trouble adding a 4-byte integer with an 8-byte integer. Here's what I'm doing: Column Name: BIG_ID Derived Column: < add as new column > Expression: (DT_I8)[ID] + 840230000538058 Data Type: eight-byte signed integer {DT_I8] The error I get: The literal 840230000538058 is too large to fit into type DT_I4. The magnitude of the literal overflows the
  • Endless running package using a proxy
    by Norbert.Bender
    1 Replies
    Last post by Norbert.Bender
      • I have a package which runs fine, when I execute it with my account (e.g. double-click on the .dtsx file and run it). Now I would like to establish a job, which starts the package. I created first a credential for my Account (which is a domain administrator account also for the box, where SQL Server is running on), then I defined a proxy to this credential. In the job definition I changed th