exec sp_helpdb DatabaseName
datach:
exec sp_detach_db 'MyDatabase', 'true'
attach:
exec sp_attach_db 'MyDatabase',
'C:\Program Files\Microsoft SQL Server\MSSQL\data\MyDatabase_Data.MDF',
'C:\Program Files\Microsoft SQL Server\MSSQL\data_log\MyDatabase_Log.LDF'
Change logical file name:
alter database MyDatabase modify file (name='test', newname='MyDatabase')
alter database MyDatabase modify file (name='test_log', newname='MyDatabase_log')
source: Timothy Chen Allen
Wednesday, October 21, 2009
Tuesday, October 20, 2009
A quick tutorial on using hibernate for webapp
Directly from Netbeans KB:
http://www.netbeans.org/kb/docs/web/hibernate-webapp.html
However, don't expect to learn much from this over simplified tutorial.
http://www.netbeans.org/kb/docs/web/hibernate-webapp.html
However, don't expect to learn much from this over simplified tutorial.
Monday, October 19, 2009
Using Netbeans and Eclipse side by side with SVN
while I was doing the group assignment for comp9323, I thought about using netbeans and eclipse side by side. Initially I preferred Netbeans but after all I was using Eclipse for the project.
After playing around Subversion and Netbeans/Eclipse for a while, I actually realize that this can be setup in a way that netbeans and eclipse can be used side by side in same project. In my case, I created the source repository in SVN then synchronize it with Eclipse, later I use Netbeans to check out a copy then follow the instructions to create netbeans project, when it complaints about existing build folder, just remove the build folder then you can proceed.
After playing around Subversion and Netbeans/Eclipse for a while, I actually realize that this can be setup in a way that netbeans and eclipse can be used side by side in same project. In my case, I created the source repository in SVN then synchronize it with Eclipse, later I use Netbeans to check out a copy then follow the instructions to create netbeans project, when it complaints about existing build folder, just remove the build folder then you can proceed.
Subscribe to:
Posts (Atom)
Disable Microsoft Defender for Cloud for Visual Studio Subscription (MSDN)
I use a visual studio pro subscription which comes with $150 azure cloud credit, for some reason Microsoft Defender for Cloud was turned on ...
-
Error 15401: Windows NT user or group '%s' not found. Check the name again. SELECT name FROM syslogins WHERE sid = SUSER_SID ('Y...
-
Finally, it is time. E4SE 811 and eBackoffice 736 will replace our current 810b/735a environment after staying so many years. Just got the n...
-
/etc/ipsec.config conn ios keyexchange=ikev1 authby=xauthrsasig xauth=server lef...