looks like you are looking at the right tag, i think. maybe it's int he AlterTableActionList?

http://schemas.microsoft.com/sqlserver/2006/11/eventdata/

inthe ALTER_TABLE events,

here's the XML tags:

-<xs:complexType name="EVENT_INSTANCE_ALTER_TABLE"> -<xs:sequence>

<!-- Basic Envelope -->

<xs:element type="SSWNAMEType" name="EventType"/>

<xs:element...

the Stairways series is a great start:

http://www.sqlservercentral.com/stairway/

there is a LOT of different subjects, and they build up in complexity and understanding as you go through each stairway.

I'd recommend starting there.

just guessing here, converting zero to datetime is allowed; converting zero to datetime2 isnot.

select CONVERT(datetime,0)

select CONVERT(datetime2,0)

Msg 529, Level 16, State 2, Line 1

Explicit conversion from data type int to datetime2...

for best practices , this is a really good reference:

Troubleshooting SQL Server: A Guide for the Accidental DBA

by Jonathan Kehayias and Ted Krueger[/url]

Simple-talk also has a collection of books,...

unless you obscured the items you pasted for security reasons, it looks like you have two instances installed:

SQLLocal\INSTANCE05,5678

SQLLocal\INSTANCE02,2932

so you should be able to conect to either of them by...

nice first post, you provided quite a bit of info.

my first point, is in the future, if you can provide your data as CREATE TABLE / INSERT INTO statements like...

sufiyan.sarguroh (7/20/2012)

---

This does give access to only two tables , but does this prevent him from viewing the SPs and views ? Does it have to be done explicitly .

Also,...

could it be that really large execution plans are getting truncated at 8K in the grid,and since it's not valid XML with an ending tag, you only see the text...

i tried pasting your code in SQLserver management studio, and it gives errors;

are you working in another language, or did you paste pseudocode?

ranganathanmca (7/19/2012)

---

Thanks for your reply,

Actually i am passing the product id only so if 2 sub product we are getting 2 set of results, i need to avoid those type...

my wild guess:

SELECT *

FROM [mainproduct]

LEFT OUTER JOIN [subproduct]

ON [mainproduct].mainproduct_id = [subproduct].mainproduct_id

LEFT OUTER JOIN [product]

...

ok, so my answer is D. Seven function types. Final Answer.

(...waiting for the failure buzzer.....)

my thinking is there are the Built in functions plus these six others.

AF = Aggregate function...

sqlfriends (7/19/2012)

---

Thanks, I know how to check collation from SSMS and code.

I cannot connect to this server somehow from other SSMS client.

And on the server itself no SSMS installed, there...

there's not very many differences between 2005 and 2008; first make sure the compatibility level on the target database really is 9.0/90 if it is 2005. you might be hitting...

just tested this, seems to give what you asked for:

select SERVERPROPERTY('Collation') As ServerCollation,

name As DatabaseName,

collation_name As DatabaseCollation

from master.sys.databases