Viewing 12 posts - 1 through 12 (of 12 total)
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...
January 5, 2009 at 8:39 am
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...
December 30, 2008 at 1:57 am
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...
December 27, 2008 at 10:56 pm
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...
December 27, 2008 at 6:40 am
Hai,
This is a sample CLR code, hope this will work, you can try this one:
SqlConnection
objConnnection = null;
SqlCommand...
July 26, 2007 at 5:36 am
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.
July 24, 2007 at 7:04 am
you can query / view, windows, login names in sys.syslogins view under loginname column.
Please clarify If I'm wrong.
July 24, 2007 at 4:24 am
I hope this will solve you problem.
SELECT
T1
.ID,
SUM(T1.ID)
FROM
TABLE1...
July 24, 2007 at 2:00 am
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...
July 24, 2007 at 1:21 am
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.
April 20, 2007 at 1:06 am
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...
April 19, 2007 at 11:15 am
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...
April 9, 2007 at 12:53 am
Viewing 12 posts - 1 through 12 (of 12 total)