Viewing 15 posts - 15,661 through 15,675 (of 19,564 total)
Alvin Ramard (3/31/2010)
CirquedeSQLeil (3/31/2010)
Steve Jones - Editor (3/31/2010)
March 31, 2010 at 6:17 pm
The port number that you manually assigned to it.
March 31, 2010 at 6:15 pm
If you are going the table variable route, I would create a stored procedure and then call the stored procedure from .Net.
Other Options would be a CTE.
March 31, 2010 at 6:14 pm
Grant Fritchey (3/31/2010)
CirquedeSQLeil (3/31/2010)
Jeff Moden (3/31/2010)
Grant Fritchey (3/31/2010)
dma-669038 (3/31/2010)
March 31, 2010 at 6:05 pm
Steve Jones - Editor (3/31/2010)
March 31, 2010 at 6:04 pm
rainleta (3/31/2010)
If I use machine_name,1533 in SMSS, it works. It seems the SQL Browser doesn't work?
I am not sure the Browser service works that way. If there are multiple...
March 31, 2010 at 6:03 pm
crainlee2 (3/31/2010)
Wilfred and Jason,Thanks to both of you for taking the time to implement and publish your queries.
I have an immediate use for them at work.
LC
You are welcome.
March 31, 2010 at 6:00 pm
The same result occurs if you eliminate the >= '1%'.
If you do it this way though, it will work.
Declare @var1varchar(10)
,@var2varchar(10)
Select @var1 = '1%',@var2 = Number
From Example
where Number like...
March 31, 2010 at 5:59 pm
Are you able to connect if you specify the port number?
March 31, 2010 at 5:49 pm
Are there any other error messages along with that message?
March 31, 2010 at 5:39 pm
Check out this article:
March 31, 2010 at 5:35 pm
Try this
http://www.eventid.net/display.asp?eventid=100&eventno=4016&source=MSSQLServerADHelper&phase=1
March 31, 2010 at 5:33 pm
Lynn Pettis (3/31/2010)
Jeff Moden (3/31/2010)
Lynn Pettis (3/31/2010)
Gift Peddie (3/31/2010)
Jeff Moden (3/29/2010)
Gift Peddie (3/29/2010)
All I want is please leave the doors open to all [font="Arial Black"]with the ability[/font].Exactly... 🙂
Thanks Jeff I...
March 31, 2010 at 5:27 pm
I have taken this script provided by Wilfred and updated it to SQL 2005.
If interested, you can read about it at:
March 31, 2010 at 4:18 pm
Steve Jones - Editor (3/31/2010)
Why do I feel this discussion has gotten way off track?
It was lunch time.
We will get back on track. Need time to digest the information...
March 31, 2010 at 3:59 pm
Viewing 15 posts - 15,661 through 15,675 (of 19,564 total)