Home
How To Change SQL Server 2008/2005 Object Schema?
- Details
How To Change SQL Server 2008/2005 Object Schema?
Problem
It is not easy to change SQL Server 2008/2005 object schema (tables, stored procedures and views) to "dbo". Here is a solution.
Solution
a. Execute the following SQL script in SQL Server Management Studio query window.
SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + o.Name FROM sys.Objects o INNER JOIN sys.Schemas s on o.schema_id = s.schema_id WHERE s.Name = 'yourschema' And (o.Type = 'U' Or o.Type = 'P' Or o.Type = 'V')
b. Copy the output to another query window and execute.
ALTER SCHEMA dbo TRANSFER yourschema.vFindVistType ALTER SCHEMA dbo TRANSFER yourschema.vEditPatients ALTER SCHEMA dbo TRANSFER yourschema.T_Referrals ALTER SCHEMA dbo TRANSFER yourschema.T_Therapist ALTER SCHEMA dbo TRANSFER yourschema.vOpenRefs ALTER SCHEMA dbo TRANSFER yourschema.vTherapists
c. Now all objects (tables, stored procedures and views) should be "dbo" schema.
Ubuntu Root Password
- Details
This is one of those question that still gets asked all the time.
By default the Ubuntu root password is set to nothing so you can not login to that account.
Sometimes this can be a headache.
To change the password, login as the user you made during setup.
type: sudo passwd
and type the new password and confirm the password
Now the root account is set to that password you can now log in.
Note:
if you want to ssh as root you need to do the following
nano /etc/ssh/sshd_config
change:
PermitRootLogin without-password
to:
# PermitRootLogin without-password
save
Then restart SSH:
service ssh restart
Mapping Drive via RDP RDC
- Details
One of the most common tasks you'll need to do when using an RDC is transfer a file from your local machine to the remote machine that you're logged into. In the past I would open a new file share on the local machine and browse to it from the remote one. Or maybe I'd map a drive using NetBios.
But not anymore! Microsoft's RDP Client has a sweet little feature that will connect your local hard drives to the remote machine when you open a RDC.
How to do it!
First, open the Microsoft Remote Desktop Connection (Start -> All Programs -> Accessories -> Communications -> Remote Desktop Connection). Then click on the Options button and go to the Local Resources tab. The bottom section of the tab is titled Local Devices, and there you will see a check box labeled Disk drives. Checking this box will automagically connect all disk drives on you local machine to the remote machine when you open the RDC.
When you get logged into the remote box, open My Computer and you'll see that all the drives (hard drives, floppy drives, CD/DVD ROM drives, and even mapped drives) will show up as mapped disk drives. Sweet!
Go ahead and open one of the newly mapped drives and transfer files to your heart's content. Now, how easy and painless was that!
Connect to MS SQL Server
- Details
How to connect to a MS SQL Database with MS SQL Manager.
First Whitelist your IP address you can get your IP by clicking here: MyIp.ourace.com [new window] this is your External IP not a 192.x address
- Login to Plesk.
- Click Websites & Domains tab at the top.
- Click SQL white list beta? icon (last icon seen).
- Click Add IP, select service and type IP; Click OK.
-or-
Click Add my IP then select service.
Click connect to manage your Database. Also you might see a lot of Databases so you will need to find yours.
Page 26 of 40