Hi Teekay

10 things that will convince you to upgrade to SQL Server 2005

http://articles.techrepublic.com.com/5100-9592_11-6047958.html

But, in my opinion I will waite for SQL Server 2008 release.

Regards,

Ahmed

Hi Mahen,

I want just add thoses links which seems interesting to learn before migration

http://www.sqlservercentral.com/articles/Administration/sqlserver2005bestpractices/2183/

http://www.dell.com/downloads/global/power/ps1q06-20060126-Microsoft.pdf

http://articles.techrepublic.com.com/5100-9592-6036309.html

http://searchsystemschannel.techtarget.com/tip/0,289483,sid99_gci1229039,00.html

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

Regards,

Ahmed

Hi Shakti,

I think you have to use a cursor

Set nocount on

Declare @Post_ID int, @Post_Title nvarchar(100)

Create table #temp(Post_ID int, Post_Title nvarchar(100))

Declare c cursor for SELECT distinct [Post_ID],[Post_Title] FROM [Cfamla].[dbo].[Post_Detail]

Open...

So Im happy for you just re-write EXEC master..xp_cmdshell @CmdString, no_output

to not have the output null

Regards,

Ahmed

Hi,

try to save to c: drive I meant Set @CmdString = 'echo ' + @msg + ' > C:\save.txt'

I meant you dont have write to create file in C:\Documents...

Hi,

try to save to c: drive

Set @CmdString = 'echo ' + @msg + ' > C:\Documents and Settings\admin\Desktop\save.txt'

Insert into tablefortrigger (Lastname,Firstname) values('Anu','Jahnavi')

Hi,

I assume you already ceated the message

EXEC sp_addmessage

@msgnum = 50005,

@severity = 10,

@msgtext = N'%s',

@lang = 'us_english'

GO

Please give me the error displayed

Regards,

Ahmed

Hi,

with the following script you will have the last 20 backups.

Select

Top 20 Convert(Varchar(40), S.database_name) AS [Database Name]

,Convert(varchar(19),S.backup_start_date, 120) AS [Start Date]

,Convert(varchar(19), S.backup_finish_date, 120) AS [Finish Date]

,Datediff(s,...

Hi Zaheer, Did you tried what I already post.

Hi,

In this link you'll find transfer logins script provided by Microsoft http://support.microsoft.com/kb/246133

Regards,

Ahmed

hi vebjornwa

Check theses links,

http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx

http://www.mssqltips.com/tip.asp?tip=1367

Regards,

Ahmed

Hi Buxton69

Check the following code http://www.mssqltips.com/tip.asp?tip=1367 (good one)

regards,

Ahmed

hi,

I tested the script I already posted and it works fine, the file save.txt is created with the approriate message.

Sorry

I missed to tell you When SET ANSI_DEFAULTS is ON, SET QUOTED_IDENTIFIER is enabled

Regards,

Ahmed