Pratibha_Pillai (5/27/2009)
Hi,I came across default trace offered by sql server 2005.
1)Can it act as a substitute to DDL triggers?What's the difference between them?Also I didn't find any column in the log file where i can get the sql command which was fired last.
2) Also can anyone give me a brief idea as to what is the pupose of scripting(wherein we use the wizard to script different objects) is it also a way to track database schema changes?
Actually I am in a way to find the best way by means if which i can track the schema changes on server db and notify the same to the client(sql ce).
3)How can i propagate the schema changes from server to the client(mobile) and are the sql command compatible to sql ce commands?
Thanks in advance.
A trace is not a substitute to a DLL trigger. a trace simply shows you the commands the sql server engine is performing at any different time. a DLL Trigger is a piece of code that gets fired on a schema change. The main question is what are you trying to do. Since what i believe that what you're trying to do is your question 2 and 3, I can recommend [url=Randolph - http://www.nobhillsoft.com/Randolph.aspx?HeardVia=Itamar%5DRandolph%5B/url%5D (SQL version control tool) which is really the best way to get those things done.
--------
SQL Data compare , Synchronize data from diffrent surces, and many other SQL tools[/url].