Viewing 15 posts - 1,456 through 1,470 (of 59,066 total)
Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.
I'm pretty sure that BCP doesn't work on actual spreadsheets...
May 9, 2023 at 7:11 pm
I think the answer is "because". 😉 I've not checked privs on system versioned temporal tables before but it may very well be that if the user has write privs...
May 9, 2023 at 7:02 pm
Thanks for the advice.
So i read this before and did a log backup.
Backup Type: Transaction Log
It doesnt work... Or do you mean anything else?
Edit: So i turned the log...
May 9, 2023 at 6:55 pm
If you look for the accepted answer at the following link...
... it says...
Status = 2 means that VLF can't be reused (overwritten) at this time and it...
May 9, 2023 at 6:07 pm
Bulk Copy "BCP" might be another option. But the import wizard's probably the easiest since it's GUI driven.
I'm pretty sure that BCP doesn't work on actual spreadsheets ((but I...
May 9, 2023 at 5:57 pm
Hi Jeff,
Thanks for the reply.
It only deletes some of the data. Also, the query that isn't returning data only pulls from that subset that gets deleted.
Those rows are locked...
May 9, 2023 at 5:55 pm
I have table for employee activity with the following fields:
[Emp ID] , [Hire Date] , [Term Date] , [Mod Date] , [Old Div] , [New Div]
When an employee is...
May 9, 2023 at 5:52 pm
Hi Ratbak,
Thanks for your reply but order is the only my main problem.
--Expected o/p : Previours years following by current year data --Jan-2022,January-2022,Jan-2023,01-01-2023,Jan-2023,Jan-2023
Thanks
Bhanu
Since this seems new to you, read...
May 9, 2023 at 5:45 pm
By enabling cross-database ownership chaining or by designating a database as trusted by the instance using the TRUSTWORTHY attribute, a trust relationship between databases can be created. The sys....
May 9, 2023 at 5:20 pm
Are you saying that the DELETE in the hourly process deletes ALL of the data in the table or just some of the data?
May 9, 2023 at 5:09 pm
I can "azure you" that I can't answer your question because I've never used Azure before. 😀
I just want to say "Thank you" for the link to what looks like...
May 9, 2023 at 5:02 pm
Probably a few more times. Is there anything I should be concerned about or something else I can do to improve the process?
I was going to suggest that if...
May 9, 2023 at 4:45 pm
The other method is "WITH NORECOVERY". But, people need to find and read the documentation to know of either option before they tackle the two most important things a DBA...
May 9, 2023 at 4:39 pm
Whooo!!!! That's what I was looking for! Thank you so much! Very helpful!
I'm curious... how often will you need to do this from the same spreadsheet? (Obviously, after some...
May 8, 2023 at 11:38 pm
Hi
I have checked the logs and cannot find any alter database statements.
Think about that statement... Do you have any proof that the database was ever set to anything other...
May 8, 2023 at 1:17 pm
Viewing 15 posts - 1,456 through 1,470 (of 59,066 total)