totally agree with you on that Perry the domain admins should handle the DC's.

the issue came that once power was restored, all of the servers powered on at exactly the...

we use the followin script to find out which objects are on which filegroup

SELECT

o.[name] AS ObjectName,

o.[type] AS ObjectType,

s.[name] AS SchemaName,

f.[name] AS [Filename],

i.[name] AS PrimaryKey,

i.[index_id] AS IndexID

FROM

sys.indexes...

are you also taking active directory offline?

if so dont power on the sql servers until ad is back online.

our server guys have fallen into this trap many a time, where...

don't make me laugh, A4, i would need to be superman to be able to read an A0 poster printed on a A4 sheet of paper.

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...

now to find a printer big enough to print it on one page, i know we have one somewhere in the office

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...

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...

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...

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?

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...

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...

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...

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...

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,...