Thanks for the reply. I have already tried it locally it works for me too, but when I'm trying to access the same as a URL it is giving me...

Thanks Bob. I already googled those quoted phrases as I just started understanding Full text search functionality I couldn't make out which link is best suited for me. I never...

wow, thanks Adi..It works perfect...::). But I have one doubt, why it is accepting braces at insertion and why can't in "replacing value of" statement? does it mean by...

sorry guys! It was my fault. I have updated the script and added the closing } brace, but still I am getting the same error message. Could you tell me...

Hai,

 This is a sample CLR code, hope this will work, you can try this one:

SqlConnection

objConnnection = null;

SqlCommand...

If you are using SQL Server 2005 , you can write a .NET CLR Procedure/Function which will gives you the windows login name. Hope this will work.

you can query / view, windows, login names in sys.syslogins view under loginname column.

Please clarify If I'm wrong.

I hope this will solve you problem.

SELECT

T1

.ID,

SUM(T1.ID)

FROM

TABLE1...

I guess you can recover your data back in two ways:

1. By taking backup of your db, before deleting the data, and recover it later. Or

2. Create an object in...

Thanks Greg,

  I'll go through the BooksOnLine as you said and try to get information for the "DDL trigges" and "Event Notification" in SQL Server 2005.

Y.Kiran Kumar.

Thanks Greg,

  My question was how will the second sysadmin get an alert or saved on a log file about the changes made by the first sysadmin. What my intention...

Hai Philip,

Its true that microsoft put lot of effort for security in SQL Server 2005. That way, in sql server 2005 there are two types of fixed roles are provided:

1. Fixed Server roles.

2. Fixed...