Answer Questions

• Hakan Gümüş My sqlcache doesn't work consistently under ASP.NET 2.0, any suggestion?

  I have some problem with ASP.NET cache, I found other people has similar problem, but I didn't find real solution. The one bother me most is the SQLCacheDependency doesn't work stable. I insert object in cache and has SQLCacheDependency linked. After a period of time, it stopped working. That means the the object is still in cache, but change on db side doesn't remove the cache entry. I am not sure if it is ASP side or SQL side, I feel it is ASP side. I am using 2.0 + SQL 2005. Once the db command notification stop working, you have to restart IIS or clear all items in cache since you don't kno which one is changed. The following is the code I use to handle the cache : string cacheKey = LinkSites.GetMappedKey(virtualPath, fi ...Show All

• Tb2006 Problem with uninstalling SQL Server 2005

  Hi all, I had installed Sql Server 2005 Express Edition Beta 2 on my computer. Now i would like to upgrade with SQL Server 2005 Express edition. It is noticed ( http://www.microsoft.com/france/msdn/vstudio/uninstall/default.mspx ) that i have to uninstall all previous version following a specific order. In my Add/Remove program i have : 1 -Microsoft .Net Framework 2.0 Beta 2 -SQL Server 2005 Express Edtion Beta 2 3 -SQL Server 2005 Tools Express Edtion Beta 2 4 -Microsoft SQL Server Setup support files The problem is : 2 & 3 can't be uninstalled from my computer: the uninstalling program is blocked Can somebody have a solution forme The link appears to take ...Show All

• Gurpreet Singh Sawhney WIndows Authenticated linked server

  How do you create a linked server to use windows authentication We want to be able to use user level authentication with Windows Active directory. In other words, we would create a link using 'be made with login's security context', but all logins would be under NT user groups. I've been told that this works in theory, but in practice is very flaky. Why It's really flaky. I connect one minute, and the next I can't, I get the 'null' error. The linked server shows up one minute, the next it doesn't. We don't want to install Kerberos. We only need one hop. I added the linked server connected to our dev boxes under my win login, using the wizrd. I marked 'be made using login's current security context' Then ...Show All

• Bernd Wechner SSAS Deploy Error - Trust Relationship

  I am trying to deploy an analysis services project to a remote server and continually receive the following error: Error 1 The following system error occurred: The trust relationship between the primary domain and the trusted domain failed. . 0 0 I am confused by this since the machine I am working on and the remote server are part of the same domain. There is a firewall between myself and the server, so could this be a firewall issue Does visual studio connect on a different port than Management Studio I can connect via Management Studio with no error. I have tried all options under the Data Source for impersonation information and this error still occurs. Here is what I have figured out ...Show All

• Martin Moe KB918222 Windows 2003x64 R2 fails

  When I try to apply this post SP1 patch to SQL Server 2005 x 64 on a Windows 2003x64 R2 system it fails everytime. The following is the HOTFIX log: 07/12/2006 15:02:06.781 ================================================================================ 07/12/2006 15:02:06.781 Hotfix package launched 07/12/2006 15:02:08.046 Product discovery successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 SP Level check successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 Product language check successfully completed during the install process for MSSQLSERVER 07/12/2006 15:02:08.046 Product version check successfully completed during the install process for MSSQLSERVER 07/12/2 ...Show All

• M.A.D iif statement problem

  hi all, i've browsed some of the smilar iif expression problems but no idea how to solve mine. i get an #Error when i wrote the following expr : =sum(iif(Fields!revenue_type.Value= "R" , Fields!amount.Value,0)) but no error when it's =sum(iif(Fields!revenue_type.Value= "R" , Fields!amount.Value,0) - iif(Fields!revenue_type.Value= "T" , Fields!amount.Value,0)) If i filter the dataset and just take in data where revenue_type = "R" then there won't be error... how come did i do something wrong please help... this seems so simple yet i couldn't get it.. Maybe RS is not so clever Your field if decimal or duble or some ...Show All

• Drudkh # of Full-Text Catalogs per SQL 2005 server.

  In SQL 2000 there was a limit of 256 Full-Text Catalogs per server. What is the limit if any in SQL 2005 I heard SQL 2005 lifted this limit of 256, but I can't find anywhere what the new limit is. I do not believe there is an imposed limit, just a physical hardware limit I've also looked all over for an answer to this question. There must be some limit - it would be good to have a definitive answer from Microsoft that this has been increased and what it has been increased to. ...Show All

• Bigmo Send Mail Task

  Well I thought it should be easier but send mail task supports only windows authentication but i want to give different user id/password, is there any other way to do it except script Thanks Though third party tools are alwyas not a solution but still, its better to have something then nothing, whetas about writing a simple script Sending emails via the script task is definetely a good option. Check out the sample code @ http://blogs.conchango.com/jamiethomson/archive/2006/07/03/4176.aspx Thanks, Loonysan ...Show All

• tonn Can't see the SQL Server Express Instance on SQL Browser

  Hi All, I am using SQL Server Express to connect to the network using VPN on a local machine. I have done the following.. a.) Enabled the remote connections for the Express Instance and rebooted the machine. b.) Connected to the machine with Express Edition locally and can also connect other SQL Server instances from it to verify connectivity. c.) Yes, SQL Browser Service is running. d.) Firewall is not turned on, so I do not have to configure any exceptions. Now here is the big problem: When I browse for SQL Servers on the network the machine does not show up on the list, i.e "macinename\SQLExpress". I had uninstalled and reinstalled the Express edition and rebooted the machine several times with no luck on t ...Show All

• xyte SQL Cluster Domain Move Issues

  We have: A Microsoft cluster, (SQL Failover cluster) with one node as the domain controller. The cluster was built off site and the domain name used is the same as our existing domain where we eventually need to install this cluster. We need: (At least I think we need:) To remove node 2 from the "cluster domain", DCPROMO node 1 and eliminate the "cluster domain". We then need to join the cluster (nodes) to the existing domain. We also need to recreate the accounts/groups used during installation. Questions: 1) What adverse impact will the removal of the "cluster domain" have on the security groups/accounts used in the installation 2) Will I have to re-install SQL 2005 3) Is my parano ...Show All

• Fabriciom rowmodctr & SMO.

  From MSDN pg for sp_updatestats: http://msdn2.microsoft.com/en-us/library/ms173804.aspx '... In SQL Server 2005, sp_updatestats updates only those statistics that require updating based on the rowmodctr information in the sys.sysindexes compatibility view; therefore, preventing unnecessary updates of unchanged items ...' I was hoping that somewhere in the SMO namespace I would find a way to programmatically obtain rowmodctr info., (in order to determine when stats need updating), but I failed to find any method or property within the stats-related classes through which I could do this. If I've missed something, or there is another way to programmatically obtain the same, then any suggestions/comments would be gratefully received. ...Show All

• MA2005 Remote connection issues

  My experience with SQL Server Express 2005 has been nothing short of a nightmare. It is installed correctly, and is running, I can connect through management studio express and have created a database, but only to instances running locally. If I try from another machine, it won't connect, saying that the problem may be due to the fact that by default, SQL Server does not allow remote connections. However, I have enabled remote connections (through TCP/IP and named pipes). I have added sqlserver as a firewall exception, to no avail, and disabled the firewall as well. Nothing seems to work. Ultimately, I want to connect to a database and execute queries from a VB program. I am a competent programmer but I am at my wits end. ...Show All

• CoderMonkey Storing query results in SQL table

  Hey guys/girls, I was wondering if there is a way to store the report query results into a SQL database for use within an application. I would like to have the query information used in the report updated to a SQL table for later use. The other catch would be to deploy the information to a separate datasource location than the report is using (because the information will be stored in a different location than where the report is gathering information. Thanks! BJ BTW, it is like IM'ing on here! :) YOu are missing two parts in the frou part name, you additional have to prefix the linked server name and the database name you want to pull data from / insert data in ...Show All

• mshvw degenerate dimension and partitioning

  I needed to provide drill down to some granular attributes, so I setup a degenerate dimension with several attributes like serial_number, etc. Doing so has somewhat understandably caused my processing time to increase from 2 minutes to 45 minutes for my sample set of data. To handle this increased processing time, I'm attempting to use partitioning. Now, the trouble I'm running into is how do I process the degenerate dimension in step with the partitions. I am getting errors from the process that boil down to fact_key does not exist in the degenerate dimension so the fact can not be joined to the fact dimension table. How do I process a degenerate dimension in step with my partitions. Does that make sense Keehan The same ...Show All

• ktietjen howto open tunnel connection

  Hi, I'm connected to a remote server via a ssh tunnel. On the server there is an SQL Server running. The remote SQLServer TCP port 1433 is forwarded to local computer to port 8966. So I have to connect to localhost:8966 instead of remote:1433. In the connect dialog I can specify only protocol but no ip address neither tcp port number How can I specify the localhost:8966 in the SQL Server Management Studio Express as the endpoint to connect to Open SQL Server Configuration manager and set your values under SQL Server Network configurations options. There you can specify the port number to connect to by default. Hope it helps. If you are able to connect to this server on SSMS with a normal registration, there is no need to ...Show All