Viewing 15 posts - 4,606 through 4,620 (of 14,953 total)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 11:48 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 11:46 am
GilaMonster (3/15/2011)
WayneS (3/15/2011)
GilaMonster (3/15/2011)
WayneS (3/15/2011)
Does anyone know if we'll be able to download them later on?
Streaming, not download. Something an issue with but PASS doesn't seem to be willing to...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 11:37 am
Use Raiserror to raise an error and have the front-end capture that and alert the user.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 11:30 am
-- 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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 11:27 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 11:21 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 11:15 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 9:29 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 9:25 am
rkaria (3/15/2011)
so the user has to enter the information twice??
No, the multi-select or drop-down is primary, but they can use the free-form text if the want/need to.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 8:23 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 8:21 am
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,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 8:17 am
Jeff Moden (3/15/2011)
GSquared (3/15/2011)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 8:14 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 7:44 am
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 16, 2011 at 7:33 am
Viewing 15 posts - 4,606 through 4,620 (of 14,953 total)