Feb 5, 2007 #1 Jimmy24 IS-IT--Management Joined Sep 7, 2006 Messages 21 Location US Dear Sir or Madam, I have a SQL db that I need to rename from SIVApps to MISIVApps. How would be the best way to do it? Thank you in advance for your assistance. Regards, Jimmy
Dear Sir or Madam, I have a SQL db that I need to rename from SIVApps to MISIVApps. How would be the best way to do it? Thank you in advance for your assistance. Regards, Jimmy
Feb 5, 2007 1 #2 gmmastros Programmer Joined Feb 15, 2005 Messages 14,912 Location US Well... you could use the sp_renamedb system stored procedure.... http://msdn2.microsoft.com/en-us/library/aa238879(SQL.80).aspx -George Strong and bitter words indicate a weak cause. - Fortune cookie wisdom Upvote 0 Downvote
Well... you could use the sp_renamedb system stored procedure.... http://msdn2.microsoft.com/en-us/library/aa238879(SQL.80).aspx -George Strong and bitter words indicate a weak cause. - Fortune cookie wisdom