Answer Questions

• nkojuharov SQL Server Log Viewer

  Hi I've noticed that when a DB gets dropped there is no entry added in the Server log. However when you create a DB it and all its options are logged. e.g. Setting Multi User option On for database 'myDB'. How can I get an Event like Drop myDB added to the SQL Server Log when it happens short of tracing events with Profiler, I'd prefer to look in the logs for this sort of important event. Any input is appreciated! Thanks Jens What would those logs of the master db you speak of, look like (what is the table name) I think most are DM views now, no Good idea, re. DDL trigger on the DROP Database statement. I thought I read one could create an Alert on an event in SQL Server. It's not really an error, in fact it ...Show All

• srem Replication problem with stored procedure

  I am working on a transaction replication, i have no problem with all the tables, but when adding the stored procedures, i got the error message: Insert Error: Column name or number of supplied values does not match table definition. The first column - wsSTUAPP_WEXP_iID 's "identity incremnet" definition of table tbl_wsSTUAPP_WEXP is set to 1. The system works well in the publisher server, and the table itself has no problem for replication, but when adding the stored procedure to the replication article, the problem happens. Please advise how to slove this problem. Below is the part of the store procedure and the error message: THANK YOU IN ADVANCE! STOREd PROCEDURE: ALTER PROCEDURE [dbo] . [sp_wsSetS ...Show All

• My Vizai Error Handling + changes to sysmessages in SQL 2005

  Hi.... Im currently migrating a db from 2000 to 2005. Within the 2000 master database, I hold all my custom error messages in the sysmessages table. I'd like to insert the old error messages into the 2005 master database. Unfortunatley it seems that sysmessages has been replaced with a catologue view in 2005. Does anyone know where I can add my error messages now Many thanks Jeremy You can use the sp_addmessage system stored procedure to add custom messages.  It's fully documented in Books Online, so look up the notes and syntax there for more information.   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.ht ...Show All

• tamri UDM cube wizard

  May I know how does the cube wizard able to detect the dimensions and measures What is the logic How can a table be dim and measure as well..thanks. Regards Alu Hi may i know what does outgoing and incoming means Thanks. Regards Alu Take a look at the DSV diagram in BI Dev Studio. Edward Melomed. -- This posting is provided "AS IS" with no warranties, and confers no rights. The logic in the cube wizard is pretty simple. It analyzes the table relationships and suggests that every table with all the outgoing relationships should become a fact table. The table with incoming relationships - dimension. Edward Melomed. -- This posting is provided "AS IS" with no warranties, and confers ...Show All

• jens_essen DMDecisionTreeViewer

  Hi, Anybody knows how to use DMDecisionTreeViewer from Microsoft Thanks in advance ....... :) Please post queries related to SQL Server related queries in this forum. Thanks I've tried it but i found no answer..... Really need help .... So Where can I post question like this Or, could you please help me answer this question thoug may be it is out of the topic of this forum Thanks .... You might try searching under ASP.NET forums http://forums.asp.net . ...Show All

• logtorahul How to know what is the default sort order of a database

  Hi all, The server is sql server 2000, it has a database with collation SQL_Latin_General_CP1_CI_AS. How to know what is the default sort order of it By the way, is it possible to use a query using query analyser to find the sort order of the db Thanks in advance. As far as a query you can find the sort order/sollation for individual databases with SELECT name, collation_name FROM master.sys.databases For the entire server instance, you can find the installed collation with SELECT SERVERPROPERTY ('collation') Look at the code page definition CI = Case Insenstive AS = Accent Sensitive HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Rups11 Unable to Edit Windows Password in Connect to Server dialog

  Hi, I think my description says it all. I have just installed Studio Express for the first time. I want to attach a database. When the connect to server dialog is displayed the user name and password text box is greyed out. The Password box is blank and I need to edit this. I switch to SQL authentication they are enabled but if I switch back to Windows authentication they are both greyed out. I have uninstalled and reinstalled but still no luck, Any help would be great. That's strange. Are you attaching the database via code or via the management studio Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Hi, I was not aware of that whic ...Show All

• MisterB Modifying the default website setup (http://(computername)/Reports

  Hi, I want to modify the layout and stuff of the main reporting page...but I'm not sure how to open it ... is there a project for it that gets installed on the server I've seen some video demos on the microsoft site and they had some pretty nice front ends set up. I'd like to put some actual metrics on that front page and set up some links and different layouts. Can someone please at least point me in the right direction to do this I'm hoping it doesn't require setting up an entirely new site from scratch. Thanks, Roxanne Amythyst, Yes your correct that its talks about using Sharepoint, that is one of the ways to modify SQL report layout. It's next to impossible to modify the current ...Show All

• MA2005 How to create cumulative S-curve?

  Hi I need to make two reports: one containing the Raleigh chart, the other containing a cumulative curve. In the raleigh report I do this: Per project I can see the amount of mandays on a timebase(weeks). For the s-curve (cumulative curve) this needs to happen (and I dont know how): I need to see the sum of the amount of mandays on a timebase(weeks). An example: In raleigh curve: week1 has 20md(mandays), week2 has 30md, week3 has 15md, week4 has 5md In s-curve the same values should give: week1 has 20md, week2 has 50md(30+20), week3 has 65md(50+15), week4 has 70md (65 + 5) I tried a sum of a sum but thats not allowed in RS Anyone who knows how to generate an s-curve (cumulative curve) ...Show All

• StairCounter SQL Server 2005 Capacity Planning & Server Sizing

  Hi; What is the best practice for SQL Server 2005 Capacity Planning & Server Sizing Please help Thanking you Eddie You'll find lots of great information in the book "MicrosoftR SQL Server 2005 Administrator's Companion", ISBN 0-7356-2198-5. There's also the SQL Server Resource Kit, though it hasn't been released for SQL Server 2005 yet. (At least, not as far as I know.) You can find whitepaper that discusses capacity management over in TechNet: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops6.mspx That paper is written from the point of view of monitoring, but if you think of monitoring as the first step after setting up a new server, I think you ...Show All

• sybaselu OLE DB Source Editor

  hi, I am using SSIS to extract data from sql server and import into MDB file. In the process, under data flow task, I have used OLE DB Source Editor as source. Here i have choosen SQL Command as mode of data population. In the box below i have typed the following statements. "Exec Site_Address" I have used many temperory tables in this procedure. When i run this procedure in the query analyzer window i get the desired data which has to be imported to an MDB. After typing the above statements and when i click the button preview i can see the data. But when i click the Columns.... i dont see anything there. I am unable to see any columns there. This is getting to my nerves because, when i use OLE DB as Destination i am unable ...Show All

• Mr_White Re-installing SQL Server Express

  I recently posted this question in the SQL Server Express forum and it was suggested I also post this issue to this forum. In the hope that someone can shed some light on the problem. A couple of days ago I installed SQL Server Express and it seemed to be running fine. (I've not really had a lot of time to devote to trying it out). Today I decided to remove the software as I noticed it placed various components on differnet drives (my fault, I think). Anyway I removed everything using Add/Delete Progams and then deleted any folders left behind. Now I try a fresh install of SQLEXPR_ADV and I get as far as the "Instance Name" dialog and use the default Named instance of SQLEXPRESS and then click Next. The next dialog b ...Show All

• Paul Shmakov Non-additive measures

  We need to support non-additive measures in our cube, such as rates. The rates will be averaged across time by using a custom formula (weighted average). The rate measures cannot be aggregated by any other dimension. However, when the end user browses by the Account dimension (each member in the Account dimension relates to exactly one record in the fact table), the user must be able to see the rates. I set the average function of the rates measures to None. How can I surface the rate measures from the measure leaves to the Account dimension leaves Hi, Mosha. I appologize for not making this clearer. The measure group is already created. The lowest grain is the Account dimension. The measure grou ...Show All

• droujav Merge Statement

  Is there a merge statement in SQL Server 2000 I want to combine update and insert statement into single statement as follows. MERGE INTO MyTable USING MyTempTable ON MyTempTable.MatchingField1 = MyTable.MatchingField1 WHEN MATCHED THEN UPDATE UpdateField1 = MyTempTable.UpdateField1 WHEN NOT MATCHED THEN INSERT VALUES(MyTempTable.MatchingField1, MyTempTable.UpdateField1) Currently if I try to run this stmt, it gives error "Incorrect syntax near the keyword 'INTO'." Thanks We are considering adding MERGE feature in a future version of SQL Server. It has been requested frequently. For now you have to use a technique like Adam outlined. No, SQL Server has no such statemen ...Show All

• esaba.keith.cz FlatTextFile Licence Limitation with SQL 2005 Standard

  I have developped a package that loads a flat text file into DB. Runs OK from SQL BI Studio. When I run it from SQL IIS, I have the following error message "Erreur, le niveau de produit est insuffisant pour composant <<file IN>>" that let me think this FLATTEXT ConnectionManager is only in SQL 2005 Enterprise version Can you help Please check out the following thread -- I don't think it's just the flat file connection that will give you trouble: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=806065&SiteID=1 Hope that helps you! - Mike Darren, I tested it again. Using TSE on the SSIS server directly. No problem when executing the D ...Show All