SQL Server

Page 1046




  • Topics
    Replies
    Last post
  • Failed to open a fastload rowset
    by Pratibha
    5 Replies
    Last post by Bob Bojanic - MSFT
      • Hi. In OLEDB Destination, AccessMode as OpenRowset Using FastLoad raises the following error: "Failed to open a fastload rowset db_object. Check that the object exists in the database" db_object exists in the database. Is there any key point for the table or view used for fastload Thanks
  • Error 3154: The backup set holds a backup of a database other than the existing 'xx' database.
    by Chris1960
    4 Replies
    Last post by Jens K. Suessmeyer
      • HELP! This is happening with a restore to SS 2005 from a SS2000 backup. This article says to use the 'WITH REPLACE' clause. The SS2005 management studio does not seem to allow this via the GUI. http://msdn2.microsoft.com/en-us/library/aa238217(sql.80).aspx
  • TSQL Disable / Enabling Distribution Agents
    by nathbr
    3 Replies
    Last post by Asaf.Meir
      • I want to write a script that I can easily disable or enable all my distribution agents that live in my distribution server. Any ideas I tried to find some TSQL commands but couldn't find this feature. Thanks Nate
  • Displaying MDX result in GridView
    by Vladimir Zinchenko
    6 Replies
    Last post by danparker276
      • Hello all. I'm trying to use GridView to display a simple MDX query result. If I set AutoGenerateColumns property to true, then it fails on GridView1.Databind(); while executing the following code: AdomdConnection conn = new AdomdConnection ("Provider=MSOLAP.3;etc., doesn't really matter"); conn.Open (); AdomdCommand cmd = new AdomdCommand ( "SELECT" + "{"
  • Coma separated string value as function parameter
    by ZacF
    7 Replies
    Last post by ZacF
      • Hi Let¡¯s say I have employees table that contains id column for the supervisor of the employee. I need to create a function that gets coma separated string value of the supervisors¡¯ ids, And return the ids of employees that the ENTIRE listed supervisors are there supervisor. (some thing like ¡°Select id from employees where supervisor=val_1 and supervisor=val_2 and ¡­ and supervisor=va
  • olap and hierarchy problem
    by Roy mm
    6 Replies
    Last post by Roy mm
      • Hi. This is an OLAP question. I have a dimension which is a father-son dimension. I built the cube in analysis server. In the analysis browser I can see the dimension fine, I hant my reporting services report to show that dimension. The problem is that the report won't show me that dimension in hierarchy tree (even if I check drill down) but flatten it down. Does some one know if report service ca
  • Dumb question about compatibility level
    by msdnzoo
    4 Replies
    Last post by GlennAlanBerry
      • Hi everyone, This is my first psot so I am hoping for success.. I had been asked to web enable a sql 2000 database. We upgraded to sql 2005 and I imported the data. All went well until a tried to run a CTE ( common table ) routine and it kept on coming back with an error. On searching the web it turns out that the compatibility level must be set to 2005. When I tried to set the compatibility level
  • Error Handling in SQL Server 2000 - Need Help
    by MA2005
    4 Replies
    Last post by Nitin Khurana
      • Hi Everyone: I have a stored procedure with the following structure and I would like to find out how to catch my error from each block, and raise them if transaction is rolled back in the end. As you can see, I am on SQL Server 2000, so no TRY CATCH functionality is supported, please let me know, specificaly I am looking for the code that would catch the raiserror msgs from each block, and retu
  • Customize Report Parameter Layout?
    by jprl
    2 Replies
    Last post by jprl
      • Hi, I'm trying to deal with a way to change the report parameter's default layout. currently it seems to default to two columns, that's fine until you have a large screen and the "View Report" button is all the way to the right and you have a big chunk of whitespace. For Example: Parameter 1 Parameter 2 <View Report> Parameter 3
  • Troublshooting with SQL Server 2005 Expess edition
    by Ivan Delic
    1 Replies
    Last post by Jens K. Suessmeyer
      • Hi, all there! I have a simple question. About one month ago I installed MSDE on Windows XP SP 2 machine, so I should be able to project my databases made in Access 2003. It work well for a while. Then a few days ago I downloaded and installed SQL Server 2005 Express edition, but simply forgot to read about upgrading MSDE to SQL Server. After installing SQL Server I yesterday decided to uninstall
  • Attribute Key Cannot Be Found: Single Underlying Table!
    by Robin Sarac
    2 Replies
    Last post by Robin Sarac
      • I've spent quite a bit of time searching this topic and have not come up with an answer that would help my situation. I'm building a cube from a single table. That table is used to build both the attributes and measures. I sometimes get the "attribute key cannot be found" error even though queries prove that the data indeed there. Often all that needs to happen to fix the problem is to s
  • How the analysis serivces system compare a non-null value with a null value?
    by Helen999888
    2 Replies
    Last post by Helen999888
      • Hi,All experts here, I wanna know how the system compares a non-null value with a null value Will all non-null values greater than null values or how would it treat it in this case I am looking forward to hearing from you and thanks for your help. With kind regards, Yours sincerely,
  • Printing in Reporting Services hangs
    by VPDJ
    28 Replies
    Last post by VPDJ
      • Please Help!!! We have never been able to get the printing to work on any of our reports using SQL Server Reporting Services 2005 SP2 in our production environment. Without this feature of printing a report, we cannot go live with SSRS at all. We have tried adding the SP2 after a clean install on a new server -- yet we still have this problem. I read a few some posts about uninstall the old Active
  • SQl Server 2proc licensing
    by JohnWoo
    2 Replies
    Last post by Michael Hotek
      • Sorry in advance for the potentially boneheaded question: I would like to purchase SQL Svr 2005 Std Edition in a 2 proc licensing config. All my retailer has is 1proc and doesn't have answers for 2proc... Can I buy a 1proc and upgrade thru MSFT If not, how do I buy a 2proc copy... Thanks! JohnWoo
  • migrating from Paradox into sql server using SSIS
    by swan_sgp
    6 Replies
    Last post by Phil Brammer
      • Hi All, Can anyone suggest me a way to migrate data from paradox tables to sql server tables using SSIS. Paradox tables are having millions of rows. Any help on this is greatly appreciated. Thanks, SVGP
  • MSSQLServerOLAPService crashing frequently
    by mnice
    8 Replies
    Last post by Ricardo Sada
      • System: Sql-server 2005 (x64) SP1 , Windows 2003 Server (x64) SSAS seems to crash now and then and application log fills with : The description for Event ID ( 22 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag
  • Accessing Remotely located SQL Server via Access
    by Jay_1305
    3 Replies
    Last post by Designing-Systems.com
      • Hi, I need the code to create a connection between the Sql server using ACCESS form. Can I do this. If yes . can you help mw with it. Currently I am accessing the server with remote desktop connection Regards, Jay
  • Replication Error 28559
    by samithad
    14 Replies
    Last post by stemill
      • We have a PDA application (Net CF 2.0) which uses sql mobile and synchronises to a SQL Server 2000 database (merge replication). We were using SQL CE 2.0 on the PDA earlier and moved to using SQL mobile recently. Since this move we are getting error 28559 (SQL Server Mobile encountered problems when opening the database - says in the documentation). The error does not happen regularly. Wh
  • Installation problem - can't find startup program
    by JohanNL
    1 Replies
    Last post by Jens K. Suessmeyer
      • I installed SQL Server 2005. In the add/remove programs are all the programs visible. But when I use "Start -> All programs -> Microsoft SQL Server 2005", there are only 5 configuration tools, no management studio. What is going wrong Where can I find the executable that start up SQL Server 2005
  • Dynamically populating an IN() clause within an SSIS package.
    by AdamSQLMan
    7 Replies
    Last post by NigelRivett
      • Hi, I currently have a list of User IDs (in a flat file) and I need to connect to a database I have read-only access to, so that I can retrieve additional data about these users. I imagined a package that ran a query something like: SELECT * FROM table WHERE UserID IN (<dynamically populated from flat file>). Can somebody give me some advice as to how I can achieve this
  • querying 9.5 millions records with no Primary Key
    by km6589
    2 Replies
    Last post by km6589
      • Hello all quick question-- Im looking for the most effiecient way to extract data daily from a table with some 9.5 mill records and growing. These are transaction records and ideally I would like to bring over the last days transactions and add them to my existing table. I cannot use the transaction date as sometime we have to operate in an "Offline" mode where the records are brought
  • Coldfusion Web appls from Oracle to SQL Server 2005 - How to use Application Roles in Coldfusion
    by tpfloor
    3 Replies
    Last post by Satya SKJ
      • Coldfusion Web appls from Oracle to SQL Server 2005 - How to use Application Roles in Coldfusion. Is there anyone who has used application roles in Coldfusion Applications How would you set this up I know how to set up application roles. If you establish your application role and you move from one page to another, how would you run cfquery since you loose your initial user connectio
  • overflow error
    by guddu567568
    13 Replies
    Last post by guddu
      • i m getting date like this 25-Dec-2006.....now i want to convert this date to 2006-12-25... but i m getting erorr Server: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type datetime. The statement has been terminated. select tbl_cams_uploaddetails.amount,tbl_cams_uploaddetails.folio_no,tbl_cams_uploaddetails.Scheme_Code,tbl_cams_uploaddet
  • Matrix Report Not Showing All Columns
    by Art Vandolay Jr.
    4 Replies
    Last post by Art Vandolay Jr.
      • I have a matrix report that I am using with MonthName(Fields!Month.Value) across the top of the report. However, when there is no data under the column, the month is skipped. So, for example, I get this: January March Actual Goal Actual Goal 25 25 30 35 I have tried adding iif(Sum(Fields!Total.Value, "DatasetName" )> 0, Sum(
  • merge agent doesn't upload again!
    by WII
    14 Replies
    Last post by IanFe
      • Hi, I have a problem with merge replication again. This is the replication between sql server 2005 standard edition and express edition. non-filtering. after the merge agent ran normally for a couple of days, the merge replication always stops at the uploading point. It seems like the merge agent can't run the 'MSmakegeneration' sp. Here is the output log. I wish someone could give me hand. Thank