Viewing 15 posts - 586 through 600 (of 1,189 total)
Thanks for the advice.
It looks like switching the order of the code allowed me to write to the log table. See the code below. I also added a ROLLBACK statement.
When...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 24, 2013 at 1:41 pm
Lowell (7/9/2013)
compare this to sp_who2, and see if it helps you any:
select
conns.client_net_address,
conns.auth_scheme,
sess.* from sys.dm_exec_sessions sess
LEFT OUTER JOIN sys.dm_exec_connections conns...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 9, 2013 at 3:17 pm
catchmekc (7/9/2013)
They are related to system SPIDs. See the SPID column, all are less or equal to 50
Thanks. Some of them are system SPIDs, but I see several where the...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 9, 2013 at 2:56 pm
Thanks, everyone, for the prompt replies.
Just so I understand correctly, does a dot mean that the connection in question is being made from the current SQL Server itself? How would...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 9, 2013 at 2:45 pm
I just tried this question and picked B (correct answer was D, it says).
Even though I see the point of the issues with the question wording, I want to praise...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 5, 2013 at 1:01 pm
david.wright-948385 (7/2/2013)
gary.morgan 31549 (7/2/2013)
The featured contents should be put back at the top of the letter so that a summary is immediately viewable.
+1
Also, the width of the original would scale...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 2, 2013 at 9:02 am
Yes, thanks to Hugo for the detailed explanation. I agree with those who say that the Microsoft documentation could use Hugo's addition!
I think the following queries show the switchover point...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 1, 2013 at 8:57 am
opc.three (6/28/2013)
webrunner (6/28/2013)
Maybe I just need to manually load whatever snap-ins I want to use or test out?
Yep. For oft used snap-ins you can edit your Profile so they are...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 1, 2013 at 8:45 am
Thanks for your response!
When I run this command in a new session:
Get-Command -commandtype cmdlet | select PSSnapin -Unique
I get this:
PSSnapIn
--------
Microsoft.PowerShell.Core
PS C:\Windows\system32>
Maybe I just need to manually load whatever snap-ins I...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 28, 2013 at 2:52 pm
Thanks - really cool question.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 28, 2013 at 12:57 pm
marcia.j.wilson (6/20/2013)
webrunner (6/20/2013)
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 20, 2013 at 12:14 pm
As technology industries move further and further into areas where lives can be lost (as in pharmaceuticals and construction), I think we will see that things have to mature or...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 20, 2013 at 8:49 am
Ola Hallengren (6/11/2013)
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 11, 2013 at 8:44 am
This is a fantastic set of scripts. Thanks to Ola Hallengren for them!
I do have one question, though. I have tried setting the CleanupTime for the backup script to 24...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
June 10, 2013 at 2:44 pm
Great question. I was close but got it wrong. Still, a great teaching question.
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
May 10, 2013 at 8:52 am
Viewing 15 posts - 586 through 600 (of 1,189 total)