Hi

Whenever you are adding a Job step "@output_file_name parameter" is not valid for a job step of type 'ActiveScripting'.

...

Hi

Just change the compatibility mode. Nothing else is required.

Best Regards,

SQLBuddy

Hi

Suppose that we have a Server A with SQL Server A.

And if we change the name form Server A to Server B, then we have to run the following...

Hi

What is @output_file_name parameter ?

What command are you typing in the Activex Script Task?

...

Hi

If you have multiple instances on the server then All counters refer to the counter value for all the instances together or you can get...

Hi Sushant,

Try to shrink the database and then...

Hi Sushant,

As you are restoring the database from the backup, backup and...

Hi

CXPACKET Waits occur due to the high incidence of parallel queries when MAXDOP is enabled on the server.

...

Create the Role in the Master and then grant the permission.

...

Hi Sushanth,

How many data files...

Hi

Are you able to connect to this SQL Server from any external server using 1. SQL Server Name 2. IP Address?

Are you able to ping the Windows server hosting this...

Hi MTY,

Please try to provide full information. If you are getting any error...

Hi

If you are a sysadmin, then create a Activex Script proxy with your windows account as the credential for that proxy and run...

Hi,

I would got with Backup and restore. Copy DB wizard is not a robust solution.

...

Hi

Try to use UserDB_Log instaed of using 'UserDB_Log'.

...