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...
Can you be more clear on which rows need to update? However, as per my guess, you would like to have identical tables with data. Use following query Insert...
Dear all, I am facing an issue i have a user with dbcreator server role and this user has pubilc access to the model db. 1- Now this user can create a new db ...
1st Query: I have 2 tasks: and need it ASAP: Any GURUS canhelp me....... I need an update statement on one table to another table: Both tables got 13...
I have 2 tasks: I need an update statement on one table to another table: Both tables got 13 columns: Table1 has 100 rows..need to add 100 more rows to...
Hi, I want to know the log shipping jobs which belongs to which database from sql query. suppose if we configured log shipping for two databases then. ...
Hello, Meet founders of over 300 startups at the siliconindia Startupcity on Saturday September 12, 2009 at Hotel Rangsharda, Bandra (West), Mumbai. It's by...
Hi Guys, Do any one knows how to find the Mugh Events and details. Since MSN groups closed, i hevent getting any information about the user gorup meetings....
Hi sqlcon@yahoogroups.com, I set up a Facebook profile where I can post my pictures, videos and events and I want to add you as a friend so you can see it....
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.
