Answer Questions

• iayman Database.Create()

  I'm looking at using SQL Server SMO to create databases dynamically from a code generator that I'm writing that will use UML class diagrams of business entities as the input metadata. Is there a sample for using the Microsoft.SqlServer.Management.Smo.Database class, and specifically the Create() method. When I try a simple call to Create() after merely assigning the database a name, I recieve an inner exception stating: "You cannot perform op ...Show All

• Sathya How to add SQL statements to the package created by Export Data wizard?

  How to add SQl statements to the package created by Export Data wizard I need to add SQL coming from file, the flow would be like this: 1) SQL would drop all objects: (views, tables, stored procedures) etc 2)  SQL would create all objects: (views, tables, stored procedures) etc 3) Export Wizard SSIS package would execute Also is there a dynamic way to add more tables do the package once created in SQL database I w ...Show All

• Philip W RAISERROR() is invalidated by xp_fileexist function when run through ADO (example included)

  Help!  Does anyone know why (and how to work around) this situation I have a stored procedure in MSSQL 2000 SP3 defined as follows: CREATE PROCEDURE sp_mycheck AS BEGIN declare @ret int EXEC master.dbo.xp_fileexist 'C:\temp\bogus.txt', @ret OUTPUT                                &nbs ...Show All

• horacy timing out on downloading snapshot ?

  Hi This is to do with HTTPS merge replication. We were getting an error when downloading the initial snapshot. The snapshot was about 25 meg, over an average link. It returned an error after a few minutes - it did start to download the .cab file (it was compressed). By not compressing the cabinet file, it worked fine - I can only presume it was some sort of timeout error. The downside was that the amount of data was much greater, with it n ...Show All

• vkumar Maintenance Plan creation fails

  I've been searching everywhere for a solution to this problem and no answers exist anywhere. When I try to create a new maintenance plan I get the following error. I've been told it may be related to SSIS but nobody has a solution. How do I fix this issue so I can create a maintenance plan. Exception has been thrown by the target of an invocation. (mscorlib) ADDITIONAL INFORMATION: An OLE DB error 0x80004005 (Client unable to establi ...Show All

• Insecurity Check if cube exists

  How can I check whether a cube exists and make the control flow dependend on that Thanks for help!! Note: I found the Microsoft.AnalysisServices.dll, but how can I reference this assembly in SSIS Could you give me a small example There is only little information available in the SQL Server help. The help for AMO shows me, there should be a Microsoft.AnalysisSer ...Show All

• lakis Consistent Deadlock, need to identify the rogue PAGE lock

  I'm having trouble tracking down a deadlock in a large multi-threaded application. I have been able to gather some information, but not quite enough to identify the two queries at fault. I collected the following by turning on the -T1204 and -T3605 parameters: Deadlock encountered .... Printing deadlock information 2006-04-13 09:13:48.70 spid3 2006-04-13 09:13:48.70 spid3 Wait-for graph 2006-04-13 09:13:48.70 spid3 2006-04-13 09:13:48.70 ...Show All

• vcboy Rebuilding dimensions with huge fact tables

  Hi, I have a dimension which is used in two Measure Groups. It has many levels (let's say 10). One fact table handles level 1-8, the other 8-10. The facts are huge, about 2 billion records for the first table (for level 1-8) and 100 million records for 8-10. We discussed a fitting partitioning schema and this will not be the big issue. Our problem is, that in the last levels (9-10) members can move from one parent to another. Tha ...Show All

• SFSW combine 2 select count datediff

  I have created two select clauses for counting weekdays. Is there a way to combine the two select together I would like 1 table with two columns: Jobs Complete Jobs completed within 5 days 10 5 ------------------------------------------------------------------------------------------------- SELECT COUNT(DATEDIFF(d, DateintoSD, SDCompleted) - DATEDIFF(ww, DateintoSD, SDCompleted) * 2) AS 'Jobs Completed within 5 ...Show All

• bruce2005 Install Error with Sept CTP

  Hi all, I am running into install error when prompted "PLEASE INSERT DISC 2" when I am installing with virtual drive using Daemon Tools instead of from CD or DVD.  I am a Universal MSDN Download Subscriber, but apparently MSDN don't support install issue with beta version of their product.  I am stuck with not able to use this app, and any help is much appreciated. Sincerely, -Lawrence Great!  I ...Show All

• Dragan Panjkov Connection problem to SQL Server Standard Edition

  I posted the following question in the VB forum but thought that it might be better in this one. I am new to VB. I am trying to connect to a SQL Server 2005 data source by creating a new data source. I am receiving the following error: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not a ...Show All

• gugu How to quickly evaluate SSIS, programmer perspective

  SSIS looks interesting .  I haven't loaded any Yukon or read the 2005 BOL, so I'm coming in with a clean slate. In the past I have found the graphical programming interface for DTS, limiting, annoying and unnatural.  I much prefer coding in an OO language the conventional way. I'm interested in evaluating SSIS as quickly as I can.  The ideal is programming with a standard .NET language.  I am happy if a de ...Show All

• jresnick Questions about data mining programmality

  Hi, all here, I have a question about having data mining progammability. I mean is there any functions we can not realize through data mining graphical user inteface Otherwise cant see any point to use data mining programmability which is a harder way compared to available graphical user interface for data mining. (it is just like because you can do things in a hard way dose not mean you have to ) Thanks a lot in advance for any guida ...Show All

• Dariusdm Full Text Search component problem

  Hai i having Mssql Server 2000. My System OS is Windows xp and Ram 1 Gb I having Install MS Sql Sever Service Pack 3 in my system. then i install Full Text Search component I run this Command SELECT @@VERSION Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2) SELECT SERVERPROPERTY('productversion') return =8.00.760 ...Show All

• siddharth_V Matrix Column Trouble

  I am trying to add an ungrouped columns to the end of a matrix. in RS SP2 2000 For example how do I add the three columns in red to a matrix in a report Q1 Q2 Q3 Total Percentage Turn Over Ratio Budget Variance Sales 100.00 100.00 100.00 300.00 100% 1.23 4.22 Cost 100.00 100.00 100.00 300.00 100% 1.23 4.22 Expense 100.00 100. ...Show All