Thanks for the update. There is notepad++, this tool has no connectivity with database, still a very good free tool for organizing.

Thanks,

Rajesh

could you tell if the dev database and prod database are the same ? In any case you need to mention database connection values.

Hope this helps,

Rajesh

Could be a good one 🙂 But I am looking for free stuff ;). My company wont pay for this 😀

Thanks,

Rajesh 🙂

I didnot had this problem at all. I have successfully installed Adventure works, even though I didnot had SQL Server running. I didnot attach database for this reason. Any how,...

I normally use SSMS to add linked server. It's a GUI, so making mistakes are less ;). Your connection method seems to be fine.

Hope this helps,

Rajesh

From codeplex you normally get as setup file. You need to select the sample and database option at the time of execution.

Hope this helps,

Rajesh

I am not a great expert of VB.Net. If you could execute SQL command in your VB.Net then Bulk Insert command might be helpful. You could have more information in...

Hi,

Best way to paste the script is run dtsrunexec.exe in dos, fill all the columns and then when it displays the command, copy and paste. This would help you.

Rajesh

Hi,

If you are querying from SQL Table wont you do like Datepart(mm, ) instead of using cast, convert ?

Rajesh

Hi,

If you look at SSIS 2005. You have Event handler. This would be best to use. At the event handler you could call SSIS job agent. This method might be...

Hi,

The only way I see in SQL Server 2000 is to write an activex script. I dont have the code to paste it here, as I have worked a long...

Hi,

Looks like here discussion is happening on encryption of data 🙂 ?. If so, I don't think its a good idea to loose information and again run behind for what...

Hi,

Very sorry. Let me try explaining again. I have a table with:

Col1 col2 col3 col4...