This is exectued in ssms 2008 against a 2005 database.

Server[@Name='XXXX']/Database[@Name='master']/Table[@Name='DeadlockEvents' and @Schema='dbo'] ...

So SSMS for 2008 is not backward compatible. I understand what Peter had written but the point is we connect to both 2005 and 2008 databases using the SSMS...

It's not a sql2008 db. It's only mgmt studio connecting to sql2005

We are running into the same problem. Create a user and grant them db_datareader. They'll not be able to see all the tables. We can see some...

Where do you find the AlwaysUseDefaultCodePath="TRUE" . I'm using ssis to go from sql to oracle 10g

This will put your am or pm in there for ya.  Enjoy

select convert(varchar(20),getdate(),101)+' ' +convert(varchar(20),getdate(),108)+' ' +substring(convert(varchar(20),getdate(),100),18,2)

Here are my results with the below query -- 08/10/2004 09:13:34

select

convert(varchar(20),getdate(),101)+' ' +convert(varchar(20),getdate(),108)