Port check for SQL Server connectivity
Generates a script to check connectivity between a list of SQL Server instances on a specified port.
2012-10-17 (first published: 2012-08-09)
1,714 reads
Port
Change the port number for connections to SQL Server
How to change the port number for connections to SQL Server.
2012-03-01
11,389 reads
RE: Columns and Rows
I realize Mahesh's proc is more generic, but it doesn't appear to be working properly. I'm not to interested in debugging it, though, too tell you the truth.He's using the same technique I am, just more generalized. I ran my pivot table script, and it worked just fine. I'd suggest you start with that and […]
2004-08-17
RE: Parmeterized list to a stored procedure
It could be that what reddyk needs is the ability to receive a comma-delimited string of arguments and parse out the individual arguments, or something similar. If so, the following code might be enough to get you started (pretend that the whole snippet of code is really a procedure definition, and that @myString is really […]
2004-01-09
1 reads
RE: Drill through issues in virtual cubes
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-12-26
RE: How can I connect to another database?
I do not understand well your question. In TSQL there is no such command as connect. First you have to connect to a server/database then you can issue TSQL commands. Of cours you can connect to the server by using QA, EM, and all other client tools or programming languages. What is exactly your question? […]
2003-11-27
1 reads
2003-08-20
1 reads
Blogs
T-SQL Tuesday #176 One piece of advice that you wish Past you had
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
T-SQL Tuesday #176: One piece of advice for Past Steve
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers