Answer Questions

• Anand77 get the data directory

  Hi, I am searching for how getting the data directory where default mdf files are based. (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data) My goal is to deploy mdf file in this folder during installation. Thanks Thanks for your help Andrea hi, I'm little in trouble giving advieces as well as registry values are not honored as the seem.. you can query, via a NON documented extended stored procedure the Windows registry for some info.. you can see a HKLM\Microsoft\Microsoft SQL Server key.. SQL Server 2005 registers instances as MSSQL.1, MSSQL.n, and this for every engine type, like Report server, Olap engine, ... but you can get the MS ...Show All

• Rubeus_Esclair How to make table columns invisible

  Hope this is the correct forum for this question. I have set up membership and roles, and have a login function. I am using a grid view and a form view to show some information that is unique to each user. In particular, I want the grid view to show the user’s client list (client first name, last name and email), and the form view to allow input by the user of client names and emails. I have set up the grid view and connected it to a table in my data base. This is a table that includes UserName (which is also in the aspnet_Users table), Client ID (which gets set automatically by the program), clientFirstName, ClientLastname, and ClientEmail. I have a select statement of: SELECT * FROM [Clients] WHERE ([UserName] = @UserNam ...Show All

• Sondre - MSFT Regional Director Headings missing in export of SQL Report to Microsoft EXCEL

  When testing within the development environment, the headings on all pages are exported. When deployed on the SQL Server, the headings (on page 2 onwards) are not exported. Anyone know why ...Show All

• toneho sql server 2005 sp1 installation problem

  When i run sql server 2005 sp1 setup, during setup it authenticates everything except Database engine and reporting services. I m running this setup with administrative previliges.....can any one help regards, Mahmood no i am not getting any error...everything else is authenticated except these two...actully i changed my system password then again revert the password back to original...setup generated error for Integration services but this problem has been resolved.. Did you solve the problem HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- Are you getting an error HTH, Jens Suessmeyer. --- http://www.sqlserver2 ...Show All

• pkrug Inserting to Dimension on Failed Lookup

  First, I'm very new to SSIS, so forgive any stupid questions. I'm trying to normalize some data by creating rows in a dimension table as I find new values in the original table. My first thought is to use a Lookup to replace string values with id's to the Dimension table, and when the Lookup fails, insert the value into the Dimension table with a new key. Does that make sense This would be relatively easy to do with TSQL, but surely there is a way to do this in SSIS. Thoughts OK. Thanks alot. I appreciate your advice. I read that thread, and the example that Thomas Pagel blogs on is what I'm looking for... however, this really seems like an unnecessarily complicated approach. Since I'm new to this, I'm inclined to thi ...Show All

• Woyler Regex oddness in Management Studio

  Running 2005SP1 Development edition, Mgt Studio 9.00.2047.00. Regex replacements at beginning or ending of line does odd things. With the following lines: a b c d e f g h i j k l Putting the cursor to the left of the 'a' on the first line, then selecting to the end (including the l; the above blue reflects what is highlighted), then doing a replace of ^ with ' (replace BOL with quote) results in a 'b 'c 'd 'e 'f 'g 'h 'i 'j 'k 'l That is, it skipped the first line, even though it was highlighted and the cursor was at the beginning of that line. But the odder thing, and the one that's more annoying, is trying to replace end-of-line with something. That is, selecting all lines above again (after the first replacement has added th ...Show All

• Adix SSIS Import/Export flat file

  Firstly, I hope this question isn't asked too frequently but I found no existing reference to this situation.... I had a bunch of stored procedures in SQL 2k which imported and exported data to and from flat files using TEXTPTR, READTEXT, UPDATETEXT etc... The flat files were continuously changing so the filepath was a parameter for the sp. The reason I used the pointer to flat files is because I didn't want to load the files in memory before commiting them ie. with TEXTPTR and UPDATETEXT I can import a 1Gb binary file 80000 bytes at a time and keep (precious) memory usage down. I was accessing this procs from a C# application. Since these methods are going to be phased out by the guys at MS what is the best way of importing/exportin ...Show All

• jgurgen How SQL Server deals with on the occasion if I imput unicode characters into a varchar column?

  Hi all, I want to know how SQL Server deals with it if I imput unicode characters into a varchar column Will it truncate or do something else Thanks! Samsudeen B wrote: Hi Robert, SQL Server implictly converts the unicode character to the Varchar type,If the unicode character is same as the (say English) the SQL Server installed Language ( say Language) and there will not be any data loss.If the unicode character is some other language there are chances of Data Loss Regards, Samsudeen B Hi Sam, I think what you said is right on the occasion that the collation was set to the default SQL_Latin1_General_CP1_CI_AS. But if the collation was set to Chinese_PRC_CS_AI, the s ...Show All

• Joe Horton Analysis Services 2005 Processing Log

  Analysis Services 2000 had a "processing log" that all processing activities could be logged to. Is there a similar capability in Analysis Services 2005 How do I enable it Thanks! Keith Spitz, Software Engineer, Wall Street On Demand You can define ErrorConfiguration object, which contains the path to the processing log or define ErrorConfiguration element if you are processing from DDL script. If you are processing from UI (Management Studio or BI Dev Studio), on processing dialog click on Change Settings and go to the Dimension(Partition) key error tab. Or in SSMS right click on the object, dimension for example, and choose properties->Select a page: Error Configuration. ...Show All

• waheyluggage Icons used in SQL 2005

  I searched BOL, and I couldn't find information on icons used in all SQL Server 2005 sub-systems and what they mean. I am mostly interested in SQL Agent job icons. You'll find most of the graphics explained in each particular topic, other than the obvious red, green and yellow ones. You can also file a question in Books Online by using the feedback, where you can send a screenshot. If the document doesn't have a good explanation, you can ask them for one and they will put in a bug request for you. Buck Woody ...Show All

• Jack Spade Documentation of RMO and Merge Replication

  Hi there, In a lot of the Replication documentation it only refers to the merge agent operating in the context of a push or a pull configuration. i.e. if it is push then the merge agent is at the distributor but if it is a pull then the merge agent functions at the subscriber. I recently joined a project which is configured as a push but it uses RMO for synchronisation. This RMO application is installed on a compeletely separate server. Initially I thought the RMO was just passing requests through to the publisher/distributor/subscriber but the distributor didn't seem to be doing any of the work. It therefore seems that the merging/synchronisation is being performed on this RMO application server and not the distributor or subscriber ...Show All

• pompeyjohn How to truncate complete database?

  Hello, I want to truncate all tables present in the particular database, Is there any simple way to do it or do I have to do it on individula basis (table by table) regards When you say truncate, do you just want to remove all records from all tables The easiest way would be to script out the tables with drop and create statements. To actually truncate the tables, you could write a cursor to loop through the table names and to run dynamic sql to truncate each table. I hope this helps. thanx very much for your support Zadoras wrote: Hello, I want to truncate all tables present in the particular database, Is there any simple way to do it or do I have to do it on individula basis (table by table) ...Show All

• ChopperDavo Report Manager Look and Feel

  Afternoon Ladies and Gents, I have a feeling the answer to this question is going to be a resounding no , but here goes anyway: Can Report Manager be customized If possible it would be nice to add a corporate theme to reporting services but there doesn't seem to be an obvious way to change the default colours or to add company logos. Any ideas Thanks, Chris Hi Chris, have a look at the following thread, which discusses a simular issue http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=396769&SiteID=1 Also an alternative is to use report viewer add in, to either your own asp pages which works with visual web developer express upwards or you can use report viewer with sha ...Show All

• zort15 Loop throught columns of an Excel file using dtsx package!

  Hello, I'd need an help because I'm stucked!! I have to import an Excel file into my DB. The Excel file is made by 2 worksheets but I need only one and inside this worksheet I have to loop through the columns and for each column I define a Data Flow that trasform the data as necessary and then insert into the table. I started with a "Foreach ADO.NET Schema Rowset Enumerator" with connection=excel file and the schema was set to "Columns" but the loop go also through the worksheet that I don't need.. after 4 hours of tries I'm lost... Someone could give me an advice ThankX Marina B. marina B. wrote: Header: pricedate,F2,F3,F4 row 1 : null, typeName1,typeName2,typeName3 ...Show All

• RubenPieters Strange Query Behaviour

  Hi, I am seeming strange results with a query. I have two tables, lets call them Table1 and Table2. Table1 has an ID field, Table2 does not have an ID field. To be sure I wasn't blind, the query 'SELECT ID FROM Table2' returns: Invalid column name 'ID'. OK. Now when I run the query 'SELECT * FROM Table1 WHERE ID IN (SELECT ID FROM Table2)' it returns all the records from Table1. What gives Is this a bug, or am I missing something I didn't find any Strange result here.. You are using Sub Query, here column ID is fetched from the Table1 not from Table2. Try this, Select 100 From Table2 What you got 100 will be return on all the rows Rite. But 100 is not depend with your ...Show All