Answer Questions

• Tryst Web Synchronisation Using RMO

  hi every body please help me out on this issue , since i am at final stage in finishing up the module. Previously i had done web synchronisation using RMO it is working fine at my office where i have an 2003 server which is an domain controller , publisher i have configured on the 2003 server , and i had subscribers on xp Machines where it was well working fine, clients were not on the domain , it is an independent Machine. we had an security error which was resolve by this same forum, ie the client windows login id should exists on the server too. only then synchronisation is happening at our office, Now the problem is i have an same setup , but the server 2003 is hosted at a remote place , which is not an domain controller, n ...Show All

• yeos_lee Dynamically build aggregations

  I have an SSIS process that dynamically builds partitions as new data becomes available in the source system. One thing I am trying to figure out is how to emmulate the "build aggregation" wizard via SSIS. For example, lets say I have a new partition and want to have a higher number of aggregations versus an older one. If I change the aggregation percentage and run PROCESS INDEX, will that take care of it Or lets say I define new aggregations (higher %), dont I have to tell it to point to the next aggregation design So in short, can SSIS mimick the aggregtion wizard One of the things I am struggling with is to understand how the aggregation design fits into all of this. This is probably a second question, but when you dynami ...Show All

• helseruwu wrap text in excel export

  When tables are exported to excel, the text in the cells is automatically wrapped. Is there a way to tell Excel to not wrap these cells when a report is exported. Any/all info appreciated. Thank you. Chicagoclone, Did you find a solution for this it is causing me a lot of hassle at the moment Cheers John I don't think this can be done as in RS the column width is fixed and the CanGrow propety only applies to vertical growth. The only option is to set the column to be wide enough in the first place. ...Show All

• robinjam Drop Down box not showing option

  I'm using a drop down list for a parameter in RS2005. The issue comes when there is only one option. When I render the report inside the microsoft studio it works fine, but when I render the report from the Report Server (web browser) if there is only one option in the dropdown menu then it seems that it is there but I can't see it. It is a multivalued parameter. Is there a way to resize the dropdown list or any way I can fix this Any help would be greatly appreciated. Thanks for your response. I contacted Microsoft Support and they told me I needed an article Number. Do you know that number , If so, can you please send it to me Thanks again, Pilar This i ...Show All

• DonMartin Integrating data from two Tables into one

  Hi all, In case I have two tables. In them there is data and I want to integrate all this data into one table. that is to say Table A and Table B has data (Both A and B are from the same database) I want to integrate all this data into Table c. How do i go about this Regards, Ronaldlee No men, you are not rude. Okay, I do not have any idea about the JOIN or UNION Transformation. May be you can recommend. I need table C to have all the five columns from table A(3Columns) and B(2Columns). Table A and Table B are the source Table C is the target. I need to find a way to join Table A and B.(Is it possible ) Ronald My god this is like pulling teeth!!!!! What transformation do ...Show All

• TWild Transaction question

  I need to select items in Table1 whose column2 value is not 'Processed'. I use the following code to get this working. BEGIN TRAN INSERT INTO @Temp Select Column1 from Table1 WHERE Column2 <> 'Processed' UPDATE table1 SET Column2 = 'Processed' FROM table1 T1 JOIN @Temp Tmp on T1.Column1 = Tmp.Column1 SELECT Column1 FROM @Temp END TRAN Since the default transaction level is read commited, two queries to sproc returns identical results. If I change the transaction level to Repeatable read, this works fine, but the performance degrades. Is there any other alternative which is better than this approach Thanks Pravin   I need this for Sql2005.  ...Show All

• Robert3234 backup of sql2000 databases from sql2005 on the same server

  Hi, I have a sql2000 and sql2005 installation on the same server. Only the sql-agent of sql2005 is active. How can I create a backup job to save the sql2000 databases Thanks in advanced! -wim- ...Show All

• Tryin2Bgood ER-Diagram

  Can we say the Database Diagram generated by Enterprise manager (sql 2000) or SQL Server Management Studio(2005) is ER-Diagram Reply Yes - the diagrams inside SQL Server 2000 and 2005 constitute an E-R diagram. There are several types of those, however. You can read more about them in this series of articles: http://www.informit.com/guides/content.asp g=sqlserver&seqNum=62&rl=1 Buck Woody ...Show All

• Gary Thorne Jr Multi-line subtotal

  Hi guys! I have a problem... I need to create matrix report with 2 total rows... It should looks like: User Name        Col1      Col2      Col3        Total   User1              2            3          2             7                         0      ...Show All

• qayoom Request for SqlCeEngine.Exists(), .Delete() methods

  Given a connection string, I can create a database using a SqlCeEngine object and call engine.CreateDatabase(). However, there doesn't seem to be a way to determine whether a database exists, given a connection string. I would need to interpret the connection string myself and extract the file name to use File.Exists() etc. There should be SqlCeEngine methods to test whether a database exists, test whether it's accessible, and to delete it, given a connection string. Cheers, Oli Hmm...I can get you a work around if you are taking connection string as input. This should help you! conn = new SqlCeConnection(inputConnectionString); if (File.Exists(conn.DataSource)) File.Delete(conn.DataSour ...Show All

• Swamy Kanakala EncryptByPassPhrase and SQL Server Profiler

  Hello, My client wants to encrypt data using sql server 2005 encryption mechanism. But one of the core requirements is that the DBA should not be able to decrypt my data on the SQL Server. I have opted for the EncryptByPassPhrase option. But here is my problem: I call the encryptByPassPhrase function within my stored procedures and I pass in the pass phrase as a parameter in Stored Proc call from the client intranet application. The problem is that one can clearly see the passphrase in the Profiler when I call my stored procedures. I did a bunch of research and found out that if I added a commented out " sp_password " command in my stored procedure, then the stored procedure call gets masked from the profiler. This ...Show All

• thirteenburn Execute Remote Stored Procedure from the receiver's queue

  How can my receiver's queue procedure execute a procedure on another server Everytime it gets to that remote procedure statement, I get DISCONNECTED_INBOUND status. The procedure I want to call is on SQL 2000. The problem was not the security at all. I couldn't execute remote stored procedure when it's in a transaction. For now I have to remove the begin tranaction/commit from the Target's queue procedures.. It's working now. It's the WAITFOR. Remove the WAITFOR and put back the transactions. See this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=555948&SiteID=1 HTH, ~ Remus It doesn't work for me. Can you try that I did try using Sy ...Show All

• jaomello 64-Bit SQL Server 2005 (Enterprise), SQL Agent Notifications and Database Mail

  We have database mail configured on our 64-Bit SQL Server Enterprise 2005 (SP1) and are able to send test messages from the context menu that appears when selecting database mail component. However for some reason when a SQL Agent Job fails, no emails are sent to the 'operator' that has been defined for the job. I have confirmed that we have the operators correctly configured. We also have a small SQL Agent Job that just sends a test email via the sp_send_dbmail command and that works properly. However if I deliberately create a malformed parameter in the sp_send_dbmail command to 'break' it...no notification of a job failure message is sent. I have verified that the service_broker component is enabled...and the status of databas ...Show All

• xdzgor From Job step execute Bin pkg or non-Bin pkg

  Have 10 pkgs in an SSIS solution. All share a common data source but none of the pkgs call each other. I store everything on the hard drive. I build the solution and it builds all the 10 pkgs and places the 10 pkgs in the bin folder. When I call a pkg from a job step, do I just want to point to the pkg in the bin folder. It works either way, calling the pkg in the bin and non-bin folder. Im thinking I should call the one in the bin folder. Or should I be calling the pkg somehow with the syntax - MySSISsolution.Pkg3 You want to use the packages out of the bin folder, unless you create a deployment utility, then you want to use the packages from the deployment folder. ...Show All

• comspy Save some Stored proc in file and create SP from file

  Every day we are restoring prod DB in Development env. I need to save before restore users stored proc, restore DB and after create SP from file. Thanks. The command-line tools may not be adequate because the defaults do not suffice if your definitions are larger than say 8000 characters. And it will be a pain to automate the scripting of multiple objects and so on. Best is to use SQL-DMO/SMO or DTS/SSIS tasks for this. use sqlcmd or osql ...Show All