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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

database refresh time

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :ASP.Net
 
Hi,we have a sql server 2005...that has 70-80 databases and hundreds of tables....It is supposed to refresh every night.... refresh is done by other vendor(3rd party).... we dont know what method(technology) they use to refresh the databases....My question is .....Is there a good way to know when the last refresh has happend...can we determine it from sys tables.....the sql server is installed in window server 2003 box.... we have access to the box as well as the sql server.....plz suggest...


View Complete Post


More Related Resource Links

huge number of data from database ... so how to minimize load time

  


Hi ...

I have used the above method to configure my crystal report ...

Its working fine , But i have huge number of data in database ....

So , it take long time to load the report ...

So , i have decided to show only the last 50 records inserted into the database , not all the 500 records to be loaded every time.

Plz help me with this issue  ...

 

Also , Plz explain me abt index legend in crystal report.


Can this code be setup to run against the whole database instead of just 1 record at a time?

  

We have made some changes to this code to start capturing 1 new field of data and updating it as new records are added. But there is currently about 120,000 records more or less.. those records of course dont have the new field populated with anything..

We would like to run this logic that already in place and run it against the tables to update the fields 1 time. I think to make it easier, if it can be setup to expect the "valueTwo" variable, so that we can run it againt the individual codes instead of doing all the records at one time.. there are codes that only have a few records, so it would be best to test initially against the small code group.

thanks.

  
            strSqual = "insert into trans (trans_type_name, trans_date,sys_id,mod_user_id,show_ind, remoteCode, techName) values('" & valueTwo & "','" & TransDate & "',"&strSystemID&", 1,'T', '" & dbQuote(strUser) & "', '" & strTechName & "')"        
  
            getStaticRecordSet(strSqual)   
            'get the new transaction_id out for just inserted alarm   
            strSqual = "select max(transaction_id) as transaction_id from trans"  
            set rst = getStaticRecordSet(strSqual)

Crystal Report Asking for Database Authentication each time when I view Page.

  

Whenever I open my Crystal Report page, I am taken to the Database Authentication page where I am asked for

User name
Data Name
Password

each time.

Is there a way to avoid this and I save these authentication in my page once.

I am using VS2005, C#.

Any Help will be appriciated.

Thanks
Asif


Refresh update panel when database changes

  
I have an admin page in which I need to change the list whenever a user signs up on our web site.How can I put and event to MySql database so that whenever the count of  a table row changes it refreshes my update panel for me to see the new user.

VS 2010 could not find database at design time

  
Hi all, I'm having this problem.... Scenario: C# 2010, WPF, SQL Compact 3.5 SP2. I'm working at a wpf window which loads records from a SQL Compact DB and shows data in textboxes. At runtime everything works perfectly but since this morning (working on it last 2 days) i'm not able to edit the window at DesignTime. As soon as I open the window with the wpf editor I got the error (translating from Italian): "Impossible to find the database. Check the database path. [Data Source = C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\thedbfile.sdf]" Now, in settings and app.config I have the connection string which is something like Data Source=|DataDirectory|\thedbfile.sdf I don't understand why and where NOW (only since this afternoon) at Design Time VS look that path for the database, while at RunTime it's ok. Again, I'm using Datasets, and I can preview data, ecc., as said everything is ok except the edit of the window which crash with this error.... thanks

adding sqlserver database files in the time of project deployeement

  
hi all,        how can i add sql server 2005 database files in the time of a windows application project deployment i have designed a project in Visual Studio 2005 using vb.net language and i want add sql server 2005 database file to it. i am connecting to sql server database by the connection string not using any any dataset or anything else. so how can i add database file ... please replay... 

VS 2010 could not find database at design time

  

Hi all, I'm having this problem....
Scenario: C# 2010, WPF, SQL Compact 3.5 SP2.

I'm working at a wpf window which loads records from a SQL Compact DB and shows data in textboxes. At runtime everything works perfectly but since this morning (working on it last 2 days) i'm not able to edit the window at DesignTime.

As soon as I open the window with the wpf editor I got the error (translating from Italian):

"Impossible to find the database. Check the database path. [Data Source = C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\thedbfile.sdf]"

Now, in settings and app.config I have the connection string which is something like

Data Source=|DataDirectory|\thedbfile.sdf

I don't understand why and where NOW (only since this afternoon) at Design Time VS look that path for the database, while at RunTime it's ok.

Again, I'm using Datasets, and I can preview data, ecc., as said everything is ok except the edit of the window which crash with this error....

thanks


Refresh time in custom webpart

  

Hello all,

Am developing a custom webpart for sharepoint using c#.net ,and am writing my code only in class library and deploying directly to sharepoint portal,my plm is am able to dsipaly current date and time success fully with the help of date and time functionality,like

DATETIME TME=DATETIME.NOW; and etc etc
 
with this am able to dsiplay current date and time but after deploying into the sharepoint portal am unable to see my time changing according to the system time i.,e time is not refreshing,please help me out from this issue!!

 

Thanks!

 


Restoring Database taking long time in SQL Server 2008 R2 -- some how urgent

  

Hi all

I have Database size 12GB in SQL Server 2005 and It is backed up.

Now I tring to restore Database in SQL Server 2008 R2(wizard)....it is not at complted after 2hours...still running.

 

any idea..or help appreciated..

 


SNIVAS

Accessing my Web Application's database with MSSMS at the same time.

  

Hello,

I wish to acces my database using MSSMS at the same time that I am running my web application. When I tried to access my database with MSSMS I get the following error:

Failed to retrieve data for this request (Microsoft.SqlServer. Management.SDk.Sfc)

Additional Information:

Unable to open the physical file "C:\inetpub\wwwroot\myapp\App_Data\aspnetdb.mdf".
Operationg system error 32: "32(The process cannot access the file because it is being used by another process)". (Microsoft SQL Server, Error:5120).

What can I do to being able to view my database with MSSMS at the same time?

Thanks for your help,

Louis



How to Refresh Gridview data from update panel in specified time

  

hello frnds,

i have some search criteria.

after filling all criteria when i press search button the result arrives in gridview nw when searchbutton pressed after that every 20seconds i want 2 update gridview data which is in update panel



Refresh dbml when database schema changes

  

Hi,

 I have a .dbml file that I have dragged several tables on to from a database in the Server Explorer.  I have written a lot of code against the model that was created.

Now I have added another table (Companies) to the database and a Foreign Key in one of my existing tables (People) which references the PK of the new table.  I have refreshed the Server Explorer and can see the new table and the new FK in my existing table.  I can drag the new table on to the dbml workspace, no problem.  But how do I make the new FK appear in the dbml class?  I have tried right-clicking on the .dbml file in the Solution Explorer and choosing "Run Custom Tool" but that doesn't do anything.  I suppose I could just delete the .dbml file and start all over again, but surely there is a better way!  Eventually there will be dozens of tables involved and recreating every time one column changes in one table would be very painful.

Please tell me that I am overlooking something simple.

As a matter of interest, what if I went the other way and added or modifed a class in the dbml, can I get the database schema updated?

thanks in advance

Paul


Refresh dbml when Stores Procedurs are Changed in database

  

Hi.

I have a DBML file in C#. And I have drag and drop some Stored Procedurs in it . Now I have changed some SPs. Now I want to refresh the dbml file without drap and drop the SPs. How can I do it in C#. Is there any way that the changes Made in SPs will come with out drag ang drop the SPs.



SSAS Cube to give an error when cube not available during refresh time

  

Hi,

I am currently using the below query to know my last cube refresh time,

My cube refesh time is not fixed , I am trying to create a report which shows a status of cube availability i.e status should show red when cube is not available and when cube returns some value then it's green . How do I do that.

SELECT Cube_Name, Last_Data_Update

FROM $SYSTEM.MDSCHEMA_CUBES


XML with PrimaryKey values to delete rows in database table at a time

  

 Hi,

I'm having a gridview in my aspx page with checkbox, User can select one or more than one record(s) at a time and clicks on delete button, Then i'm constructing an object of my DTO and adding all the checked row's Primary Key (DataKeyNames - GUID's in my case) to a serializable class and generating an XML and sending it as parameter to the Stored Procedure.

My Doubt is, can i bulk delete all the rows from database table those are present in my XML document??

If it works, I can do bulk update with XML only, i already did bulk insertion by generating an XML..

My Another Question is, Will it affect the performance? Each time when i construct an DTO object and adding it to the Generic List??

WHich one is better, I mean ObjectDataSource or SQLDataSource or my XML method??

Can anyone please help me out clarifying my doubts and also XML Delete Query..

 

My XML will be like this

 

<root>

<Customer>

<CustomerID>GUID1</CustomerID>

<CustomerID>GUID2</CustomerID>

<CustomerID>GUID3</CustomerID>

 ...

 ...

</Customer>

</root> 

Will bulk delete happen in the above case?

Thanks,

PAvan


first time use and got error when trying to attach database from management sudio

  

I am trying to attach a database from Management sudio.  I just installed SQL Express and this is the first time trying to attach a database.  Thanks  David

And get the error immediately after right clicking to attach database:

===================================

Cannot show requested dialog.

===================================


Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridControl)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidthInternal(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
   at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidthInternalForPublic(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
   at Microsoft.SqlServer.Management.UI.Grid.GridControl.SetColumnWidth(Int32 nColIndex, GridColumnWidthType widthType, Int32 nWidth)
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SetGridColumnWidth(SqlManagerUIDlgGrid grid, Double[] columnWidthRatio, Int32 columnIndex)
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SetDatabasesGridColumnWidths()
   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.OnScale()
  

How to handle Daylight Saving Time issues in sql server Database

  

Hi We have users across the globe and have issues everytime the Daylight Savings change occur. Is there a way to handle this issue in sql server?

Thanks


Categories: 
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