Viewing 15 posts - 1 through 15 (of 131 total)
yea added that step:
select run_status = @runstatus from msdb.dbo.sysjobhistory jh
inner join msdb.dbo.sysjobs jb on
jb.job_id = jh.job_id
where jb.name = 'myjob1'
and run_status = 1
if @runstatus = 1
But still it fails.
July 6, 2020 at 12:08 pm
Same error on all the databases on same server
January 24, 2020 at 1:27 pm
The database is not corrupt and is accessible normally.
no there isn’t any existing db with the same name.
i had deleted tables which were user n type TT but don’t want...
January 24, 2020 at 1:19 pm
Yea we went from SQL 2012 to SQL2017.
We cannot put our systems back to 110 since other product would be impacted.
Morever, forcing old query plan would be bad idea. With...
December 10, 2019 at 3:09 pm
thank youBut using both the above methods i get rows only with "error" while i want rows above error and below error.
I can achieve this with cursor...
February 6, 2019 at 12:20 am
Thanks for the valuable inputs.
I have the script already, dealingwith 50+ db over 500gb size.Its a quarterly restore yet! Just re- writing to extract the physical file...
January 15, 2018 at 11:18 pm
Yea I've used FILELISTONLY and HEADERONLY to get the information.But I' m stuck at: The DB already exists on server and I have to place the data/log files at...
January 15, 2018 at 3:54 am
August 30, 2017 at 3:21 am
August 29, 2017 at 11:26 pm
August 29, 2017 at 2:24 am
Its sad that only hard coded date needs to be given. I was wandering of having a variable and scheduling a job so that I don't have to change...
August 16, 2016 at 11:33 pm
Full_backup with copy_only is required for some other purpose.
and as for weekly full backup rather than daily, there are few overheads like space (we have 8 diff QA env, with...
March 11, 2016 at 2:46 am
How about creating the new column and filling it with the converted data, add the appropriate indexes, then convert the old column to a computed column? Your existing code...
January 14, 2015 at 10:08 pm
even the renaming will not be allowed since SP are dependent.
We are looking at any Third party tool since the code will eventually promote to Production environment where its more...
January 13, 2015 at 1:33 am
When I try to drop old column it passes an error of dependent Stored procedure.
I can drop the index and recreate them however I do not want to the SP...
January 13, 2015 at 1:07 am