I have created a report and deployed it. But when I try to create subscription I am getting the following error.

Subscriptions cannot be created because the credentials used to...

Thanks guys.

Got it.Thank you.

Do I need to install the litespeed on the server or is it ok if I install it on my machine and compress the backup file from my machine?

Can I rollback the changes in case if something goes wrong with the sync?I am not sure if this option is there in sql compare and data compare.

Thanks.

Thanks for the info.

The new table is also created in the dbo schema that other tables also belong to.

The user can execute DMLs against this table.

It worked for me.

Thanks for your help.

Do we definitely need a secondary file group to create partition?

I need to create a partion on user table for username column.

Can I write the partition function like this?

CREATE PARTITION FUNCTION [pf_Product_Partition](VARCHAR(10)) AS RANGE LEFT

FOR VALUES (N’g’, N’l’, N'r',N’s’)

Thanks.

When I did the following

In SSMS Object Explorer, selected database, right-clicked on the table and right clicked Storage and then I see only two options enables.

Create partition and manage compression.

I...

No,it's not on production.

The reason why I am asking this is because after testing I need to deploy these partitions on production.

I haven't created these partitions on staging.

So I...

And where can I see the script of the created partitions.

When I queried SELECT * FROM sys.partitions it shows 6 partitions on this table. But where I can see the...