Answer Questions

• e_LA Cannot add or replace data in SQL express

  In this project I m using SQL Server 2005 express edtion.I can run select queries but I couldnt run insert and update query.Is there any protection for adding data to the Sql Server express edition thanks. thanks Ahmedilyas. There is no error or like that.Seems like everythings ok but I go to the database, there was no changing. like this: UPDATE tblBorc Set bKalan=@kalan,bOdenen=@odenen where tblBorc.bID=@borcid and sending some data like this : borcekle1.borcguncelle(10000, 250000,1); Is there any mistakes thanks. it looks fine, remember, nothing will be returned back from the Update/Insert/Delete command, like it does with a SELECT comma ...Show All

• Fenghus Can't get Instanses of the Report Server through WMI using Non-Administrators access

  I'm trying to conncet to Report Server with Non-Administrator user through WMI in compliance with this document: http://msdn2.microsoft.com/en-us/library/ms365170.aspx When I try to get Instances from MSReportServer_Instance class I get an exception: <Null> The data nessesary to complete this operation is not yet avaible. An error occurred while attempting to retrive the list of objects. In my C# project i have an exception: System.Runtime.InteropServices.COMException (0x8000000A) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext() But, when I give the account Domain Administrat ...Show All

• SavasCilve FULLTEXT query returning irrelevant results with the relavent ones

  Hi, I have the following query running against a fulltext index: sqlComm.CommandText = "SELECT TOP 200 RANK, intID, chLink, chTitle, chDescription, chAuthor FROM FREETEXTTABLE( tblData, *, 'ISABOUT(" + searchstring + " WEIGHT(1.0))') a JOIN tblData b on a.[KEY] = b.intID ORDER BY RANK DESC;" ; Anywas there are certain results that are returned no matter what the query is, along with actual relevant results. One in particular is returned as the top results no matter what I type, even though it has none of the text that I am typing in any of its fulltext fields. Any ideas why this might be happening It looks like you are using freetexttable incorrectly. Freetext ...Show All

• Cameron D Question transport-level error

  Hi all, I'm having a little problem with my sqlserver 2005. I'm trying to crate a user in Microsoft SQL Server Management Studio throug a query. Like this: ------------------------------------------------------------------------------------------- USE [master] GO CREATE LOGIN [MYUSER] WITH PASSWORD = N 'MYPASSWORD' , DEFAULT_DATABASE = [MYDB] , DEFAULT_LANGUAGE = [us_english] , CHECK_EXPIRATION = OFF , CHECK_POLICY = OFF GO ALTER LOGIN [MYUSER] ENABLE GO USE [msdb] GO CREATE USER [MYUSER] FOR LOGIN [MYUSER] ; GO GRANT EXECUTE ON [sp_start_job] TO [MYUSER] GO EXEC sp_addrolemember 'db_datareader' , 'MYUSER' GO EXEC sp_addrolemember 'db_datawriter' , 'MYUSER' GO EXEC sp_addrolemember 'SQLAgentOperatorRole' ...Show All

• furjaw PrevMember Question

  Hello, I am running into an issue where CurrentMember DOES NOT return all members at the lowest level. Here's my dimension Hierarchy --> [Week].[Week].[Week Name] I want to have it return the following when I select [Week].[Week Name].CurrentMember Week of 09/04/2006 Week of 09/11/2006 Week of 09/18/2006 But it is returning at the ALL level All Once I can return all members using CurrentMember, I should be able to use CurrentMember.PrevMember to return Total Revenue for the previous member, same as Lag(1). If anyone can shed some light on how to return all members at the lowest level using CurrentMember, I would truly appreciated! If there's an alternate way of NOT using CurrentMember, please feel free to let me kn ...Show All

• KevinBurton Can you have a drillthrough if your using an AS cube

  Trying to drillthrough one report to another. But im not getting the correct values. I dont know why its not working. I created the parameters and linked them in the properties of the clickable field. What am i missing or is it more complex in a cube to drillthrough then relational tables well i figure this out. Since im using an AS cube, the parameters were looking for the uniquename of the attribute. So when i do the parameter properties, i type =Parameter!County.uniquename instead of =Parameter!County.Value The dropdown displays it when you type the (.) . Hope this helps someone , because i was stuck on this one for awhile. Conceptually, there is no diffe ...Show All

• LANengineer management studio does not work

  Hi, I get TITLE: Microsoft SQL Server Management Studio ------------------------------ Exception has been thrown by the target of an invocation. (SQLEditors) ------------------------------ ADDITIONAL INFORMATION: An error occurred creating the configuration section handler for system.data: Column 'InvariantName' is constrained to be unique. Value 'Microsoft.SqlServerCe.Client' is already present. (C:\Windows\Microsoft.NET\Framework\v2.0.50727\Config\machine.config line 128) (System.Configuration) ------------------------------ Column 'InvariantName' is constrained to be unique. Value 'Microsoft.SqlServerCe.Client' is already present. (System.Data) ------------------------------ BUTTONS: OK -------------------------- ...Show All

• TDT99 The process could not connect to the distributor....

  I have a small problem, I get this following error when trying to start the snapshot agent "The process could not connect to the distributor 'distributor name'. NOTE: The step was retried the requested number of times [10] without succeeding. The step failed. I thought it was related to users or rights but i am using the same user than in previous replication with the server and the rights haven't been altered. I don't know if someone has some knowledge of what to do or a workaround solution, any help would be greatly appreciated. Thank you in advance. You can take a look at the command line of snapshot agent. Take a look at the following paramters and verify they are good. [ -Distributor ...Show All

• Learning VB Merge Replication on SQL Server Compact Edition + SQL Server 2005 SP2

  I followed the tutorial found on http://msdn2.microsoft.com/en-US/library/ms171908.aspx . I have SQL Server 2005 with SP2 installed (NOT an Express version), SQL Server Compact Edition SDK, Server Tools and all other downloads I could find for CE. I'm running it on Windows XP Pro box, with SP2 and IIS 5.1. Entering http://localhost/SQLMobile/sqlcesa30.dll diag results in a page titled SQL Server Compact Edition Server Agent Diagnostics, SQL Server Compact Edition Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5300.0 SQLCESA30.DLL SUCCESS 0x0 3.0.5300.0 Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler ...Show All

• Leo Rozing How to Add Reporting Services in Microsoft Dynamics CRM 3.0

  How to Add Reporting Services in Microsoft Dynamics CRM 3.0 Hi Subodhs, Please Help me out, i am also not able to open System settings and getting the same error as you are getting if you know the solution,please let me know ASAP...Its URGENT....gentle request Thanks & Regards, kunal Dear Mattias, When I click http://localhost:5555/ReportServer , I am getting error as follows: An error has occured. For more information, contact your system administrator. Also when I click on System Settings, it gives me same error as above. What do you mean by "add reporting services in [...] CRM" SRS is a prereq ...Show All

• Hoakie Pivot table Conditional calculation field

  Hello All I am using owc pivot table as a control to display the data in cubes. Now i have a requirement to apply the formula (calculated field) for all records except few. How to solve this scenario. Please Help Thanks I am still in need of a solution for this question please help!!! Jerome, Thank you for your response. I implemented this but the total is displaying the old value only. Hi Anil, Sorry I took so long. If you need to apply a function to some of the records of the fact table, you can create a function on the SQL Server which applies the formula according to a condition: CREATE FUNCTION <Function Name> RETURNS <Data Type> AS IF <Condition& ...Show All

• Paulson Abraham Dedicated Administrator Connection

  Hi: I am trying to connect to my local instance of SQL Server 2005 using Dedicated Administrator Connection by using Admin:Servername\Instancename and I end up with the following error. Dedicated administrator connections are not supported. I enabled the connection in the SQL Configuration Manager and still get the error. Any ideas on how to resolve this error . Note: SQL Browser service is running. Thanks Ak Thanks Ashvin. That did exactly confirm that I was connected using DAC. It returned one row. So my million dollar question is why cant I connect to DAC using ADMIN keyword. I tried all that have been suggested in this thread and still it says DAC connections ar ...Show All

• DLdfrd SSIS Logs Vs Custom Logs components

  Hi, In my case I have to log the errors raised by any task in a package to either windows event log, text file or SQL server. Also I need to send an email notifications to a group of people telling them about the error. Now can I use SSIS package logging for logging the errors into the required destinations. I mean right clicking on the package and selecting Logging, then adding the required log providers and enabling the events for logging into those. I think I have to upfront select the log providers to log the error, I will not have the liberty to log the error to the destination, the name of which is passed as a variable to the package. This is okay with me though. Now what will a custom log provider help me to do in this case ...Show All

• Digo21 Help with an error message

  I keep getting this error message when I try to restore a database backup that I have made. System.Data.SqlClient.SqlError: Directory lookup for the file "D:\Databases\GTT_Data.MDF" failed with the operating system error 5(error not found). (Microsoft.SqlServer.Express.Smo) What I have done is created a backup of my sql sever database and I am now trying to restore it into sql server express for someone to play around with without it affecting my actual database. This is where the error messages are coming from. Please help Yes its during the restore. Yes the machines are not the same. Please could you give me further details on how to restore the databse with the WITH MOVE option. Thanks for your help ...Show All

• agarg Connectivity issue

  I am using the connection string as "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TMS_CHECK_CONVERSION;Data Source=PHILDCAP4Q\VENDOR" in specified named instance is installed on the Respective machine. It is giving the following error., Sqlserver does not exist or access denied., Please suggest ... The connection string which I am using is Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBTest; Data Source= ServerPC\TestInstance DBTest is the database name ServerPC is the system where the sql server is installed TestInstance is the name instance of sql server on ServerPc Sql server is installed on Windows 200 ...Show All