We ended up as below:

USE db1

GO

-- Step 3

CREATE VIEW VW1

AS

...

I created a login 'test_login'

I created a user 'test_user' for the login 'test_login'

I created a role named 'test' and added 'test_user' to that role.

I granted select and execute to the...

Thank you for your input mate.

I have found the solution for this. I break down the strings and add trailing zeros and make their length is 8(in my case). e.g....

Thank you for your efforts mate..thats the start I wanted

Thank you buddy..whatever way you have helped me is awesome

btw the article you suggested is almost like the same one I am following:-P

Thank you for your response

Here is the screenshot of the http connection manager (no proxy)

Any help guys..

USE [msdb]

GO

/****** Object: StoredProcedure [dbo].[SQL_Agent_Jobs_Details] Script Date: 3/24/2015 4:02:09 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[SQL_Agent_Jobs_Details](@JobName varchar(5000)

,@LastRunDate nvarchar(20)

,@LastRunStatus varchar(50)

)

AS

BEGIN

-- SET NOCOUNT ON added to prevent...

Any help guys..Percentage sampling is not sampling the data properly 🙁

Any help guys..

IMHO, the simplest way is to restore a backup of production over the dev with replace unless the size is an issue. The second bird you hit with this stone...

My objective was to refresh the Test server with the live data, so that we will have some realistic data to test with and it needs to be done with...

If we reseed the identity to -1 then the 2nd row in the table will have id 0..which is wrong

Not possible.. You know the importance of an identity column right 🙂

Solved it..

No need to set identity_insert ON and OFF before bulk copying.

SQLBulkCopyOptions.KeepIdentity takes care of this.

So, following code worked for me:

using (SqlBulkCopy bulkCopy =

...