Can you post the DDL, sample dara and the expected results?

😎

Depending on your maintenance window, best option may be a fresh install of the new server, script transferrable logins, detach and copy the databases, attach on the new instance and...

Quick answer, No.

😎

Phil Parkin (8/3/2016)

---

Eirikur Eiriksson (8/3/2016)

---

Phil Parkin (8/3/2016)

---

Eirikur Eiriksson (8/3/2016)

---

A while back I did an import system that used a staging table with x number of varchar(xxx) column and a error...

Phil Parkin (8/3/2016)

---

Eirikur Eiriksson (8/3/2016)

---

A while back I did an import system that used a staging table with x number of varchar(xxx) column and a error flow to insert to...

A while back I did an import system that used a staging table with x number of varchar(xxx) column and a error flow to insert to a table with varchar(max)...

Quick thought, you can define "hard" attributes like weight, size, value etc. which are common to all and then use sparse columns in the same table for softer attributes which...

Post the DDL (Create table scripts) for all the tables, sample data as insert statement and the expected output, makes it much easier for us to provide you with the...

Have a look at Time and Space: How to Monitor Drive Space in SQL Server By Ed Wagner[/url]

😎

IIRC, either when the batch size is reached or the last row has been processed.

😎

Quick question, have you tried Robocopy?

😎

Quick suggestion, have a look at this article[/url].

😎

yujinagata72 (8/2/2016)

---

Hi,

When I run an SQL query, sometimes I got the error,

and sometimes is okay....

You can use Adam Machanic's sp_WhoIsActive to identify the culprit

😎

Quick example using FOR XML PATH

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#XMLTable') IS NOT NULL DROP TABLE #XMLTable;

CREATE TABLE [#XMLTable](

[BatchID] [nvarchar](25) NOT NULL,

[Count] [int] NOT NULL,

[Status] [varchar](6) NOT NULL,

[Type] [varchar](10) NOT NULL,

[Code]...