I have to agree with Anthony. Something changed the password, it isn't going to change itself. I'm not sure if the default trace will be of help as...

anthony.green (3/15/2012)

---

have you removed the username from the error message or is the error saying its a blank user?

Msg 18456, level 14, State 1, Line 1

Login Failed for user ''

or

Msg...

Everyone is guessing at what you need. How about telling us what you really are trying to accomplish.

What we are trying to say is that we need more information. To convert seconds to time we need to know the basis of the seconds. Is the...

According to this, http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx#physical_memory_limits_windows_server_2003_r2, Windows Server 2003 R2 on 32 bit servers only supports 4GB ram.

SQL Server 2005 SE X32 supports what the OS supports, http://msdn.microsoft.com/en-us/library/ms143685(v=sql.90).aspx.

According to this, http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778(v=vs.85).aspx#physical_memory_limits_windows_server_2003_r2, Windows Server 2003 R2 on 32 bit servers only supports 4GB ram.

SQL Server 2005 SE X32 supports what the OS supports, http://msdn.microsoft.com/en-us/library/ms143685(v=sql.90).aspx.

Not sure if AWE is...

Please read the first article I reference below in my signature block below regarding asking for help. Follow the instructions on what to post and how. In this...

Please read the 2nd article I reference in my signature block below regarding ask for help with performance issues. Follow the instructions regarding what to post and how. ...

ColdCoffee (3/14/2012)

---

How about this?

Sample data

DECLARE @Table TABLE ( DatetimeasVC VARCHAR(30) );

INSERT @Table

SELECT '10/28/2011 11:47:55.686455 AM'

UNION ALL

SELECT '9/28/2011 11:47:55.123455 AM'

UNION ALL

SELECT '11/12/2011 11:47:55.789455 PM'

UNION ALL

SELECT '10/9/2011 11:47:55.9996 AM'

UNION ALL

SELECT '1/26/2011 11:47:55.3456...

Amazing he is...

GilaMonster (3/14/2012)

---

jcrawf02 (3/14/2012)

---

I don't know, that's always bothered me because he never went back before then to even check on her (at least we're not told that) but he's got...

ColdCoffee (3/14/2012)

---

Lynn Pettis (3/14/2012)

---

Or, if all things being equal:

DECLARE @DatetimeasVC VARCHAR(30);

set @DatetimeasVC = '10/28/2011 11:47:55.686455 AM';

select convert(datetime,

substring(@DatetimeasVC, 7, 4) + substring(@DatetimeasVC, 1, 2)...

Looks like each table variable needs to be declared separately, just like creating tables.

Nope, I don't see what you are trying to accomplish. Might help if the expected results were formatted to see what values are in what column.

SQLRNNR (3/14/2012)

---

GilaMonster (3/14/2012)

---

Stefan Krzywicki (3/14/2012)

---

GilaMonster (3/14/2012)

---

Yes, I can think of a large number of ways not to use a linked server,...