skip to main
|
skip to sidebar
Sarat Dontula
Software Notes
Monday, June 29, 2009
Move sqlserver tables to dbo user
SELECT 'ALTER SCHEMA dbo TRANSFER ' + SCHEMA_NAME(schema_id) + '.' + name
FROM sys.tables
WHERE schema_id != SCHEMA_ID('dbo');
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2012
(1)
►
April
(1)
►
2011
(1)
►
February
(1)
►
2010
(1)
►
February
(1)
▼
2009
(24)
►
July
(5)
▼
June
(15)
Move sqlserver tables to dbo user
Starting JavaDB (Derby) in glassfish.
Samba File Sharing Ubuntu
UBUNTU setting up environment variables.
Linux helpful commands
SQL to drop an index on table.
SQL for alter column
Oracle Timestamp
DB2 Timestamp
Sql Server timestamp field
Sql Current Timestamp.
MySQL mysqldump tablename.MYD not found (Errcode: ...
Creating MySql Database & Setting up users.
LINUX MYSQL GOTCHAS
How to import and export mysql database?
►
January
(4)
►
2008
(19)
►
December
(17)
►
November
(1)
►
October
(1)
Labels
apache
(1)
as400
(2)
blackberry
(1)
cadaver
(1)
carnatic
(1)
continuous integration
(2)
css
(1)
db2
(2)
derby
(1)
design patterns
(1)
fop
(1)
glassfish
(2)
hsqldb
(1)
hudson
(2)
icefaces
(1)
J2EE
(1)
java
(1)
jboss
(2)
linux
(2)
maven
(1)
microsoft exchange
(1)
msaccess
(1)
music
(1)
mysql
(7)
oracle
(3)
piano
(1)
rant
(1)
samba
(1)
smtp
(1)
solaris
(1)
sql
(5)
sqlserver
(7)
srikar
(1)
ssh
(1)
syntaxhightlighter
(2)
timestamp
(4)
ubuntu
(8)
unix
(2)
web frameworks
(1)
webdav
(1)
wget
(1)
Interesting Books & Links
http://slashdot.org/
http://www.javaranch.com/
http://www.javapassion.com/
http://www.allapplabs.com/
Subscribe To
Posts
Atom
Posts
Comments
Atom
Comments
Followers
Geo Visitors
Viewer Location
No comments:
Post a Comment