i would like to insert transactions at different timestamps of the day randomly , something like

transaction1 - 04/22/2024 9.55am

transaction2 - 04/22/2024 9.59am

transaction3 - 04/22/2024 10.11am

how do i grab the table names and database names into a temp table to feed your query?

all sql server services are running under same account, its weird  that only master database backups 🙁

i dont think there is any issue with the script as it works fine from SSMS but it does not work from SQL Agent job though it backups only master...

declare @dbname as varchar(80)
declare @msgdb as varchar(80)
declare @dbbkpname as varchar(80)
declare @datepart as char(1)

declare rs_cursor CURSOR for select name from master.sys.databases 
where state_desc = 'ONLINE'  and name...

it allows me to add a column but it does not allow to change a data type using SSMS.

i get this when i go to design mode to change anything

" you are not logged in as database owner , you might not be able to save...

sorry for not mentioning that here but yes this is from PDW.

i dont have much info but index date is nothing but minimum of transdate if that helps. what other alternatives i have for between if that is the one causing...

If i have to switch partitions for 60 times i understand i have to loop through for which i need a table that contentions partitions numbers and the file group...

Thanks Jeff, appreciate your response.

I created copy of the table with same same structure and indexes and did

the qry was successful but seems like it is...

Jeff, from what you are explaining it seems like there is a possibility with your approach. if could you please help with the sql for the steps you mentioned or...

partitioned tables using enterprise 2008.

table partitioned by month