Viewing 15 posts - 3,766 through 3,780 (of 26,490 total)
Iwas Bornready (5/24/2016)
Thanks for the script.
Maybe you should see if you can rewrite the script to use the system views instead of the SQL 2000 compatibility views. That would...
May 24, 2016 at 8:27 am
Brandie Tarvin (5/24/2016)
Grumpy DBA (5/24/2016)
The "Thanks for the script" guy strikes again, necro'ing several old, dead threads.
And now we shall call him the necroscripter.
EDIT: I wonder if he's grabbing all...
May 24, 2016 at 7:30 am
Grumpy DBA (5/24/2016)
The "Thanks for the script" guy strikes again, necro'ing several old, dead threads.
I refer to him as PP.
May 24, 2016 at 7:28 am
How many rows of data need to be deleted versus how many are to be kept?
May 23, 2016 at 3:10 pm
Lowell (5/23/2016)
you want to select modified data, and insert is still just an insert. i saw what you were tryingto do, though.
below is a better example
Insert INTO (
[ScenarioID]
,[CostCenterID]
,[CostCenterName]
,[FunctionID]
,[FunctionName])
SELECT...
May 23, 2016 at 3:07 pm
Brandie Tarvin (5/23/2016)
djj (5/23/2016)
Talk about needing for a crystal ballI've asked this question many times, but people keep saying there's no help for me... :w00t:
Well, there are some things we...
May 23, 2016 at 2:02 pm
sestell1 (5/23/2016)
Well, I learned something today. :angry: :hehe:
Me too!
May 23, 2016 at 9:18 am
ThomasRushton (5/23/2016)
Been a bit quiet here over the weekend - was there an outage, or did everyone else suddenly have an attack of Real Life?
Got out and sort of reffed...
May 23, 2016 at 6:47 am
GilaMonster (5/20/2016)
Ed Wagner (5/20/2016)
ON the SQL Saturday topic, the rumor is that a Detroit one will hopefully be scheduled for February 2017. I hope you can make it.
And further...
May 20, 2016 at 1:14 pm
sql-lover (5/20/2016)
Lynn Pettis (5/20/2016)
sql-lover (5/20/2016)
TheSQLGuru (5/20/2016)
sql-lover (5/20/2016)
TheSQLGuru (5/19/2016)
May 20, 2016 at 1:12 pm
sql-lover (5/20/2016)
TheSQLGuru (5/20/2016)
sql-lover (5/20/2016)
TheSQLGuru (5/19/2016)
I have no idea about your Nimble stuff, but the backup start and end times should be set by the actual backup process in SQL Server.
Thanks...
May 20, 2016 at 9:03 am
Care to explain why you are doing what you are doing?
May 20, 2016 at 8:33 am
Just curious, if clicking on Modify resulted in an error did anyone try clicking on Script Stored Procedure As, select Alter to, then select New Query Editor Window and see...
May 20, 2016 at 8:30 am
The only other thing I'd suggest, drop the tbl from your table names.
May 20, 2016 at 8:18 am
Viewing 15 posts - 3,766 through 3,780 (of 26,490 total)