Viewing 15 posts - 1 through 15 (of 607 total)
how do i grab the table names and database names into a temp table to feed your query?
May 15, 2021 at 1:44 am
all sql server services are running under same account, its weird that only master database backups 🙁
August 15, 2019 at 7:34 pm
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...
August 14, 2019 at 1:53 pm
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...
August 14, 2019 at 1:51 pm
it allows me to add a column but it does not allow to change a data type using SSMS.
June 28, 2018 at 7:58 am
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...
June 27, 2018 at 1:52 pm
sorry for not mentioning that here but yes this is from PDW.
March 23, 2017 at 9:23 am
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...
October 27, 2015 at 8:13 am
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...
March 16, 2015 at 12:44 pm
Thanks Jeff, appreciate your response.
March 16, 2015 at 11:08 am
I created copy of the table with same same structure and indexes and did
ALTER TABLE [RevDB].[dbo].[BUDG] SWITCH PARTITION 11 TO [RevDB].[dbo].[budg_arc]
the qry was successful but seems like it is...
March 15, 2015 at 9:56 am
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...
March 14, 2015 at 4:49 am
partitioned tables using enterprise 2008.
February 20, 2015 at 12:14 pm
table partitioned by month
February 20, 2015 at 10:30 am
Thanks Gail. I think i will have to go with your 1st option, here is what i think please correct me if i understood wrong
1. My database is in simple...
January 21, 2015 at 8:05 am
Viewing 15 posts - 1 through 15 (of 607 total)