Answer Questions

• RoboSchro service broker error : Connection handshake failed

      When I configure SSB in two machine to send message, I get a error message in target machine SQLProfiler:     "Connection handshake failed. There is already an existing connection with the same peer and this connection lost the arbitration. State 80."     Then I get another message "This message could not be delivered because it is a duplicate.", but I am sure the configuration of routes is r ...Show All

• HouZhenYu Need help to install sql reporting services

  I am trying to install sql reporting services and getting stopped in few places. First Reporting Services Virtual Directory window complaints about SSL and I just uncheck the box. But the major issue I have is when installation wizard asks about sql server instance. No matter which instance and Credential type I put (I tryed all possible variations), I would either get this message: 'Not Associated with a trusted SQL Server Connecti ...Show All

• Vijay1978 raw file source avoid bad data?

  I want to have a data flow like this: 1. raw file source 2. validate data or conditional split 3. sql server destination there is some bad data in my raw file.  by bad data I mean datetimes that are out of the range that sql server can handle. this should be simple right Well then the fact that its in a raw file is irrelevant. Your issue is the conversion between Oracle data types and SQL data types. Wha ...Show All

• Javed Hasnain MS Word rendering extension

  When rendering extension for RTF or Doc or WordML will be available Will it be released in service pack for SQL2K5 or it will be released in next version of SQL Server These items are on our wishlist for the next version. Thanks, Chris While SSRS does not have it, check out our new product, we've done just that. Export reports to DOC, RTF and WordML. Aspose.Words for Reporting Services - http://ww ...Show All

• A.Kahn vwd 2005 with sql 2005 express database.

  Hi, I have vwd website on my home machine and I need to find hosting. My first Q is: Is there any difference between the file structure of an SQL Server 2005 Express database file and the file structure of a full version SQL Server 2005 database file Most of the hosters say they will not host Express. I can't tell whether they are referring to the server software or the file itself I know that they host SQL 2005 databases. And I think the ...Show All

• CodeMaker Foreach loop for DBASE IV problem

  I've followed the steps on how to use the ForEach loop container using a Flat Text file and it's working fine. I tried reading the text file and put it in my SQL table. However, I have some DBF files as well and the ForEach loop does not work at all with my DBF files. Here is my scenario: A connection manager pointed to C:\DBF_FILES On the Control Flow: a Foreach loop container with Foreach file enumerator. (checks for IFUL*.DBF files ...Show All

• vaidhe SQL 2000 Xtended sp's

  Trying to assign correct userids to DB Maint procs and when I attempt to display properties of procedure, I get the error message; Error 2812: Could not find stored procedure master.dbo.xp_regread The procedure xp_regread is present in other instances of the server but not the one I'm trying to configure. Is there a way to restore procedures in the master db with re-installing Hi, You can check if ...Show All

• shango How to detach deleted databases?

  I asked this question in the Tools General forum but received no response. Does anybody is this forum know how to resolve this problem Here it is again with a bit more info: When I ran sseutil -l, I discovered several databases that were still attached. However, they were old test projects that had previously been deleted. How do I detach them if they no longer exist Using the detach command will not work ...Show All

• Manip SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• Tyler Miller Studio query results returns NULL data as actual "NULL" string

  I'm using SQL Server 2005 Management Studio and when a query returns NULL data in a column I get the actual string "NULL" output in the results. Is there any way I can stop this from happening Hi there, You're absolutely right but that gets tedious if you have wrap thirty or forty output columns with the ISNULL. Thanks anyway, Happy New Year! Hi Steven, "I've  ...Show All

• sumana List of Approved Assemblies

  Where is it documented what the list of approved assemblies are for SQL 2005. Also, is there a way via T-SQL, or other means to get it programatically Didi you already try to query te system table sys.assemblies Select * from sys.assemblies HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Here's a link to BOL that provides this information: http://msdn2.microsoft.com/en-us/libr ...Show All

• Padmanabha a general query and db question

     Hello, I have a couple of general questions that don't require help figuring out as much as help pointing me in the right direction.   I have a table that has 3 columns. it basically contains links to outside urls that contains these columns URL     ID      description.   Now I was thining that since each url is different and that I want a easy way to check ...Show All

• Hamish_NZ Need Help about Initial Snapshot

  i have created a publication whereas i have provided a network path to its snapshop folder e.g ( \\server\folder ) at time of creating. When i try to make a Pull Subscription and follow all steps of wizards, it gives me following error " The initial snapshot for publication '---' is not yet available". can you guide me what are causes of this problem and how may i solve it Thanks for help. Regards, Dear Greg, I am facing t ...Show All

• Danut Prisacaru Problems with Service Pack 4 for Analysis Services

  Hi All, I just installed Analysis Services SP 4 on our database server. We are having major problems with our DTS packages and our OLAP cube processing. Anybody got any ideas I did have to apply the  "msmdsvr.exe" fix before installing Analysis Services.  This is documented fix by which the msmdsrv.exe file is renamed prior to the installation of AS SP4. Symptoms:   Cubes not completing processing or taking much longer than befor ...Show All

• HelloHello How to sync database latest data with Analysis service

  Hi, I am creating sql server reports using analysis service(using cubes and dimensions). After creation of cubes and dimensions for existing data I deployed it. Then I created reports on this data. Reports are generated properly for existing data. But the report is not showing newly inserted data to database (latest data inserted after deploying analysis service). Did I miss anything Or any new configuration required Newly added ...Show All