SQL Server

Page 2943




  • Topics
    Replies
    Last post
  • exception handling - best practices
    by two_a_day
    4 Replies
    Last post by Arnie Rowland
      • hi all, not sure this is the correct section to post this, but couldn't find a more appropriate one. we are debating on sql exception handling usage and we could'nt have an agreement on whether we should trap constraint exceptions with a try-catch block or check them before executing insert/update/delete statements. one of my collegues insist that constraint exceptions should be c
  • Scheduling an automatic backup
    by thaenu
    14 Replies
    Last post by thaenu
      • Hi , I am using Microsoft SQL Server Management Studio Express 9.00.3042.00. I want to take the database backup daily at specific timing for instance, 8:00am daily. How can I take it automatically It should be take the backup on daily basis without my interference. with programatically Can anyone help me i neeed answer with clear example or screen shots. Thanks in advance
  • Using Integrated Security from .Net Web to access SQL Server 2005
    by jkw
    3 Replies
    Last post by Jens K. Suessmeyer
      • If I am posting to the wrong forum, please point me in the right direction. We have upgraded to SQL Server 2005 and Window 2003 from SQL Server 2000 and Windows 2000, and have been having all kinds of problems with security of our web applications. We have been forced to put the system account of the web server as a user in the database in order for the web applications to work. We have lost th
  • Accessing the underlying sql query from the rdl file
    by ArjayH
    1 Replies
    Last post by ArjayH
      • Our client uses the report builder to generate reports for collection of employees. We would like to use the employee records in this report to perform some additional processing (such as the list of employees gets assigned to a particular group). Programmatically, I can retrieve a byte stream from rs.GetReportDefinition( "\myClientEmpReport") and deserialize the stream into Repor
  • IBM DB2 as Data Source
    by AVNIP
    6 Replies
    Last post by Jan DHondt
      • Hi, I need to connect to a IBM DB2 database as a source in the Data Flow Task. However, I am not able to figure out which is the provider I should be using. It will be great if you can help me with that. Thanks in advance. Regards, B@ns
  • Reporting Services 2005 Subreport issue...
    by nsprice
    13 Replies
    Last post by Mark R. P.
      • I'm new to Reporting Services 2005. I have a sales report that displays monthly sales figures for a sales rep. I have a subreport that displays a single cell with a value that I then need to subtract from my monthly sales figure for an adjusted total. Is there no way to return a value from a subreport I've done this using Crystal Reports before and I've looked for hours on end on the web for a RS
  • SSIS Data Conversion: Convert a String (like yyyymmdd) into Datatype dt_DBDATE or dt_DBDATE
    by ulrikeG
    3 Replies
    Last post by ulrikeG
      • Hi All, I need a solution for the following: I have a field with datatype string, length 8, in the form yyyymmdd (f.e. 20070604). Now I need to transfer this field into a field with datatype dt_DBDATE or DT_DBDATE. I tried to perform this with a derrived column and type cast (DT_DATE) or (DT_DBDATE), but this does not work. Any hint for me!!! Thanks in Adv
  • SQL Compilation and execution plan
    by Chang-Il Kim
    2 Replies
    Last post by Chang-Il Kim
      • Hi all, I¡¯m having a test regarding to the image data type. The test program is written with sql native api and just update the image data type column, but I looked the SQL Compilations/sec and Batch Requests/sec counters in SQLServer: QL Statistics using Perfmon, both values are almost the same. It seemed whenever the stored procedure is called, SQLServer compiles it and makes execution plan agai
  • SQL Reporting Services - Page X of XX counts in header
    by Wendy C.
    28 Replies
    Last post by Wendy C.
      • I have searched high and low for how to calculate page numbering in the header where the global values do not apply. I have a report that generates 300+ invoices and I need the page numbers to reflect page x of xx for that invoice only. My report page breaks for each customer invoice. I have found code to get the page number in the header and I have found code to get the total pages in the
  • Export to Excel
    by mahima
    5 Replies
    Last post by Jarret
      • Hi, When our report exported to Excel, In the Excel file it is giving some extra columns between the data columns.How to avoid those extra columns.This extra columns causes problems when we want to sort one column it is throwing sort can't be applied on merged columns. How to avoid the Extra columns. Thanks in advance
  • ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
    by Bob Hodgman
    2 Replies
    Last post by ts11
      • I've read about this hotfix at http://www.kbalertz.com/Feedback_933097.aspx but I can't find anything on microsoft.com about it. It sounds like a worthwhile hotfix, but I'm wondering about the absence of an announcement on microsoft.com. Anyone else know about this hotfix Thanks!
  • Layout question
    by guyinkalamazoo3
    2 Replies
    Last post by guyinkalamazoo3
      • We have a report that is printed landscape and contains a main table with values. Inside this table we also want to create a "sub-report" table based on two other criteria (charges and credits), but this data is still grouped with the main table. Here is a simple schematic of the report XXXXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXX Charges
  • Flat File Data Source with variable number of delimited columns
    by Greg Ritter
    1 Replies
    Last post by Phil Brammer
      • I am writing a package that will process delimited flat files that will come in one of a few different versions. Within each flat file, the number of delimited columns will be the same, but each version of the file has a different number of columns. I have tried configuring the flat file data source to expect the version with the largest number of columns, but it will then throw away rows that hav
  • Stuck on a Inner Query
    by BH1234
    4 Replies
    Last post by DaleJ
      • Please help, I want to do a select query selecting the ID (from table 1) for where the person is under 18 and if there has been an episode (table 2) done on the person in the last 12 months (ie. Start date). The problem I¡¯m having is that there may be more than one episode that has been done. I think I need a query something like this Select t1.id from table1 t1 Where Exists
  • help with WHERE clause
    by kenniejaydavis
    2 Replies
    Last post by kenniejaydavis
      • I have a situation where I want to be able to match an exact string value and if that is unsuccessful then match all strings like the search parameter. The scenario I'm working on right now is searching for users by username. An example for simplicities sake is if I have the user "admin" and "administrator" in a database, if I search for "admin", I only want th
  • SQL in OLE DB
    by Jim Work
    4 Replies
    Last post by Jim Work
      • Hey all! Okay, this may not be the right forum, but I *think* it's an SSIS Question. If it belongs elsewhere, point the way and I'll repost it correctly. I'm importing a flat file, and then I want to check to see if a column of the input matches a column of a reference table. INSERT INTO BATCH CASE WHEN IN-REC-TYPE == BATCH.REC-TYPE THEN (REC-TYPE, CYMD) VALUES (IN-REC-TYPE, IN-CYMD
  • Unused Connection Managers
    by alpha0mega
    6 Replies
    Last post by alpha0mega
      • Hi, I am unsure if i am managing my connections in the correct way... but as it stands we have them in a .dtsConfig file that each package references in order to get the relevant details.. This is working fine, except that in total our ETL project uses 6 different connections, and none of the packages utilise all 6. This leads to an error message upon opening up EVERY packa
  • Please help me SSIS...
    by Devender Naik
    14 Replies
    Last post by dev15`4534345677
      • Hello everyone, I have a very little experience in SSIS bit a good experience in DTS. Now i am working for a solution to implement. If you can let me know a feasible solution and the steps for the following task. The task is as follows: 1. Have a Log Table where all the transactions are stored from various tables. 2. This table has the table name, the primary Key feild name and the rowid,
  • How to debug database engine stored procedures on SQL Server 2005?
    by UncleSam89
    2 Replies
    Last post by Jens K. Suessmeyer
      • 1). When you right click stored procedure in the Query Analyzer on 2000 you can select debug from the list of menues. I can't find this functionality in the SQL Server Management studio. 2). By the way I also can't find where went the output of my print statement. 3). Does server cursor functionality is still working in 2k5
  • using uniqueidentifier datatype
    by Maju V Poulose
    4 Replies
    Last post by Maju V Poulose
      • Hai, Because uniqueidetifier is not an auto generated field, How can be it used with a primary key column Thanks Maju
  • Error 18210 Backup up SQL Server 2005 Database to network drive
    by churchwell
    4 Replies
    Last post by Jens K. Suessmeyer
      • I have 2 different servers that run nightly backup jobs to a network drive using the UNC format. I am noticing the larger databases encountering the following errors on a regular basis Error: 18210, Severity: 16, State: 1. '\\fnfssql3\SQLBackups\MNSQL05\<database>.BAK'. Operating system error 64(The specified network name is no longer available.). BACKUP failed to complete the
  • Adding records
    by madskunk
    6 Replies
    Last post by madskunk
      • Hello guys, I hope someone can help me! I have a (probably simple) problem with compact edition, I can't seem to add records using VB 6.0. Here's some sample code I've been testing with: Dim pConn As ADODB.Connection Dim pRS As ADODB.Recordset Set pConn = New ADODB.Connection Set pRS = New ADODB.Recordset pConn.ConnectionString = "PROVIDER=Microsoft.SQLSERVER.MOBILE
  • Value of next record
    by Vander Eduardo
    4 Replies
    Last post by Shyam Sundar
      • How can I take the value of the next record in my report Thanks, Vander
  • Date filter in MDX
    by Galin Iliev
    4 Replies
    Last post by Galin Iliev
      • Hi guys, I have a cube where I want to make filter based on date range. I've created a cube with appropriate measures and I have Dimension with date field ( I want to filter on that field). I've found two solutions: FILTER([Reservation Search Log].[Reservation Search Log].ALLMEMBERS, CDate([Reservation Search Log].[Reservation Search Log].Properties( "Simple Insert Date" ))>= "2/
  • ADO:Dispaly Limited Records
    by vaibhavsaxena17
    2 Replies
    Last post by vaibhavsaxena17
      • Hi all; qrymillcgetbytype_app ( stored query in MS-Access) in my code : MS-ACCESS Part: query defination PARAMETERS prmMillToolType Long; SELECT MILLC.ID, MILLC.InsMillBdyID AS [Tool ID], MILLC.SubType, MILLC.Radius AS [End Radius], MILLC.CuttingDia AS [Tool Dia], MILLC.EffAxlCutLen AS [Effec Cut Length], MILLC.OverallLen AS [Overall Length], MILLC.HandOfCut AS [Hand Of Cut], MILLC.NoOfFlute