I'm trying to develop a script in TSQL which employs sp_changedbowner to change all non system databases back to sa but am running into a problem with the 'Use" syntax to switch the database context that I'm in.Script I've been testing with follows:Anyone have any ideas to get around this?Thanks===============--create procedure ChgDbOwner as SET NOCOUNT […]
It is in the registry:HKCU\HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers XIf you have a roaming profile you get the same servers on every machine.It is easiest to export from current user, logged in as your colleague en import as yourself. Otherwise you can export form HK_users\sid-colleagueOne possibility to get the sid is with psgetsid from http://www.sysinternals.comJoachim.
How did you 'define' your decimal field? The proper syntax is: DECIMAL(p,s) p=precision - the number of digits total s=scale - number of digits to the right of the decimal. So, to be able to store your numbers 2.5, 3.125, 4.1275 you would need a decimal column as: DECIMAL(5,4) -SQLBill