command line - SQL 2005 Express Edition - Install new instance -

-

looking way programatically, or otherwise, add new instance of sql 2005 express edition system has instance installed. traditionally, run micrsoft's installer in command line below , trick. executing command in installer not issue, it's more matter of dragging around 40 mbs of ms-sql installer don't need if have sql express installed. installer executes:

sqlexpr32.exe /qb addlocal=all instancename=<instancename> securitymode=sql sapwd=<password> sqlautostart=1 disablenetworkprotocols=0

i don't need assistance launching command, rather appropriate way add new instance of sql 2005 express without running full installer again.

i'd go great detail why want i'd bore everyone. suffice say, having ability create new instance without time takes reinstall sql express etc. assist me deployment of application , it's installer. if makes difference anyone, i'm using combination of nsis , advanced installer installation project.

it sounds user instance might you. if have mdf , ldf files, can connect files instructing sql server express launch user instance , attach specified file instance.

this artile http://msdn.microsoft.com/en-us/library/bb264564.aspx has description of how can lean on existing sql server express installation instantiate user-specific instance duration of connection.

hope helps.


Comments

Post a Comment

Popular posts from this blog

c++ - How do I get a multi line tooltip in MFC -

-
right now, have tool tip pops when hover on edit box. problem tool tip contains multiple error messages , in 1 long line. need have each error message on own line. error messages contained in cstring new line seperating them. my existing code below. bool ontooltiptext(uint, nmhdr* pnmhdr, lresult* presult) { assert(pnmhdr->code == ttn_needtexta || pnmhdr->code == ttn_needtextw); // need handle both ansi , unicode versions of message tooltiptexta* pttta = (tooltiptexta*)pnmhdr; tooltiptextw* ptttw = (tooltiptextw*)pnmhdr; // tchar szfulltext[256]; cstring strtiptext=_t(""); uint nid = pnmhdr->idfrom; if (pnmhdr->code == ttn_needtexta && (pttta->uflags & ttf_idishwnd) || pnmhdr->code == ttn_needtextw && (ptttw->uflags & ttf_idishwnd)) { // idfrom hwnd of tool nid = ::getdlgctrlid((hwnd)nid); } //m_errprojaccel[ch] contains 1 or more error messages each...
Read more

asp.net - In javascript how to find the height and width -

-
i having .aspx , masterpage page. in masterpage loading aspx page . in aspx page design using generating table structure using code-behind server in javascript how find height , width . regards, kumar if you're looking table height , width, should it var tbl = document.getelementbyid('tbldemo'); alert(tbl.offsetwidth + '\n' + tbl.offsetheight);
Read more

c# - DataTable to EnumerableRowCollection -

-
i have datatable according client requirement can contain invalid date "00/00/1999",null,empty string.(typed datset) when collect them enumerables wish convert of invalid forms empty string. (i.e) enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || (how check date invalid date) ? string.empty : order.field<datetime>("orderdate") } how check whether date valid date or not? datetime.tryparse...like given current code: datetime date; enumerablerowcollection<datarow> query = order in _table.asenumerable() select new { orderdate= string.isnullorempty(convert.tostring(order.field<datetime>("orderdate")) || !datetime.tryparse(convert.tostring(order.field<datetime...
Read more