Forum Replies Created
Viewing 15 posts - 196 through 210 (of 327 total)
-
RE: How to find all the SQL servers within a domain
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Spool to Excel from SQL Server 2005 - help!
"This sounds like a perfect time to use a DTS Package"If you are using SQL2005, you can use the Import/Export wizard in SSMS. Right click on a database, choose Tasks...MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: How to find all the SQL servers within a domain
have look at this tool.
http://www.specialopssecurity.com/labs/sqlrecon/
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Create T-Sql script to export to csv
glad I could help
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Create T-Sql script to export to csv
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>'
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Create T-Sql script to export to csv
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Create T-Sql script to export to csv
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Create T-Sql script to export to csv
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.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Create T-Sql script to export to csv
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.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: ALTER VIEW-will index be recreated or reindexed?
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: ALTER VIEW-will index be recreated or reindexed?
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: SMO vs SQL-DMO
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Scheduled Tasks
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:
hope it helps
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Instant Querying
"It won't be long before QA is a thing of the past and we'll all be swearing each time we start up SSMS".Unless MS decides to do something that...MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: SQLCMD vs OSQL: Missing Script errors
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....
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Viewing 15 posts - 196 through 210 (of 327 total)