jimmycjen (5/8/2015)

---

We run DBCC CHECKDB as a job in the evening when there is less activities. All the jobs are run with a domain account that have local administrator rights....

Lead

sqly2kdba (5/8/2015)

---

I apologize for not being clear

I have to pull this data from table with 1000 rows like this

Wondering , where in the query I plug in the actual column...

sqly2kdba (5/8/2015)

---

thank you.is this how I replace my column names?when I do I get the following errors

SELECT

sys_id('(HostSystemIdentificationInfo/identifierValue/text())[3]','varchar(50)')

,sys_id('(HostSystemIdentificationInfo/identifierValue/text())[4]','varchar(50)')

FROM host_sys);

sys_id is not a recognized...

GilaMonster (5/8/2015)

---

For a couple seconds I thought that was directed at...

Code

Sorry I misread the question. The server will check the permissions of the login account in the second database unless Cross-database ownership is enabled and it is the owner of...

Quick suggestion

😎

DECLARE @SAMPLE_XML XML = N'<obj xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:vim25" versionId="5.5" xsi:type="ArrayOfHostSystemIdentificationInfo">

<HostSystemIdentificationInfo xsi:type="HostSystemIdentificationInfo">

<identifierValue> unknown</identifierValue>

<identifierType>

<label>Asset Tag</label>

<summary>Asset tag of the system</summary>

<key>AssetTag</key>

</identifierType>

</HostSystemIdentificationInfo>

<HostSystemIdentificationInfo xsi:type="HostSystemIdentificationInfo">

<identifierValue>PSF:</identifierValue>

<identifierType>

<label>OEM specific string</label>

<summary>OEM specific string</summary>

<key>OemSpecificString</key>

</identifierType>

</HostSystemIdentificationInfo>

<HostSystemIdentificationInfo xsi:type="HostSystemIdentificationInfo">

<identifierValue>Product ID: 654081-B21</identifierValue>

<identifierType>

<label>OEM specific string</label>

<summary>OEM specific string</summary>

<key>OemSpecificString</key>

</identifierType>

</HostSystemIdentificationInfo>

<HostSystemIdentificationInfo...

Merrier

caddywonkus (5/7/2015)

---

Scenario: a stored procedure is executed in database ABC. The procedure includes a MERGE statement with objects in the ABC and DEF databases. A Windows login is executing the...

With your short and concise style, it could fit into an article:-D

😎

No,...

How about different types of db recovery?

😎

____ KD (5/7/2015)

---

Thank you for all the replies.

The code was working in SQL query.

I wanted to drop the table because the table schema may change so I only...

mxy (5/7/2015)

---

I have SSD storage of size 1TB, if I partition into multiple disks for tempdb, data, logs does it improve performance or not. I mean keeping in single...