hi I found this interesting puzzle and am putting this across ... Consider RAM a mango seller he sells mangoes everyday .Now for future sales projections he...
600
itinprogress
itinprogress@...
Nov 1, 2004 1:17 pm
IT GIANT in Hyderabad requires .NET Testing, Developers for the below skillset. 1.Development – Senior Developers / Leads – Total experience = 5 - 10...
Hi, I am running a generic DTS package that inserts records into a specific table 'XYZ'. My requirement is that, if a null value gets inserted into a specifc ...
602
balaji_nv
balaji_nv@...
Nov 2, 2004 1:48 pm
Hi friends, This is N.V.Balaji newly joined in this group, friends plz kindly send me the complete material of SQL if anyone having the softcopy. thanks &...
Dear Moderator, I am Suresh Babu, this is my first mail to this group....... I am working as a Software Engineer in .NET Technologies and i am using the...
Anjana, I am not a DTS expert, but AFAIK, regardless what performs the insert, the insert trigger will get fired, unless you explicitly disable it. Remeber...
Balaji, what you mean by complete material of SQL? Books online is the first reference you should look at, which is available with SQL Server Installation. ...
Suresh, make sure that the collation setting, comaptibility level and version are same on both the servers. It seems like there is a version difference. Try...
Dear Bala , you have demanded everything in two lines..Its like filling whole Ocean in my Cup of Tea and Presenting it to you...That is very difficult. I...
Hi, Thanks! Actually the DTS package is disabling the triggers. What I want to know is if there some way of not letting the DTS package disable the trigger :)....
610
Raghava Naraharasetti...
v-ragnar@...
Nov 3, 2004 5:25 pm
Hi, Why you want to write trigger for this. Instead ADD DEFAULT constraint to that column. Thanks Raghava ________________________________ From: Anjana Ram...
Hi, I am rajan, I am having inside_ms_sqlserver_2000 of MS Press not a pdf. If you want i can send it. Rajan Vishwakarma hifzee <hifzee@...> wrote: hi i...
Rajan, will appreciate if you could send that as well. Thanks n regards Vaibhav ... From: rajan vishwakarma To: sqlcon@yahoogroups.com Sent: Thursday, November...
U can upload the same in the files links of our group and share with everybody...I am not sure abt the size you can upload... ... pdf. ... http://www.mugh.net ...
http://geekswithblogs.net/veerji/archive/2004/09/29/11867.aspx veer <vwangoo@...> wrote: U can upload the same in the files links of our group and share...
Hi There is one simplesolution to your problem. Any Bulk copy program say bulk insert or bcp or dts does not fire a normal trigger.. U have to write...
All good programmers test their code. But can testing be easier? Can it be better? S. A. Miller shows how unit tests can help, along with an open source...
dear friends, what are different types of master and details releationship? what is size of db_table? plz reply urgent how timestamp maintain by databse? how...
Off Topic : Testing Professionals. Bangalore MNC. Loadrunner Unix We are seeking top-notch testing professionals (experts in Unix and having working knowledge...
Hi All, I have following question. I need to extract the data into tab delimited text files from SQL SERVER Tables in Batch Process. Manually we can do using...
Hi, We would like to convey you that we are looking for SQL Server DBA with 5+yrs of dba experience for our client in Singapore. So if you are interested,...
You can use DTS packages for same and Schedule them even in the form of Jobs and even call them fron VB/ASP code to trigger them... Please let us know if you...
hello could u tell me how to copy database with different name in sqlserver 2000 i want one more copy of the same database say for example 1. i want the...
hi Raja Sekhar I would recommend using BCP utility this is great tool to dump records to a flat file from Sqlserver Table and Vice versa. For the exact syntax...
Hi Anwar i would not recommend copying all tables of a database to the tempdb. Even for migration this is not the best place to storing data for long. Also...
Hi Try right clicking the transform Data Task Unselect fast load option in the Tools tab Hth Viswanath ... normal trigger.. ... default it will not fire the...
Hi , One simple way to do this is detach the database. Copy the mdf and ldf files to another location. Then attach the database one with the old name and other...
