Tuesday, September 25, 2007

Remember

WorksheetFunction. in excel VBA

Blog of the Day

Well, the latest update.  I have moved into some VBA code.  So what is VBA?  VBA stands for Visual Basic for Application (Office).  I have to admit at first I was a little stand offish, but after playing with the tools in the Office application I am a bit taken by the power.  Just like all Microsoft products the Object Model is easy to pick up.

 

I am actually developing some reporting in Excel from SharePoint lists being populated by InfoPath Forms.  I hope to be moving into the InfoPath to Web services to SQL server to us SQL reporting soon.  I will keep everyone updated.

 

<moojjoo>

Tuesday, September 11, 2007

Backup and Restore on SQL Server

thanks to moonguy on MSDN he saved me many hours of work.

When you try to backup, SQL Server 2005 shows the default backup path i.e. c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ . This directory default has SQL user rights. Go to Backup directory and check the user name. Its very big name and I have not checked how SQL server adds it in allowed users list. You can do 2 things:



1. Let the Server take backup on default directory and copy the file in your desired folder. I did that.

2. Give same kind of permissions to your desired folder as Backup directory has.



Hope it solves the issue.



Moonguy