Hi Folks, I have a Date "01/01/1621" in my source data (Oracle) and trying to migrate it to sql server. This is a Valid Date for my Application. SQL 2005 says...
Vinay, Unfortunately we dont have any other option for this. SQL Server allows dates between Jan 1 1753 to 9999. The only option left is to store these dates...
i am having one query that i want to create a stored procedure(using sql server 2000) where i am going to pass a parameter value,size will 10000+ . Is that...
I will be out of the office starting 17 Jan 2008 and will not return until 29 Feb 2008. For any urgent matter please contact Sushant WAGLE/ITD GLT/HSDI/HSBC or...
Hi Sivaraman, No it is not posible - maximum is 8000 chars. You can create local temporary table with text field and pass its name to stored proc. Pavel ... ...
Hi, I need sample paper for SQL Server 2005 certification. CAn anybody help me out? Thanks in advance.... Nitin Unlimited freedom, unlimited storage. Get it...
Hi All, Any body have the recent dump for MCTS(431 sql server 2005). Please help me out. Thanks Harsh Kumar kunal choudhary <nitin_mca_23@...> wrote: ...
I have a stored proc which is doing a search from a few tables by doing an inner join. When I enter a new search string, the proc takes some time to get the...
Hi Nitin, We recently purchased a dump and looking for people to share expenses. Are you willing to spend Rs.500/- for the dump. Sorry, since this is a...
Hai, I am having one doubt . That we have created a stored procedure . this stored procedure will four functions,5 other stored procedure and also it has over...
I have a requirement to free up some space in the main database (as it has become very bulky) and also we need this data in future. So, we need to do...
Hi I can share the cost. Plz send it it to me. Mobile: 9845652010 Thanks Chandra Techie <sqlserver1717@...> wrote: Hi Nitin, We recently purchased a dump...
I am also interested to share.. I am also ready to pay.. Plz send it to me also.. _____ From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On Behalf...
Hi All, In one of our Dev database server, we are not able to populate (both full and incremental population) the full text catalog. we were getting 'The...
I am ready to pay. Call me @09881121388. Nitin ... From: Chandra Shekar <chandu_mam@...> To: sqlcon@yahoogroups.com Sent: Wednesday, 23 January, 2008...
If you dont want the log for this operation, you can issue the following command that prevents the log file growth during that operation. BACKUP LOG...
You can increase frequecy of transaction log backup (Like every 2 minutes or every 3 minutes) during this period. It will help you out. Nitin ... From: shaik...
Thanks for sharing the books. Can you please share some study material? I am a sql server 2000 developer and will like to learn sql sever 2005. I will really...
Hi, Please send me. My no. is 9866659641 Meenal _____ From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On Behalf Of Satya Prakash Sent: Tuesday,...
Hi Akhil, Following are the links for book Apress Beginning SQL Server 2005 for Developers From Novice to Professional. Download all below files in one folder...