Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

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

CREATE TABLE dbo.MyTable (

[id] INT identity NOT NULL,

[sess_id] INT NOT...

dallas13 (9/22/2015)

---

Hello,

I am trying to run ssis package on sql 2014 which has SFTP task but it gives me below error.

Description: Cannot create a task from XML...

Ed Wagner (9/22/2015)

---

whereisSQL? (9/22/2015)

---

DonlSimpson (9/22/2015)

---

Revenant (9/22/2015)

---

Ed Wagner (9/22/2015)

---

crookj (9/22/2015)

---

anthony.green (9/22/2015)

---

Ham (Brigadier General...

Those TEXT_MIX_PAGEs store the LOB values for whatever objects in tempdb i.e. temp tables, table variables etc..

😎

randyetheridge (9/22/2015)

---

I have a field I am trying to bring into a SQL statement

,ISNULL(Convert(nvarchar(50),OPP1.OriginatingLeadId),'') AS 'OriginatingLeadId'

I get this error message

Conversion failed when converting from a character string to uniqueidentifier.

the field...

balcock (9/22/2015)

---

We deleted some SQL instances and nodes from our SQL 2012 failover cluster but we are still getting DCOM attempts to connect to those servers. I did a...

Joe Docherty (9/22/2015)

---

An application process was failing with "605 Fatal error".

The SQL Server errorlog had many of the 2 rows below over the previous 3 days. They had occurred 2-3...

Have a look at this blog post: Microsoft SQL Server Licensing For Dummies.[/url]

😎

peacesells (9/22/2015)

---

Anybody here experienced difficulty in passing a date parameter in a stored procedure through OLEDB Source (Data flow task). We have a multipurpose stored proc in which one...

SQLSACT (9/22/2015)

---

Hi All

When troubleshooting a memory pressure situation on a SQL Server.

I noticed that PLE was low, Lazy Writes/sec was higher than normal, Buffer Cache Hit Ratio was down....

Brandie Tarvin (9/22/2015)

---

GAH! I just got upgraded to Office 2013 and now I can't read a single thing in Outlook. That pale blue is killing me!

Why oh why oh why...

ChrisM@Work (9/22/2015)

---

There's a couple of references to the 64/65 split in this article by Paul White. I'm sure I've seen something more comprehensive somewhere but the Google - force eludes...

whereisSQL? (9/22/2015)

---

Animal

Doesn't come as a surprise,thought it was worth mentioning though....

Deadweight