If I couldn't keep every file in a local folder - so that I could use a simple File.Exists() in C# to determine if the file has already been downloaded,...

So - we all say that using SELECT * is a 'bad' example.  However - there are many places where it can be used that is not only safe but...

Since the data...

• This reply was modified 3 years, 9 months ago by Jeffrey Williams.
• This reply was modified 3 years, 9 months ago by Jeffrey Williams.

Curious - why do you need to create a script task and execute a SQL query in that script task?  If this is a one-time call to get/set some variable(s)...

Another possibility is a bit shorter, uses only LIKE instead of LIKE and the LEN() function, and does the same thing is...

IIF(D.Zip LIKE '[0-9][0-9][0-9][0-9][0-9]', d.Zip, '99999')...

You need to create a credential in SQL Server for the domain account ABC\xxx.  Once that is created - create a proxy account for the appropriate subsystem (Powershell or Operating...

Here is a script you can use to monitor the restore process

 Select r.command
      , s.text
      ,...

As Jeff stated on the other forum - not the response we were looking for...

If the request isn't clear - then how could anyone provide a solution?  What is the goal of adding an AG to the FCI cluster - what is trying to...

You have been posting long enough now to know that you need to provide what you have tried - and where you are having issues.

It isn't clear what you are asking - or what problem you are trying to solve.

Is it possible to add an AG to an FCI clustered instance?  Yes.

Is it possible...

SQL Server installation only creates the system databases - it does not create any user databases.  The user database in your picture was either created through another script executed after...

It seems to me you are making it much more complex than needed.  As you have stated, you need to cursor over the data and determine insert vs update -...

Did you back up the encryption keys - and restore them to the target server?  See: https://www.sqlshack.com/moving-the-ssisdb-catalog-on-a-new-sql-server-instance/

Note: I don't recommend restoring the SSISDB database.  Upgrading to a new edition will...

Instead of using a CASE expression (as you were trying) - or stacked OR's:

WHERE @mDepth > iif(@tDepth = 0, -1, @tDepth)

Consider: @mDepth >= 0 is equivalent to @mDepth > -1

Of...

• This reply was modified 3 years, 10 months ago by Jeffrey Williams.
• This reply was modified 3 years, 10 months ago by Jeffrey Williams.