sql server - sp_dropserver and sp_addserver not working -

-

i using sql server express 2008 r2 , wanted change instance name "machine name"\sqlexpress2008r2 "machine name". ran:

sp_dropserver 'old_name'  go  sp_addserver 'new_name', 'local'  go

then restarted sql service. when @ 

select @@servername --this correct

but isn't correct?

select serverproperty('servername') --this still shows old name

so when try connect instance via ssms still have connect using old instance name isntead of new on applied? doing wrong? why new name not taking?

thanks,

s

this books online:

although @@servername function , servername property of serverproperty function may return strings similar formats, information can different. servername property automatically reports changes in network name of computer.

in contrast, @@servername not report such changes. @@servername reports changes made local server name using sp_addserver or sp_dropserver stored procedure.

and first comment correct. you'd have reinstall sql in order change default instance.

per bol if change machine name named instances have use follows:

sp_dropserver <'old_name\instancename'> go sp_addserver <'new_name\instancename'>, local go

Comments

Post a Comment

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -

-
pypdf throws exception: pypdf.utils.pdfreaderror: eof marker not found i don't need fix pypdf, need eof error cause "except" block execute , skip on file, doesn't work. still causes program stop running. background: batch ocr program pdfs python, pypdf, adobe pdf ocr error: unsupported filter /lzwdecode ... saga continues. i got 10,000 pdfs in folder. ocrd, not. can't tell 'em apart. step 1 figure out ones not ocrd , ocr (see other threads details). so i'm using pypdf. exceptions related unrecognized characters , unsupported filters when try read text. guestimated if throws exception, it's got text in , doens't go in list. problem solved, right? so: pypdf import pdffilewriter, pdffilereader import sys, os, pypdf, re path = 'c:\users\homer\documents\my pdfs' filelist = os.listdir(path) has_text_list = [] does_not_have_text_list = [] pdf_name in filelist: pdf_file
Read more