SQL Server

Page 4462




  • Topics
    Replies
    Last post
  • JDBC driver NullPointerException when updating timestamp column value to null: version 1.1.1501.101
    by sm_msdn
    5 Replies
    Last post by David Olix - MSFT
      • When updating a timestamp column value to null from within a java program, I get the exception below. The env is MS SQL server 2005 SP2, and MS jdbc driver version: 1.1.1501.101. Please advise of any workarounds or solutions. Update <table_name> set <colname_oftype_timestamp> to null java.lang.NullPointerException at com.microsoft.sqlserver.jdbc.AppDTVImpl$SetValueOp.executeDefault(
  • Connect to Analysis Services with specific username
    by Grace SQL
    2 Replies
    Last post by Grace SQL
      • Hello, We are trying to develop an ASP .Net web application that connects to an SQL Server 2005 analysis services and executes MDX statements. We want the connection to be made using a specific user name that we specify in the code rather than having the web application inherit the logged on domain user account. We tried to specifiy the user name in the connection string as follows, but
  • Bulk Insert from Mapped Network Drive
    by Gosatu
    14 Replies
    Last post by jimmieBV
      • Hi, I am trying to perform bulk insert using mapped network drive, but getting following error: Server: Msg 4861, Level 16, State 1, Line 1 Could not bulk insert because file ' F:\Download\MVY.b45 ' could not be opened. Operating system error code 5(Access is denied.). F is mapped network drive pointing to my SQL Database Server. While searching, i got the following link but not able to r
  • If i set an unary operator for the top level is it necessary to define an all member lavel?
    by Rafael Augusto
    3 Replies
    Last post by Darren Gosbell
      • Hi, I have a cube in as2005, and in one of the dimensions(parent-child) the top level has 2 members and they have an unary operator associated. When i have an all member defined (parent attribute aggregatable=true) the cube works. When i set the unary operator to "None" OR when i remove the all member level, the cube stops working and has the same behaviour in both
  • Stored Procedure - INSERT/UPDATE
    by FlemmingMalmkvist
    6 Replies
    Last post by FlemmingMalmkvist
      • HI, I¡¯m trying to do a Stored Procedure (SP) that stores data from a form in ASP.NET. If the record does not exist, it will create a new record first. This is my first SP, so if best practise is done another way, I would like to hear about it. Code: Code Snippet CREATE PROCEDURE dbo . StorUserRecord /* some of these are for future use */
  • Need help to create this named set
    by pmak
    5 Replies
    Last post by Teo Lachev
      • I have a "Date" dimension with several attributes in it such as "Accound Period", "Calendar Year", "Completed Year"etc. I want to create a "named set" for some dataset to filter out the "Calendar Year" which has the value "Less than or equal to" the value of the attribute "Completed Year". The structure for the "Date" dimension is as follows: Calendar Year (attribute) Members Calenda
  • INSERT INTO AS400 - NUMERIC value
    by Tina N M&amp;#38;&amp;
    1 Replies
    Last post by Tina N Mörnstam
      • Hello! I try to use "Execute SQL Task" to insert a numeric value into AS400. The following command works: INSERT INTO "MSSPRDDAT"."MSSDATE" VALUES 1070528 But I need to use a parameter insteed. I have tried several Data Types, but non seems to work. When I use NUMERIC, LARGE_INTEGER, ULARGE_INTEGER or NVARCHAR I get the following error messa
  • Searching for a field name
    by tvks
    5 Replies
    Last post by Pranava
      • Hi all, I have a very big database with me. This database has large number of tables and each table has n number of fields. My trouble now is that I desire to search for a field name called 'empname'. Is there any query possible for me to search all tables and return me the table names which contain fields which match with 'empname'. Adding essence to the porridge I would like to know if I specify
  • pls help - doubt regarding OLAP cubes.
    by jaee83
    3 Replies
    Last post by HariK
      • what is it that decides that a particular OLAP cube is small or large Is it the number of tuples or the number of dimensions that are present in the cube Thank you.  
  • Improve VFP source performance
    by jabadwy
    6 Replies
    Last post by jabadwy
      • I am not an expert in either SSIS or VFP technology but know enough to get my way round. One anomaly I did discover I thought was worth sharing for all those concerned with getting large amounts of data out of VFP in as short a time as possible. When you search for performance tips in relation to SSIS the advice is to never use select table or view from data access mode list in ole db source as t
  • Need infos regarding install of SQL Express 2005 SP1
    by St&amp;#233;phane Beauchem
    14 Replies
    Last post by Arnie Rowland
      • Hi, A little technical question. If I want to install SQL Express 2005 SP1, do I have to uninstall current version first Thanks in advance, Stephane
  • Recomendations for keeping track of changes
    by Andreas Brosten
    11 Replies
    Last post by Arnie Rowland
      • Let's say I develop a 'version 1' of a program/database and ship it to some customers. Then I continue work on version 2 with some databasechanges etc. When version 2 is shipped to the customers, they need a way to upgrade their database from version 1 to version 2. I guess this is easiest done with one/several sql-scripts. What I want is your opinion about the best way to keep tra
  • MS SQL Server 2005 Express Edition installation problem - Help!
    by ExpressionWeb
    5 Replies
    Last post by Arnie Rowland
      • During installation, I get a warning message that the hardware doesn't meet minimum requirement. But I'm running it on a laptop with 30 gigs of free space and running Windows XP home edition. When I click on install anyway, I end up getting an error message that I need a "sqlncli.msi" file that can't be found. Could it be because I have both 2.0 NET and 3.0 NET installed
  • Quick Question - Need some advice on troubleshooting SSIS Errors
    by MA2005
    6 Replies
    Last post by Rafael Salas
      • Hi Everyone: I have a SSIS Package which in brief moves data from one SQL data store to another. On my local machine, the package executes fines, and does what it is supposed to do, by moving data from Point A to Point B. I have both Point A(DB) and Point B(DB) on my local machine. But when I deploy this package over to ASSEMBLY which is basically another environment, I get weird intermitte
  • RECEIVING messages from a Windows service
    by ChrisB7
    4 Replies
    Last post by chmur
      • I've done a bit of work with the External Activator but I think it may be a bit overkill for what I need to do (which is RECEIVE messages from a single queue and process them with managed code). I've tried creating a Service Broker Interface service that retrieves messages from this queue, but I notice that if I set the timeout to -1 to watch for messages indefinitely, the Service never completes
  • [URGENT] Collation conflict error
    by sroughley
    0 Replies
    Last post by sroughley
      • Hi all, We have a stored procedure that is producing a collation conflict error. We have tracked down the source of the error to the line reading: SELECT @key = max(RegistrationNo) FROM #PBs. We have checked and rechecked that the database and server collation are the same (Latin1_General_CI_AS) and we have even specified the collation of the RegistrationNo collumn (in the create table stateme
  • custom formatting codes
    by Levi Wallach
    7 Replies
    Last post by Levi Wallach
      • I need to create formatting that is a bit different from the standard formatting codes in SSRS. Specifically, I need to have the percent sign come right after the number (SSRS inserts a space), whereas with currency fields I need to inster a space between the $ and the number (SSRS has no space). Is there any way to do this with custom formatting codes, or will I need to go through and add the per
  • Creating user to own schemas?
    by windthorstking
    4 Replies
    Last post by windthorstking
      • I have noticed that some folks create a user to own a schema, with both having the same name (ex: userowner = pfm schema = pfm) and others make dbo the owner for all their schemas. From what I can tell, it doesn't really matter; what does matter is if your database users are granted access to the schema. Since most users only have public rights and dbo has database owner rights, is there any part
  • RDA and SQL Server Express
    by moldau04
    2 Replies
    Last post by moldau04
      • Hello, I was wondering if there is a limitation of how many mobile devices can connect to SQL Express using RDA, as well as desktop connections before they would need to upgrade to full version of SQL Server 2005. Thanks in advance!
  • Facing Timeout Error
    by Shaantu
    2 Replies
    Last post by Matt Neerincx
      • I am facing Timeout Error as i am using SQL Server 2005 as a database and in database set pooling property as 0 and RemoteTimeout as 0 also as a front end i am using .net 2005 and in web.config file i set pooling=False but then also i am getting the following error. Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled
  • Locks the tables while running Report...Very Very Urgent....
    by rupamp
    2 Replies
    Last post by BobP - BIM
      • Hi all , When i Run the report in reporting services, it lock s the tables. so is there any option to Un lock the tables. I m using just select query to run the report but when i run the report it locks the tables. I used with(no lock ) option in select query but it didnt work...still showing me lock on the tables. Pls help...its urgent Thanking You, Rupali Rane.
  • Katmai installation
    by jaegd
    2 Replies
    Last post by jaegd
      • Installing Katmai took 4 attempts, all of them on Virtual PC 2007. In my experience, CTPs should be installed on virtual machines, because VMs are relatively easy to replace, particularly with the undo disk functionality. 1. First attempt installing Katmai June CTP. Vista Business x86 guest / Vista Ultimate x64 host. No go, install died with Management studio error. Post abortive inst
  • Error installing SQL Server 2005 editions on Windows VISTA
    by looplocal
    14 Replies
    Last post by raedalfawal
      • There are numerous posts regarding this error when installing SQL Server 2005 on Windows Vista RTM thus I am starting a new thread in order to get resolution one way or another: SQL Server Setup failed to execute a command for server configuration. The error was [SQL Native Client]Windows user or group "\USERNAME\SQLServer2005MSFTEUser$USERNAME$MSSQLSERVER" not found. Check the name again...
  • Problem Using Stored Procedures in Report Datasets
    by vanGogh
    1 Replies
    Last post by Ian Roof - MSFT
      • I have a local Reporting Services report that I am modifying to use a stored procedure. Although I am executing a stored procedure in the dataset query window, I also have to run a SELECT statement to retrieve the fields from a table that will populate the report. The code that I have in the dataset query window looks like the following: ---------------------------------------
  • Filtering datasets
    by sog
    2 Replies
    Last post by sog
      • I have the following report 1. A mulitvalued parameter State with WA, SA, QLD, TAS etc 2. A single value parameter of Top n - 10, 20, 40 The user will select the state and the top number to get the top n sellers off that state or a combination off states. I have a dataset with the following cutdown version off SQL Declare @TopNo Int Set @TopNo = @Param_TopNo