View Complete Post
We have made some changes to this code to start capturing 1 new field of data and updating it as new records are added. But there is currently about 120,000 records more or less.. those records of course dont have the new field populated with anything..
We would like to run this logic that already in place and run it against the tables to update the fields 1 time. I think to make it easier, if it can be setup to expect the "valueTwo" variable, so that we can run it againt the individual codes instead of doing all the records at one time.. there are codes that only have a few records, so it would be best to test initially against the small code group.
strSqual = "insert into trans (trans_type_name, trans_date,sys_id,mod_user_id,show_ind, remoteCode, techName) values('" & valueTwo & "','" & TransDate & "',"&strSystemID&", 1,'T', '" & dbQuote(strUser) & "', '" & strTechName & "')"
'get the new transaction_id out for just inserted alarm
strSqual = "select max(transaction_id) as transaction_id from trans"
set rst = getStaticRecordSet(strSqual)
Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.
MSDN Magazine September 2004
I recently downloaded the ASP .NET mobile web forms templates for VS2010. Where/how can I get the database scripts to set up a db for the default login example? I've set my connection string hoping it would automatically create the db for me on startup,
but now I'm thinking it doesn't work that way.
How to generate the setup file for windows application (VS 2008) and how to install the SQL server (2005) at client system. Should i install complete SQL Server or anything else..? or Can i integrate the database file (.mdf) into setup file...
Before install these setup at client system, should i install .NET 3.5 framework..?
Please Help me....
I have an application that relies on Database Mail for sending out alerts and notifications.
I have it working wonderfully... as long as I manually set up Database Mail.
How can I provide a script to take care of the details of setting up Database Mail?
Most of SQL Server Management Studio has a "script" button which will accept input, then generate a script to take the actions requested. This doesn't exist for the "Configure Database Mail" Wizard.
I was able to find "Database Mail Simple Configuration Template" in the template explorer. My main question is how to set one of the profiles as the default profile