Answer Questions

• Gary Trembath does anyone know how to run a batch file using vb script?

  This is not working. Set oShell = CreateObject("WScript.Shell") oShell.Exec "test .bat " That doesn't seem to work. The error is can't find specified file. Try the "call" command. it works in similar scenarios. I have not tested it in vb script from SSIS but it should work just fine. Here is the modified command: Set oShell = CreateObject("WScript.Shell") oShell.Exec "call test .bat " Thanks, Greg Van Mullem Try Run instead of Exec. Set oShell = CreateObject("WScript.Shell") oShell.Run "test .bat " ...Show All

• Luhar Prolonged execution for table UPDATE statement - not sure it finishes

  I am cleaning up a large database table that has Date keys instead of real DateTimes. To do this, I am running the following query... UPDATE MQIC.DBO.OBSERVATION_F SET MQIC.DBO.OBSERVATION_F.OBS_DATE = MQIC.DBO.DATE_D.ACTUAL_DATE FROM MQIC.DBO.OBSERVATION_F INNER JOIN MQIC.DBO.DATE_D ON MQIC.DBO.OBSERVATION_F.DATE_KEY = MQIC.DBO.DATE_D.DATE_KEY where Actual_Date is what is being stored, and the Date_Key is to be dropped. The particulars are this - Date_D table - 92,000 rows - 40 MB Observation_F - 20,000,000 rows - 3.2 GB This is being run on a remotedly hosted rack server with an AMD processor, 1 GB RAM, 60 GB harddisk space, 20 GB used. SQL-Server 2005 Express - SP1 If I do the same query as a SELECT statement... UPDATE MQI ...Show All

• payal tandon Login failed for the user (using windows integrated security)

  Hello Everyone, I am trying to connect SQL database through code but I get this error,I have spent days to solve it but unfortunately I couldn't...Here is my code in VB express(OP:windows 2000 with SP4)I am new to VB,so it makes the situation more difficult for me. my code is: Public Class Form1 Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim conn1 As SqlConnection = _ New SqlConnection( "Data Source=.\SQLEXPRESS;" & _ "Integrated Security=SSPI;" & _ "database=deneme3_database;" ) 'Open connection conn1.Open() MessageBox.Show( "Connection succeeded." ) 'Close conn ...Show All

• CaptBeagle Binary Data on Multiple Servers

  I'm using EncryptByKey to encrypt data in my SS2005 database. Since our server is really slow to access from home to work on, I used the Database Publishing Wizard and installed the db to work on at home. Then I created the certificate and symmetric key in my home db. When I pull info using the DecryptByKey on our database at work on Windows 2003 Server, no problem, the data is decrypted. However, the same data does not decrypt at home on my Windows XP computer. I'm using TripleDes on both machines for the symmetric key (AES won't work on XP). --To create my cert and key: USE My_DB; CREATE CERTIFICATE MyCert ENCRYPTION BY PASSWORD = 'some password' WITH SUBJECT = My Data', START_DATE = '01/01/2007', EXPIRY_DATE = '01/01/2099' ...Show All

• remo.waller Storing calculated measures into existing measure groups

  Apologies if this is a really obvious question, but how do I put calculated measures into existing measure groups I have a calculated member Z that's defined as Measures.X / Measures.Y. I want to put Z in the same measure group as X, but I don't see an option to do so on the "Calculations" tab. Thanks! Not sure what would it mean to "put" calculated measure into measure group. You can specify AssociatedMeasureGroup for calculated measure, but it has no meaning for semantics or functionality, perhaps some effect on UI - i.e. in some client tools such calculated measures will be grouped together with measures from their measure group. In the calculations tab in the cube editor yo ...Show All

• spelger Nested filtering in Ad Hoc reports?

  There are many business users in my office who would like an AD HOC reporting system. I am not in a position to install the entire suite and check it out myself. I have seen some presentations and i like the tool for the most part ...I have some questions if anyone can help.... 1. Can the user specify more than one condition in the filter. Like Name = X AND Address = Y AND Job = Z 2. Can the users sort on more than one column 3. Can the users group by on more than one column. Nested grouping I'm assuming by "Ad Hoc" reports you mean creating reports using Report Builder. If so, then the answer to all three of your questions is YES. ...Show All

• Battlekiller Asynchronous events to database clients via DAL?

  Greetings, I have a requirement for a SQL Server 2005 database to notify 3rd Party applications of a table change. As is stands now, 3rd Party applications access the database via a Data Access Layer (DAL) dll (C#). I'd like to somehow implement an asychronous event notification scheme via the same DAL to these clients. Can someone offer a clever way to implement such events Broker Services I am under the impression the SSBS is typically deployed when databases are to communicate with one another. Triggers to call some CLR code Other Thanks in advance, Loopsludge Greetings Remus, Sorry it has taken me so long to respond. I have been exploring Query Notifications. I'm still not certain this is the ...Show All

• SCRunner Package Variables Not Available at Runtime

  Hello, I have three package variables that I need to have access to at runtime. All three variables have package scope. The first two, 'StartDate' and 'EndDate' are DateTime variables. The third is called FilePath and is a String variable. I have taken the following steps; 1. Enabled package configurations 2. Set up all three variables as Parent Package Variables, and have targeted the 'Value' property for each. 3. In the properties of the solution, I have set AllowConfigurationChanges to True. 4. After the package was built, I ran the Package Installation Wizard from the Manifest. I have done both File System and SQL Server installations. When I go to run the package, none of the three package variables are available for modifica ...Show All

• Whoisit Aggregate() function not working when a measure is not specified.

  Hi, I am new to Analysis Services, having used it for less than a month. I do apologise if this problem is the result of a stupid newbie mistake, but I could really use some help. I am totally unable to get the Aggregate() function to work unless I specify the optional measure. I have build a cube from the Adventure Works DW database, based on the internet sales fact table and related tables. I used the wizard to design the hierarchy for the time dimension. Both of the following queries fail with the same error message: Query 1: WITH MEMBER [Time Aggregate Test] AS 'Aggregate({[Ship Date].[Calendar Year - Calendar Semester - Calendar Quarter - English Month Name - Day Number Of Month].[Calendar Year].&[2002].&[2 ...Show All

• clint 2 Create new database as a user instance

  Hello... Is there any way to create a new database directly as a user instance. I guess this means creating a new mdf/ldf pair which is detached from the server after its created. Thank you... Hi Mike, I'm creating a database installer for a client/server application. The installer will run on server and I want to provide the end user (administrator of the application) with the option to create a database registered under an sql server instance (the classic way) or create a database by providing a path for an mdf file where the database will be created as a user instance. I know this database is accessible only by the local machine. This is no problem since only server code (ASP.NET Web Services app) can access the database. ...Show All

• kevinrj0314 Microsoft.SQLServer.ManagedDTS.dll reference error in VB.Net 2002

  I am using VB.NET 2002 and we have set up a test environment running SQL Server 2005. I am trying to add a reference to Microsoft.SQLServer.ManagedDTS.dll which is required to run a DTS/SSIS package from VB.NET. However the dll does not show in my add reference listing so when I select BROWSE and select the actual DLL I get a rather long error message telling me that only 'dll' and COM components can be referenced. The exact message is: A reference to 'C:\Programs Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll' could not be added. This is not a valid assembly or COM component. Only assemblies with extension 'dll' and COM components can be referenced. Please make sure that the file is accessible, ...Show All

• furjaw Login failed for user 'Domain\userId'. [CLIENT: <local machine>]

  I have a strange problem. I have installed sql server 2005 w/ SP1 (developer version) in my local. After the installation the event log shows the following error message: 2006-10-25 01:25:27.59 spid9s Clearing tempdb database. 2006-10-25 01:25:27.89 Logon Error: 18456, Severity: 14, State: 16. 2006-10-25 01:25:27.89 Logon Login failed for user 'Domain\userid'. [CLIENT: <local machine>] 2006-10-25 01:25:28.09 spid12s Starting up database 'msdb'. (Obviousely, I have removed my id for security reasons) The real problem is that I couldn't connect to local or any remote servers using my Sql Server Management Studio . I have spent a lot of time on the forum(s) to find an answer, but seems to me that it is an "unknown" ...Show All

• btravis Can't set the owner to the current login

  I'm using express edition, compatibility set to 2005. I'm logged in as DOMAIN\user , using windows authentication. When I try to set the owner to this login, I get a "login does not exist on the server" error. Setting the owner to sa works fine. Any fix to this problem Also - can I just work with the owner set to sa or can this cause problems in the future Thanks. The property that I'm trying to set is the database owner - in the database properties' files page. I need to do this in order to use diagrams, which are not available without a valid owner. Buck, Thank you for trying to help. The diagrams work fine - but the thing is ...Show All

• tenchyz SQL Server 2005 Performance issues

  We are having serious issues after our migration to SQL 2005. A little history before getting into the problems. We moved all our OLTP databases to a new installation of 2005. This was a migration to a new server and not an upgrade. The server itself is an active\active cluster with OLTP on Node 1 and Reporting Services on Node 2. The server is an X64 with 64-Bit Windows 2003, 64-Bit SQL Server Standard Edition, 16 GB Memory running on a SAN. Our Data files are spanned across three raid fives with Non Clustered indexed on one and the other two are the filegroup default. Our log and temp files are on a seperate drive. Issue #1 - Query performance for some not all is horrible. Queries were returning in minutes on 2000 are not return ...Show All

• Reid Westburg High level of login/sec

  Hi All Perfmon shows max 3900 login/sec and avg is 1500. ASP.NET v 2.0 application uses this SQL 2005 server consists of 10 webservers. Max Pool Size on each was changed today to 300 (was default so I suppose - 100) and it didnt change logins/sec graph at all. Application uses SqlConnection object from ADO.NET v 2.0 obviously. Can someone explain - what could be reasonable explanation - is load that high Do we need 3000 as Max Pool Size (I cant imagine what could be maximum recommended size of pool for W2003 32-bit server) Thank you I just ran through this same issue with MS support. They pointed me to the April 2007 books on-line and the entry for the Audit Login Event Class. Here it is ...Show All