Viewing 15 posts - 16 through 30 (of 1,183 total)
A few questions:
1. Is Length always in minutes?
2. Wouldn't you exclude Id 10 since that individual session starts at 11:30 which is the end of the overall session and therefore...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 22, 2015 at 5:13 pm
Great question!
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 17, 2015 at 4:06 pm
No. Place the file where you want and then when attaching via the gui, just browse to it.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 15, 2015 at 1:00 pm
No, you can specify the new location of the log file after you've selected the MDF file. Use the GUI in SSMS, it's fairly easy.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 15, 2015 at 12:35 pm
bgrossnickle (9/15/2015)
Do each of the sql files execute fully before the next one starts to run?
Yes.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 15, 2015 at 10:40 am
wmyers01+SSC (9/14/2015)
You know you can skip all of that and just run this following from the command line:for %f in (*.sql) do echo osql -S servername -E -i %f
Sure, but...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 14, 2015 at 3:48 pm
andreas.brandsteidl (9/14/2015)
Thx for the way how to call several script files!
My question is: How can I or what is the best way to catch an error in one...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 14, 2015 at 3:47 pm
But that's not in SSMS. 🙂
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 14, 2015 at 8:38 am
Iwas Bornready (9/8/2015)
Wow, this looks really risky.
Risky? It doesn't run any code. It simply creates the code for you. We've used in production for over a year now and it...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 9, 2015 at 6:36 am
Just a thought, but do you have Max memory set for each Instance as to not choke the OS out?
Are you able to RDP in/is windows unresponsive too or is...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 4, 2015 at 7:22 am
Personally, I'd set both to automatic and let SQL Server manage them both.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 4, 2015 at 7:18 am
One addition to the really old post.
Load your database into a Database Project in Visual Studio (SSDT - SQL Server Data Tools free add-in for VS). Then you can...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgSeptember 1, 2015 at 10:24 am
ZZartin (8/28/2015)
Jeff Moden (8/27/2015)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgAugust 28, 2015 at 8:50 am
That's generally a discussion between the DBA and management, but some key questions that come to mind...
1. Can they perform their job duties without said access or is this "just...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgAugust 25, 2015 at 2:21 pm
sleipner (8/13/2014)
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgAugust 13, 2014 at 3:51 pm
Viewing 15 posts - 16 through 30 (of 1,183 total)