Hi

Try this

[font="Courier New"]

SET NOCOUNT ON

DECLARE @definition TABLE (id INT IDENTITY, line NVARCHAR(MAX))

INSERT INTO @definition

   EXECUTE sp_helptext 'sp_test'

DECLARE @id INT

DECLARE @line NVARCHAR(MAX)

WHILE EXISTS (SELECT TOP 1 * FROM @definition)

BEGIN

   SELECT TOP(1)...

Hello

The problem with the tables, PKs and FKs might be not so difficult:

* Create all tables

* Create all the primary keys (this might be done within the first step.

* Create...

Hi

I just tried exactly your statement and it works fine:

DECLARE @emp_mst TABLE (

emp_code VARCHAR(100),

emp_name NVARCHAR(100),

emp_desig INT,

...

Hello Amit

You can use OPENQUERY to get server properties from a linked server:

SELECT * FROM OPENQUERY(LinkedServerName, 'SELECT @@VERSION')

Greets

Flo

Thank's for your affirmation Jeff! It's also the only business case where I'm...

Hi

Sorry I really don't see any problem within the code... 🙁

Maybe also log the stack trace of the thrown exception to see which part of .Net internal code throws it,...

If your executable is throwing an error usually the error should be logged into the job history.

Does your executable support any logging? Maybe, if you wrote it, try to enclose...

Hi

How huge is the whole database? The user table maybe is only 2.5 MB but if your whole database is 500 TB ;). You wrote that there are 60 FK...

Hi

Could you post the whole error message from job history?

Thanks

Flo

Hi

I'm using sql_variant alike Jeff stated for logging. I've got a usp_Log like this:

CREATE PROCEDURE dbo.usp_Log

@msg VARCHAR(4000),

@p1 SQL_VARIANT = NULL,

@p2...

Hi Robert

DECLARE @phone VARCHAR(100)

SET @phone = '1234567890123456'

SELECT REPLICATE('*', 12) + RIGHT(@phone, LEN(@phone) - 12)

Greets

Flo

Available Servers? If you select "Connnect SQL Server Compact" and Select "Browse for more..." option from drop-down list there should appear a dialog to directly browse for the file; not...

Hi

Did you try to browse for the database file location?

"Object Explorer" -> "Connect -> "SQL Server Compact" -> "Database file" -> "Browse for more..."

Greets

Flo

Hi

http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407

Greets

Flo

Hello Hein

Is this the complete Message?

Right click on the job, select "View History". You should get a window with a tree on the left side and a list on the...