Viewing 15 posts - 1 through 15 (of 45 total)
I am looking for the script as there is a security concern of running any tool except TSQL script. Could you please help me getting it.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
November 7, 2014 at 3:51 am
We cannot use powershell too. It would be good to have a script in TSQL itself.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
November 6, 2014 at 10:36 pm
After uninstalling with the uninstall option, just delete all the SQl folders from the drives & then go to the registry -->HKEY_Localmachine & delete any entries related to SQL server...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
May 22, 2012 at 5:40 am
Make sure the smtp port is open & you have proper permission to the exchange server
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
May 22, 2012 at 5:36 am
Just try locating the mdf file & it will automatically pick the log file.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
May 22, 2012 at 4:51 am
If you have added triggers you can check all that.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
August 24, 2011 at 3:11 am
hi,
You need to add the IP address details in all the sections during configurations whereever you find the IP field. Also if you are using dynamic/static port also you need...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
August 24, 2011 at 3:10 am
not required to restart the sql agent for such job changes.
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
June 29, 2010 at 3:03 am
Make sure you have similar columns & data type defined in both DBs
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
June 10, 2010 at 6:55 am
Make sure authentication mode is set to Mixed Mode(Windoes & SQL). Else the SQL users will not be able to login.
Have a nice Day !!!
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
April 1, 2010 at 12:46 am
Hi,
At times you will find that all of the SQl components do not appear under Add/Remove programs. In that case you need to download Windows Clean up Utility, install it...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
February 25, 2010 at 4:44 am
Hi ,
You may need to check if the Microsoft SQL Server folder in Registry has been granted full permissions to the user with which the installation is being carried out....
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
February 25, 2010 at 4:41 am
Hi,
Also, you can try out using -i D:\SQL\Script1.sql in place of -Q if you are directly calling a script. -i indicates the script file path.
Have a nice day !
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
October 20, 2009 at 4:41 am
Hi,
Try this command:
sqlcmd -Sservername -d myDB -E -Q "select col1, col2, col3 from SomeTable" -o "MyData.csv" -h-1 -s"," -w 700
-h-1 removes column name headers from the result
-s"," sets the column...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
October 9, 2009 at 5:15 am
Thanks Jack.
But I am not getting on what code/expression to use within script task . If you could help me it would be great. I have no idea of SSIS...
----------------------------------------------------------------
**"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **
August 7, 2009 at 6:01 am
Viewing 15 posts - 1 through 15 (of 45 total)