Search Results

A small query

Thread by: Siona, Sep 30, 2009, 6 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, I need to alter a existing column to IDENTITY in a table, but it is not happening. I mean in my table "Employee", Employee_ID column is...

Database Mirroring VS Database Replication?

Thread by: Siona, Jun 18, 2009, 4 replies, in forum: SQL Server 2005 General DBA Questions

Dear All, We have a special requirement like we have around 21 servers across the globe and running few .net application and other OLTP system and...

Running Job Status

Thread by: Siona, Mar 11, 2009, 5 replies, in forum: SQL Server 2005 General Developer Questions

Hi All, In my server 100 nos. job are scheduled. And itâ€™s all automated. I want to store the status of the entire Job running on a day in a table....

XML Indexing

Thread by: Siona, Mar 3, 2009, 4 replies, in forum: SQL Server 2005 General Developer Questions

Dear Friends, I need to know what XML Index is and what architecture itâ€™s following. And how itâ€™s working during the execution..?? Cheers! Siona.

Which one is better Option? Sp Vs. Function

Thread by: Siona, Mar 2, 2009, 7 replies, in forum: SQL Server 2005 General Developer Questions

Dear Friends, In Sql Server which one is better option for a reusable codes. FUNCTION or Stored Procedures.. Cheers! Siona.

My Sql Problem

Thread by: Siona, Mar 2, 2009, 4 replies, in forum: General Developer Questions

Dear Friends, I have a Table with one Identity column. I want to insert few records.I want to make off identity and after inserting identity should...