Stepping away from TLS being the issue, can you run the isql command with the -v parameter? This will give you verbose output and will tell you EXACTLY what is...

Cyrusbaratt, I am a bit confused why you say that monitoring tools slow things down then suggest Idera, which is a 3rd party monitoring tool (plus a ton of other...

Is that the only error? USUALLY an "unable to connect" is followed by some information about a login issue or a cannot find the host or something along those lines.

BUT...

Wanted to throw my hat into the ring on this - I have done both. In-place upgrades and migration upgrades. My biggest factor in deciding the method is "how many...

No can do in SQL Server according to the docs: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

Those state we have 1024 columns max in a table.

You'll need to break it up into multiple tables; probably want...

As a random thought, are you fully patched on both SSRS and SQL Server?

Also, when you uninstalled Standard, did you reboot after the uninstalls? And did you reboot after the...

I could be dumb, but this really sounds like a homework/assignment style question. That being said, if I asked something like this, my first question would be "what does the...

I suppose that is a good point Jeff. In this specific scenario where the OP is trying to write the file to the server itself, having the data flow from...

One nice thing is that with email notifications, things show up how you would expect. The other fun thing is it happens outside of the code block too:

those above...

Oh I agree with you here Jeff. When things are set up properly, xp_cmdshell can be secure, but I find that a lot of times, it is used and abused....

@steve-2 Jones - replace the _ with a space and you'll see what's happening.

If there are no jobs (maintenance plans are still jobs) or scheduled tasks, then I'd say something must be happening on the Azure side of things that is backing it...

My opinion - don't. Firstly, SQLCMD mode is a client side thing (ie part of SSMS) not a server side thing (ie not part of SQL Server Engine) so SQLCMD...

My question would be do you need to use replication for this?

What I mean is could you modify the stored procedure that updates the primary to ALSO update the secondary...

If I understand correctly, could you do something like this:

SELECT [T1].* -- or could do [T2].*, not certain which table row you are trying to show, you...

• This reply was modified 1 year, 9 months ago by Mr. Brian Gale.