Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Copy/Refresh a database in the night Expand / Collapse
Author
Message
Posted Monday, October 4, 2010 2:26 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 22, 2014 10:17 AM
Points: 27, Visits: 467
[b]@filename to nvarchar(260).


It is true, however that Microsoft guy did not know if you use multiples of binary number, you save space allocation. When do you have a device name over 255 characters (Unicode), and why he chose 260?


Jason
http://dbace.us
Post #997874
Posted Thursday, October 7, 2010 9:20 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 22, 2014 10:17 AM
Points: 27, Visits: 467
[b]Quick question - Is it common for most DBAs to have different passwords for accounts in the development or test environments?


Refresh in layman's language means make that database the same. You do have to take care of users after refresh. You can script a job step after database refresh. I will never use the same login on production and QA, Test.


Jason
http://dbace.us
Post #1000619
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse