Jai,

if you read carefully in BOL you will see that the SET DATEFORMAT option only applies to the entering of dates and not the way they are displayed.

Markus

Reddy,

the issues whtith DTS and EM you're refering two are related to the Itanium 64-bit version. WIth the x64 version you don't have these problems.

A direct upgrade from a 32-bit...

If you try to start a job which is already executing, nothing will happen. So you don't need to worry.

Markus

Yeah,

windows administrators ust don't realize that databases are a lot bigger than most files on a fileserver. Had this type of issues too in the past, that's why I...

Kyle,

my first question would be which of the two result sets do you want to insert in your table?. You obviously can't insert them both  into the same table...

Matthew,

since you posted this under 2005 General discussion I assume you're using that version. So as an alternative to logshipping you can setup Mirroring and create snapshots on the mirror...

Gary,

with maintenance plans the jobhistory is usually not very useful when it comes to fiding the reason for a failure. The logfile  "H:\oPlates\oplatesStaging\LOG\oPlatesStaging DB Maintenance Plan4.txt" should give youa more detailed...

Sorry this should be

"Even though you can't type another windows name".

Markus

Ian,

even though you can type another windows name in the connection window, there are a couple of ways to do this.

1) Start SSMS with the "Run as" option.

2)...

You better start your arrangements.

You can "create" system pocedure by marking a user procedure as system with the stored sprocedure sp_MS_marksystemObject. It's an undocumented procedure which allows you to...

Mark,

from MS Technet: SQL Server Express supports subscriptions to merge, snapshot, and transactional publications, but does not permit publications itself.

So in order to create a publication you must use Workgroup,...

Mark,

the problem is not that OPENROWSET is not supported, but that for security reasons, by default Ad-hoc remote queries are disabled. You need to eablem them either through the Surface...

You can calculate the uptime using the sysprocesses.

select

DateDiff(ss,login_time, getdate())

BMC offers a backup solution which supports object-level restore. Can't say I have any real world experience with it, but I tested it some time ago and it looked fine.

But...

Johan,

the file you found is for the distribution database. It's not in use until you configure your server for replication, and even then it might not be used because you...