Answer Questions

• ac30boy Dynamically determine subtotal visibility in matrix?

  I'm using SSAS2005 SP2 as a data source, and RS2005 SP2 for reporting. With the upgrade to sp2, users assigned to an area in a sales location tree no longer get a value returned for AGGREGATE(MyValue.Value) when looking at a region higher than they are assigned. My MATRIX reports now look like: _______________________________|___|___| Region____Sub Region____Area1__|_5___3_| Sub Region Total_______________|_______| Region Total___________________|_______| Grand Total____________________|_______| Before sp2, they had the 5 and 3 values repeated in all total rows. My thought was to hopefully dynamically hide the sub region and region groupings and their related subtotals - but when trying to do this, only the grand total shows, and ...Show All

• ititrx Freeze panes when report is exported to Excel

  I am using RS 2005 and emailing reports in Excel to my end users. Is it possible to set the report in VS.Net to freeze the panes so that the user will always see the column A when they scroll to the right once they view the report in Excel I have the feeling the answer is no, but I thought I'd check. I'm having the exact same issue. Has anyone been able to accomplish this successfully Jens Suessmeyer : I tried the property option but that didn’t work for me. The closest to what I’m trying to accomplish (that I’ve gotten); it’s using a report header which freezes the first row (or whatever u have in the header) yet by design it doesn’t accomplish what I (and rs12345) a m trying t ...Show All

• Vulcanoro how do i change the domain name for users

  Hi, A friend migrated windows domain users and it happened that the users now belong to a new domain domain2, The users in sql server are still defined as part of domain1, now he needs to migrate all sql server 2000 users from the domain1 to the domain2 (just the name of the accounts, users or logins). Any idea please. if it s also to go through users and change their credentials in sql 2000 to reflect the new domain name. Thank you. The clean ways is to set the ownership of the existing users objects to sa (dbo) and drop and recreate the users. Dirty ways is to update the system tables , master.sysxlogins, master.syslogins and update the old domain with the new domain for the users, and then updatin ...Show All

• GrandpaB "Incorrect syntax" exception when prefacing SP names with "dbo." and named parameter issues

  We're currently trying to evaluate SQLJDBC 2005 1.1 June CTP's support for database mirroring automatic failover. Unfortunately we're getting unexpected exceptions for calls that work fine w/ jtds that our blocking our ability to perform these evaluations without us making substantial changes to our codebase. The first issue is with the name used when calling a stored procedure -- SP names that start with "dbo." give us the following error: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '.'. src:{call dbo.xyz( , , , , , , , )} The call will work if we change the SQL statement to {call xyz(...)}. I don't understand why we would need to do this, especially given that the documentation for the dr ...Show All

• Urip SQL server stopped unexpectedly

  Hi I am running SQL 2000 SP3 and running redgate to backup databases. Last week my SQL service stopped unexpetedly and it doe snot have any error logs as to why it did it the last action was a diff backup and redgate failed to send email and there was errror like there was no strogae avialable. However I goto the agent error log and found this. My agent runs as a SA but the SQL services run under the local account can anyone tell me what this error is about or any suggestions regarding if server stopes unexpectedly will it try to restart the services 2006-08-06 04:03:45 - ! [359] The local host server is not running 2006-08-06 04:03:45 - ! [359] The local host server is not running 2006-08-06 04:03:47 - ! [012] The MSSQLSERVER service t ...Show All

• CBuilder sql beginner - saving views to a file

  is there anyway to automatically save a view to a file at a scheduled time Thank you for any help or pointing me in the right direction. Additionally, in 2005, you can even use a query like: select object_definition(object_id) + char(13) + char(10) + 'GO' from sys.views to get all of the view definitions. There are a few ways to do this, but the simplest is probably to use a command-line tool such as osql which comes with SQL Server or the client tools. You can schedule this using the Windows scheduler or an AT command in the operating system. I have a full example and tutorial of that here: http://www.informit.com/guides/content.asp g=sqlserver&seqNum=151&rl=1 B ...Show All

• ArizonaJoe Mobile Device Database Develpment Problems

  Hi, Guys I read a lot of your post about the mobile device connecting SQL Server. I try to solve my problem, but i still in trouble of Mobile database application. The following is my development enviroment Visual Studio .net 2005 Sql Server 2005 Windows CE.Net 4.2 Microsoft ActiveSync 4.2 First i can run some simple application on the Mobile Device( Symbol MC9060G Mobile Device), all the connection between develop PC and Mobile Device is fine. All the develop SDK for the Mobile device without problem. Secont, i can develop a simple normal windows database application, work fine, can get data from SQL Server 2005. the connection to database server is fine. I used VS2005 develop a simple database with DataGrid on the for ...Show All

• Kent Waldrop Fe08 get dates NOT between x and y

  Hi. I hope this is the write place to post this, I hope it is. basically, I want to be able to return me a query of giving me available dates in a table. What I mean is that, if I have a table with fields including start date and end date, I want to return me the dates which are NOT listed/stored in the table. kind of like a booking system, where you store the room reservation dates and obviously you don't want to double book that room, so I would like all the available dates to be returned back. is this possible how can I go about doing this Thanks! Many thanks for this valuable query, greatly appreciated. I do have a question though - you say "Create a calander table that contains all possible da ...Show All

• swathi_challa RaiseError inside stored procedure

  I want to execute some insert statements within a stored procedure and commit those changes regardless of any raiseerror that occurs later in the stored procedure. My difficulty is that I am forced to use raiseerror with severity 16 in order to send a message through the powerbuilder application interface (compiled vendor code). I have tried save points but can't get that to save my insert and still present an error to the user about something else that happens later. here is an example BEGIN procedure Insert something and save it even if error is raised below RaiseError('you made a mistake and need to do this.',16,-1) END procedure First of al ...Show All

• Anand Raman - MSFT MSDE Multiple Instance

  I am trying to set up multiple instances of MSDE 2000 for use by Trend Micro virus scan products. I have the instance set up but I am trying to access svrnetcn.exe to set up named pipes and TCP/IP and I keep getting a 126 error "The Specified Module could not be found". Any ideas how to set this up. thanks, eric I had this same issue and ended up searching for that 126 error message. I found a somewhat related reference to an older service pack being installed than what it wanted, so maybe SVRNETCN.exe or some of its required files were corrupted. Who knows. Maybe at some point I installed an older version of MSDE over a newer version and broke it. I went to add/remove programs and remove ...Show All

• NewbieDude Permissions for Connecting to Reporting Services in Management Studio

  Hi, We have a user in the System Administrator and System User roles of 2005 SSRS. He is able to connect to the website (http://<servername>/Reports) and do whatever he needs to do. But, when he tries to connect to Reporting Services in Management Studio, he receives the following error: =================================== Cannot connect to <servername>. =================================== The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ Program Location: at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName) at Microsoft.SqlServer. ...Show All

• Fwank79 Update slow(5 Hrs, 14mil rows) on perm tables, however as part of SP using temp tables fast(45 mins 14mil rows)

  Greetings All ITEM1: Here is the statement :(Perm Tables) update jkk_AllLogic_Allocation1_Work set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from jkk_AllLogic_Allocation1_Work a, jkk_SumOfSales2 s where a.ID = s.ID ITEM2 Here is the similar Statement(excerpt) from SP: /* Adjust Expense amount depending on sales ratio */ update #AllLogic_Allocation1 set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from #AllLogic_Allocation1 a, #SumOfSales2 s where a.ID = s.ID The SP does a lot of things Update being the longest. QUESTION Why is ITEM1 taking 6 times longer to run than ITEM2. I am totally confus ...Show All

• Cosmin Nicolaescu Reinitializing Push subscription after it expired in Transactional Replication

  I am using SQL 2000. How can I get my transactional replication reinitialized after it has failed with several attempts. I know one way of doing it through enterprise manager and specifying the subscription to reinitialize. But this will apply the snapshot and will take long time. Is there a fast way of doing it -Nipul A reinitialize requires reapplying the snapshot. Can you be more clear what you're trying to accomplish I think what you want to do is just restart the distribution agent, does this work ...Show All

• Jeff54 Create new row on the fly

  I have data that looks like the following ID ===== 123456 234567 345678 456789/567890 654321/765432/876543 In some instances, the older system had to store multiple IDs in one field and used a "/" delimiter. Does anyone have any ideas on how to create new rows on the fly and split the IDs out to the new rows Thanks in advance. Jamie Thomson wrote: That won't work but the following might: Public Overrides Sub Input0_ProcessInputRow( ByVal Row As Input0Buffer) While ( "," occurs in Input0Buffer.Row.ICS) Row.code = substring(Input0Buffer.IC, start, length) End While End Sub You don't need to call AddRow() if its a sync ...Show All

• MrDoomMaster SQLCLR 32-bit Vs 64-bit

  Is anyone here aware of any explicit/definite differences between running sqlclr on 32-bit and 64-bit. Note: These must be documented, well defined differences. If you know of a specific BOL Index Topic, feel free lol Have not found one yet... Steve, I would give you two answers for that one reply if I could. EXCELLENT REPLY AND THANKS There aren't really any explicit, intended functional differences in SQLCLR itself between 32-bit and 64-bit. The only one I'm aware of at all is a subtle difference when running under WoW64 that clr must be enabled on server start-up in order to initialize it. However, there are still several subtl ...Show All