If you want more control over the e-mail, set up DBMail, and use sp_send_dbmail. You can control the whole message that way. Pretty easy to set up and...

You will definitely need to do the tail log backup before you start restoring, unless you're restoring to a different server/instance, or to a different database name. Otherwise, you'll...

GilaMonster (3/15/2011)

---

WayneS (3/15/2011)

---

GilaMonster (3/15/2011)

---

Streaming, not download. Something an issue with but PASS doesn't seem to be willing to...

Use Raiserror to raise an error and have the front-end capture that and alert the user.

-- Local Variables

declare @Dayin int = 0

,@DayGood char(1) = 'y'

,@LengthofStay int = 1

,@xx int

,@RMSDays int -- new variable

SELECT @RMSDays = RMS_Days

FROM ResMinimumStay

WHERE RMS_ResortId = @ResortID and RMS_RoomType = @RoomType and...

Don't directly call SSIS from a trigger. Triggers are part of the transaction, which means locks will last longer, concurrency and performance will suffer, and, if the SSIS package...

If you plan to do it yourself, my main piece of advice is do it in a test environment first.

Use some form of source control, and script any database changes...

You can either add them all to sys.servers, and loop through that, or you can take a look at Red Gate's Multiscript product and see if that will do what...

While there is some overhead just in having code in a UDF instead of a script, it's usually about 3-5% as a performance hit.

Here are the things I suspect are...

No, the multi-select or drop-down is primary, but they can use the free-form text if the want/need to.

You can use CLR in stored procedures and user-defined functions (and user-defined datatypes, even) in SQL 2005 and later. It's not as simple as writing lines of VB.NET inside...

I would do three data flow objects in one package for that. Easier to document that way. They can be set to run in parallel or in sequence,...

Jeff Moden (3/15/2011)

---

GSquared (3/15/2011)

---

Also, using parsename in this fashion requires more complex documentation, since it's being used in a fashion that it isn't designed for. Anyone looking up "parsename"...

Cross Apply isn't compatible with SQL 2000 (which is what Compat 80 means).

It's giving a syntax error because it thinks the Cross Apply target is a table, and the parameter...

If the report is based on a stored procedure, you can handle it there. Either raise an error, or change the To Date to something that makes sense.