I noticed the job is executing the below command in CmdExec subsystem.

DTSRn / ~ Z z0xfx….

Seems /~Z means it is encrypted. How can we identify the dts package name in...

• This reply was modified 5 months ago by  ramana3327.

Yes, the dts packages are stored in msdb.

We are using DNS alias in packages. Those aliases are pointing to this server

The login that running the job is sysadmin on sql server. It is showing login failed  as domain\machine$. This domain \machine also already sysadmin in SQL server.

Tried creating the proxy...

Yes, Thank you. The requirement is below

I have TestDB1.bak, TestDB2.bak, TestDB3.bak , TestDB4.bak …etc in the below

G:/Backups

Need to restore all 30 databases with replace option using those backup available in...

Thank you.

We’re not allowed to download the DBA tools

Tried using both windows authentication & sql login. Getting similar error with both.

Thank you

Thank you.

Somehow in Visual studio the target server version to SQL server 2022 is not able to see. It’s available up to SQL2019 only

Thanks,

We are not allowed to download.  SCOM is not using run as account as the article mentioned. In that case we’re not sure what permission needs to check but we’re...

Due to vendor Application we have to stick the os old version on the client. We can’t use the latest version of SQL server but support sql 2008 or 2012.

We...

• This reply was modified 1 year ago by  ramana3327.

Thank you.

The existing server is SQL2000. Extended events doesn't support. I installed the SQL 2008 to support the migration for SQL 2017. Little worried to run the trace  on this...

Thank you.

Yes, it happened in the past. Not able to find the root cause. We are restarting the server for every 4 months otherwise we’re seeing the same issue like high...

• This reply was modified 1 year, 3 months ago by  ramana3327.

Thank you.

The data type is image. I used the function default. Can we use any other way of masking?

If you have a column with data type image. If you need...

• This reply was modified 1 year, 3 months ago by  ramana3327.

The data type is image. I used the function default. Can we use any other way of masking?

If you have a column with data type image. If you need to...