Good stuff!

😎

My memory playing tricks on me:-P

Thanks Sean!

😎

Thinking back, I cannot remember ever using 0 as seed value for a CHECKIDENT if the initial seed value was <> 0, regardless of which method was used of emptying...

george sibbald (5/7/2014)

---

from glenn Berrys diagnostic...

Quick thought, what rights has the user (running the package) in the file system, I've seen this where users can list but not open directory content.

😎

Shaun2012 (5/7/2014)

---

The path is correct as it goes through Foreachloop container and through sequence container, also it goes check the the audit table and delete the rows but fail...

Can you run the DBCC statement from Visual Studio?

😎

Does the file exist and is the path correct?

Or was the file created in Excel and still open in Excel?

😎

That is the transaction isolation level, configurable ie. within the connection parameters. Simplest...

Raghavendra Mudugal (5/7/2014)

---

QUOTE

Once you create a memory-optimized filegroup, you can only remove it by dropping the database. In a production environment, it is unlikely that you will need to remove...

That would be implicit rounding:cool:

More like this

'$ '+REPLACE(CONVERT(VARCHAR(32),cast(round((Total_Amount/12),2) as MONEY),1), '.00', '') as Monthly_Amount,

😎

Just move the division inside the round function.

😎

martin.whitton (5/7/2014)

---

Is a "tiny bit" a "bit" that will only store zeroes? 😀

My personal feeling is that "bit" is not...

Ove.Kernell (5/7/2014)

---

Hi all,

If I have a table

CREATE TABLE [dbo].[logg](

[Id] [bigint] IDENTITY(1,1) NOT NULL,

[Details] [varchar](MAX) NULL)

insert logg (Details) values('')

insert logg (Details) values(null)

Will both statements above access only a single page (as...