Viewing 15 posts - 6,301 through 6,315 (of 6,395 total)
yeah the app creating the database is the same as running a script so yeah leave it as what ever it installs
i can understand your confusion, just best to keep...
July 8, 2011 at 9:29 am
now to find a printer big enough to print it on one page, i know we have one somewhere in the office
July 8, 2011 at 1:06 am
You said the standard is Latin1_General_CI_AS for servers and your saying your using Latin1_General_CP1_CI_AS within the software database, this must mean that someone created the databases as the CP1 collation...
July 8, 2011 at 12:45 am
you can't, you will always have to remember to set the collation to you'r default, so if it is Latin1_General_CI_AS and your in the USA, then you will always have...
July 7, 2011 at 9:37 am
Thanks Gail, I guess the will be doing the upgrade exams anyway from 2008 to Denali like they have for other versions.
I have just ordered the training kit for 70-432...
July 7, 2011 at 3:50 am
Also, would anyone recommend waiting until the Denali exams are released instead of taking the 2008 exams as I guess Denali is only really around the corner?
July 7, 2011 at 3:27 am
Yeah I would say I have some very good hands on experience, but I would say that it has been more focused into certain areas and not across the whole...
July 7, 2011 at 3:21 am
Generally if you skip the collation setting when running setup, it will default to the windows code page currently defined by the servers regional settings.
I would check to see if...
July 7, 2011 at 12:58 am
to add on from Lowell's post, data center is now the licence you need to have unlimited virtual hosts running on a ESX host and not enterprise.
this was to bring...
July 6, 2011 at 1:06 am
Apologies on this as it might not be relivant, my experience with Sybase is SQL Anywhere (ASA) not ASE.
We have a 64bit data warehouse which uses the 64bit ODBC ASA...
July 6, 2011 at 12:51 am
yeah i have tried both char(10), char(13) and char(10)+char(13), they all individually do what is needed when you look at the results in a text output but not in dbmail,...
July 5, 2011 at 4:06 am
ok had a brain wave and it works to an extent
changed the body format to html, put in '< br >'...
July 5, 2011 at 3:19 am
it just seems to be sp_send_dbmail which is missing the char(13)'s
if you export the output of @mess to text in SSMS it shows on new lines which is great
just the...
July 5, 2011 at 2:15 am
Right on a different note this time, getting execute on sp_send_dbmail denied. Now I dont want to grant all the users the ability to send db mail in MSDB...
July 4, 2011 at 7:34 am
DOH missed out the ALL from ALL SERVER, my bad, all is now ok.
July 4, 2011 at 6:57 am
Viewing 15 posts - 6,301 through 6,315 (of 6,395 total)