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.

We cannot use powershell too. It would be good to have a script in TSQL itself.

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...

Make sure the smtp port is open & you have proper permission to the exchange server

Just try locating the mdf file & it will automatically pick the log file.

If you have added triggers you can check all that.

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...

not required to restart the sql agent for such job changes.

Make sure you have similar columns & data type defined in both DBs

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 !!!

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...

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....

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 !

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...

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...