hi Busxton 67,

The following is from BOL:

SET ANSI_NULLS must also be ON when you are creating or changing indexes on computed columns or indexed views. If SET ANSI_NULLS is OFF,...

Hi Snujahnavi,

For the raiserror, you have to create the message 50005 before (outside the trigger)

EXEC sp_addmessage

@msgnum = 50005,

@severity = 10,

@msgtext = N'%s',

@lang = 'us_english'

GO

alter Trigger TestTrigger

On dbo.tablefortrigger

For...

Hi dr_csharp,

Check the new features in SQL Server 2005

http://www.microsoft.com/sql/prodinfo/features/top30features.mspx

http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx

Make the jump to SQL Server 2005

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

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1194265,00.html

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

Regards,

Ahmed

Hi Anujahnavi,

For the raiserror, you have to create the message 50005 before (outside the trigger)

EXEC sp_addmessage

@msgnum = 50005,

@severity = 10,

...

hi,

Or just use Surface Area Configration to enable xp_cmdshell

Regards,

Ahmed

Hi Zaheer,

Check the following

http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/

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

Ahmed

Hi Zaheer,

Use the way described in the following links to transfer logins.

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

Regards,

Ahmed

Hi ALZDB,

If I want to create the user JustProc on AdVentureWorks datatbase.

Please Just confirm the following:

1. Connect to an instance as the sysadmin

2. Create a new login JustProc (SQL...

Sorry DaGmen

I think I was wrong check the following link http://www.mssqltips.com/tip.asp?tip=1203

As such, stored procedure based access to SQL Server from your front end applications offers the following benefits:

-...

Hi,

I am not sure you can allow user to execute Stored Procedure (which probably does a lot of Select/Update/Insert) whithout giving the user any type of access to tables. For...

Hi,

Yes you have to enable AWE.

Check the links

http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx

http://msdn2.microsoft.com/en-us/library/ms178067.aspx

Regards,

Ahmed

hi,

you can also schedule the dts to run automatically each monday.

Hi,

why you dont use a DTS/SISS or BCP to insert the data from your text file to the database.

http://www.databasejournal.com/features/mssql/article.php/3391761

http://www.verio.com/support/documents/view_article.cfm?doc_id=3846

http://www.sqlis.com/

Regards,

Ahmed

Hi,

You can use the following to perform what you want.

This proc give you Input/output on Database files (from the starting of the server until now).

it's just a little bit...

Hi,

You are rigth.

If we talk about strategies it depends on a lot of considerations.

In my case I do the following

- Backup

- Daily Full backup at 12Am.

...