I've not had to reconfigure but on the Options tab there is an option to change the default port. I would imagine that if a list of open ports was...

have look at this tool.

http://www.specialopssecurity.com/labs/sqlrecon/

glad I could help

I put the osql (or your case sqlcmd) in a batch file (.bat) and create a step in  a job using the operating system command (CmdExec). Use xp_cmdshell '<path\batchfile.bat>'

OSQL is run the command line. You can put the OSQL command in a batch file (.bat) and use Scheduled Task to schedule and execute it if it's something that...

You could use the DTS replacement- Integration Service (don't ask me how but mybe someone else can help with this)

I would use OSQL with an output file. Use the -h-1...

Honestly, I didn't know it could be done progammatically in the script. I have always changed the option for the script before running it.

SSMS - Tools - Options - Query Results - Results to Text --> there is a drop down box for output format that has the options that are in 2000.

Looks like we won't be able to use an indexed view. M$ says it can't have a UNION and requires a unique clustered index. We can't meet either requirement and since...

SORRY - Fat fingered it

the rest is:

we are querying vendor tables that are created each month with a common prefix but a random suffix.

Since we can't change the vendor...

The official stance is that Microsoft does not support SMO in VBScript. VB.Net (2005) is the preferred method and DMO is supported via a .Net wrapper around the DMO COM.

As...

I don't know how to do it with WMI, but I use the SCHTASKS in a cmd or bat file. Look here for documentation on it:

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/schtasks.mspx?mfr=true

hope it helps

I tried this with the same outcome. Fortunately, I can validate the input files.

This problem is actually an old DOS issue with not being able to redirect the stdout....