Hi Team, I am facing some problems on designing the look up table. We are going to move data by using lookup table and for that I have designed few columns...
Hi Vemuri, what is the access pattern of that table? i.e When you query this table what kind of queries you are going to use? Thanks -- Vijaya Kadiyala ...
Hi, Sorry for the late reply, We are using this table when we check with source data, like take status type example , source is 'ACTIVE' and Target is 'AC' ...
Dear Babu, It would be gr8 if you could let me know the Company for which this requirement is.. ... From: Babu <babupp@...> Subject: MUGH-SQLCON SQL...
Hi Sorry was out of Internet... In your case it would make sense have as a Key value pair combination(i.e. 2 columns). You dont have to use nvarchar for this,...
Online Engineering Degree <http://www.careerdegreeinfo.com/degrees-by-subject/online-engineering-d\ egrees.html> The progress in the field of engineering has...
I am taking this Spammer Off :) Regret this inconvenience. From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On Behalf Of school_get124 Sent:...
Think Twice Before Upgrading to IE8 <http://tinyurl.com/m3hppu> Microsoft is attempting to foist its latest browser upon the world -- don't let this happen to...
Think Twice Before Upgrading to IE8 <http://tinyurl.com/m3hppu> Microsoft is attempting to foist its latest browser upon the world -- don't let this happen to...
Hi everyone, I am about to upgrade one of my SQL server 2000 SP2 to SP4 and they are setup in a 2 node Failover cluster (Active/Passive) environment. Are there...
Hi All, while connecting to the Integration services from mgmt studio we are getting the error message. the same has been attached. after changing the...
Hi Sunil, Thanks for your reply. Bu I need this format only (714) 123-1234 I need like 1231234 ( NO DASH)this only ... From: sunil john <suniljk7@...>...
Hi All, I used different method to get the results.. here it is: Declare @phone varchar(13) Set @Phone = '(714)123-1234' select substring(@Phone,6,3) +...
what i did also will work! Best Regards Sunil John ________________________________ From: Varra Reddy <varra_s@...> To: sqlcon@yahoogroups.com Sent:...
Dear Varra, Bakup Log <database> with truncate_only dbcc shrinkfile <db logfile> before truncating make sure u have full back or tran log back Best Regards ...
Hi, Aren't you taking T-Log backups? Take T-Log and see it helps you this would be the first thing you should do. And then you should investigate why it has...
Hi All, we have installed sp3 and hot fixes on all the prod,bcp,sit and dev (around 150 server). environments. in some of the servers client components...
There might be any huge uncommitted transactions going on. Check with the current transactions...if you find one, try to execute in smaller chunk/batches with...
Hi Team,  We have a requirement to test SQL server 2005 64bit on windows server 2008 64 bit virtual Machine and create benchmark. Testing includes database...
Hello Folks, Learn Exclusive C# 3.0 on weekends for free of cost in Hyderabad. Course Name: C Sharp 3.0 Start Date: July 26th, Sunday Start Time: 9:00 am (3-4...
Hello Friends, Can anyone of you brief me about the differences between Merge Replication and Transactional Replication with updatable subscribers (in SQL...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
