oh yeah, and stubborn old me only likes varchars..so if you have a table that has a name with nvarchar, like  below, you'd have to find and replace all the...

spcghst440 / Tim C, thank you very much for pointing out that gap!

I've been using this for literally a decade or more, and so far , in my environment, i...

if you are comfortable with PowerShell, this example command will get all end users, including those that are members via a group-within-a-group:

here i am assuming you found a group named...

see if this script can help you visualize the actual blocker(s).

this is what I use, I am sure I picked it up here on SSC and further enhanced it. for...

it's permissions.

you have permissions, but the account running the SQL service does not.

regardless of who is running the SQL command executing xp_cmdshell, once outside of SQL server, xp_cmdshell runs as...

• This reply was modified 1 year, 8 months ago by Lowell.

a piece of the puzzle here is connectivity. are you already using cnames to point to the server, so with a simple DNS change, you can say PRODSERVER points to...

the SQL2022 CU11 patch potentially covers SSRS and SSAS as well. as a result, I would recommend the following:

1. if you use UNC paths for your backup directory, you must...

start at the basics:  can we narrow it down to see if it could have been a DBA process or a Business process?

did you have a scheduled job for statistics,...

In my environment, i have a very similar need, but much more robust.

• I need to script out the current permissions from a development database
•  restore a database from prod,

...

On SQL2019, i get an error trying to compile the code.

Msg 13822, Level 16, State 1, Procedure MyOpenRowSetTest4, Line 4 [Batch Start Line 7]

File 'd:\downloadedfiles\filethatdoesntexist.txt' cannot be opened...

Login failed for user 'brainiac' is the key.

EXECUTE xp_readerrorlog

and find out the specific reason why the login failed. it will tell you exactly the problem on the next line AFTER ...

if the SQL Service is stopped, one of the things it does is puts a pointer in  thelog, to track what is committed or not committed as far as transactions...

you'll want to change the definition of @VbCrLf from VARCHAR(2) to something larger, and like this, maybe?

and make sure it is not being re-assigned to CHAR(13) + CHAR(10) later.

you'll end...

this is a typical permissions thing in SSRS.  you want to connect from the server itself, and then add your domain group or domain logon to fix that.

it follows the...

on the server that is running the SSRS Service, you should find the Reporting Services Configuration Manager.

run that, and there is a tab to show you the database it connects...