that is the download to use for 32 bit, see http://support.microsoft.com/kb/948111/ as well

you are possibly referring to MS08-040

see http://www.microsoft.com/technet/security/bulletin/ms08-040.mspx

system stored procedure sp_helpuser will return this information for you

jkoon (11/14/2008)

---

4 hours of project work per day, 2 hours of "things that fall out of the sky on my head" per day and 3 hours of meetings per...

sorry, not sure i understand...

presumably you mean backing of db x on primary server. Taking a full backup will not affect logshipping. The fact a full backup has been done is recorded in the...

its been a long time and I don't have a script, but your problem might be that before being able to restore you need to ensure the device layout the...

If the question is 'what are included columns in 2008', I don't see how 'a new feature introduced in 2005' can be part of the answer. It might be a...

Jonathan, maybe I did take it out of context but IMHO its too simplistic to take giving advice on coding as the final arbiter of a good dba. The worlds...

katedgrt (11/12/2008)

---

Joe Johnson (11/11/2008)

---

" I have seen DBA's that cannot develop and they have no idea how to help people optimize their code to take the best advantage of the...

chances are spid was running a parallel query. If waittype was CXPacket then thats definitely the case.Happens quite often if processing a lot of data.

Doesn't mean its a bad thing,...

check out xp_sqlagent_enum_jobs as well.

or simply:

SELECT * FROM master.sys.master_files

if you want that matched up to the database name

select c.name,a.name as logicalname,a.physical_name from

master.sys.master_files a

inner join master.sys.sysdatabases c on a.database_id=c.dbid ...

This cannot be done. the development version and production version of the database have had separate, different updates made to them. therefore their LSNs will be out of synch.

You are...

are you using the wizard for this log shipping.? If so are you keeping 72 hours worth of logs as well on the reports server? this value is specified separately...