If you're sql server is 2005 you can use openxml() function to the data from your xml and insert it to your table. You could also use xquery to query...

Hi as far as SSRS is concern, I think you may take the MCTS: Business Intelligence Track and upgrade to MCITP: Business Intelligence Applications Developer. It includes SSRS, SSIS and...

If the user complaint you that application is running very slow. As

a DBA where do you start your work ???how do you find where exactly

the problem is???

As for me I...

Can u send me a snapshot of your database mirror setup and any error msg if any... I'll try what I can do to help... Thanks

here is my email:

matubisalbert@gmail.com

Try creating an xml index on the fields containing xml data type. You can create Primary XML index and add secondary XML indexes

If you have configured your database mirror as High Availability (with witness). It will automatically failover to the mirror

I think this has to do with the schema. SQL Server 2005 uses schema instead of ownership.

The fully qualified names is somewhat like this

FOR SQL 2000

...

Database Mirroring in SQL Server 2005 works this way.

The Primary, witness and Secondary forms a quorom of three after a successful setup. A fail over will occur if Witness and...

I agree with Markus... You need to modify your trigger to include a statement that every time a trigger is executed, you need to insert that name of the trigger,...

try querying sys.trigger_event for sql 2005 or sys.server_trigger_events