Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a short tutorial on exporting data from SQL Server […]
2020-01-02
13,443 reads
I have data in a SQL Server database that I need to get to an older version of SQL Server. I tried the backup and restore method, but received an error indicating that this wasn't allowed. I also tried to detach and attach the database, but that operation failed too. I understand that typical methods I use to move the database around don't work when I have to work with an earlier SQL Server version. What can I do to get the data out? This is a simple database and I want to spend a minimal amount of effort.
2012-05-10
3,518 reads
One of the most powerful permissions available in SQL Server is control. But what...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Kevin3NF
Welcome to a new year, and a new look at what I’ve learned in...
Hi, I have a job that keeps getting a deadlock victim error and fails....
I am using SQL Server 2008 R2. While using XML data type and XQuery...
Hi Experts, Currently, we are using the enterprise edition of SQL Server 2014 in...
Ask SSC