This logic doesn't quite match what's given - the pm.pdenddate=pt.pdenddate part excludes all lines where one side only of the...

You could try something like the following, though you'll still have some work to do to split out the datestamp, filesize and filename.

IF OBJECT_ID('Folders','U') IS NOT NULL

DROP TABLE Folders;

GO

CREATE...

A free comprehensive third party option is Ola Hallengren's solution (http://ola.hallengren.com) which is based on stored procedures, sqlcmd, and SQL Server Agent jobs. We've used it on SQL2008 R2,...

Agreed, if you can use one of the standard styles.

The initial triggers for me writing this were a couple of requests that didn't seem to fit in with one...

dwain.c (7/29/2013)

---

Your expected results are off for the <30 days column (can't be less of a percent than <20 days), but something like this should do it:

SELECT datein

...

Setting up a SQL Agent job to run the master SSIS package may help. The job step configuration for an SSIS package includes a "Configurations" tab for defining which config...

Alternatively, you could transfer the logins and passwords from the original server to the target server. This can have the advantage of not having to deal with orphaned users...

Thomas - yes. Also "ft -a" instead of "ft-a" in the example script.

Other than that, finally got me going with PowerShell - thanks Aaron!

Alternatively, add a column with the instance name to your CentralJob table and view and optionally set composite key on InstanceName and job_id e.g. your view could look like:

CREATE VIEW...

Nadabanan - thanks for spotting this. Have updated with correct text.

This explains it:

http://msdn.microsoft.com/en-us/library/aa258274(SQL.80).aspx

For division:

[EDITED - was incorrect, apologies CFF]

scale of the result = max(6, s1 + p2 + 1)

where s1 is the scale of...

The missing digits is due to the initial casts - with decimal, they are automatically converted to the minimum numeric precision and scale required before the calculation is done, so...

An alternative option may be to restore the database as a whole rather than exporting data from one server to another - maybe the existing DTS package does this already...

Interestingly

SELECT entryname FROM test2 WHERE entrycode LIKE 'MU' -- no trailing space

returns the result MUMBAI. MSDN is illuminating on how leading and trailing spaces are treated...