SQL Server

Page 2222




  • Topics
    Replies
    Last post
  • Not able to render the report
    by MannuBhai
    2 Replies
    Last post by MannuBhai
      • Hello All, I have a report which throwing this error: Cannot read the next data row for the data set ALERTSBYSERVERS. (rsErrorReadingNextDataRow) Get Online Help Arithmetic overflow error converting expression to data type datetime This report can be viewed on the Visual Studio, but is not rendering it on the Reporting console. Any ideas Mannu.
  • date format, select convert(varchar(8), getdate(), 1)
    by daniel ku
    7 Replies
    Last post by rusag2
      • With this clause "select convert ( varchar (16 ), getdate (), 101 )" I can get mmddyyyy but How can I get time such as mmddyyyyhhmm Thanks Daniel
  • Format Parameter Error
    by aichoo
    1 Replies
    Last post by Brian Welcker - MS
      • Hi all, i am a newbie to reporting services. Hope someone can help me with this date problem. I have a parameter date which i declared as type string in the report manager. when i entered the date as eg) "31/12/2003" and clicked on the 'preview' tab in the report manager, it gives me error saying that 'Cast from string "31/12/2003" to type 'Date' is not valid.' So i use t
  • processing cube with partitions
    by cherriesh
    7 Replies
    Last post by Darren Gosbell
      • Hi, I have a cube with 2 partitions. Are these 2 partitions being processed everytime I have a ProcessData and Process Index Coz i worry that if it's just processing 1 partition every time, i might have new data in one extraction that should reside in Partition 1 and another set of data (also in the same extraction) that reside on Partition 2. cherriesh
  • How can i create a Pipe-Delimited export option?
    by codemonkey001
    5 Replies
    Last post by codemonkey001
      • i've read that it's possible and this is what i entered in my rsreportserver.config file. <Extension Name="PIPE" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/> <OVerrideNames> <Name Language="en-US">PIPE Delimited CSV</Name> </OverrideNames> <C
  • third party components for SSIS?
    by Cosmin Ioan
    1 Replies
    Last post by jwelch
      • hello all -- I'm an SSIS newbie who is exploring (custom) programming functionality through third party components, to be plugged into SSIS, for SMTP, FTP, PGP, TAR, WinZIP, basically for a scheduling & automation utility. Is there such a concept of third party components (and marketplace for this ) or is VB a much better choice for this vis-a-vis components variety, $$ and robustness
  • Same error with different Interface
    by Nicholas Buse
    14 Replies
    Last post by John Childress
      • I have just installed the released VS2005 as well as the released SQL2005.  When ever I try to browse my SQL Server with either the Object Explorer in MS SQL Server Management Studio or the Server Explorer in VS2005 I get the following error: Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.VisualStudio.OLE.Interop.IServiceProvider'. This operation failed be
  • Transactional Replication with additional columns in destination Table
    by sknsphr
    5 Replies
    Last post by sknsphr
      • In Transactional Replication -while Publisher, Distributer & Subscriber are on same instance- can I have additional columns in destination Table & set "Action if name is in use" for related Article to "Keep existing object unchanged" I do this but even Snapshot is not transfered to destination table!!
  • endpoints
    by rocky_don
    3 Replies
    Last post by rocky_don
      • I am trying to find info / examples of how to send information to a webservice using sql server is that at all possible.
  • domain user belonging to multiple windows group
    by LK
    3 Replies
    Last post by Raul Garcia - MS
      • If I have a domain user DOMAIN\user1 who belongs to multiple window groups say DOMAIN\LookupConfigUsers and DOMAIN\AuditConfigUsers. In sqlserver, I would create two logins - DOMAIN\LookupConfigUsers and DOMAIN\AuditConfigUsers and matching users in the database. Then I grant LookupConfig role to the LookupConfigUsers user and AuditConfig role to the AuditConfigUsers user in the database. When DOM
  • error message says WkUFind cannot open because MSVCR70.dll is not found
    by tanya111
    3 Replies
    Last post by JohnnieT
      • how do I load this file
  • Cannot save server properties on Case Sensitive instances
    by Jordi Rambla
    1 Replies
    Last post by maksymov
      • Hi all, I've filled this suspect bug to Connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=282812 The issue is: I'm unable to save any change to server properties if instance is set to Case Sensitive collation . The process returns an error like (translated from Spanish, so not exact message): "Error in metadata manager. Log file
  • Query Error
    by lk_wick
    2 Replies
    Last post by lk_wick
      • i cant run the following query on the reporting(2005) surface . but it is perfectly running on the 2005 sql environment. can some one correct it select {[Date¡ªVEPLock].[VEP Lock].members as status} on rows, {[Measures].[Amount Usd]} on columns from Profitability where [Date¡ªFiscal].[Year].[2005].[Quarter 4].lastchild:[Date¡ªFiscal].[Year].[2006].[Quarter 4].lastchild Error: measure hierarch
  • Installing SP2 directly over SQL Server 2005 without sp1
    by mrleokarthik
    2 Replies
    Last post by Satya SKJ
      • Hello, 1. Can we directly install sp2 without SP1 - for sql server 2005. 2 . Iam basically dotnet developer. iam using sql server 2005 both developer and express editions. Do i need to stop sql server service before installing sp2. During sp1 installation, it seems some file are locked and when it prompt, i stopped service and continued installation. 3. Moreover Sql server 2005 expre
  • Package with WinZip hangs
    by ChrisCo
    9 Replies
    Last post by ChrisCo
      • Dear Folks, I have a package that calls winzip to extract files(command line usage) in an Execute Process task. The package runs fine if I am logged in to the server. It hangs on the winzip task otherwise. The package is stored on the server (as opposed to the file system) & is run under a proxy account using the SQL Server Agent. I tried adding folder and WinZip32.exe permissions for the doma
  • How to retrieve most recent file from local directory?
    by sadie519590
    11 Replies
    Last post by jwelch
      • Hi, Here's my situation. Every day I will be downloading extracts to a folder. The extracts are named: 20070529.Extract1.csv 20070528.Extract1.csv 20070527.Extract1.csv 20070529.Extract2.csv 20070528.Extract2.csv 20070527.Extract2.csv So, on any given day, I will want to find the most recent versions of Extract1 and Extract2, for example: 20070529.Extract1.cs
  • Default Date in Query Designer
    by edy80y
    2 Replies
    Last post by Arnie Rowland
      • Hi, My database has just recentrly been upgraded to SQL 2005 and i have noticed a change in the interface when writing a query in "Query Designer" For one of our tables we have a 'Time' field. I know that time only doesnt exist yet and upon insertion a default date of 30/12/1899 is automatically inserted. Im happy with that! My concern is with Query Designer. If i bu
  • Setting up the hard disks
    by jason7655
    1 Replies
    Last post by Arnie Rowland
      • I have a new server. It was shipped with a 76 gig drive setup in RAID 1 (2 disk) and a 400 gig drive setup in RAID 5 (4 disk). I would like to determine what is the best way to setup up the partitions. What size and what should be placed on each. Like the C: Drive...Should I just put Windows on there and nothing else Do I stand to gain something from not using part of that 76
  • CREATE SCHEMA fails Inside an If Block
    by sbogollu
    5 Replies
    Last post by sbogollu
      • Hello All, The below "CREATE SCHEMA" sql statement fails if it is inside an IF block. It runs fine if i run it without the IF block... --------------------------------------------------------------------- IF NOT EXISTS ( SELECT * FROM sys.schemas WHERE name = N 'Customer' ) BEGIN CREATE SCHEMA Customer AUTHORIZATION [sys] END ------------
  • Create View errors in SQL 2005
    by DianeDavis
    4 Replies
    Last post by Arnie Rowland
      • We have a script that drops the views on all the database tables and then creates them as part of version update of the database. For instance: if exists ( select * from dbo . sysobjects where id = object_id ( N '[dbo].[SPONSOR_SYSTEM_TD]' ) and OBJECTPROPERTY ( id , N 'IsView' ) = 1 ) drop view [dbo] . [SPONSOR_SYSTEM_TD] GO CREATE VIEW dbo . SPONSOR_SYSTEM_TD AS SELECT sp
  • SQL 2005 Developer edition fails during installation
    by Amir5656
    14 Replies
    Last post by Quesi Jay
      • When trying to install SQL 2005, I keep getting the foll. error: Error 1706. Setup cannot find the required files. Check your connection to the network or CD-Rom drive. For other potential soltions to this problem, see C:\Program ....\1033\setup.chm I have tried using two different DVDs, and also downloaded SQL 2005 from msdn, but none of them work. Can some please help. Thanks, Ami
  • Looking for table / view that will tell me if I need to reinitialize subscription
    by Bill - Developer SC
    7 Replies
    Last post by Greg Y
      • I have kind of unique situation. I am running Merge replication. In one of my publications I am only publishing procedures/functions/views. By design, these do not change that often, but when a programmability object changes, it is scripted in a way so that: 1. The article is dropped from the publication 2. the object is then changed 3. The article is added back to the publication M
  • Help with retrieving string data
    by AnonymousAswell
    4 Replies
    Last post by Sankar Reddy
      • Hello, I am trying to retrieve only the first few characters (12 to be precise) from this string that is coming in from FoxPro to SQL Server 2005 and I am coding in C#. I have tried these methods (after reading it in a book, as I am new to this) but it still gives me an error saying that the field cannot exceed 12 characters. autoClaimSalvage.Phone = "Select LEFT ('&quo
  • Export to Excel
    by DevDiver
    3 Replies
    Last post by Mahasweta Das
      • Hi, I have several similar reports all with a table with more or less columns depending on the report it self. On one report I made the table rows with a bigger Height( because I have a small column with big data where I need to wrap) It works OK on the Preview (Designer) it works OK on the reports Web Page (ReportManager) . it works OK when I export to PDF When I exp
  • Concatenation issue?
    by sooks
    9 Replies
    Last post by hunchback
      • I have a table called long_text that stores long descriptions used for different projects. It contains fields key1-8, (key1, key2 etc) whcih key1 is used to seperate and organize different descriptions and key2 is the primary key which holds the unique ID of the projects. Then there is 2 more fields one called line_number and one called line_text. line_text holds the actual descriptions and line_