If possible, the schema of the tables would help.

0.0000005328  is not an integer. When you cast or convert it, it will be 0.  The decimal portion is truncated.   The largest number a Numeric (18,18) can hold is 0.999999999999999999.

It...

• This reply was modified 3 years, 9 months ago by Michael L John.

One of the annoying things about the $(ESCAPE macros is that they are recognized only in job code (at least the last time I checked this).

So you'll have to...

I took a smaller db backup from the STD2012, and was able to restore to my SQL2017 instance. I can't move the backup to the sql2017 Box as it...

Ok, have you verified that the network settings of the new server are set properly?  Is it...

I glanced at this article.  You do realize that this was written 12 years ago, and that there are far easier ways to do most of this?

Like this maybe?

https://dbatools.io/commands/

If...

A better question is what are you attempting to do?

Because it looks like you are trying to generate T-SQL code based upon a situation.  Like, one proc to run everything. ...

I was asking the question of a stripped backup because maybe Transferring the 45gig caused a problem. I thought maybe smaller files could be moved quickly and eliminate file...

why do other uses need to see who can login on a server? that is on its own a security risk and should not...

This has nothing to do with connections to the database.  It's a connection POOLING issue.

Check this out.  https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-connection-pooling

A simple Google search of "This may have occurred because all pooled...

We upgraded from SQL Server 2016 to 2019, and our reports on the report server now say:

An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to...

I can't say with 100% certainty the cause of the error, but to me that doesn't look like TSQL.

What I mean is the $ part and ESCAPE_NONE.  I don't...

Why...

I would pick Extended Events to monitor deadlocks

https://www.mssqltips.com/sqlservertip/5658/capturing-sql-server-deadlocks-using-extended-events/

I suppose the only time I've ever really USED identity column I also identified it as the PK.  I guess I'm not really sure why else you would use...