Lookup SEQUENCE - instead of using IDENTITY for the detail table.  It will require code changes to support - but it can do what you are requesting.

I have never utilized this task - so I am not sure, but could this be a case where there isn't any output from the task so nothing to be...

What is the purpose of moving to AG?  You already have failover - and all the shared storage has been setup and configured - and it is working...why change it?

If...

The files should revert back to initial size on a restart of SQL Server - if that doesn't work, then you can shrink the files specifying the size (using DBCC...

I am working with a table that I have not seen before, and do not have a clear idea on what it is doing or what the data in...

When using the join only option - most likely the reason it isn't synchronizing is because a log backup was performed on the primary node prior to the restore on...

Instead of suffering for the type conversion - use CONCAT which will take care of the conversion for you:

Declare @CaptureError varchar(100) = 'This is an error'
 ...

• This reply was modified 6 years, 3 months ago by Jeffrey Williams.

We can actually simplify this even further:

Declare @endDate date = '2019-11-16';

   With groupedDates
     As (
 Select t.recid
    ...

Here is another option:

   With groupedDates
     As (
 Select t.recid
      , t.docdate
    ...

• This reply was modified 6 years, 4 months ago by Jeffrey Williams.

Hi,

i would like to generate csv file with datetime  through sql job with below power shell script.But it didn't work.

Any suggessions.

$dt=get-date -format "_yyyymmmd_HHmss"

Invoke-Sqlcmd -Query "SELECT * FROM [xxxxxx].[xxxx].[xxxxx]" -ServerInstance...

You can use Standard Edition to support the databases for Enterprise SSRS, but it doesn't save you anything since you already have to license the SSRS instance at Enterprise Edition...

Are you planning on scaling-out your deployment - if not, then I see no reason not to host everything for SSRS on the same server.  It has to be licensed...

Someone pointed out that this could be done with synonyms - which I think might be a better approach.

To identify which staging table - you can query the currently defined...

You could also just perform the restore from the file located on the original server - instead of copying the file across to the new server.  All that requires is...

SSDT does not have a built-in sFTP component - the only way to utilize sFTP is to utilize a third-party product.  The basic setup would be an Execute Process Tasks...