SQL Server

Page 1977




  • Topics
    Replies
    Last post
  • Circular Reference?
    by Binh Cao
    5 Replies
    Last post by Binh Cao
      • I get this error when I ran the below statement what did I do wrong "The definition of MonthRange set contains a circular reference" WITH SET [MonthRange] AS { [Dim Originationasofmm].[Dim Originationasofmm].&[200101].PrevMember : [Dim Originationasofmm].[Dim Originationasofmm].&[200101].NextMember } SELECT {[Measures].[Closing Balance]} on 0,
  • Unable to retrieve data from a source CSV file that contains embedded text qualifiers
    by Subhash Subramanyam
    3 Replies
    Last post by Subhash
      • Hi Mates, I am unable to fetch data from Source which is CSV file whose sample contents are given below: ----------------------------------------------------------------------------------------------------------- "Fiscal year";"Posting period";"Company Code";"Functional area";"Profit Center";"Business area";"Group Account&qu
  • SharePoint Add In Install Problem
    by atulmistry
    5 Replies
    Last post by bghmin
      • I upgraded my SQL Server Enterprise 2005 instance to SP2 CTP. I also have sharepoint server 2007 b2tr running on same machine. The portal is running fine off port 80, and Reporting Services is running fine off poer 8080. I configured reporting services with in Sharepoint Integrated mode, using the report services config utility. I downloaded sql server 2005 reporting services addin for sh
  • DTS : Format Problem !
    by RajaGanapathy
    2 Replies
    Last post by RajaGanapathy
      • I have a statement in the DTS ( Activex Script ) like this : TomorrowDate = Format$(Now, "yyyy-mm-dd") When i am running the package, i am getting the following error : --------------------------- ActiveX Script Task: undefined --------------------------- Error Code: 0 Error Source= Microsoft VBScript compilation error Error Description: Invalid character E
  • Issues with removing replication
    by itznfb
    14 Replies
    Last post by itznfb
      • SQL Server 2005 Standard replicating to an identical server. My issue: When we go into the database to remove a large number of rows, it says we are unable to delete since the database is in replication. Is there a way to pause, or stop replication temporarily I stopped the log reader but it still gave me the same error. The only way I have found around this is to delete the publication and re-cre
  • SQLFetch and SQL_NO_DATA
    by jimmy shin
    2 Replies
    Last post by Jivko Dobrev - MSFT
      • hi all~ struct user { unsigned int uid; unsigned int auth; }; int funct(int idx) { struct user usr; SQLINTEGER ret[2]; SQLBindCol(hStmt, 1, SQL_C_ULONG, &usr.uid, 0, &ret[0]); SQLBindCol(hStmt, 2, SQL_C_ULONG, &usr.auth, 0, &ret[1]); if(SQLExecDirect(hStmt, (SQLCHAR*)"select uid,auth from my_tbl where idx=12", SQL_NTS) != SQL_SUCCESS) return -1; if(SQLFetch(hStmt
  • Multiple Where Clause on One Report
    by Convince70
    2 Replies
    Last post by Convince70
      • Hello People, Please help. I have a basic report with a parameter in the 'Where" clause called (@Stat) from the statement below: " WHERE contractinfo.termdate >= GETDATE() AND provider.status= 'Active' AND provider.credentialstatus = (@Stat)" This variable has one of two values: 'A' or 'B' that the user selects, how do I set it up so that if user selects say 'A
  • Differencies in triggers behavior on 2000 and 2005 SQL Servers
    by Sestrin
    5 Replies
    Last post by Satya SKJ
      • This code works fine on MS SQL 2000 but fails on MS SQL 2005: create database tt go --exec dbo . sp_dbcmptlevel @dbname = N'tt' , @new_cmptlevel = 80 go use tt go create table t (id int ) go create proc p as update t set id=id go create trigger t1_i on t instead of update as update t set id=id go create trigger t1 on t for update as if @@nestlevel >
  • MDX Fact Count throught a intermediate dimension
    by Boulton Cédric
    7 Replies
    Last post by Deepak Puri
      • Hi I have 2 fact tables -Action -Intervention Action is linked to 2 dimensions - Action Type - Customer Intervention is linked to 1 dimension - Customer I want to have a pivot table like this ActionCount | InterventionCount ----------------------------------------------------------------------------- ActionType1
  • CPackage::LoadFromXML Failure
    by LKHall
    9 Replies
    Last post by Steve Wang 2006
      • My current package and all backups of previous packages are giving me this error. Anyone got any ideas I have 1 GB free disk space. Last OS update a month ago. Ready to reinstall SSIS. Error 1 Error loading SanDiegoRiverside.dtsx: The connection type "FLATFILE" specified for connection manager "ExtractDenormalizedErrors" is not recognized as a valid connection manager type.
  • ISNULL ( ) support in SQL Server mobile?
    by Abhi_7
    5 Replies
    Last post by NozFx
      • Is ISNULL ( check_expression , replacement_value ) supported in SQL Server 2005 Mobile edition. If not, then why the following statement executes without any error: -  " select ISNULL(a,12) as test from tableA " Where 'a' is int column. However, even though i do not get an error, it doesn't behaves as expected. I mean the result which i get is : - a. If the column is not null, the value in '
  • I can't get a SQL QUery to accept a null for a parameter
    by GrahamY
    4 Replies
    Last post by GrahamY
      • I have straight forward Insert Query, which takes values mainly from text boxes, however I am having trouble when the value is null. eg cmdP0.Parameters[ "@EmpID" ].Value=txtEmpNo.Text; When I run the Query I get... Message="Parameterized Query '(@ID int,@EmpID int,@Photo nvarchar(260),@DoB smalldatetime,@Med' expects parameter @EmpID, which was not supplied." I also
  • no merge replication but merge systables needed
    by William Lowers
    2 Replies
    Last post by William Lowers
      • I just was having a real strange problem. I deleted all the merge publications on my server. Once that was complete we got errors about invalid object sysmergearticles... this table did not exist because there is not merge replication. So why would the database think it needs it there I had to create a merge publication to make the error go away. SQL 2005 Ent SP2
  • SQL Server Management Studio Express on Vista Home Premium (Error on attaching and detaching .mdf)
    by Glen Satuito
    6 Replies
    Last post by Glen Satuito
      • I have SQL Express 2005 SP2 installed in my Vista Home Premium. I am using SQL Server Management Studio Express to manage .mdf. When I click "Add..." to attach .mdf database, I have this prompt error message : The server principal "My-PC\MyName" is not able to access the database "model" under the current security context. (Microsoft SQL Server, Error:
  • Filtering results in the Where clause vs a Having clause
    by Brett Selleck
    3 Replies
    Last post by Ben Aminnia
      • I am working with a vendor on upgrading their application from SQL2K to SQL2K5 and am running into the following. When on SQL Server 2000 the following statement ran without issue: UPDATE dbo . Track_ID SET dbo . Track_ID . Processed = 4 --Regular 1 leg call thats been completed WHERE Processed = 0 AND LegNum = 1 AND TrackID IN ( SELECT TrackID F
  • Best Practices Analyzer 2000 vs 2005?
    by SillyMS
    2 Replies
    Last post by SillyMS
      • I am new to Best Practices Analyzer, so I downloaded both 2000 and 2005 and noticed that the 2000 version covers lots of issues that 2005 seems to ignore. The 2000 version has lots of options, while 2005 seems to offer almost no options. I ran both against a 2000 database and the 2000 version caught lots of things 2005 ignores. Of course, 2000 can not analyze a 2005 database, so I wonder, Why does
  • Stored Procedures
    by Ģ&&am
    3 Replies
    Last post by timbailey
      • Is it possible to select from the results of a stored procedure. In other words, I want to do something like this: SELECT MyField1, MyField2 FROM ( EXECUTE dbo . usp_getRevenueExpense )
  • CLR Triggers, Linq, and Transactions
    by IgorH
    2 Replies
    Last post by IgorH
      • I'm trying convert my working CLR Trigger to a Linq-based implementation, but I don't seem to be able to get Linq to cooperate with the Trigger's context transaction (a local SubordinateTransaction with IsolationLevel="ReadCommitted") . For brevity's sake I've boiled down my scenario to a bare minimum: A SQL table [Test] with three columns (int Manual, int Automatic, IDENTITY int ID) ne
  • FTP Task Send error
    by lcj
    3 Replies
    Last post by lcj
      • I cannot seem to get the FTP task to send files. I tested the process manually (not using ssis) and it works fine. I have tried many ways to transfer the files, using variables, including full paths, partial paths, etc. but I keep getting a "550 permission denied" error. I have rechecked all variables. Has anybody else had trouble sending files with the FTP task
  • ODBC as Data Source in Workgroup Edition
    by dahlbyk
    0 Replies
    Last post by dahlbyk
      • I'm working on a report that needs to connect to to an ODBC data source. The connection works fine in the designer, but deployment to our server fails with the following error: "An attempt has been made to use a data extension 'ODBC' that is not registered for this report server." I've verified that ODBC is listed under Extensions > Data in RSReportServer.config, so I'm curious if the
  • URL parameter problem
    by mr4100
    13 Replies
    Last post by Jarret
      • Does anyone know why this won't pass my parameter It pulls up the report but doesn't pass the parameter in. I have the prompt user box checked. http://gip-sql/Reportserver/Pages/Report.aspx ItemPath=%2fGradReport%2fGradReport&rs:Command=Render&rs:Format=PDF&rs:&Programs='100' thanks,
  • Package Configuration in SSIS
    by Ramesh Chandran
    10 Replies
    Last post by jwelch
      • Hi, I am new to SSIS. I have an SSIS package which we are storing it in the application server ( not in SQL Server ). We are storing the database name etc.. in package configuration. Where should I store the configuration file In app server or in the database server. Also please tell how to execute the package stored as file system. Thanks ramesh
  • is it possible to pass array to stored procedure
    by imranabdulaziz
    2 Replies
    Last post by Madhu K Nair
      • Dear All, I am using sql2000, I want to know whether in stored procedure we can pass array. Or is there any other solution to pass array of records Please Guide Me thanks
  • Saving maintenance plan failed?
    by EaUsKY
    14 Replies
    Last post by Sirish Davuluri - MSFT
      • =================================== Saving maintenance plan failed. =================================== One or more arguments are invalid ------------------------------ : Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword) Microsoft.SqlServer.Managem
  • Are you online?
    by MNOR
    6 Replies
    Last post by MNOR
      • Hello, I have installed SQL Server 2005 Express edition but can not 'launch' or 'invoke' the application. When I look under ' SQL Server Configuratin Manager' there are 2 files, SQL Server and SQL Server Browser which the status of both is 'Running'. I do not see any other files or icons to launch the application. Can anyone tell me what other steps I need to take or install to run the app