Viewing 15 posts - 121 through 135 (of 2,897 total)
Can you later open the SSIS via V.S. to edit and set that option ?
April 22, 2022 at 1:06 pm
You can go into SQL Server Agent, open the job and see if the backup code is there, or perhaps points to a maintenance plan that you can look at,...
April 18, 2022 at 7:21 pm
I do look at that folder regularly as I have to delete older files or it fills up the drives.
Automate that to delete files older than 'X' days.
April 18, 2022 at 5:10 pm
Do you see SSISDB if you expand "Integration Services Catalogs" ?
https://www.sqlshack.com/introduction-to-the-ssis-catalog-database-ssisdb/
April 18, 2022 at 2:48 pm
If you have the space, you could restore one of the large backups to a test server, with a new name like "ntegracheck_BigBAK" , and see what it looks like.
April 18, 2022 at 2:34 pm
Do you have backups of your main database you can use to recover and load into your "copy" database ?
"...this is Copy of Main Database..."
I don't understand why you have...
April 14, 2022 at 1:13 pm
How is SQL used at your workplace ? Are you looking for Administration or Developer skills ?
SQL has so many different areas, it would be good to focus on what's...
April 12, 2022 at 4:40 pm
How about:
SELECT A , B , C ...
From Table_A
WHERE ( last_modified_date between '01/04/2021 00:00:00' and '31/03/2022 23:59:59' )
OR ( balance > 0 and last_modified_date NOT between...
April 11, 2022 at 4:27 pm
Maybe Extended Events has information ?
April 7, 2022 at 2:30 pm
Short version
Post table create statements, and sample data INSERT statements.
April 6, 2022 at 8:54 pm
Following Brian Gale's suggestion, to create a new table based on an existing table, you can use the scripting function.
Right click your original table -> Script table -> New query...
April 5, 2022 at 4:42 pm
If it's a "One time" job, or the tables won't change, just scroll through the list of tables, clicking the ones you want.
I don't think you can accomplish it in...
April 1, 2022 at 7:04 pm
I think I read that != may not be supported in the future, and <> is recommended ANSI standard
March 30, 2022 at 9:56 pm
"...However, we are not all that knowledgeable in the best methods. Our first thought was replication, but didn't think this would be good, because DB1 is not a transactional database...
March 30, 2022 at 3:35 pm
Viewing 15 posts - 121 through 135 (of 2,897 total)