Ken Davis (5/9/2015)

---

I have a large table in a large database. The DB = 1.2TB and the big table is 70% of the DB or 840GB. I would...

Quick solution which should be enough to get you passed this hurdle

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_A') IS NOT NULL DROP TABLE dbo.TBL_A;

CREATE TABLE dbo.TBL_A

(

nRef ...

Sequence

petervdkerk (5/9/2015)

---

A little explanation:

[giftregistry] is the general description of the list, the bridal couple in this is the only owner. They can add a text they want to send to...

Add a CTE for the conversion, then you can use the same code

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_XML_SAMPLE') IS NOT NULL DROP TABLE dbo.TBL_XML_SAMPLE;

CREATE TABLE dbo.TBL_XML_SAMPLE

(

XS_ID ...

One more thing, can you run DBCC CheckDB('[database name]') WITH NO_INFOMSGS, ALL_ERRORMSGS and post the full unedited output?

😎

Quick questions:

😎

1) The amount column in giftregistrypurchase table, is that the quantity of items?

2) In the same table, is the itemid the giftregistryitems.id?

Looking at the schema, I suspect that either...

Freyja

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