Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. renatoboscolo

    Database mail didn´t send external e-mails from exchange account

    We have a SQL Server 2008 in a Windows Server 2008 and set database mail using an exchange account (2007). E-mails send to the same domain are sent and delivered. E-mails send to another domains are sent but not delivered. When we set this account in a outlook profile using smtp works fine...
  2. renatoboscolo

    Comand to convert Datetime - diferences from sql 2000 to 2008

    Thanks gmmastros! It was a login language difference. My login in SQL 2000 is in English but 2008 was in Brazilian. I changed to English and worked as it is in 2000 w/o change any code. Thanks for all!
  3. renatoboscolo

    Comand to convert Datetime - diferences from sql 2000 to 2008

    Yes, it is a datetime field. In fact, I know how to fix this command. But I am migrating from 2000 to 2008, and this means I would need to change all codes. My question is why works in 2000 but not in 2008, since the regional settings are the same. Is there a setting I change to the command...
  4. renatoboscolo

    Comand to convert Datetime - diferences from sql 2000 to 2008

    The following sql command works fine in my sql 2000 but not in my sql 2008: select * from table1 where fd_data >= convert(varchar(10),GETDATE(),101) SQL 2000 - windows server 2003 portugues - regional settings: English (United States) - local: brasil - non unicode: English (United States)...

Part and Inventory Search

Back
Top