If you are going to rename it, are you also going to disable it?

Run this query, and see what is returned:

SELECT * FROM dbo.tuser WHERE email = 'abc@gmail.com'

If results are returned, then run this:

DELETE dbo.tuser WHERE email = 'abc@gmail.com'

Wow Lynn, that stinks.  I was pretty fearful of being eliminated when we let a significant number of folks go in April.  I definitely was not looking forward to looking...

There are filters for users, and there are still rows that...

Instead of looking at sp_statement_completed and sql_statement_completed you should look at rpc_completed and sql_batch_completed.  The events you are currently looking at identify each statement in a stored procedure (sp_statement_completed)...

Is this a mapped drive?  If so, use the UNC path.

Does the service account have access to the backup location?

Not sure this is a bug in Ola's script.  The max length is 259, you are at 95.

If the vendors only need to access a sub-set of the data, then I would probably choose transactional replication.

If they need access to the entire database, then I would likely...

In VMWare, you have multiple different SCSI adapters, and you can create a total of 4 for a given VM

I suggest you create 4, 3 of them as "VMware paravirtual",...

Why can't you add the update statement as the first step in the job, and then again as the last step?

Or, remove the code from the job, assuming it's T-SQL,...

Interesting read

https://jenstirrup.com/2020/06/24/i-have-stepped-down-as-a-microsoft-mvp/

• This reply was modified 5 years, 6 months ago by Michael L John.

If there is an application that uses this database, then it's likely trying to connect over and over. Closing it will clear the exiting connections.

If you are in SSMS, you...

Then you grow up and find out that your family crossed the pond in 1643 and was farming in Pennsylvania and Ohio by the time Mozart was entertaining...

A linked server perhaps?

https://docs.microsoft.com/en-us/sql/relational-databases/linked-servers/create-linked-servers-sql-server-database-engine?view=sql-server-ver15

Hi All,

Not too familiar with Macros at all, but I have adjusted a pre-existing script and I am trying to create a Table from it.

The query works fine but...