Viewing 15 posts - 2,731 through 2,745 (of 5,393 total)
Tom.Thomson (9/12/2011)
Gianluca Sartori (9/12/2011)
Well, actually I can't, but I can ask Steve to do it for...
-- Gianluca Sartori
September 12, 2011 at 2:19 pm
Do you still have a sysadmin login that can connect to the instance?
-- Gianluca Sartori
September 12, 2011 at 9:45 am
It's a networking issue.
Can you connect to the remote server from your laptop/desktop?
If it works from your computer and it doesn't work from your server, probably it's a firewall issue.
-- Gianluca Sartori
September 12, 2011 at 9:44 am
Steve Jones - SSC Editor (9/12/2011)
Gianluca Sartori (9/12/2011)
-- Gianluca Sartori
September 12, 2011 at 9:30 am
I re-read my reply and I see that it violates the "if you don't have anything nice to say, don't say anything at all" rule.
Steve, can you delete the "sandbox"...
-- Gianluca Sartori
September 12, 2011 at 9:03 am
If you think that my reply was not called for, I can delete my post.
Well, actually I can't, but I can ask Steve to do it for me.
If you also...
-- Gianluca Sartori
September 12, 2011 at 8:20 am
Tom.Thomson (9/12/2011)
ChrisM@Work (9/12/2011)
WayneS (9/11/2011)
ALZDBA (9/11/2011)
:sig:The one who's name thow shall not state felt the need to kill a forum newbe with ancient history and lousy advise.
-- Gianluca Sartori
September 12, 2011 at 7:55 am
Ok: so just use the code in the article.
You can use that code to create the split function and then you can use the function to break the input string...
-- Gianluca Sartori
September 12, 2011 at 6:30 am
GilaMonster (9/12/2011)
How would you handle things like these:John van Wyk (van Wyk is the surname)
David West Jnr (West is the surname)
etc...
... or
Gian Maria De Rossi ("Gian Maria" is...
-- Gianluca Sartori
September 12, 2011 at 6:26 am
Lavanyasri (9/12/2011)
Thanks for the quick response and thanks for the information .
this is the correct way to check the user connections ???
SQL Server General statistics :...
-- Gianluca Sartori
September 12, 2011 at 6:17 am
ALZDBA (9/12/2011)
Way to go, Gianluca !http://www.sqlservercentral.com/Forums/FindPost1173218.aspx
--> http://www.sqlservercentral.com/Forums/FindPost1173217.aspx
Glad you liked it. 😉
I'm sure Mr. Celko won't understand, though.
-- Gianluca Sartori
September 12, 2011 at 6:13 am
You could use the splitter function you can find here:
http://www.sqlservercentral.com/articles/tally+table/72993/
Read the whole article, it really is worth the time.
If you need help on how to use the code, just ask...
-- Gianluca Sartori
September 12, 2011 at 6:12 am
MladenPrajdic (9/10/2011)
I exclusively use SchemaSurf by Atlantis Interactive.It's free and IMO awesome.
http://www.atlantis-interactive.co.uk/products/schemasurf/default.aspx
Nice! Thanks for the pointer, Mladen!
-- Gianluca Sartori
September 12, 2011 at 2:17 am
If now we could focus on the original issue, that would be great.
-- Gianluca Sartori
September 12, 2011 at 2:12 am
Viewing 15 posts - 2,731 through 2,745 (of 5,393 total)