Try and 'SLIPSTREAM' the SP2 installation file on to the SQL installation files. This will create new installation files for SQL with SP2 included.

There are many websites providing a step-by-step...

When you create and send a test-mail, do you recieve this mail?

Try following the steps provided in the topic "Troubleshoot Database Mail" in BOL.

This code is a VB Script file that will read a folder and add the text of each file to a new (combined) file. The combined file can be executed...

ananda.murugesan (10/12/2008)

---

i want script itself how to attach at @messagefile backup report text file automatically from particular disk path,

For example - @messagefile = N' C:\dbbackup\filename.txt', this file name has...

Try changing the notation of the date.

Instead of

use CAST('20081008 12:01PM' AS DATETIME)

You should also check if the local settings of the machine are...

After closing all applications, you have to look for running processes. It sure looks like you have an application running on the background (or hidden). If the failing logins also...

Try removing the dashes from the value in variable @WeekEnding:

Set @WeekEnding = '20080101'

This is the general notation of dates as a string that will convert to correct datetime values.

And what...

Keep in mind that if the table has a clustered index, the column or columns defined in the clustered index are automatically appended to the end of each nonclustered index...

chad (10/1/2008)

---

There are 3 non-clustered indexes on this table. One on the Date Entered column, another on a integer ID column, and the last on both the Date Entered...

If you need to update existing records and insert new records you need to program a kind of MERGE command. Several samples can be found on this site.

Here's a very...

dcarpenter (10/7/2008)

---

select u.username +' '+u.surname,sum(total_boarded), sum(placementfee), count(p.placementid) from targets t

join users u on u.userid = t.userid

left join placementconsultants pc on pc.userid = u.userid

join placements p on p.placementid = pc.placementid

group by...

jpim3nt3l (10/7/2008)

---

1. Are there other ways wherein I could do the export / import more easily?

2. What's the best delimiter to use when exporting data?

3. What's the best way to...

Storing photo's in your database will certainly increase the database size. This will have impact on your backups and recovery. But this option will give you enhancements about integrity, because...

If the login is originated from your computer and the error is captured every 5 minutes, it could be a scheduled task.

Else I suggest to look with task-manager on your...

Looks like the SQL Engine tries to open the file 'D:\Master_Files\Model_Data', but it doesn't exist. Copy your msdb.mdf file to this location (and...