Please provide more information on what you want/need to do...

Are you just moving the data from one database into another one?

Are you wanting to upgrade the server and SQL Server...

This wait type is for SQL Server traces (Profiler, default trace, etc.) that someone may be running. You can disable the default trace if it is not needed but I...

You can use T-SQL to find in the log where your deleted record is at, but the only way you are going to get it back is from a restore...

If I am not mistaken Kerberos authentication works off the SPN that the SQL Server service creates in the AD domain, or that is created manually. If the SPN is...

A few links to review.

Multiple Versions

SSIS Coexistence

Each component (SSRS, SSIS, SSAS, and Database Engine) are all services so the different versions can coexist on the same machine. You can...

Bug was reported for this on connect: SQL Management Studio output Copy and Paste or Save to CSV gives unexpected results

KoldCoffee (3/17/2014)

---

Shawn, I've been googling but OData links are sparse.

I want to create an OData source in a new Project/package but there's no Source Connection Manager called that in...

KoldCoffee (3/17/2014)

---

Shawn, In the XML file I find three connectionManagers.

It seems that VS is not liking the OData one. So, I removed it (left other two alone) and tried...

KoldCoffee (3/17/2014)

---

And what files would be a reasonable way to ask for from someone intending to share their ssis package with you? This ssis package exists on that person's...

KoldCoffee (3/16/2014)

---

thanks for replying happycat and shawn. Glad to learn about opening up in notepad and tips for finding version.

PackageFormatVersion is 6 so 2012!

So, should...

Take a look at the msdb.dbo.restorehistory table. Take a look at the "stop_at" column, a datetime value.

You can open the DTSX file in Notepad to determine what version of SQL Server it was created with and look at the "PackageFormatVersion" value. The exact line should look...

What process are you using to determine what amount of RAM the SQL Server instance is using?

The maximum server memory is only for what the buffer pool will allocate....

Initial thought: I would go find another side project to work on...

No clue about Access issue and you are not likely going to get much help on that from this...

GilaMonster (2/20/2014)

---

Always.

I'll...