>> set @strsql=' SELECT *from history_view Where Send_by = '' &(@userid)'''

I think the above statement has problem.

Change it as follows:

set @strsql=' SELECT *from history_view Where Send_by = ''' + @userid...

declare @TableName char(50)

select @TableName = 'PING_' + left(convert(char(50), getdate(), 120), 4)

print @TableName

execute sp_rename 'PING', @TableName

>> why I was not successful when I assigned server name directly to Data Source parameter in connection string

In case of named instance, ServerName\InstanceName should be used. In case of...

>> So, is there a way on a production server to capture things like the deadlock graph without the Profiler running?

Yes. Using "WMI event alert" it is possible.

Use DATEADD function. For example:

select getdate(), dateadd(m, -25, getdate())

2008-06-23 10:03:11.3172006-05-23 10:03:11.317

http://support.microsoft.com/kb/942861

>>i can do that by running update query manually but when i run sp its not working pls help me

You mean following query is working. Right?

update testtbl set value='anj@test.com'...

Replace '31/05/2008' with '05/31/08'

>>Should I create these indexes during the schema creation or after the populations scripts?

Create indexes after pupulating the data.

Benefits:

1) Data population will be faster as there is no index update.

2)...

If you have difficulty in restoring the database using UI, use RESTORE command.

For example:

restore database NewDatabaseName

from disk = 'E:\Training_full.bak'

with move 'Training_Data' to 'E:\Training2_Data.mdf',

move 'Training_Log' to 'E:\Training2_Log.ldf'

CLR Integration Data Types ?

sp_start_job

We have alert for all the object (table, stored procedure, index, etc) changes.

>> Why do we name all constraints by the same name here?

Same name is not used for all the constraints. It is used for only for the first one...

Log is written sequentially. Therefore, multiple files will not improve performance.

You can go for it to resolve free disk space issue.