yes, but xp_sendmail I intend to say that I must have Exchange.

How can I do for to configure SMTP adress  ?

Thank you.

Hello,

I would like in trigger send a mail, create a file on disk.

Thanks

Hello,

How can you call your store procedure ?

Witch sql exception is returning by your application ?

Hello,

Can you give me connection string please ?

Try this : Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=base test;Data Source=yourServerName

Hello Mark

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=268558

It's ok, I found it :

ALTER

SCHEMA mySchema2 TRANSFER mySchema1.myTable1;

However, I don't find in Management Studio.

Hello,

I would like to do this query into access design but I don't know to do.

I want that my query return all elements + sum from this total element

Thanks

Sorry , I am forgoten a finaly return

I found.

I create a new user SQL and in this properties, I have select French in default language.

Hello,

it's ok, I found.

@userid didn't same type between this two table. (uniqueidentifier and int).

When I add parentheses, it's the same error.

@userid is variable. This value must be inserted foreach rows.

CREATE PROCEDURE [contact].[importContactClient]

(@userID...

Hello  Joseph, thank for your help.

I woud like to protect my software. I find an alternative, I going to be install a virtal pc in the server. And I will be...

It's ok,

But If administrateur  kills SQL Server service, Is it possible to encrypte or protected by password my database (If he attach .mdf file in an other database ) ?

I...

In my database >> Security >> Certificates , I see my certificate.

I have possibility to refresh or  delete, but if I need know expiry date, it's impossible.

How can I do for...