Here's a quick 'n' dirty I use:

SELECT

S.ScheduleID,

C.[Path] ObjectPath,

U.UserName,

SB.[Description],

S.StartDate,

S.LastRunTime

FROM ReportServer.dbo.ReportSchedule RS

INNER JOIN ReportServer.dbo.Schedule S ON S.ScheduleID =...

sum(cast(4 as bigint)*8) as DBSize

I am not sure exactly what you mean either. The word "batch" is mentioned, so I am wondering if perhaps you want to decode the encrypted DTSRun.exe command set...

newbieuser (10/6/2009)

---

Thanks Mark. We are proposing to use OLE DB provider for Oracle as well on ORacle 10g. So would be a similar setup..

Can you please tell me what the...

newbieuser (10/6/2009)

---

Thanks Mark. That was clear enough. Hope I got that right.. the windows authentication will be the set up with the ODBC connection to the Oracle server and the...

You may want to start off with running a Profiler session on the specific database. Open SQL Server Profiler, Create a new trace (File --> New Trace). Log...

newbieuser (10/6/2009)

---

Be made using this security context:

Remote login:

With password:

Is this the Oracle server's windows credential?

Please give me your thoughts on this. Thank...

mbrady5 (10/6/2009)

---

Good Morning,

just want to make sure my query makes sense....pretty new to this stuff.

I have a table that I would like to update a column called 'status' to 'Expired'...

Gotcha - and understood. ...

Personally, I have NEVER done a restore through the GUI, either in SSMS or through EM :blush:

I have a script that I use over and over again in which the...

igngua (10/5/2009)

---

Hi! in this edition of noob-weekly-problem (:-D) i need to know how can i update a row with substring from another row.

example;

row1 ...

In the times I have had to use MAXDOP, yes, you can specify it multiple times within a procedure. I have also worked with changing server-wide MAXDOP options for...

select datename(dw,record_date),

sum(case when shift = 1 then 1 else 0 end) Shift_1,

sum(case when shift = 2 then 1 else 0 end) Shift_2,

sum(case when shift = 3 then 1...

Tara-1044200 (10/2/2009)

---

But iam dealing with 150 databases from one server to another.

If i put singloe user before backup and restore on another server , the destination server will resotre in...

This is not a CU, just a hotfix.

From http://support.microsoft.com/kb/925419/:

Hotfix file information

This hotfix contains only those files that are required to correct the issues that this article lists. This hotfix may...