Answer Questions

• Steven Bowman I couldn't access the Secondary Database after I finished Shipping Configuration

  Dear All Please I need an urgent help After i finished all Transaction Log Shipping Configuration. I tried to use the database in the secondary database but i couldn't access it i saw it in SQL Managment Studio as (Restoring......) i tired to make a database snapshot from it , i had a message Msg 1822, Level 16, State 1, Line 1 The database must be online to have a database snapshot. Please urgently the se ...Show All

• Valdimar Simulate ROW_NUMBER () in SQL 2000

  I would like to generate an incrementing column value to each row found in a query in SQL Server 2000.  My understanding of SQL Server 2005 is that you can accomplish this approximately along these lines:    insert into MyList (myNo, lName)    select ROW_NUMBER() myNo, lName    from Employee    select * from MyList    order by myNo    myNo   &nbs ...Show All

• IECUSTOMIZER Diagram/Criteria/SQL panes

  Is there any way that I can always show the diagram, criteria and sql panes when I do "open table" It's not configurable in SQL Server Management Studio. In Visual Studio, you can go to Tools -> Options -> Database Tools -> Query and View Designer to customize it. You can also toggle each pane quickly by pression CTRL+1 (diagram), CTRL+2 (criteria), CTRL+3 (SQL) and CTRL+4 (results). ...Show All

• Craig Lichtenstein - MSFT Decode funktion

  Hi! I have a question about the "Decode" funktion. is it only avaiable in Oracle The reason for my question is that I need to SELECT a colum in a table based on a int value. So if the uservalue is lower then that take that colum, lower then that take colum...etc. Can I use decode or/and is there better funktion (I'm using MS SQL 2005) Thanks in advance Mark Thanks a lot, I think that ...Show All

• Barham ...cannot be run because the SSIS subsystem failed to load....

  Greetings all, After moving all my packages to a new server, win2K3, SQL2k5, non of the SSIS packages run. They all ran fine on the other server. The error is "2006-03-07 13:09:38 - ! [LOG] Step 1 of job 'ExportXML' (0x4E0C7495EFE4034FA6EF94B7C7F77262) cannot be run because the SSIS subsystem failed to load. The job has been suspended" These packages ran perfectly on the old system. Running the package manually, using DT ...Show All

• Rodcet How to get the Row Number per Distinct Records?

  Row Number Name Phone Number 1 John Doe (555) 123-1221 1 John Doe (555) 144-9989 2 Smith (666) 191-1201 3 Jane Doe (555) 188-0191 3 Jane Doe (555) 189-0192 3 Jane Doe (555) 190-0193 Here are the records I get back using a Grouping on "Name". I would like to assign a Row Number for each "Distinct" row. I've tried all the possible aggregate functions with n ...Show All

• Mr. SOAPitStop Using UDL insde SSIS package

  Anyone knows how to use UDL file inside SSIS packages like the way UDL is used inside DTS packages Or does SSIS supoorts using UDL in the same way as DTS Thanks. Steve, Plenty here for you to peruse: http://blogs.conchango.com/search/SearchResults.aspx q=configurations&s=24 -Jamie iortizvictory wrote: Hi Jamie, I thought you said to store connection strings in a single connec ...Show All

• peter8 Calculated Member not working

  Please could somebody help me to understand what is wrong with the following calculated member definition (tried many variations of this now, always the same problem) CREATE MEMBER CURRENTCUBE .[MEASURES].RatioVal AS [Measures].[Val] / SUM (([Tbl Acc Codes].[Tbl Acc Lvl1].&[OUR],[Tbl Acc Codes].[Tbl Acc Lvl2].&[CORE],[Tbl Acc Codes].[Tbl Acc Lvl3 - Lvl 3 Code].&[INCOME]),[Measures].[Val]), NON_EMPTY_BEHAVIOR = { [Va ...Show All

• fastboxster Express cannot convert different data types automaticly????

  I have a SQL Server 2000 database which works like a charm in my asp app. Joining tables by id columns which are of different data types (eg. int in one table and varchar in the other) is no problem with the SQL Server engine, but Native Client refuses to do so and hands me back an error. Even if columns have a slightly different collation (like Slovenian_CI_AS and SQL_Server_1250_CI_AS) SQL Express native client returns an ERROR !!! Is it pos ...Show All

• MoeC Inserting a string with apostrophe to SQL Server

  Hi, I develop a windows application using C#. I try to take a value from the textbox and put it in the table on SQL server. I create a connection string and the command string (ODBC). The value I want to insert surrounded with apostrophes. The problem occurs when user wants to insert apostrophe in the textbox. It is inserted to the string value and SQL server recognizes it as an end of string. Does anybody know how to resolve this problem than ...Show All

• srgibson Gurus: Please help! SSIS package using custom dll fails on server

  I have a SSIS package that has a script component. In the script I reference a custom dll that contains some functions. The dll is registerd with a strong name in the GAC on my machine and the SQL Server 2005 box. The package works fine in Visual Studio. The problem lies when I deploy the package to the server. (note: several other packages created without the dll work fine on the server). Is there something else that has to be configur ...Show All

• ZoRoNaX Yukon SP performance issue

  Hi all, I'm using the next-to-latest Yukon Enterprise beta. I have an SP with a complex query and have discovered a strange performance issue. My query includes:   * 8 variables, 3 from the SP parms and 5 locally defined   * a .NET UDT I have a fairly simple schema: 9 tables of which four are accessed in the query. When I call the SP, it takes ~16s to execute. However, if I replace the parms with static values, it takes ~0.1s! What' ...Show All

• hansondan How to show progress bar in report column

  Hi, I have to show particular item progress status in a report column in graphical format. For example, if item finish state is 60% then, column should display status in progress bar or similar to that. Is this possible Any help would be appreciated. Thanks Hi, you either make a graph showing 60 in the scale of 100 or use any thrid party tool from dundas to show gauges (or a different object) ...Show All

• Tsutomu YASUI Complex Join

  Hello, I am blocked with a Join Request I have 3 tables : TaUtilisateurs store the users TaClients store the customers TaJoinClients_Utilisateurs store right of user on customers : for example : TaUtilisateurs Id_Utilisateur Login 1 Nico 2 Philo TaClients Id_Client Entreprise 0 Company 1 4036 Company 2 TaJoinClients_Utilisateurs Id_JoinClient_Utilisateur Id_Utilisateur Id_Client Editeu ...Show All

• Ken Grissom How to display group footer at end of the page

  How to display group footer at end of the page You would create a group and set the group property to page break at then of group. There is no "fill page" function so the page break will occur at the end of the group, not the page.   Brian Welcker - MS wrote: You would create a group and set the group property to page break at then of group. There is no "fill page" function so the page break will occur at the end of the gro ...Show All