Viewing 15 posts - 181 through 195 (of 208 total)
i have never used profiler before, should i be able to pick it up pretty quickly?
April 12, 2010 at 8:17 am
ok, from my research i think i will go with the following
1. From the SAN present several LUNS, one is VMFS for the OS and the rest as RDMs
LUN1 -...
April 8, 2010 at 6:08 am
Hi David
i would, only i see how its installed at the moment based on what i can tell there advice, (iv just started with the company a few weeks...
April 2, 2010 at 4:06 pm
Any advice anyone? 🙂
would love to be able to get an expert in and get a bit of tutoring but its simply not an option at the moment, tho i...
April 2, 2010 at 9:21 am
Hi Eddie
the SAN must be divided into whole physical disks.
it will have 12 x 300gb SAS 15k discs
we have approx 10 database's not counting logs or system db's
the most important...
April 1, 2010 at 4:49 am
thats fine, i understand now!
thanks for getting back to me very much appreciated
March 31, 2010 at 3:25 pm
Hi jeff
could you tell why this will wait until all updates are notified? i know it does i just dont understand why :w00t:
what is the SELECT @msg = ISNULL purpose?
March 31, 2010 at 8:50 am
cheers for that jeff! will come in useful im sure
March 30, 2010 at 3:46 pm
sure i can 😀
create trigger TestStock on dbo.mal_test After insert as
declare @StockCode varchar(10)
declare @Description varchar(10)
set @StockCode =(select StockCode from Inserted)
set @Description =(select Description from Inserted)
begin
declare @msg varchar(500)
set @msg...
March 30, 2010 at 2:11 am
oh yes i see now! thanks for that
i take it small triggers like these have little impact on performance so trying to make one larger trigger willl save little ?
March 29, 2010 at 8:37 am
hi Lowell
im trying to see how your trigger loops looking for multiple lines? but dont see how it does!
can you point out the obvious to me? 😉
March 29, 2010 at 8:06 am
the spaces are getting padded automatically somehow when i post !
March 29, 2010 at 5:29 am
sorry misunderstanding i think
i am getting
New Item created with a Product Code"PT123 "and a description"testpart ".
where the field placeholders are giving me...
March 29, 2010 at 5:28 am
cheers, thats it!
only thing now, if i have the fields defined as eg varchar(10)
i get
New Item created with a Product Code"PT123 "and a description"testpart ...
March 29, 2010 at 5:15 am
sorry one more question!
in the trigger i am setting the email body as below
set @msg = 'New Item created with a Product Code' "+ @StockCode +" ' and a description'...
March 29, 2010 at 4:50 am
Viewing 15 posts - 181 through 195 (of 208 total)