What does running this query return

select log_reuse_wait_desc from sys.databases where name = 'YourDbName

If you want to be able to restore to a point in time then you need to backup the entire log. If doing this will cause an issue - lack...

sqlfriends (6/14/2016)

---

So I guess can view the results from report or more advanced to query the SSIS db.

Then what is that output file on the advanced tab?

Also I guess the...

SSRS is part SQL so if you have a licensed SQL instance already then you are licensed to use SSRS. The exception would be if you wanted to have SSRS...

The query below will give you the field names in a column and the data type in a separate column.

WITH

XMLNAMESPACES

(

DEFAULT

'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition',

'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'

AS RepDef

)

SELECT

...

Sounds like permissions. sp_testlinkedserver only tests the connection it doesn't check any permissions. I don't know what you mean by alien in this context.

What error do you get then you...

SELECT *

INTO #Table

FROM ( SELECT 'New Dmark' AS sitename

...

SELECT @@VERSION will give you the SQL version

if it is express there is a 10GB limit per database

What version of SQL are you using? Express?

If you aren't using express do you have space on the hard drive in order to increase the size of the database? If...

Just replace VARCHAR2 with varchar, but why are you going to all that trouble? Just use a date datatype.

If you have a date of 03/04/2016 is that the 3rd April...

Your tab delimited script does that. You may want to change the file extension to be csv instead of xls to stop excel from complaining but it will put the...

What sort of file do you want? A csv file or a tab delimited file? As you mention csv but the script you are posted is using tab as the...

Are you using SSMS remotely? Try launching SSMS on the server and running the package from here. If it works then see the url below.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/774b0e3e-3836-47e8-9feb-5b8f2c3b4b47/cannot-execute-package-from-remote-integration-services-catalog-involving-double-hop?forum=sqlintegrationservices

sqlkohai (6/7/2016)

---

Yes, I put it on a sql 2012 instance and I'm trying to use the Send Mail task. So you're saying use execute sql task and use the...

How are you running the package on the server - through SQL Agent or executing via management studio? Are they deployed into the Integration Catalog (project deployment method) or are...