Hi Mike

So the hard way (for now)...

Open command shell. Enter:

C:\> sqlcmd -S (local) -E

... and press enter. Now you should be connected.

With the following two lines you can see which...

Hi

This is a little less information to help.

* What does your progress? Show data? Update data?

* How many data does it handle?

* Which statement(s) do you use?

Greets

Flo

I can introduce you to my project manager, he can explain that. He sometimes also thinks that days have 30 hours....

Hi

Do you find the following tool:

Start -> All Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio

??

If yes, start it and a new connection dialog should appear automatically....

Hi David

You have to define the @Id also for OUTPUT when callin':

declare @ID uniqueidentifier

exec dbo.Add_Header @ID OUTPUT, 'A','B','C','D','E'

select @ID as ID

Greets

Flo

Hi

A little example. Your procedure:

CREATE PROCEDURE usp_MyErrorProc

AS

RAISERROR ('Hello, I''m a custom database error.', 11, 1)

In .Net:

private void Button_Click(object sender, RoutedEventArgs e)

...

Steve Jones - Editor (4/1/2009)

---

I'd disagree. You don't want to set this on databases that are being used, but if you suspect that there is a database not used, or...

Hi David

You cannot use RETURN for guids. You have to define an additional parameter (e.g. @Id) as OUPUT parameter:

CREATE PROCEDURE [dbo].[Add_Header]

@Id ...

Hi Steve

I...

Oversight...

You are using a linked server, right?

"TRUNCATE TABLE " is a DDL statement, not a DML so I think it is not possible with a linked server.

Maybe it works over...

Dang! You got me! 😀

I really feared that something might be damaged and started to review the script...!

Have a nice day 😉

Flo

Change the (not posted 😉 )

EXECUTE @sql

To this:

EXECUTE (@sql)

Or this (requires @sql as NVARCHAR):

EXECUTE sp_executesql @sql

Greets

Flo

Hi JacekO

What is the problem?

Greets

Flo

I'm using the sys.indexes as overview for all tables. In operative processes it seems to be a quiet rare requirement to get a complete count without any criteria.

Greets

Flo

Hi

Two questions:

* Could you please provide your sample data as file?

* Could you please provide your expected output XML as file?

Since now it is hard to help 😉

Greets

Flo