Hi,

On my server, srvid from master.dbo.sysservers is definitely NOT the source for distribution.dbo.MSsubscriber_info.subscriber_id.

I found this discussion because I was looking for a way to get the default value for an int column. Here is what I came up with:

declare
...

This is in response to Jim's aversion to cursors. As a lead DBA, I advised my team to avoid cursors unless necessary. There are times where set based processing is...

• This reply was modified 3 years, 2 months ago by  JediSQL. Reason: punctuation

Reading between the lines, given the 18 decimal points, I'm assuming that you are storing Ether (or some other cryptocurrency). Based on @william Rayer's explanation, maybe you should...

Well, that's disappointing.

• This reply was modified 3 years, 4 months ago by  JediSQL.

Testing and Results

I used the UDF from the  script I contributed .

Please fix link to  script  so I can compare my gaps query.

• This reply was modified 3 years, 8 months ago by  JediSQL.

We always use template SQL scripts to create tables, and for temporal tables, the HISTORY_TABLE clause is there.

CREATE TABLE dbo.TheTableName
...
( SYSTEM_VERSIONING = ON ( HISTORY_TABLE = dbo.TheTableName_hst...

That's what I was wondering about. When SQL Server is running...

I work to have scripts be idempotent where feasible. However, it is not always feasible. So.... what do we call those scripts that are not idempotent? That is, what is...

• This reply was modified 3 years, 10 months ago by  JediSQL. Reason: fix formatting of bullet points

It looks like something weird happened when copying and pasting the "SQL script to initiate a backup of a database."

SELECT @MyFileName='C:\PS\SQLScript\Backup\' + REPLACE(cast(cast(convert(nvarchar(20) as nvarchar(max)) as nvarchar(max)),cast(cast(GetDate()...

• This reply was modified 3 years, 12 months ago by  JediSQL.

Hi. Here are a few points from me...

1. The overall success of a job depends on the success status of the last step run, even if an intermediate step failed...

Hi,

I posted a request to fix this at Microsoft's User  Voice forum:

https://feedback.azure.com/forums/908035-sql-server/suggestions/41700883

Oh, yeah, I'm in another thread on this:

Not able to create tasklist in Sql Server Management Studio

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4a160d5f-b390-4583-bab4-eb7596729088/not-able-to-create-tasklist-in-sql-server-management-studio?forum=sqlgetstarted&prof=required

1. It looks like Microsoft is moving towards getting rid on Task List. In SSMS 18.6 it is not on the View menu anymore, though it can be accessed by...

Thanks,

I did a little research on the Task List, and it seems like it is something that has been broken since SSMS 2017: Task List seems incomplete.

My coding often...