Can you please re-phrase the Question?.
Franks... Thanks so much for u're reply.<br /><br />Here is the total Scenario.... Seeing the below table structure what do you think is the good way...
I have a table with around 240 columns and one of the column in the Table is the Inserttime ( DATETIME ) and I using a GETDATE() function in the...
Frank/Adriaan, Can you please give me an Example for this ( or the Pseudo code ) Thx Venu
Its good but If I re-run the process on the same day ... that will be an Issue. V
Need some suggesttions. I have a table CREATE TABLE Symbols ( Symbol VARCHAR(16), TradeDate DATETIME , ProcessIndicator CHAR(1) , Col1...
I am planning to use SQL Lite for backing up the databases to reduce the time window for backing up... Does any one had any issues using SQL Lite?...
Thanks Adrian, But if the Users passes an Empty String or just a space ' ' , then the it will insert 1900-01-01 00:00:00.000 instead of Current Date...
I can't use the default Value either , because if the User supplies '' ( empty space ) then also I want to insert the date. I was looking for an...
Thanks Thomas. How to put a check Contraint for checking ( If ColName IS NULL OR ColName = '' ) THEN GETDATE(). I tried but it throws an error...
1st Question 1. I have a table called XXX in the 4 diff Databases. I want to get the row Count of the XXX table in from 4 diff TransDB's and sum the...
RosID2 has some information in that the first byte has represent the order type and the other 3 bytes will have the date. both the sorce and...
RosID1 RosID2 67108865 33884956 67108865 33885211 67108865 33885212 67108865 33947907 67108865 33947921 67108865 33947922 The integer values...
Enabled the Network Access in MSDTC . All is fine. Some times I have this error message .... and the program fails "New transaction cannot enlist...
I am doing a simple IO Test with the below script ... Just wanted to keep things simple and to check how many Inserts I can do on a given SQL...
if you guys are talking about inserted and deleted tables in SQL Server. SQL Server automatically creates and manages these tables. You can use these...
the statistics or the query plan might be getting out dated ... check it out
Make sure you have a good back up copy of the database you are trying to detach.. DETACH and ATTACH are pretty smooth... I don't think you will have...
If you want to make sure that no one connects to the old database , take the old database offline on the old server .. Check if you are using any...
Share the Drive( say Dumps ) on XYZ machine and back up the database from ABC to XYZ ( Some thing like this from the Query Analyser \XYZDumpsDB.BAK )...
Separate names with a comma.
