hello all,

i was able to get most part working...i took the below article and used it to come up with my strategy of backing up newly created DB that will...

Thank you. Just the block by itself works great...how would i go about integrating that into what i am trying to do...

declare @newdb table

(

newdb nvarchar(4000),

loc ...

i tried that as well, but get the below msg...

"incorrect syntax near 'H:'

Awesome, that works like a charm. Thank you guys

Thank you for your reply.

I initially thought of that as well, as to run my job every 5 secs for 10 min. But then i notice in...

Thanks for the info,

what about any historical data for number for user that logged on ?

Thanks for the info,

I was looking for something more at OS level than inside the instance ?

That worked like a charm, giving the port number...

So now how do i go about fixing the browser ?

yes the firewall is off on client side, and server side it on...

as far as aliases, we are not using alias...

the same servername/inst_name that i used, is being used by...

client was able to connect via telnet to the named sql server instance with that port...

hello, how would i go about following point 2(setting UDP inbound port)...that is

"2. UDP remote port 1434 is not set as an inbound rule on the client machine...

yes the client can ping the host machine and we dis able the firewall on this local machine... and still get the same issue...

anything on this ?

could you explain what you mean when you said ---

they have some sort of network scanning/inventory application on their machine that tries to connect with no login name.

...also we got...

Thanks for the info, I figured that was the issue as its giving the IP address. But that dose not seems to be the IP address for the sharepoint...