Answer Questions
BrandyQ Bypassing locks when doing insert or update
Hi, I want to bypass locks while doing Insert or Update. I am only updating a log db and I don't care about one or two fields getting junk as I won't use it later (atleast as long as I am working with my current company ;) ) I am using MS SQL 2000 I am getting too many deadlocks and messages like these "Process ID was deadlocked with another process and has been chosen a victim. Please rerun the transaction". Please tell me how to achieve this. Regards, Noorul You absolutely CANNOT bypass locking when doing UPDATES or INSERTS or DELETES. Nor would you want to. You are getting deadlocks because your code is accessing the data in differring order, you are holding transactions open too long, and/o ...Show All
CnCs Show all days
I am pretty much brand new to reporting services so I apologize for any simple questions I may ask. I have created a call report that shows data broken down by day and grouped by week. Everything works great. However, if there is no data on a certain day is does not show me that day on the report. Is there a way I can make it display the day even if there is not data for that day and just give me 0 values Or do I need to modify my query Thanks in advance. The query should return the complete set that you would like to see. You can perform this with a date table or numbers table and a left outer join. cheers, Andrew ...Show All
Beast Forever Vista, 18452 and the remote domain
Hello We have a setup of two very separate domains, they are connected via a couple of routers, we connect to the remote domain mainly for administration mostly via remote desktop. We setup the same user name & password on both domains, with XP as the operating system we can setup the sql link via odbc using windows authentication which works fine, a couple of PC's have now been upgraded to Vista but the increased security stops this from working, we now get error 18452 error code with the user name of "null" I assume vista has stopped the passing of local credentials to what it considers an untrusted domain, fair enough, does anyone know a way of either adding another trusted domain to Vista I do not want to setup an ...Show All
the frenchman Can anyone help me?
Hi all, I just installed the reporting services with named instance DEV. It is not showing any error message in reporting services configuration tool but when I try to login through SQL server management studio as <myserver name>/DEV windows authentication it always shows this error message TITLE: Connect to Server ------------------------------ Cannot connect to <myservername>\DEV. ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html', but expected 'text/xml'. The request failed with the error message: -- <html><head><title>Server Application Error</title></head> <body> <h1>Server Application Error</h1>The ...Show All
pdurbha Hide some columns in Matrix but not in subtotal
Hi all, I would like a matrix that look like this: 2006/01 2006/02 2006/03 Total % % % % Amount Amount Class. BU1 98,82% 78,53% 88,12% 88,49% € 217.763.099,50 € 207.328.766,75 BU2 64,98% 32,53% 92,19% 63,23% 5.093.781.522,65 € € 287.731.766,75 BU3 74,71% 45,78% 78,69% 66,39% € 847.871.349,50 € 819.123.124,75 I want detailed subtotals but I don't want the "Amount" and "Amount Class." values in the details of my Matrix. I've not found other w ...Show All
enric vives Can't Creat Subscriptions
We're new to SQL Reporting Services and have a new SQL 2005 server. I'm having a problem activating scubscriptions. - "New Subscription" is greyed out in Server Management Studio. - Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error; "The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)" Any suggestions Found the problem. When configuring the Data Source the "Impersonate the authenticated user after a connection has been made to the data source" b ...Show All
djdotti Regional numbers are formatted wrong
Hello, I am running reporting server on a "english" server with dutch regional settings. My client and the client of the users are also a "english" client with dutch regional settings. A dutch number should be formatted like 1.234.567,89 Unfortenately when I run a report I get the number back (non formated) like 1234567.89 How do I get it in the dutch format With regards, Constantijn Enders check the properties of the textbox where u have placed the field. there is a property called Calendar in International property. there u set ur settings of dutch You can set the language property of a report to dutch. To fix all report I did a search and replace of ...Show All
Alexander Stoyan Can't receive Message from Queue (Async Trigger)
Hi Folks, I've found a pretty good code example on http://www.dotnetfun.com for a Asynchronous Trigger. I've parsed through the Code, to understand how to wirte my own Async Trigger with a Service Broker, but the Code isn't working! It seems that the stored procedure don't receive the messages in the queue, but the queue get's filled. MessageType CREATE MESSAGE TYPE myMsgXML VALIDATION = WELL_FORMED_XML; Contract CREATE CONTRACT myContractANY (myMsgXML SENT BY ANY) Queue CREATE QUEUE myQueue WITH STATUS = ON, RETENTION = ON, ACTIVATION ( STATUS = ON, PROCEDURE_NAME = sp_myServiceProgram, MAX_QUEUE_READERS = 5, &nb ...Show All
mix600 I can't deploy a Cube
I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY). I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY, But, when I try to deploy the cube, I have this error message: " the user XXXX don't have permission to modify the object or the object does not exist" I don't know if I must configure some specific access. Could you help me please, I search a solution since 2 days with any results. Betty You can add the user to the group through the Local Users an ...Show All
ShrikantBijapurkar HOW TO setup SQL MAIL
hi, I want to receive a mail when SQL Server Agent JOB fail,so I go to setup the SQL MAIL,but it skip an error "xp_get_mapi_profiles: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client." Someboby can tell me how to solve it thank you! don't forget, if you're using SQL 2005, you should use "Database Mail" instead of "SQL Mail" which is being deprecated http://www.microsoft.com/sql/prodinfo/features/top30features.mspx http://www.sql-server-performance.com/da_email_functionality.asp Hi, SQL Mail needs a mapi file. You can create this file either with Outlook or wit ...Show All
mizan1214 SQL 2005 x64 bit, but need 32 bit for workstation management?
Hi, I'm running SQL 2005 x64 SP1, but I want to be able to manage the SQL from a Windows XP SP2 32 bit workstation, aswell as the server. I can't install the management tools from the 64 bit media on the 32 bit as it complains that the OS version is not 64-bit. Is there a way to do this or obtain the tools Do I need an additional licence anyway for the management console for the 32 bit workstation Thanks ...Show All
kotov_ks Current executing task
Hi everyone I'm trying to write a monitoring application for SSIS packages deployed on my machine. I know I can look at running packages via the DtsRuntime.Application object's GetRunningPackages method. Does anyone know if there is any way one can view tasks in that package that are currently being executed Cheers Sachin sachin.rao wrote: Wow! Brilliant! I was hoping for at least one reply... I guess I have to question whether this is possible or not. :) You posted at 17:09 and then sent this reply at 09:20 on the next working day. GIve people a chance! Also, nobody is required to answer you know. As jaegd said, y ...Show All
Ski_Hard11 using RAISERROR
In my Windows application I use sqlCmd.ExecuteNonQuery() to execute the stored procedure, In case of an error in the stored procedure I need to return an exception to application, will RAISERROR in stored procedure accomplish that Yes. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
Vincent Fournier ODBC error when running stored proc to pull sql2005 data into Access 97
I have a stored procedure the runs a query and loads data into a access 97 table. We recently upgraded the sql server database to SQL2005. If I check my odbc connection when creating it is test successful. however when I run the query in access to kick off the stored proc it gives me a ODBC Connection failure message. Neither the stored procedure nor the access database have changed. I am able to run the stored proc successfully from sql query analyzer. is there are compatability issue with Access 97 (they refuse to upgrade) and SQL2005 ...Show All
Misiacik7 RDA push error
While trying to push a tracked table using RDA.push, I get the following error: Error Code: 80004005 The message cannot be built. The make message failed. Minor Err: 28581 Source: Microsoft SQL server 2005 Mobile Edition. All other tables in the database are getting pulled and pushed correctly. This table is different only in the larger number of columns, around 150. It has a primary key, no other constraints. Any help to find the reason for this error will be greatly appreciated. - Paul As far as I remember there was a bug around when you have more than 128 columns. This got fixed later in the SP1. Thanks, Laxmi Hi, The problem persists with SQL server 2005 SP1. Any ...Show All