.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Change Database and Log Properties

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :Sql Server
Hello, I have the following T-SQL code when creating a database: create database DBFA on primary ( name = 'DBFA_Data', filename = 'DBFA_Data.mdf', size = 40MB, maxsize = 2GB, filegrowth = 20MB ), log on ( name = 'DBFA_Log', filename = 'DBFA_Log.ldf', size = 20MB, maxsize = 200MB, filegrowth = 10MB ) This is working fine when creating a new database. But how can I define this properties but on a existing database? Thanks, Miguel

View Complete Post

More Related Resource Links

Change database fields automatically according to date

Hi, I'm currently developing a software application for my client. Part of the project is to keep track of his stock's shipping status. The client must insert the stock's pick-up date, expected time of departure (ETD) and expected time of arrival (ETA). The stocks will be called out using Grid View and the status, being one of the keys of the database, will be shown. Before the current date reaches pick-up date, the status must show "in warehouse", and after the current date reaches pick-up date and is before ETD, status must show that its "on the way to the port", and after ETD and before ETA, "in freight", and finally after ETA, "arrived". What datatype should I use for the database and where should I program it so that it changes automatically accordingly ?

Change SSP and Search database names

While creating SSP, besides the Admin site and MySite content databases, two more databases get created. They are usually named MySSP_DB and MySSP_Search_DB. If later we have a need to change these database names, what is the procedure? Thanks

how to create property widget and change the properties of dragged-dropped UIelement in canvas in wp

I'm new in WPF development. I'd like to learn it. I'm curious and having problem in developing property widget for the UIElements. I want to change the properties of the dragged and dropped UIElement from the Property widget. How could I do this? I'd glad if any help is suggested. I've listbox and canvas. Elements from listbox can be dropped to the canvas. I'm trying to change the properties of the dropped element through a property widget. I don't know how to do this. I'd be grateful to any kind of support.   Regards, Binaya

change password from the database

I have created login page(login.aspx) using login cotrol, now my lead asked me to provide an option "Change Password" so that end-user can change his password any time.I have created different form named as ChangePassword if you click lable ChangePassword on login.aspx page a pop-up window appears with changepassword control.how can i make this work using same(login) table. i searched around for code around i did not find.I used this link to create login page http://www.vbdotnetheaven.com/UploadFile/raj1979/VBLoginControl07242008114552AM/VBLoginControl.aspx Can any one help me,thanks

can we change the properties of any dimension member as from hidden to unhidden without deploying a

hello , well i just want to known that , can we change the properties of any dimension member/measure as from hidden to unhidden without deploying a cube.? well i have a deployed and process cube and i just want to change some measure properties to visible from hidden without reprocessing the cube so can we do like this..?.. plz help me out ...

Database Service number does not change

I notice when I check to make sure the SP3 took I still see SQLExpress\9.0.3042 instead of 9.0.4035 for SP 3. The server management studio changed has to 9.0.4035 but not the database. Can some explain this?

Change webpart properties programmatically

I am attempting to modify the properties of another webpart when my webpart's button is clicked. The code compiles and runs, and stepping through it shows that the properties do change. However, they don't stay changed. This example attempts to toggle the visibility state, but other properties won't stay changed either. Any help is appreciated.     SPSecurity.RunWithElevatedPrivileges(delegate() { // get the site in this context using (SPSite SiteCollection = new SPSite(mySiteGuid)) { // get the web in this context SPWeb myWeb = SiteCollection.OpenWeb(myWebGuid); myWeb .AllowUnsafeUpdates = true; // Hide/display another webpart. Microsoft.SharePoint.WebPartPages.SPLimitedWebPartManager mgr = null; mgr = myWeb.GetLimitedWebPartManager( "default.aspx", System.Web.UI.WebControls.WebParts.PersonalizationScope.Shared); foreach (System.Web.UI.WebControls.WebParts.WebPart myWebPart in mgr.WebParts) { // If this is the webpart we want to modify... if (myWebPart.Title == "Other Webpart Name") { // Toggle the visibility state. myWebPart.Visible = ! myWebPart.Visible; myWeb.Update(); break; } } } });

how to change the web application Database connection form Windows authentication to SQL Server acco

Hi, I have a web application created and Database connection authentication was given as Windows authentication. how can i change it to a SQL server account in MOSS 2007. Thanks in advance.

Managing TypedDataSets when there is a change in backend Table / Stored Procedure / Database schema

Hi All, I am just curious to know if there is any easier way to synchronize the TypedDataSets with the chages made to backend Table / Stored Procedure schema.  I use Typed DataSets in my project extensively and I found them very useful and easier to code, but difficult to maintain  The difficuly I have always faced is whenever there is a change in a backend database table structure or stored procedure that is linked to any of the Typed DataSet in our project requires to recreate whole DataSet again by scrapping the old one. The backend changes will not be reflected unless and untill you recreate the whole stuff again. Is there any easier way to synchronize those typed datasets with the changes made to backend database schema or any other workaround that will not required to recreate the whole DataSet again.Hope above question makes sense. Any ideas.

Change a controls properties from another window

I have a WPF App that opens a window (MainWindow) and has a button control that creates a new instance of a Window2 class and calls window2.show() When I click this button I disable it from within MainWindow code. The question I have is when the Window2 onclosing event is called  how do I access the Mainwindow button properties to enable it again. TIA Mike

EF - How to change database used by model

I created an Entity Frameworks model (.edmx). Now, I want to change the database that my model is using. How do I do that? Just change the connection string in the .edmx Properties, or is there more that is required?

Getting notified on database change

I have bound my DataGrid to a DataTable and would like to display a msg whenever there is a change in the database which might have been done by other users working parallelly. 

Cannot change the collation sequence of a Database in SQL Server 2008 R2


I tried two steps below separately: restricted user ran for 30 minutes then I stopped the execution; They obviously could not run simultaneously. I only want to operate at the database and not the server level. Our other key db is already in the desired collation. We'd like to have equijoins work on tables with the same collation sequences, and not have to use ETL or individual ALTERs for each table involved.

Second point: is CP1 below a 2000 only collation? That appears to be a patently false assumption in another forum posting. It appears to be a valid 2008 R2 collation is the point.




COLLATE SQL_Latin1_General_CP1_CI_AS ;


Many Regards,




Data Base Properties column Identity value will not accept value change


In the tutorial I am doing I have been requested to change a field in the colums properties of a table.  The ID column is currentl displaying NO and NO again for "is aIdentity.  I can Highlight the values but cannot change to yes.  either in the properties talbe or in the properties window on the right hand side of IDE interface.  How do I change that value?


How to change properties of all Controls within a TableLayoutPanel in c#


I have a TableLayoutControl that contains several buttons.

            tableLayoutPanel1.Controls.Add(button11, 0, 2);
            tableLayoutPanel1.Controls.Add(button12, 0, 3);
            tableLayoutPanel1.Controls.Add(button13, 0, 4);
            tableLayoutPanel1.Controls.Add(button14, 0, 5);
            tableLayoutPanel1.Controls.Add(button21, 1, 2);

how can I set a property for all Controls at once? For example: set all Dock properties to DockStyle.Fill ?

SSRS Change field properties dependent on the render type


I've built a report that has background images with text over the top, which when rendered as Word or Excel the images don't show and because the client has requested the text is white against the image, the text isn't visible.

What I'd like to do is run code within the report that identifies the render type and if xls will change the text color through an expression.

Any ideas would be greatful.


Communicator Presence Bubble - Can I Change / Hide the AD Properties?


My current project requires that I pull a list of users Contacts from Exchange, Present them in a web part and have the presence bubble enabled allowing the user to send mail, call, create meeting request and so forth. 

I'm calling it from code as normal: 


return string.Format("<li><a class=\"ms-imnlink\" href=\"javascript:;\"><img width=\"12\" height=\"12\" id=\"IMID12\" onload=\"IMNRC(&#39;", Contact.Email, "&#39;)\" alt=\"My SID\" src=\"/_layouts/images/imnoff.png\" border=\"0\" showofflinepawn=\"1\"/ sip=\" \"></a>&#160;{0}</li>", Contact.FullName);

IMNRC() Is going to Active Directory and populating the presence bubble with user properties from AD, such as email address, work phone, work mobile and so forth. 

I need to either find a way to populate this information from <b>Exchange properties</b>, or Hide the information all together while still offering full functionality of the p

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend