But of course question is misleading (as well as explanations).

It reminds me a very old joke:

Answer ONLY YES OR NO!!!

Where have you been yesterday from 8 to 9 pm?

(Correct answer...

looked at both values:

select current_timestamp, getdate()

2008-12-09 10:56:40.477 2008-12-09 10:56:40.477

Didn't notice any difference... According to BOL current_timestamp is an equivalent of getdate().

The only difference is that current_timestamp is a part of...

1. An empty formatted drive should show less than maximum capacity since formatting itself occupies some space. The space occupied depends on the size of your HDD.

2. When moving your...

-- Import the file into an XML variable

declare @xmlimportdata xml

SELECT @xmlimportdata = xmldata

FROM

(

SELECT *

FROM ...

And the version of the SQL server is ...?

And files are located where... (filesystem, stored in DB)?

You have to check what are the settings on your server?

select @@datefirst

I believe default is 7...

Lynn, I hope this is not a question addressed to me? I am not providing interpreter's services 🙂

I just provided a...

select getdate() + 7 - Datepart(dw, getdate())

My bad. Try looking here:

http://www.eggheadcafe.com/software/aspnet/30519822/rights-to-execute-jobs.aspx

Search BOL for SQLAgentOperator Role.

Create a job1 with no associated schedule (your ETL package run).

Create a job2 which is running every Sunday.

Job2 consists of 2 steps.

Step1 - T-SQL - calculate Sunday's dates for current...

Thank you, Steve.

Interesting article.

I am using ApexSQL Diff in conjunction with VSS ...

Sorry for bringing an initial question to a slightly different direction, but would you please...

H-m-m...

Are you sure? I was under imression that Subversion does not have a direct integration with SQL server...