Many of the suggestions that we would recommend may not have even been covered by your instructor yet. I'm sure you have been given all the information you need...

You can put a use statement in the script.

Use database1

go

Select statment

Use database2

go

Select statement

What you can do is if the parameter is null set it to equal itself. If you pass a parameter it will use the value otherwise it will ignore...

I really like the Exam Cram series. The chapters are short and to the point. There is a small test at the end of each chapter, and two...

Can you do a ...

replace(varText, '''', '''''')

If the database is in Full recovery mode, you need to take scheduled log backups. If you do not need log backups, change the recorery to Simple.

LOG truncates occurs...

Here is a script I wrote to collect the space for the drives and the databases.

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

You can use the bcp command to write directly to a file.

DECLARE @FileName varchar(50),

@bcpCommand varchar(2000)

--The character after -t notes the field delimeter. If -t is removed tab is the...

sheetalsh (6/26/2008)

---

Hi Ken,

It's giving error as follows:

Msg 321, Level 15, State 1, Line 28

"sql_handle" is not a recognized table hints option. If it is intended as a parameter to a...

Here is the script. I am not sure why it will not copy correctly from the article. When you copy the script from the article there is no space...

DROP DATABASE FILE

IF NO BACKUP TO RESTORE

BEGIN TO DENY

Here are some samples of setting up and sending database mail.

http://cybersql.blogspot.com/2008/06/script-to-setup-database-mail.html

One thing you can check is the sysmail_allitems table and see if there are any errors.

SELECT * FROM...

You have to download Management Studio seperately.

http://www.microsoft.com/downloads/details.aspx?FamilyID=6053c6f8-82c8-479c-b25b-9aca13141c9e&DisplayLang=en

You have to open Sql Server Business Intilligence Development Studio.

Here you go.

UPDATE fiscaldate

SET fiscaldateperiod = ( CASE

WHEN MONTH(fiscaldate) < 6 THEN dateadd(m,6,fiscaldate)

ELSE

dateadd(m,7,fiscaldate)

END

)

from fiscaldate