Viewing 15 posts - 1 through 15 (of 90 total)
My answer was an absolute guess. I had no clue. I just kept thinking about how many pages it would take and how to link them all together.
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
February 16, 2022 at 9:11 pm
NOOOOOO! The kingdom I inherited over 10 years ago had seen several different programmers and between duplication and poor design, they created a monster that I'm still dealing with. CHAR...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
February 11, 2022 at 3:01 pm
I didn't know it, so I googled it and found it here https://www.sqlservertutorial.net/sql-server-basics/sql-server-offset-fetch/
but the answer didn't just jump out. I used process of elimination. If this is cheating, I apologize.
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 29, 2021 at 12:20 pm
When you say "The SQL code to add to the job is shown here:" do you mean add it to the end of the job or where?
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
October 28, 2020 at 3:45 pm
Excellent and well-written. Unfortunately I'm still on SS 2008! However, that changes in January. So, hopefully I get a chance to practice this technology. Thanx!
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
December 18, 2019 at 1:11 pm
Execute xp_cmdshell 'BCP Mailing.dbo.tTotalJimsListNEW IN "\\MyServer\Shareddata\MyFolder\Mailing Lists\ListtoImport\RemovalsNoCusts.txt" -c -S SQL1 -U me -P mypassword'
I run scripts like this from an SSMS query window,
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
January 4, 2018 at 9:02 am
the example given would be run from ad hoc queries in SSMS. Similar imports, which have a static naming convention run from stored procedures. Yes, a trusted connection could be...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
January 4, 2018 at 8:35 am
Wow! I'm going to play with this a while. That's the best way for me to learn.
Thanx!
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
January 3, 2018 at 2:41 pm
Amen on "start down the PowerShell learning path that I should have been going down for the past several years." I'm in that same boat. This looks like an excellent...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
January 3, 2018 at 8:34 am
What version of SQL Server are you using?
What application are we seeing in the Screenshot? It doesn't look like SSMS (at least SSMS 2008).
I'm using Log Shipping but...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
April 11, 2017 at 10:32 am
I haven't tried this, but thought you might want to.
Leave the old database in place. I know you have moved the tables to a new DB.
Create Views in the...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
February 26, 2016 at 7:34 am
Ours are attached. They've been modified recently to accommodate a log shipping setup. The logs cursor through a table which consists of database name and a bit field...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
December 17, 2015 at 6:28 am
Yep, this answer is dead on. It removed agent jobs from the primary and secondary.
After that I just deleted the secondary database which was in Read Only mode.
Thanx!
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
August 28, 2015 at 11:00 am
Joie,
Yes, the copy job has worked all along(see caveat below) and I checked the backup folder against the restore folder on the Secondary. They have the exact same files....
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
August 27, 2015 at 6:29 am
Certainly a viable option, but the above code is part of a stored procedure, the first part of which populates a table which is then exported. The proc is...
Wallace Houston
Sunnyland Farms, Inc.
"We must endeavor to persevere."
July 23, 2015 at 7:19 am
Viewing 15 posts - 1 through 15 (of 90 total)