I do understand that you are trying to run OSQL from a dos script.

I would query the directory, dynamically compose OSQL line and then run. I would do it from...

SQL Bill,

He is trying to use named pipes with IP address. I don't think this combination should work at all! It did not work for me as a test. He...

David,

don't do that! I am sure it is a matter of the ports

Do the following:

1. Read the article

http://msdn2.microsoft.com/en-us/library/ms165724.aspx

Using SQL Server Browser  

2. Check Server Network Utility for the instance what...

Hi all,

I do like to work in 'Visual' Notepad same as Steve but I am OK with the new Visual Studio look of Management Studio. Now less people will think...

I can not connect using Named Pipes with IP address, I don't think it is supported. I also don't think Named Pipes use 1434, it is for TCP/IP.

Named Pipes work...

select * from sysfiles

will give you the path to the physical file for a database.

What do you mean "is active"? Are you talking about the cluster?

check that the port 1433 is open. try to change the protocol to named pipes and use fully qualified computer name with named pipes. Ping port is different from SQL...

Events from the SQL Server Logs are mostly in the Windows Event Log that you may query with the help of WMI query. See examples at:

http://windowssdk.msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/wmi_tasks__event_logs.asp

WMI Tasks: Event Logs

Hi,

the first thing I can tell you is a forward slash in 192.168.2.3/TEST  We call the named instance as computer_name\instance_name.

the second thing that the UDP port 1434 should be open for...

You may want to look at this discussions:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=189454

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=6668

execute permission...

I agree with Peter,

I even did not try to answer because I suspected what the author's answer would be. But Peter is totally correct. I ran an upgrade advisor...

I would do the repopulation off-hours.

Hi,

try to figure out if anything happens at the particular time the error comes up, like re-indexind, catalog repopulation etc. Is it an FTS towards SQL Server database on the...

You may want to read about the processor affinity and UMS Scheduler. The scheduler sort of assigns a query to a certain processor.

There is an excellent article on the subject...

Hello,

When using cmdexec use the following

cscript myscript.vbs

or in your case cscript "E:\SQLTaks\\CopyFile.vbs" I am not sure about quotes,we are running without quotes

To