Answer Questions

• hadjici2 cannot access database properties

  Hello, The code: Database db = new Database(localServer, database); SqlPropertyCollection collection = db.Properties; foreach (Property property in collection) { //DoStuff } The error: Microsoft.SqlServer.Management.Smo.PropertyNotSetException: Set property ActiveConnections to accomplish this action. at Microsoft.SqlServer.Management.Smo.SqlSmoObject.OnPropertyMissing(String propname) at Microsoft.SqlServer.Management.Smo.PropertyCollection.PropertyEnumerator.get_Current() The error takes place at the first property. Debugging this, I noticed a lot of the properties throw this exception. Why is that The user that I use dbowner on the database and sysadmin on the whole server. Thanks Hi, just found it, the construct ...Show All

• Mark Morgan How can I compare datetime in a query???

  I have a table with the following columns company_Id employee_id logon_time_id logoff_time start_valid_period end_valid_period Employee's working time should only be counted if it is between start_valid_period and end_valid_period So, if I have for employee1 from company1 logon_time_id = 04/07/2006 11:00 loggoff_time = 04/07/2006 12:20 start_valid_period = 04/07/2006 12:10 end_valid_period = 04/07/2006 12:30 I should consider 04/07/2006 12:10 as the initial datetime, 04/07/2006 12:20 as the final datetime, and count only 10min of work to him. In code: if(logon_time_id < start_valid_period) initialDatetime = start_valid_period else initialDatetime = logon_time_id if(logoff_time < end_valid_period) finalDateti ...Show All

• Tej62007 Problem with calculated member (AS2005)

  Hi all, I'm having some strange problems with a calculated member in AS2005. My calculated_member definition is as follows: ([Measures].[measure_1]/[Measures].[measure_2]) Now, i have an mdx query that uses that member. Something like: SELECT [Measures].[measure_1],[Measures].[measure_2],[Measures].[calculated_member] ON COLUMNS blah blah on ROWS FROM [mycube] WHERE some date conditions [Measures].[measure_1] value is 2285.4 (this number is correct, i verified it) [Measures].[measure_2] value is 82.67 (this number is correct, i verified it) [Measures].[calculated_member] value is 14805.03 (WRONG, should be 2285.4/82.67= 27.64!!!) What's going on here I don't get why calculated_member fails, when the measures it depends on are just fine. C ...Show All

• Sanjukta How do I order columns in my custom destination component?

  Here is the situation. I have created a package that takes 50 columns from a comma delimited flat file. I then validate and clean the data. Next I add two columns that were not in the original source file. These two columns need to be in the 5th and 9th column position when the file is then re-written to a text file. How do i get those two columns to write out in the desired order Any ideas K. Lyles You set the order in the mappings to your flat file destination. Set up your FF destination appropriately, then simply drag the columns to their destination. ...Show All

• new2SQLRpt KPI Annotations property field

  If you look through the the properties collection of a KPI in ADOMD, the last item is called "Annotations". Does anyone know how to set this property through BIDS We need to pass additional data to our client app for each KPI in order to make up for incomplete functionality and bugs in Analysis Services in regards to formatting, and we would like to use this field if possible. "Annotations" is not the same as "Description" by the way. We may have to prepend XML data to the description field if there is not an alternative. Any help would be appreciated. Thanks, Terry   Yes, we are using VBA's Format in KPIs. We're using Format_String in calculations. It may be bad practice, but AdventureWorks and all of ...Show All

• Oscarfh RS2005 and SQL2000

  Hi, As per my reading, using RS2005 with backend database as SQL 2000 is possible. Can anyone tell me whether RS2005 connect to SQL 2000 database on same same machine. i.e. in short can RS2005 reside with SQL 2000 Which edition of RS 2005 support backend as SQL2000 TIA, Tanmaya The SQL Server 2000 metadata database backend can be on the same machine or on a different machine. Non-Express Editions of RS 2005 support the internal metadata database residing on a SQL Server 2000 server. -- Robert hi Robert, i've installed RS 2005 developer edition on a pc which i've installed SQL Server 2000 developer edition as well. i've configured everything us ...Show All

• Flakky Can I Use Non-empty Behavior for These Calculated Members?

  I still find myself extremely confused about using the non-empty behavior for calculated members. We have a series of calculated members that we refer to as "Velocity", such as "Velocity Sales". The basic definition for these velocity measures is to get the total from the previous 63 business days and then annualize that total (i.e. multiply by 4), with the 63rd business day belonging to the previous month. For example, Velocity Sales for any day in September 2006 would be totaling the sales $ for the business days in the range of 06/05/2006 through 08/31/2006, and then multiplying it by 4. Perhaps not surprisingly, these measures result in extremely poor performance. Since I'm confused on the non-empty behavior, this p ...Show All

• SillyMS Problems with Nulls and SQL UDT's

  I created a UDT in C# that is working fine except when I request rows where the type is null. If I use SELECT Film.ToString() FROM ImageData it works fine, or any property they return Null as expected but if I use SELECT Film FROM ImageData it produces the error below An error occurred while executing batch. Error message is: Data is Null. This method or property cannot be called on Null values. I looked through all the examples in C# and my code matches the pattern for nulls exactly. Can anyone shead some light on what attribute I may have to add or method I should override which is not documented. This was a bug. Please see http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.a ...Show All

• spree problems with Publish Reports Script File

  How do i make the datasources same path for each report loaded I have 5 group sets I end up manually change the datasource for each one If i can make this script files to do it what changes do i need to make _______________________________________________________________________ ' Publish Reports ' Adapted from Microsoft Publish Reports Sample Script File Dim parentfolder as string Dim definition As [Byte]() = Nothing Dim warnings As Warning() = Nothing Dim parentPath As String = "/" + parentFolder Dim filePath As String Public Sub Main() rs.Credentials = System.Net.CredentialCache.DefaultCredentials Dim name As String parentfolder = "DataSources" parentpath = "/" + parentFolder 'Creat ...Show All

• Kimberly Wheeler Everywhere Edition and VS Express

  Is Sql Everywhere supported by VS Express Edition Steve Tasker's team video mentions something at the very end which made it appear that it would not work. The Express IDES only support connecting to the Local SQL Express machine using the database wizards, this means that you need to have the sql server Express system installed as ./SQLEXPRESS. If your express database does use a different named instance the system will not connect. As for other databases it is possible to connect to the database engines but you will need to code the database layer by your self in code. Once the connection is made if you do wish to use the binding wizards you will have to expose the data as objects, then you can ...Show All

• Reva Access to the remote server is denied because the current security context is not trusted.

  Hello, In SQL 2005, from a stored procedure in a local database I am attempting to execute a remote stored procedure in another database on another server. I am getting the error referred to in the Subject when the local stored procedure tries to execute the remote stored procedure. A couple of comments: The remote database is set up as a linked server in the local database. As part of the linked server definition I selected the 'be made using this security context', and provided a local user name and password. The remote database is set to Trustworthy. I have tried every combination of WITH Execute As on the remote stored procedure but nothing works. I can query against the remote database successfully within Management ...Show All

• brettlee01 Aborting a thread CRASHES Sql Server 2000!

  Hi, I'm creating a new thread and executing a database import operation using a transaction. I have had several problems that I cannot explain, the most serious of them being that aborting this thread sometimes crashes the instance of Sql Server to which I was connected! The application is a Windows Forms app, and when I launch the import operation I display a form that allows me to abort the import while it is in progress. If the user decides to abort the import in the middle of things, I call the Abort() method of the thread executing the import. I'm catching any exceptions in the method on the bottom of the call stack (the ThreadStart delegate) and logging the information, and from the stack trace I can see that the ThreadAbort ...Show All

• fa6ma Synchronization between stored procedure calls

  How would I synchronize the stored procedure calls so that if one call of an stored procedure is amid doing some stuff, the another call to same SP will wait until first call is done. Is there any Mutex, Semaphore thing in SP I will appreciate inputs here cant u do it using a caller procedure and call them in a sequence... You could create a table and lock data in this table at the begining of each SP ...Show All

• Andijk ReportViewer 2005 InValidOperationException

  Hi, I am using VS 2005 and ReportViewer 2005 web control in ASP.NET 2.0 web application. I am building custom page to host reports in web application. The website is running under known NT account that has rights to the remote Reporting Server. On the page I am using ReportService2005 web service to retrieve the list of available reports on the server and then trying to use ReportViewer control to display the selected report. I can connect to the remote Reporting Server through Web Service fine and able to retrieve all the data. I can also retrieve the report using the web service. However, when I set the URL and Report path in the ReportViewer control I get following error: Exception: InValidOperationException Message: Clien ...Show All

• sheeja System Administrator Privilege

  In SQL 2000, how do I grant system administrator privilege to "sa" or a Windows User The above links says about SQL Server 2005 version. In SQL 2000 also SA account in SQL Server has already got these permissions. To grant such permission to a windows user then add that user to SQL Server ==> Security --> Logins and then grant Systems Administrator privilege under server roles pane. I am guessing you are trying to add a principal to the SYSADMIN fixed server role. For SA, you don’t have to do anything, SA is always a member of SYSADMIN; for any other principal you can use sp_addsrvrolemember ( http://msdn2.microsoft.com/en-us/library/ms186320.aspx ) and sp_dropsrvrolemember ( http://msdn2.microsoft. ...Show All