hi all i have made a procedure. In which i use IN condition but the condition is not working. create procedure getbalance @acode varchar(2000), @csh varchar(2000) as select * from tablename where acode = @acode and c_sh in (@csh) when i pass @acode=111 and @csh='PNW' then this procedure work but i pass @acode=111 and @csh ...

We use an external Seagate hard drive in which we have our SQL 2005 databases on.  We recently updated a server and connected the Seagate hard drive to the new server. We cannot connect to the SQL 2005 databases on this hard drive – does anyone have any ideas of what we need to look for to get these db’s back online?Here is the ...