Answer Questions

• Etienne Tremblay Installation of SQL server 2005 Developer Edition Sep CTP

  Hi, I am trying to install SQL server 2005 Sep CTP on my laptop... I have installed VS.net 2005 beta 2, my OS is XP Pro SP2. It always get hanged at "Detecting Installed IIS". Please help... thanks Sorry for not able to reply before... yes... that norton security center created the problem... i did the same thing and it is working fine now... thanks for you reply... Do you have Norton Security Center by chance... I had the sam ...Show All

• Samir K Subscription limit

  Helo, what is the limit of subscriptions that we can create for a publication created in SQL Server 2005 . The subscriptions will be SQL Mobile databases running in Pocket PC and synchronizes using merge replication technique. Positive replies are highly welcomed. Thanks and regards, Shanavas For SQL Server 2005 Workgroup Edition, there can be a maxmium of 25 merge subscriptions to the same Workgroup instance. (The maxmium number of trans ...Show All

• Rupesh Bhurke Not all parent pkg vars get set

  We have discovered a problem where any parent package variables below one that fails (from not being defined in a previous parent) will not get set as well. For instance, say I have 3 packages (respectivelly named A, B, and C), pkg A runs and defines var1=True, then B runs and defines var2=False, and finally C runs and defines var2=True and calls package B again. Var1 will fail because it couldn't get set in th ...Show All

• Gmumumbuh High Performance in Mirror

  In this mode, I get that it's asynchronous. Does that just mean it sends the TX over and what happens, happens Do I at least know it hit the comms stack, or the wire or anything Or just it will do its est. Thanks. You are referring to the mode when transaction safety is OFF. In this case, the principal sends the log to the mirror but does not wait for acknowledgement from the mirror. So Mirror can lag the Prin ...Show All

• Crouchie1998 How to view Cube in WEB Browser(IE) like Pivot tables of Excel

  hi,Please! Help me.How to view Cube in WEB Browser(IE) like Pivot tables of Excel.  Your help is highly appreciated. Enclosed is the reply I got from the OWC team. Let me know if this is what you are looking for. OWC can connect to AS 2005 using the connection string property and either the data member or command text properties. PivotTable.ConnectionString = “PROVIDER=MSOLAP;Data Source=[Valid Server Name];INITIAL CAT ...Show All

• Lorren Directly editing data in results pane with SQL 2005 Management Studio

  In SQL 2000 Enterprise Manager, one was able to edit and commit data on-the-fly directly from the results pane.  Action->Open Table->Query with the SQL Pane shown gives you an interface similar to Query Analyzer.  One could write a complex select statement with where clauses and joins, and the results pane would show the resulting data.  The data is editable and instantly updated.  We are now planning to migrate to SQL ...Show All

• Kevin Using Forms authentication in scripts

  We have customized the report server to use our forms authentication. Our authentication expects a cookie. Now if I want to deploy reports using a script, how do i do it . I tried specifying rs.exe <filename> <username><password> but then it does not work as the cookie doesnt exits   Any ideas how this could be done We do not want to use the report manager to deploy reports as we want an automated process. ...Show All

• Goran Glisic hyperlink open new window

  I have a link on my report which open new window. The code i have in advance properties of that field is : ="javascript t :void(window.open('http://www.msn.com','_blank'))" (note: the extra " t " is intentionally added in the code, coz website block the keyword "java.....t") It works great on testing server but it doesn't work on production server. Both testing and production servers run windows 2003 serve ...Show All

• z1000 running DBCC Shrinkfile code, from where?

  SQL2000 Server, SP4, a database with a 17Gb log file. It has been backed up so all transactions should be validated, now the real file size needs to be shrunk because I need the diskspace plus I want to speed up the backup process. http://support.microsoft.com/kb/272318/ Tells me what to do but not where to do it. So I need to run this code : DBCC SHRINKFILE(pubs_log, 2) but from what console do I run it ...Show All

• Nowandever29 SQL 2000 and 2005 on same server

  Does SQL Server support instances of SQL 2000 and SQL 2005 on the same server If so - are there any instance naming standards to follow for this scenerio Thanks -J Sune is correct, this is a fully supported configuration, so long as you are not running on a cluster solution, which is a different story...there are many, many deployments with this configuration currently, including my own :-)... As ...Show All

• Madisn Open Navigation Link in a new window

  I have a report with a hyperlink. When I go to the navigation tab, it does not give me any options to open the link in a new window. I have a link to show help and I do not want the user to actually move away from the reports Any ideas This is such a simple thing..I wonder how MS misses this One way of doing this is to use an expression like this for the hyperlink action ( Note - I had to insert a blank between 'java' and 'script ...Show All

• joynt Combine two database

  I have a two databse say DB1 and DB2 in sql server 2005 developer edition. Both Databases are completely different in structure(i.e nothing common) Both Databases contains Important Data. I want's to combine them into a new database named dbcombined.{provided that data remains intact}. How can I do That Then Also I have to deploy that db in other system what I have to do No There is nothing Common in Between two DataBase.(i.e no common t ...Show All

• Nancy Hidy Wilson Setting the value of a Report Parameter Programmatically

  Is there any way to set the value of a parameter from custom code I am working with a simple string parameter called @City (the name of a city, used in the WHERE clause of a query). I have tried a number of approaches that all wind up doing something like this, Report.Parameters!City.Value = "Fairhope" Visual Studio Report Writer returns this error when the report is previewed, "Property 'Value' is 'ReadOnly'." T ...Show All

• M.KhoshZaban SQL Express Reporting Services

  Wow! We get reporting services in SQL Express. Excellent! Now, how do I save/deploy a report. Can we set up a report server locally. I feel a bit cheeky seeing as how this is all free, but where are we supposed to store the reports we create in the (free! thanks!) Business intelligence tool. Cheers Mick Does this mean that I cannot setup linked tables (DB2 and Informix) in SQL Express and use Repor ...Show All

• Asim A Application as service inside SQL possible?

  I would like to run an application inside SQL CLR as a service so that once started it continues to run until explicitly shut down. The application would sit idle and only wake up in response to data coming in from data acquisition devices over serial ports (COM ports). Is this possible I read somewhere that this would be supported, but I have not been able to find any information on how to do it. Any help or pointers would be greatly appreciate ...Show All