Viewing 15 posts - 511 through 525 (of 2,356 total)
There is no value displayed because there are no results being returned from the query
If you run this, does it return anything?
SELECT [VALUE] FROM dbo.TABLE_1 WHERE (IDMEASURE=(SELECT max(IDMEASURE) FROM dbo.TABLE_1)...
February 16, 2022 at 2:10 pm
Ha, sorted it.
The critical setting was Tools > Options > SQL Server Object Explorer > Scripting > Check for object existence. The option was set to True.
When I reverted...
February 16, 2022 at 2:06 pm
Hi,
I created the ticket. They add the users to my computer. I can able to run the SSMS as Domain1/Domain1ADM. When I tried to run the SSMS as Domain2/Domain2ADM...
February 15, 2022 at 2:23 pm
No, is'nt.
In this case, use to begin transaction SQL Statement.
Adding that to both procedures will not solve the issue. If an error occurs in the second procedure, the first...
February 14, 2022 at 1:53 pm
Thanks Michael.
The code you provided works much better.
One question, if I simply stop (terminate) the execution, would that be ok? It will not create any problems?
No. it won’t cause...
February 11, 2022 at 12:25 am
It seems no matter how small chunks I set, it progresses to around 98% and stucks.
Can it be because of LOB data ?
does 98% get you down to what...
February 10, 2022 at 11:37 pm
It seems no matter how small chunks I set, it progresses to around 98% and stucks.
Can it be because of LOB data ?
does 98% get you down to what...
February 10, 2022 at 11:09 pm
Thank you ANT_Green.
How do we maintain SQL jobs in secondary replica? how to set jobs execute primary and secondary AG when failover/switchover two nodes.
Thanks
What types of jobs? If it...
February 10, 2022 at 5:58 pm
Tempdb is recreated with each re-start of SQL Server. You can prove this by stopping SQL, deleting the tempdb files, and restarting the instance. The files will be created, and...
February 10, 2022 at 3:27 pm
Yes Michael, correct. You're right that I could join on the CTRseqNo field and pull the patient ID and review date out of the parent CTRs table.
My thought behind...
February 10, 2022 at 3:24 pm
I was performing dile shrinking using GUI. After more than 10 hours I got an error, saying that the shrink command failed.
Maybe a silly question but I am not...
February 10, 2022 at 3:18 pm
I have this situation in a few potentially long running clean up jobs. I did not create a second job, I modified the proc to run in a loop and...
February 10, 2022 at 2:57 pm
I guess my first question is why are you duplicating three columns from the CTRs table into CTR_PanelMembers table?
To me, you only need the PK from the CTR table in...
February 10, 2022 at 2:54 pm
Is the SQL Browsing service running on the machines?
February 10, 2022 at 1:37 pm
The DMZ host is not domain joined so can't use Windows auth anyway (well not without trying to run SSMS as another user and specifying domain\username format)
If you can...
February 9, 2022 at 8:53 pm
Viewing 15 posts - 511 through 525 (of 2,356 total)