Viewing 15 posts - 256 through 270 (of 367 total)
You know, I work for a sole proprietor and am the only employee so, it's only me and my boss. I hardly ever see him because I am always out...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 28, 2008 at 1:07 am
Madhivanan (11/27/2008)
http://sqlblogcasts.com/blogs/madhivanan/archive/2008/09/02/empty-string-and-default-values.aspx
My point exactly and that is why I used the case for when I don't want to use the default. I will do some further testing with ASP.NET when...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 27, 2008 at 8:35 am
Ninja's_RGR'us (11/26/2008)
Since when can DateofBirth = "" ???A date value is set to a date.... or null, period (sql server side).
Don't bite my head of now! I meant case when...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 27, 2008 at 4:20 am
Look, don't get me wrong here. I absolutely believe in learning the hard way because that is the things you will remember most. You look for help in BOL and...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 27, 2008 at 3:39 am
lrosales (11/21/2008)
Guys!I solved the problem. the answer is simply "Default"
insert into tt99(Datetime2, description)
values (default,'Testing the Default')
simple is it not?
😛
If you want to use a default date in that column then...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 26, 2008 at 12:08 am
Erratum:
The following piece if code is incomplete and I have placed the correct code below this:
declare @datestring varchar(12)
set @datestring = convert(varchar(12),dateadd(d,-3,getdate()),1)EXECUTE master.dbo.xp_delete_file
The correct code:
declare @datestring varchar(12)
set @datestring ...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 25, 2008 at 3:17 am
Grant, I have been motivated by your article and am trying this myself. I just have two things that I don't understand. You say that the last database backup was...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 21, 2008 at 5:11 am
Focus is my problem. I am a hardworker and enjoy my work thoroughly. I set targets for myself as to what I want to achieve for the day. I also...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 14, 2008 at 6:41 am
jcrawf02 (11/13/2008)
You should either pick a different default...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 14, 2008 at 4:55 am
Steve Jones - Editor (11/12/2008)
you can use Task...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 13, 2008 at 8:06 am
right click SQL server agent -> 'properties'
select 'Alert system' then check 'Enable mail profile' under 'mail session' then restart the SQL server agent service.
Did you do this part because if...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 7, 2008 at 2:18 pm
Prashant Pandey (11/7/2008)
Thanks to all for giving your suggestions and thoughts, "Good comments always boost your confidence" but "Bad comments always boost your confidence to do the best as well...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 7, 2008 at 1:46 pm
If you followed the steps in the link I provide in a previous post and the solution that Jason Deyalson provided in a previous post (both in this thread) then...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 7, 2008 at 12:53 pm
sobrien (11/7/2008)
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 7, 2008 at 6:54 am
you need to make sure the mail profile is enabled in the SQL server agent properties.
right click SQL server agent -> 'properties'
select 'Alert system' then check 'Enable mail profile' under...
:-PManie Verster
Developer
Johannesburg
South Africa
I can do all things through Christ who strengthens me. - Holy Bible
I am a man of fixed and unbending principles, the first of which is to be flexible at all times. - Everett Mckinley Dirkson (Well, I am trying. - Manie Verster)
November 5, 2008 at 12:40 pm
Viewing 15 posts - 256 through 270 (of 367 total)