In addition, I invite you to read this articles regarding the DeadLock, it's really important to understand what deadlock is.

- Understand the Deadlocking

- Troubleshooting Deadlocks

- Minimizing Deadlocks

-Bart...

Hi Andras,

Many thanks, with you informations I could finish my script to grant stored procedure

CREATE

 PROCEDURE [admin].[grantStoreProcedure] (@login...

it's ok, I found it.

If you encountered Error 3154 during a restore operation, overwrite the existing database by reissuing the RESTORE DATABASE command using the WITH REPLACE clause, or restore...

Thanks for this documentation,

Its works now.

it's all right, I found it.

The number of read operations on the logical disk that are performed by the server on behalf of the event. These read operations...

Sorry, I found it. I forgot to choose in database properties my user owner.

In SQL Server Management Studio do the following:

1. Right Click on your database, choose properties

2. Goto the...

Ok I found it,

charindex can be used only on char, nchar, unichar, univarchar, varchar, nvarchar, binary, and varbinary columns; patindex works on char, nchar, unichar, univarchar, varchar, nvarchar, and...

It ok  I find I.

In colunm's property >  Visibility > Hidden > choose : expression

And write :

=iif(Fields!displayTaxe.Value=true,true,false)

yes, very thanks.

Its works with square brackets.

If I use :

I made Start >> Run... >> CMD

In prompt I wrote :

C:\Program Files\Microsoft SQL Server\90\Tools\Binn>sqlcmd –E -S myInstance –d master

1>ALTER LOGIN server\windowslogin...

Hello,

lol santosh, my operating system is in french. 🙂

I think that :

osql - E

sp_defaultdb 'user's login','master'

go

is only for SQL Server 2000.

I try to use the sqlcmd utility...

ok, I find How to configure SQL Server 2005 to allow remote connections

http://support.microsoft.com/kb/914277/en-us

So good, Very thanks.

it's ok, I find it.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_5c8c.asp

it's ok, I found It,

It is my datasouce name that I had changed.