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


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

How to check time difference between two SQL 2008 servers

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server
 

Hi

I have multiple SQL server and want to ensure time is sync between them.

All the servers have common SNTP.

But I want to check the sync.

 

Any options to try are welcome.




View Complete Post


More Related Resource Links

Time Difference in Linq queries

  

Hi All,

 

I have my Linq query in which i need to find time difference(not days difference).

The field in database is datetime.

Dim ldtToday As DateTime = TimeOfDay

Dim SR_RM_InnerJoin = From SR In lcntxRT60Entities.RtSReports _

Join RM In lcntxRT60Entities.RtRMaster On SR.RtRMaster.ReportID Equals RM.ReportID _

Select SR, RM _

SQL 2008 servers and MOSS 2007 with SSRS

  

I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?


difference between win 2003 Ent and Win 2008 Ent

  
what is difference between win 2003 Ent and win 2008 ent in clustering environment?

Time difference : Hosting Server and client

  
hi All,I have asp.net/c# web project. How to manage the time difference between the server and clientFor instance, I am at India, and Server is located at UK. So if do any activity, like "comment on friend's photo" etc. the time stamps is UK's time. So if do some activity from India at 10.00 AM, the time stamp would be 5.00 AM. So if the user who sees his activity at 10.00 AM sees it as if it was done at 5.00 AM.If user whom he acted upon (like friend whose photo got the comment) too see 5.00 AM. this is ok if the friend is at UK, but causes confusion if he was at other time location like Australiahow to handle this

Time Difference

  
Hi frends,              I have used four dropdownlist, and one Textbox. dropdownlist contains  Hour(StartingTime,EndngTime ) and min(StartingMin and EndingMin), both are in 24 hours format..Now I want to calculate the Time difference between 2 times.I tried, but not working properly. int _startintime = int.Parse(dropdownlistSHour.SelectedValue); int _endingTime = int.Parse(dropdownlistSMin.SelectedValue); try { DateTime begin = new DateTime(); DateTime end = new DateTime(); begin = begin.AddHours(double.Parse(dropdownlistSHour.SelectedValue)); begin = begin.AddMinutes(double.Parse(dropdownlistSMin.SelectedValue)); end = end.AddHours(double.Parse(dropdownlistEHour.SelectedValue)); end = end.AddMinutes(double.Parse(DropDownListEMin.SelectedValue)); TimeSpan ts; ts = begin.Subtract(end); textboxDuration.Text = ts.ToString(); }

how to check one time java script file download not every session

  
how to check one time java script file download not every session

Visual studio 2005 - Port Number is difference during run time.

  
Hi, When I debug(F5), the port number display in the URL is difference from the ASP.net development server. Eg: URL address port number is  - 1084, while for the Server is 1088 I have tried difference ways such as trying to set the dynamic port to false, so that I can configure my own port, but it is not able to work. I have also turned off the ESet Firewall however the port number is still difference.  Need your help in this area.. Thank you! 

SSMS 2008 & Activity Monitor's Processor Time graph is disabled

  
Hi,I just upgraded one of my SQL 2005 clusters to SQL 2008 with CU9.  Now, when I connect to it with SSMS, either from my workstation or directly on a cluster node, the % Processor Time graph in the Activity Monitor screen is disabled.  The other three graphs are fine.  If I connect to a different SQL 2008 server, the % Processor Graph is fine.  I don't see any errors in any app event log.  Has anyone else seen this behavior?Thanks!

No Servers listed under Database Engine in SQL Server 2008 on Windows Server 2008 R2.

  
Where to begin. It's late so I hope I can be clear. I have installed SQL Server 2008. I am running Windows Server 2008 R2. I have installed SQL Server four times and I continue to have issues connecting to the Database Engine. Installation has gone without a problem at least to my knowledge I have not been presented with any errors. I have also created a local administrator account called "spadmin" to use to connect to the SQL Server database and to use with SharePoint 2010. Which brings me to the reason why I want to run SQL Server - I want to evaluate the latest SharePoint Server 2010 and WSS. Unfortunately, I have not been able to go beyond installing SQL Server and connecting to the database, because there is no database instance showing under the Database Engine, except under Integration Services. I have the following services installed: SQL Acitivey Directory Helper Service SQL Full-text-Filder Daemon Launcher SQL Server SQL Server Agent SQL Server Analysis Service SQL Server Browser SQL Server Integration Services 10.0 SQL Server Reporting Services SQL Server VSS Writer Am I missing something? I have been following several online instructions on how to install SQL Server 2008 and I can't seem to find where I may have gone wrong. After I install SQL Server 2008 am I supposed to see the default instance (MSSQLSERVER) listed under the Database Eng

Conversion failed when converting date and/or time from character string. SQL 2008

  
The below simple query giving me the "Conversion failed when converting date and/or time from character string." error. Because I've  datatype of "Created" & "Finished" column in below table VARCHAR(100) select * from dbo.mytable where CONVERT(datetime,Created) >= convert(datetime,'9/1/2010') and CONVERT(datetime,Finished) <= convert(datetime,'9/9/2010') In my table i've date stored in below varchar(100) formats. examples: '2010-09-01 11:14:54.000' --Created '2010-09-03 13:43:37.000' --Finished I tried to convert the date in following way but NO luck??? Could you please advise me??? convert(datetime,convert(varchar,convert(datetime,Created),101)) >= convert(datetime,'2010-09-01') and convert(datetime,convert(varchar,convert(datetime,Finished),101)) <= convert(datetime,'2010-09-09') Much appreciated your help!! thanks, pbrathod pbrathod

SQL Server 2008, what is the difference between (for/after) definition for trigger?

  
Hello. The difference is not clear for me. can someone explain it more carefully pls? as said: FOR | AFTER AFTER specifies that the DML trigger is fired only when all operations specified in the triggering SQL statement have executed successfully. All referential cascade actions and constraint checks also must succeed before this trigger fires. AFTER is the default when FOR is the only keyword specified. So what is the difference between for insert and after insert?

Conversion failed when converting date and/or time from character string. SQL 2008

  
The below simple query giving me the "Conversion failed when converting date and/or time from character string." error. Because I've  datatype of "Created" & "Finished" column in below table VARCHAR(100) select * from dbo.mytable where CONVERT(datetime,Created) >= convert(datetime,'9/1/2010') and CONVERT(datetime,Finished) <= convert(datetime,'9/9/2010') In my table i've date stored in below varchar(100) formats. examples: '2010-09-01 11:14:54.000' --Created '2010-09-03 13:43:37.000' --Finished I tried to convert the date in following way but NO luck??? Could you please advise me??? convert(datetime,convert(varchar,convert(datetime,Created),101)) >= convert(datetime,'2010-09-01') and convert(datetime,convert(varchar,convert(datetime,Finished),101)) <= convert(datetime,'2010-09-09') Much appreciated your help!! thanks, pbrathod pbrathod

Need to find File Share Excel Rendering time--SSRS 2008

  
we are using SSRS 2008 file share subscription to generate EXCEL reports,Requirement here is need to find the file rendering/completion time in order to send the excel file as attachement using xp_senddbmail. Your help is highly appreciated-- Sathish

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

Application time out Error after installing SQL Server 2008 R2 64 bit + CU3

  

Hi all,

webapplications  are  suffering  after installing SQL Server 2008 R2 64 bit  in my mechine.

Did i have do any thjing more make the connectons(validation faster)  or SQL Server 2008 R2 behaves like that..

any idea or suggestions are appreciated.

 

Thanks in advacne

 

 


SNIVAS

Query execution time from 1 second in SQL 2000 to 20 Seconds in SQL 2008 R2

  

When I ran this query from SQL 2000 it takes 1 second. now in SQL 2008 R2  the same query is 20 times slower.

This is the query and the numer of records and the time in SQL 2008 R2:

SELECT * FROM dbo.CxP_Saldos 
0 seconds, 923 Rows
SELECT * FROM S_Conta.Cuentas
0 seconds, 662 Rows
SELECT * FROM S_Conta.Cuentas c INNER JOIN dbo.CxP_Saldos s ON c.id = s.CtaProv
18 seconds, 923 Rows

how can I submit the actual execution Plan?


How to store only date and only time into sql server 2008 from C# asp.net 3.5

  

Hi 2 all,

can anyone help me how to store only date into sql server 2008 from C# asp.net 3.5.

I want to store only date(like 26/05/1986) and only time (like 04:45:40 AM) into sql server 2008 .

I am using C# asp.net 3.5 as front end.But i am not getting how to convert datetime into only date and only time from front end application.

It should not be as a string from front end.it should be as a date type / time type.

I can not see only date or only time data type in VS 2008.

so please help me how to store only date or only time into sql server 2008 having only date or only time as a data type.


Thanks and Regards,

Arvind Pathak


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