no my friend i`m a C# programmer not DBA, if you don`t mind add me in your Tech network in yahoo or any thing as "mscode_pro@yahoo.com"

it works man How Come?????

i did the same before but it didn't work and now it works!!!!!!!

yes the syntax error becaue i forget to delete the second paranthesis of the...

at all we all her friends before any thing and sorry if i bothered any of my friends;)

so why no answers

:P:P I'm relaxed enough Mr\Gila but i forget that you take a holiday in that day, and because i`m not experts in Sql because i`m a programmer and i think...

The table is not exist in Master Tables, and if it exists what the structure of it to make the query works???

I'm Sure that the column type in master DataBase is Varchar(max) and it works.

and after i convert to varbinary like that :

Create PROCEDURE [dbo].[spAddEmp](

@Fname varchar(50),

@Lname varchar(50),

@Uname varchar(max),

@Pword varchar(max),

@GroID int,

@Lslry int,

@IsAdmin...

I'll be wait for any solutions

So the two ways are impossible

ok So........., irealy can`t understand you obviously

i know how can decrypt Sps created by Sql2k but 2005 not

Security Issue my friend;)

yes, sure it connected to master database to be allowed to detach the database, but why if the connection has another job prevent another database to detached????

that what i wanna do man , i wanna FORCE every connection in my application to detach the database, and when i used that i success detaching my database, and...

Thank you man i found the solution :):):):)

the solution at this link :

I GET IT :):):):)

thank you BigJohn your answer is apart of the solution just you have to make it like this :

ALTER DATABASE DigArch SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER...