Hey Deepak, Try this solution. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19030 With :))s Santhosh =====-----=====-----===== Notice: The information...
Hi Santhosh, Thanks for your help. but i am getting below error while updating sysdatabases in the 7th step of document: 7) Open Query Analyser and in master...
I think you have sql 2005, in that case you can not update system objects. Try these steps (a) create a database with the same name in another directory as...
Hi Friends, Two months back my cluster (A/P) got crashed one by one both node so we have rebuilt each node one by one and add in cluster but by mistake we...
Hey Rizwan, One thing that comes to my mind is try to move the sql server to the second node and then try applying the SP4. Even though the recommended ...
Thanks Santosh for reply, Actually I can not play with this production box because I didn't tell about this mistake to my management so please let me know any...
Would suggest reading about Need_SP_Key key in registry , i had done this once cant remeber clearly however . On your own risk thanks Viswa ... didn't tell...
Guys, I need dumps on 70-443 and 70-444. I have a timeline from client and need to complete this ASAP. Please send me if someone has updated one. Thanks in...
Hi I am facing a problem with SQL Server 64 Bit SSIS Package & Oracle 32 Bit fo Connection. Connecting on 64 bit sq lServer 2005 using Visual Studio( SSIS...
Hi guys, does any one know how to delete the old databses/ or how to delete databases crdate. Example: I want delete the last year databses... any help thanks ...
Hi Friends, On one of my Production SQL Server box - full text population starts automatically whenever SQL services get re-started. I have checked that it is...
I am having one query . I am creating a user defined function in sql server 2000 . I tried to delete some records from tables and also tried to insert new...
Hi, I am trying to run a query on my sql server 2005 and get the following error message: select * from table_name; "An error occurred while executing batch....
Hi,There might be number of ways to do this job;here is the one.Dropped databases cannot be restored unless u have backup copy.So be aware about this.Supply...
For your conveience script is attached;Thanks,RaviOn 14 Mar 2008 19:27:08 -0000 sqlcon@yahoogroups.com wroteHi,There might be number of ways to do this...
Siva Raman,I am not clear with your requirement and why you have to go for a function.One thing you have to consider is "User-defined functions cannot be used...
Dear all, I haveone job for backing up all databases, till last day it was working fine. YesterdayI noticed that the status of the job is not change it was...
Sub: Positions for Software Engineers in all the disciplines. We are very much glade to announce that our company Apple computers <http://www.apple.co.in/>...
Sub: Positions for Software Engineers in all the disciplines. We are very much glade to announce that our company Apple computers <http://www.apple.co.in/>...
Hi I wonder, is there any help on getting all those table/views names that were being used in a SP. Let the tables be used for Select, Insert, Update... what...
Hi, The below query will give you the list of SPs name uses the specific table like "Test" SELECT distinct name,xtype FROM syscomments sc INNER JOIN...
What if the size of the stored procedure is really huge? Then I guess it is not completely stored in one position rather it is distributes across internally by...
Hi Chakradhar,Hope this helps:Q1:Help on getting all those table/views names that were being used in a SP ?A1: Stored procedure body will be stored in...
Hi Team, I have a need to access data on another server in a stored proc and as long as I hard code the server name, it works, but I want to have the server...
You have not mentioned SQL Server Version. If its SQL Server 2005, this is an ideal case for Synonyms. Read about synonyms in SQL Server BOL M adhu ... ...
This is the one area where sql server 2008 has many enhancements. In earlier versions (2005,2000 etc) there are couple of system sps which gives these kind of...
The following sqlcon poll is now closed. Here are the final results: POLL QUESTION: Are you ready to upgrade to SQL Server 2005 when SQL Server 2000 version...
sqlcon@yahoogroups.com
Apr 1, 2008 1:43 am
6038
Hey, I just found out about this event where millions of people around the world are joining together to make a statement about climate change by turning their...
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.
