Hi

It is possible to access Compact Edition from .Net on windows OS. For detailed information about the connection string see http://www.connectionstrings.com/.

But it has quiet less features. As steveb already stated...

Hello

What is the error message in job history?

Greets

Flo

Hi

* Create a new database

* Expand the database node within the Object Explorer

* Click on the "Database Diagrams" node

* You will either automatically be asked to create a new one...

Hello Christophe

If you are using SQL Server Management Studio it has a build in feature to create database diagrams. Sure, only for SQL Server.

I think this might be what you...

I don't think this is complete right. Since SQL Server 2005 they will do...

Hi Babar

What everybody wants to say is there seems to be no reason to transport 5 million records ever to a client application/report.

I don't think that this 5 million records...

I am quiet sure that I understood you. Let me try to explain what I understood:

You want to check if the third to fifth position within a specified text are...

Hi Anjana

I think the problem is within your client application. Snippet of your code:

Dim myCommand As New SqlCommand("sp_CUSTOM_SearchApplicant", dbConnection)

myCommand.Parameters.Add("@AppFirstName", Data.SqlDbType.NVarChar).Value = txtFirstName.Text

...

Oh sorry. Did not read correct. Try this:

DECLARE @name VARCHAR(100)

SET @name = '123abc123'

IF (@name LIKE '___[a-z][a-z][a-z]%')

PRINT (@name + ' matches - RIGHT')

SET @name = '123a2b345'

IF (@name LIKE...

Hi Mark

I still do not completely understand why the dynamic procedures.. :hehe:

But here an example for your requirement (try on a AdventureWorks)

[font="Courier New"]

-- The "procedure creator" procedure

IF (OBJECT_ID('usp_proc_creator') IS NOT...

Hi

Maybe I did not understand correct, but try this:

DECLARE @name VARCHAR(100)

SET @name = 'xxxabcxxx'

IF (@name LIKE '___abc%')

PRINT (@name + ' matches - RIGHT')

SET @name = 'abcab'

IF (@name...

Another tip:

For procedures like this you should use the "WITH RECOMPILE" option.

Greets

Flo

Hi Mark

Sure. Use sp_executesql

So, say I have a list of 10 clients,...

Hi Anjaja

Which error message do you get?

Greets

Flo

If the "some tables" are only written from your publisher database you can replicate only them.

If not:

First you absolutely need a Last-Update column in your tables to avoid always to...