How many rows in the source table?

Since you need to track deletes you may need to copy all contents of the table from the source into a staging table in...

Well, I will say it is not as obvious as Database.LogFiles hanging off the database object straight-away but when you think about it in terms of how SQL Server organizes...

You're welcome 🙂 Post back if you get stuck going beyond what I gave you.

Relevant?

http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/861b57bc-aa21-4b03-bd01-5c164e2bac4e

Lynn Pettis (5/10/2012)

---

Maybe, but it is my time to waste. I'm not going to apologize for hoping against hope for the best. I...

OPENROWSET does not have HTTP resolution capabilities. OPENROWSET requires the file be available at some disk location, either local drive or UNC path, so you'll need to download the XML...

Accounting software with that many triggers I would guess many of them are for generating a trail in audit and history tables.

PowerShell is an option, and one I would go for if this will be a recurring need.

Here is an option using some T-SQL and the SSMS GUI scripting features...

sudha.kotapati (5/8/2012)

---

Hi,

I have 200 millions of records in one table .I want to load it into set of tables based on the year.

So while loading the...

Please do not cross-post.

Direct all replies here:

http://www.sqlservercentral.com/Forums/Topic1296885-1549-1.aspx

This sample (adapted from here)worked for me:

USE tempdb

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

IF EXISTS ( SELECT *

...

There is no need to turn on Advanced options:

SELECT *

FROM sys.configurations

WHERE name = 'Database Mail XPs';

manny_emm (5/10/2012)

---

This is a stored proc that is mapped to xp_smtp_sendmail(sql2000) on another server.

ALTER PROCEDURE [dbo].[uspSendMail]

@FROM VARCHAR(256) = NULL,

@FROM_NAME VARCHAR(256) =...

Surly Yoda today 😛

@peter-2

It is unclear to me from BOL but I found this link:

Lesson 2: Internal...

That's a good paper. All the reading I have done and my experience with mirroring tells me it is not very good at scaling up to those levels. It is...