How to remove the sqlcachedependancy ?

I had sqlcachedependancy installed. But now I cannot uninstall it?

1. I unregistered:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regsql.exe -E -S localhost
-d DNN1 -dd

2. I remove the Dependencry.Start() from my application_start

' System.Data.SqlClient.SqlDependency.Start(ConfigurationManager.ConnectionStrings("SiteSqlServer").ConnectionString)

3. I removed the cache section from my web.config

4. I removed the outputcache statements from my aspx pages.

<!--<%@. OutputCache Duration="1" VaryByParam="*" SqlDependency="CommandNotification" %>-->

However, I still get the next error:

FileError When using SqlDependency without providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance.

What to do?

Any help or advice is appreciated.

Jelle

Have you done a search through all of your application's files, looking for a rogue SqlDependency instance?|||

Thank you for your reply. I looked mainly in the default.aspx and forgot that for Dotnetnuke I also modified the install.aspx file. So in the end I copy-past all the next files over my files:

default.aspx + codebehind

install.aspx + codebehind

global.ascx

assembly + global file in app_code directory

That solved the solution.

Main reason I wanted to uninstall is that in case the webserver does stop a connection, the database server starts logging errors that the connectio n with the remote webserver is lost...and then the database server hangs. Would be nicer of MS SQL2005 to stop the logging in case the webserver does not request any info anymore.

How to remove MSDE manually?

Please help me to clean a Windows 2000 Pro instance which is "dirty"
with the MSDE 7.0 and/or/both MSDE 8.0 previously incorrect
installed/removed.

I have a software product installation containing MSDE 7.0. When I tried
to install MSDE 7.0 I got an error "You have installed MSDE".

*** Sent via Developersdex http://www.developersdex.com ***http://support.microsoft.com/defaul...kb;en-us;276044
http://support.microsoft.com/defaul...kb;en-us;290991

Simon|||Thank you!
But it does not work in my case :(

*** Sent via Developersdex http://www.developersdex.com ***|||
> Please help me to clean a Windows 2000 Pro instance which is "dirty"
> with the MSDE 7.0 and/or/both MSDE 8.0 previously incorrect
> installed/removed.
> I have a software product installation containing MSDE 7.0. When I tried
> to install MSDE 7.0 I got an error "You have installed MSDE".
Frankly speaking I think that the surest way to do this is reinstallation of
OS. I am afraid that manual removal would take more time then reinstallation
of OS and all additional software.

Alwik|||can't you just disable the service and kill all the files?|||> can't you just disable the service and kill all the files?
It will leave a lot of trash in registry and next attempt to install MSDE
may be not sucessful.

Alwik
www.akwarele.com

How to remote processing reports?

Hi everyone!

I have my reports published in a report server. What do I need to do so that the user can processing reports from a windows application?

There are many ways to do that. Within VIsual Studio 2005 there is a reportviewer control which you can use within your application to contact and display report. If you only want to get a report from the Server and present the user a byte stream to save to a file (something like a button which says Save the report to PDF...) THen you can just use the Report Server Services interface. WHat do you actually want to do ? (Meanwhile you can take a look on: http://www.gotreportviewer.com/)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

sql

How to reinstall SQL 2005 in Windows Server 2003 for SBS?

I've got a Windows Server 2003 for Small Business Server. It had got SQL
installed. But then SQL was uninstalled. Now I need to put SQL back in, but
I don't see how!
There're three CD-Rom but I don't see how and from which CD to install back
SQL.
PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005, right?I don't know, but I seriously doubt that SQL Server comes with Windows
Server 2003, unless it is the Express version ...
Licensing for SQL Server can run into some serious money.
"TFS" <TFS@.discussions.microsoft.com> wrote in message
news:B877BB42-5FBA-4DF8-9ACC-24DD96F55AB4@.microsoft.com...
> I've got a Windows Server 2003 for Small Business Server. It had got SQL
> installed. But then SQL was uninstalled. Now I need to put SQL back in,
> but
> I don't see how!
> There're three CD-Rom but I don't see how and from which CD to install
> back
> SQL.
> PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005,
> right?
>|||Hello Jay,
SBS is a package of softwares and it consists of Windows Server 2003, SQL
Server, Exchange Server etc...
Windows Small Business Server 2003 R2:
http://www.microsoft.com/windowsserver2003/sbs/default.mspx
Also, please do not post your question more than one newsgroup TFS.
--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Jay" <spam@.nospam.org> wrote in message
news:ufiHseaEIHA.4748@.TK2MSFTNGP06.phx.gbl...
>I don't know, but I seriously doubt that SQL Server comes with Windows
>Server 2003, unless it is the Express version ...
> Licensing for SQL Server can run into some serious money.
> "TFS" <TFS@.discussions.microsoft.com> wrote in message
> news:B877BB42-5FBA-4DF8-9ACC-24DD96F55AB4@.microsoft.com...
>> I've got a Windows Server 2003 for Small Business Server. It had got SQL
>> installed. But then SQL was uninstalled. Now I need to put SQL back in,
>> but
>> I don't see how!
>> There're three CD-Rom but I don't see how and from which CD to install
>> back
>> SQL.
>> PS: Correct me if I'm wrong, Windows Server 2003 is sold with SQL 2005,
>> right?
>

How to recover a SQL Server database after a crash

Hi,
I had my Windows 2000 crashed and after that I reinstalled windows, sql
server etc. after taking backup of all mdf ( and no ldfs by mistake).
Now when I try to restore it, it says,
--
Could not open new database 'kothari1'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'D:\Program Files\Microsoft
SQL Server\MSSQL\data\Kothari_log.LDF' may be incorrect.
--
Any help please - I do not have ANY backup of this database :(
Thanks
AmitSee if you can use
sp_attach_db OR
sp_attach_single_file_db
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Amit Basu" <amit@.winruler.com> wrote in message
news:OHKSpDSRDHA.3768@.tk2msftngp13.phx.gbl...
> Hi,
> I had my Windows 2000 crashed and after that I reinstalled windows, sql
> server etc. after taking backup of all mdf ( and no ldfs by mistake).
> Now when I try to restore it, it says,
> --
> Could not open new database 'kothari1'. CREATE DATABASE is aborted.
> Device activation error. The physical file name 'D:\Program
Files\Microsoft
> SQL Server\MSSQL\data\Kothari_log.LDF' may be incorrect.
> --
> Any help please - I do not have ANY backup of this database :(
> Thanks
> Amit
>

How to read windows registry thru query ?

Hi
How can I access the windows registry entries from MSSQL Server query analyzer. I am looking for some stored procedures. Are there any system stored procedures ?
ThxExtended procedure xp_regread
USE Master
EXEC xp_regread 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\Setup',
'SQLPath'