Dennis van der Stelt - All Comments

re: Query analyzer for SQL Server 2005/2008

Crazy Superman — Thu, 18 Mar 2010 18:56:50 GMT

Time to upgrade from that calculator to a PC

re: WCF Part 5 : Consuming the service

Kedar — Wed, 17 Mar 2010 07:22:39 GMT

The session was informative and useful. I got to know how exactly we consume and build WCF services

-Kedar

re: Cannot drop database because of replication

Noravia Rodriguez — Tue, 16 Mar 2010 17:04:36 GMT

SQL Server 2000

a. Database

use master

exec sp_replicationdboption @dbname = N'dbPOMS', @optname = N'publish', @value = N'false'

b. Columns

use master

exec sp_replicationdboption @dbname = N'dbPOMS', @optname = N'publish', @value = N'false'

use [dbPOMS]

sp_configure 'allow updates', 1

reconfigure with override

-- For Tables

UPDATE syscolumns SET colstat = colstat & ~4096 WHERE colstat & 4096 <>0

-- For columns

UPDATE sysobjects SET repinfo=0 where repinfo=1

sp_configure 'allow updates', 0

reconfigure with override

re: Attempted to read or write protected memory in a .NET application

Elias P Ulahannan — Tue, 16 Mar 2010 16:56:10 GMT

I got the same problem. My problem was that I compiled the dll with a different version of third party component like Infragistics 9.1 instead of Infragistics 9.2. When I referenced the actual component and compiled then it's working fine.

re: Cannot drop database because of replication

Noravia Rodriguez - City Of Miami - Database Manager — Tue, 16 Mar 2010 16:51:40 GMT

Autor : Noravia Rodriguez

Date : 03/02/2010

Updates: 03/16/2010

Purpose: How to unmark a database marked as replicated in SQL Server 2005

How to unmark a database marked as replicated in SQL Server 2005

1. Try:

EXEC sp_removeddbreplication “”DatabaseName”

2. Try:

Take Database OffLine

Deatch

Attach Database Back

3. This tasks need to be done MANUALLY and in the following order:

i. Drop all existing subscriptions

ii. Drop all existing pubications

iii. Create a new publications with the same name

iv. Drop it again and say “Yes” to delete information on the Distributor (Distribution Database)

v. Verify Database has been unmark for replication

1. Go to the Database-Tasks-Detach and ensure that mark has been removed

2. Run the following query and ensure “Category”=0 (RECOMMENDED)

SELECT name,category,* FROM master..sysdatabases

re: Windows Live Writer and ZoomIt

Tim — Tue, 16 Mar 2010 15:31:31 GMT

How do I keep my mouse arrow showing on the screen when I use zoomit?

re: Unit testing in Visual Studio 2008 tips

omer — Tue, 16 Mar 2010 13:15:44 GMT

Can we set default value(s) for testing the parametrized function.

for example:

<TestMethod()>_

Public Sub GetStoresTest()

Dim target As FCFProvider = New FCFProvider

Dim intUserID As Integer = 67097

Dim expected As DataTable = Nothing

Dim actual As DataTable

actual = target.GetStores(intUserID)

Assert.AreEqual(expected, actual)

End Sub

re: ClickOnce manual updates

crystal — Mon, 15 Mar 2010 21:02:42 GMT

<a href="http://www.e-goodbags.com" target="_blank">Replica Gucci handbags</a>

<a href="http://www.e-goodbags.com" target="_blank">Replica Dior handbags</a>

<a href="http://www.e-goodbags.com" target="_blank">Replica Chanel Handbags</a>

<a href="http://www.e-goodbags.com">Wholesale Replica Handbags</a>

<a href="http://www.e-goodbags.com" target="_blank">Discount Balenciaga handbags </a>

<a href="http://www.e-goodbags.com" >Fashion Handbags</a>

re: WCF Part 0 : Introduction

Dennis van der Stelt — Fri, 12 Mar 2010 15:40:12 GMT

@Sam: From which context? An application that wants to retrieve and write data? A public service that anyone can call? Pure ADO.NET? Linq to SQL? Entity Framework?

Give me some context and maybe I can work with it. There are dozens of possibilities.

re: WCF Part 0 : Introduction

Sam — Fri, 12 Mar 2010 11:07:19 GMT

Can you give me any sample of any WCF service by which i can insert/retrieve/delete data from my SQL database. WCF is a new concept for me so plz help..

re: LINQ to SQL vs. DBA's

Dennis van der Stelt — Thu, 11 Mar 2010 06:04:48 GMT

@Bob : You're Bob and you're a DBA'r? That's too good to be true! ;-)

But anyway, I've never seen a system that could change logic inside an application by changing its T-SQL (either SProc, Views or whatever). If your application does, it's a bad practice and I can guarantee that it's WAY less maintainable than my applications are.

re: Attempted to read or write protected memory in a .NET application

Lead Generation — Thu, 11 Mar 2010 01:20:53 GMT

Just re-installed my operating system, visual studio and everything. All of the sudden it keeps giving "Attempting to read or write protected memory in a .net application". Looks like I have to grant some special rights to specific users? could any one please help?

thanks

re: LINQ to SQL vs. DBA's

Bob — Wed, 10 Mar 2010 16:20:20 GMT

uggg..SQL code in a .NET program? So everything I want to change the logic in the SQL, I need to redeploy the app, meaning that I need to schedule downtime? uggggg. Maybe LINQ can be useful in small projects, but then maybe its just best to use Access.

re: Adding SharePoint class resources to your feature using WSPBuilder

Dan — Tue, 09 Mar 2010 14:15:03 GMT

I'm trying to put some common images/css into sharepoint , any idea where these should go?

re: Cannot drop database because of replication

Pranita — Tue, 09 Mar 2010 07:06:37 GMT

Thanx....

exec sp_removedbreplication works..