Answer Questions

• Christian Sparre change Parameter order

  Hello, I'd like to change the order in which Parameters are displayed. When I go to the menu Report - Report Parameters and change the order with the arrows displayed - I'll get the following error msg.:The value expression for the report parameter contains an error:The expression contains a non existing parameter in the report parameter collection. Any ideas to change the order Edit the XML File Thanks! Thats right they depent on each other but this was automatically. How can I turn that on or off And if I turn that off - will my procedure to switch the position of the Parameter fields work Thanks! I'll refer you to my previous answer in which I stated that you can't expect to put the WHERE clause back in and expect to re ...Show All

• M.N. Ahmed Sahib SET IDENTITY_INSERT Question

  I want to use the SET IDENTITY_INSERT ON command so that I can insert a bunch of records and establish the links myself based on the ids i used. I have a table with an identity column which is a FK in another table. I need to insert into table one, then carry that id to table 2 as a fk. There is no unique value for me to tie to so I wanted to ReSeed the identity column to the number above what I am going to insert and then turn off identity insert so I can insert between the present spot and where I reseeded to. This will allow me to know the id's and assign them myslef. My question is two fold. 1. When I set Identity_Insert On does it only affect my batch, or the connection, or the whole server Essentially, when ON can other peopl ...Show All

• winstonSmith Installing SQL Server 2005, Detecting Installed IIS

  When trying to install SQL 2005, the installation halts at "Detecting Installed IIS". From a previous forum discussion I tried disabling Norton Anti-Virus and Firewall, but the install still does not get past this point. Please help. I cannot find the text string "return value 3" Would you be opposed to me emailing the log files to you You can email me at sql2005_help@yahoo.com . Thanks for any help you can give me. No, what should I be looking for Since the install seems to be hanging, the logs probably won't be of much use. Go ahead and send me the zipped up log files to samles@microsoft.com . I c ...Show All

• elvis_is_dead Can't connect to SQL Sever 2005 after upgrading from SQL Server 2000

  I recently upgraded from SQL Server 2000 to SQL Server 2005. I have Oracle databases I need to share data with. I was using the Heterogeneous Services (hsodbc) from Oracle and connected to SS 2000 fine. Since I've upgraded, I can't use hsodbc to connect to my SS 2005 database. I get the following error: ORACLE GENERIC GATEWAY Log File Started at 2006-09-06T09:40:07 hoainit (3): ; hoainit Exited with retcode = 0. hoalgon (7): ; hoalgon Entered. name = edw. DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL Server]Login failed for user 'edw'. (SQL State: 28000; SQL Code: 18456) DRV_InitTdp: DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL Server]Login failed for user 'edw'. (SQL State: 28000; S ...Show All

• parreg Package fails when I schedule it.

  Two scenarios, 1 worked, 1 didn't: First package I execute SQL (select top 10 * from MyTable) in my SQLServer2005 database. I scheduled it and it ran sucessfully. I changed the execute SQL to run against an external Oracle database. (Select * from SomeOracleTable where rownum <= 10). I preview to make sure the query works and it does return a result set. I execute the package in the Visual Studios IDE and it works. I save with encryptAllWithPassword to the SQL server. I go into the scheduler and select the package from SQL Server (as opposed to the file system). I set the step to execute the package off the server. I enter the security key by clicking on the configuration tab. I assume it saves the password to the package. I cl ...Show All

• wakewakeup Calling debugger from SSMS

  I realize that the DEBUG capability has been removed from SSMS and moved to the IDe for Visual Studio. As much as that annoys me , I am dealing with it. Is there a way I can open a SP into the debugger from SSMS I very much miss the ability to right click a SP in my list of 300 and choose form edit, run or debug. I dont care if hte debugger is a separate app, can't I have SSMS send my proc to the visual studio debugger Currently I have to open the VS app separately, and then establish connection, and the re-fnd my proc in that very long list of 300 that is in there. Sorry, you need to use Visual Studio to debug stored procedures in SQL Server. No this is not possible. ...Show All

• Suresh Ayyagari Generate Scripts option in SQL 2005 Management Studio

  Did anyone even bother to test the Generate Scripts option for a database I changed the following options from their default setting: "Include Descriptive Headers" = True "Include if NOT EXISTS" = True "Script for Server Version" = SQL Server 2000 "Script Indexes" = True and scripted all Stored Procedures, Tables, User-defined functions, and Views Problems: 1.  Generates IF NOT EXISTS (SELECT * FROM sys.objects ... should be ...SELECT * FROM dbo.sysobjects ... 2. Generates WITH (IGNORE_DUP_KEY = OFF) ... on the indexes. That portion is incompatible with SQL 2000 3.Generates EXEC sys.sp_addextendedproperty ... should be EXEC dbo.sp_addextendedproperty ... Is there a hotfix or patch to deal with these issues ...Show All

• Larry Smith Restoring a databse

  I have a system running on SQL Sever and i am trying to create a second file on a diffrent computer so that I can teach people how to use sql sever (express) without risking losing any data that I have on my proper database. I have created a backup of my database which is in a dmp file and I would like to import this into SQL Server Management Studio Express so that I can make changes to the databse without affecting the one that is running on my website. Cheers for any help What do you mean by dmp file, with which application did you create it Wouldn’t it be better (if you ’didn’t so far) to create a backup file for the restore HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• DD_Helmetman SQL Express SP2 has been released to web

  Last night at home on my 64 bit Vista machine, I encountered the same error 29506 that said that the management studio express could not be installed.  I looked up the error message and below is what I received.  I also installed the 64 bit .net framework which installed just fine before trying to install the SSSME. I followed the instructions below but this did not seem to make a difference.  However, I did not reboot after applying new permissions.  I have installed this software a few times now on 32 bit machines for both XP and RC1 Vista, and have not had a problem.  Last night, I did use the 64 bit version.  Also, there is no data file yet because after the install it rolls back, so I gave myself ...Show All

• Fox3 Allowing users to schedule jobs in Management Studio

  How do I grant a non sysdba user who has bulkadmin and dbcreator rights to schedule jobs on databases they've created The user is a developer and we dont want to give him sysdba rights. http://www.sql-server-performance.com/faq/sqlviewfaq.aspx topicid=12&faqid=137 for your information to accomplish the task. try if this works use the Execute AS command which is used to impersonate any user havent done much of a research on that one but u can easily get stuff on BOL ...Show All

• Ernst Kuschke Problems working with Many-to-Many relationship

  I'm trying to report on Doctor transactions and Doctor Credentials. A Doctor (dim) has many transactions (fact) and a Doctor has many Credential (dim) records. I have tried setting up the Credential/Fact relationship as snowflake through Doctor, referenced, fact and Many-to-Many. Everytime, instead of getting the specific credential records associated with the doctor, I get all possible credential types (cartesion product). Thanks for the help, Dave It's not quite clear how relationships have been defined, but does each Credential record point directly to a Doctor (ie. without a bridge table between Credential and Doctor) If so, you could create a Measure Group on Credential, with a Fact relati ...Show All

• Rob Wheeler BIDS keeps crashing

  All of a sudden one of my projects/packages seems to have encountered a strange problem. First I tried to remove a data viewer which caused BIDS to crash and tell me that VS has encountered a problem and needs to close. This is repeatable every time I try to remove the data viewer or the link or the transforms or the entire data flow. How do I get around this besides starting from scratch and how do I figure out why this is happening and is there some fix thanks John Yep, I didn't catch this because I was searching the forum by the error message and because the problem manifested itself not just with the removal of the data viewer but also when I would remove transforms or connections or even the e ...Show All

• RustyBadger Problem with matrix headers

  hello, I'm having a strange problem with a matrix headers. I can't put column headers above each row group header. There is a merged cell above them, which can't be split. If I have several row groups, including Customer ID and Zipcode, I can't put headers above them to identify them in the matrix. Since both have 5 numerals, they can be confused. Does any body know how to solve this Thanks in advance, Juan David No, I can't do it, I can't do it because I need to place my headers above the rows. I have many rows and the design of the matrix should be with the titles above the Rows. Example: CustomerID Name Telephone ZipCode 112233 Jhon 374564787 55443 22222 Mack 374579879 55443 333333 ...Show All

• Titu Using HTTP Access to SQL Server 2005 Analysis Serveices on Windows XP

  I've configured HTTP Access to SQL Server 2005 Analysis Serveices on Windows XP. Can I invoke SQL 2005 Analysis Services through the web If so, what's the procedure for doing this Any information would be greatly appreciated! Excel also allows you to view OLAP cubes Hi, Not sure if you are just look for web thin clients that interfaces with AS Cubes, or you are trying to write programs that query AS over the web. If it is the former, then you can try any of the thin clients list at the Mosha's blog: http://www.mosha.com/msolap/util.htm#ThinClients I have personally used the "XMLA Browser by XMLA Consulting Inc" product listed there. It wo ...Show All

• learnerplates Print Query

  Hello I wanna ask if there is a procedure that prints out a query result example : exec sp_print 'select * from test' Is there sthg like that Regards thx for ur reply pal well i donno if there is such a thing..but what i want to do is directly print this query result...can sql server do that or not Thanks in advance Hmm. I can't really see what you are trying to do. I mean, select * from test does return the result. Are you wanting it to be treated differently than as a tabular data set Print it to where SQL Server deals with batches of queries that may or may not return a stream of data. You can use SSMS or sqlcmd to view t ...Show All