There are a few methods you could use: sp_detach_db/sp_attach_db, BACKUP/RESTORE or ALTER DATABASE.

The steps to move the datafile using ALTER DATABASE would look something like this.

1) ALTER DATABASE myDB SET...

Manie,

Another thing you might want to check is the Alert System settings, which is a property of the SQL Agent. See if a Enable mail profile is enabled.

Slow compared to what? How many rows are in your table?

Two things you might want to start with. Look at the query execution plan. That will tell you...

Mark,

Since you want results based on an aggregate function look at using the HAVING clause in a SELECT statement.

Try building a statement using that. If it doesn't work out...

Since database mail saves messages and attachments in MSDB you'll also want to look at scheduling these two stored procedures as part of routine maintenance.

[font="Courier New"]msdb.dbo.sysmail_delete_mailitems_sp

msdb.dbo.sysmail_delete_log_sp[/font]

Look for the following topic...

Doing the date calculations in the WHERE clause would get you the records that are on the last day of the month for which it falls in.

CREATE TABLE Table1 (col1...

Chris,

I've seen that type behavior but it affected all files, not just those from a single application.

First suspects I'd look at though are any filter drivers, which can be checked...

ptheberge (6/30/2008)

---

The second operant field is giving me issues too.

How does the XML Task determine the number of rows returned and what is referenced in the procedent constraint in the...

The DATENAME function might be what you're looking for.

SELECT DATENAME(mm,DATEADD(mm,-1,GETDATE()))

Have you checked both share level and NTFS permissions?

From a recovery perspective it doesn't matter. You can only use the Full and Differential backups with the Simple recovery model.

As for what size it should be initially that...

It sounds like your backup is being appended to. Have a look at the "INIT" option. That controls whether the an overwrite or append operation happens.

To see how many...

Matt,

First place you'll want to look is the online help, known as Books Online, for using SELECT, INSERT, UPDATE and DELETE statements.

In SQL Server Management Studio you'd open a new...

Bob,

Choose "When the job completes" if you want a notification regardless of whether it succeeds or fails.

I think you've identified that correctly. You might want to go through all your tables with columns that can hold text data and search for the word 'script' to...