Viewing 13 posts - 46 through 58 (of 58 total)
The 'set port to 587' (even though Google says this port is for TLS/STARTTLS) and 'reenter your password if you make changes to the dbmail profile' (because SQL forgets what...
October 14, 2011 at 5:42 am
Many thanks for this post Jeffery - helped me with a project I was working on today.
October 7, 2011 at 10:31 am
Excellent! Thank you Ninja's_RGR'us.
September 26, 2011 at 7:39 am
I've not tested that way either. What I do is save the output (only errors) and if anything is inserted into the logging table then I assume something is...
September 26, 2011 at 7:15 am
Upon further investigation I was able to use the text qualifier { to successfully import the data. I don't know why the { character works but ¬ does not.
February 18, 2011 at 3:52 am
Andrew - way to be supportive of someone making one of their first posts in the newbie forum.
I acknowledged in my post that there are better ways of doing this,...
November 3, 2010 at 3:01 am
Hmm upon further testing I see why its not possible to convert decimal dates with the current year in yyyymmdd format to datetime. Numbers are interpreted as 'how many...
October 14, 2010 at 5:51 am
stewartc - many thanks, that works nicely too 🙂 I wasn't aware of the escape command previously.
September 7, 2010 at 8:08 am
I should step away from my desk more often - solutions always seem to pop into my head when I'm doing nothing
After an hour of looking for a solution to...
September 7, 2010 at 8:07 am
Looks like my first hunch was correct! Database was recovering - just checked logs and before the take offline processed (which took ages because the DB was waiting to...
April 11, 2010 at 3:03 pm
I tried to run the following code to take the database offline instead of using the UI:
ALTER DATABASE [MyDatabaseName]
SET OFFLINE WITH ROLLBACK IMMEDIATE
Now it says 'executing query' just below the...
April 10, 2010 at 3:42 pm
tcnolan (4/6/2009)
Double check your password... if you made a setting change and saved the profile, go back and re-enter the password and save the profile again. ... make sure to...
February 20, 2010 at 4:57 pm
A heads up:
All these videos that say
Please be aware you'll need to have the Adobe Flash 9 plug-in to watch this video.
don't work on my machine, even though I've got...
November 22, 2009 at 10:15 am
Viewing 13 posts - 46 through 58 (of 58 total)