Hi Shawn,

use msdb;

GO

select name, date_modified, enabled ,*from sysjobs where name='JobName'

when I use that query it is showing that the data_modified was last year. That means there is no recent...

Thanks Shawn

Last week we got mail only one time. This problem just started 3 days back. Here when I see the Job, it has 2 schedules with 1hr difference. Also...

Hi,

When you want to do the partitioning different tables in the same database. And the requirement is same.

Is it better to use same partition function and partition schema for all...

Got it. We have to click on the download. Then if we open the rdl, we can find the query

Hi,

Thanks you are thinking that Visual studio.

I am not asking from Bids where you created the report. If some one upload the report to folder using report manger url. You...

Hi,

I created a view in dev box. I need to deploy that in the production.

How to create deployment scripts for the views with all the commands needed to deploy including...

Hi,

When I generate the script for partition from GUI it is finally dropping the Index. Why it is dropping the Index?

USE [Test]

GO

BEGIN TRANSACTION

ALTER TABLE [dbo].[IsDeletedTest] DROP CONSTRAINT [PK_IsDeletedTest];

ALTER TABLE [dbo].[IsDeletedTest]...

Sorry to find the future service pack release dates

Thanks Micky

What I understand about the memory optimized tables is

1)We can't use for frequently where schema changes frequently. If schema changes every time memory optimized tables need to be recreate

2)...

Here we are using side by side migration.

We are testing mainly one database then it works fine we are planning to migrate all. For that we use the test box...

Hi,

Thanks for the replies. Please let me know

How to check my application is compatible with 2014 instance. How to find what features are removed in 2014 but that are used...

But on that table for the LastUpdateDate column they defined the default constraint.

Alter table [dbo].[Generate_Data] Add default (getdate()) for LastUpdateDate.

When anyone modified the existing table the default constraint will populate...

Thank you.

I have few columns in my report.

Email & Purchase date.. . In that email column & Purchase date some people don't have email Id. i..e My report shows some has...