HI Gaurav, Thanks a lot friend. Regards Pankaj gaurav Pandey <gauravpandey2000@...> wrote: Hi Don't worry .you can download that book. Please download...
Hi group, I would like to appear for MCSA(4 papers) certification.If anyone is having dumps or useful link related that please let me know and also let me know...
Hi Friends, I have a file called Metrics.txt which has grown to 70 GB. I suspect that one of the DTS Package is inserting data to this file and there are 150...
NO, in Query Analyzer there is no Option to automatically replace NULL value with Blank in result set. You have to handle this at server side using isnull. ...
hi , you can use case function to replace all NULL values with some text u want or by giving some space there.. will solve your issue.. Best Regards Sunil John...
Hello All *Home Computer Security Tips* We know that while working online in the internet, our home computers are vulnerable to lots and lots of viruses,...
Hello All, We are having a very urgent requirement for one of our prestigious clients. *About the Client* US based MNC having offices in Bangalore and...
Hello All, One of our prestigious clients requires Siebel Application DBA Professionals urgently. Our client is a US MNC, leading player in all ERP products...
Hi, Assume that i am having a table T1 with 2 columns as follows. T1 ... eventid int eventdate datetime t1 ... 1001 2007-06-04 11:30:45 1002 2007-06-04...
Dear All, When we execute a full backup command in SQL, what actually gets backedup into .bak files. Please also provide me the link which contains in depth...
You can take backupof sql2k and restore it in 2k5 Regards, krishna SOMA RAJU <eyesomu@...> wrote: I want to upgrade from sql server 2000 to 2005 for...
Hi group, a) where we can see the triggers created for the particular table,generally where the created triggers can be seen in sql server 2000.? b) Is...
Full backup file will have all the objects of the databases such as tables,views,sp's etc and in case if the database is having full text catalog then that...
Hi Somaraju, Check if the database in SQL 2000 is healthy first before you take backup and restore on to SQL Server2005. You can check the health of database...
Hi Mansoor, Tables,Views, Sps etc., are all logical one. Physically what actully backed up in full backup... Regards, Kishore. ... From: shaik mansoor...
Dear Mansoor, a) You can see the trigger from EM.. In the EM go to the database, then tables.. then right click the table then take all task then Manage...
Hi Friends, Vote Taj mahal for new 7 wonders of the world . It needs lots of votes to be in 7 wonders. http://www.new7wonders.com ... Take the Internet to Go:...
We have a two identical servers, due to some reason the server one crashes and we had to restore the database in the second server. The query execution becomes...
I am facing the problem with linked server. I am loosing the connection with remote server. For job executive, I have to referesh the linked server. How can i...
Hello All, *What skills employers seek from candidates? How to write an effective resume?* And many more job hunting related resources. *Click here *...
Linux <http://allmoneysense.blogspot.com/2007/06/linux-user-huide-2.html> User Guide (2) : managing users [Non-text portions of this message have been removed]...
Hi All, Any body had any documentation on how to use linked servers. The scripts etc. I am eager to learn about this topic. Thankful if provided with good...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the sqlcon group. File :...
sqlcon@yahoogroups.com
Jun 11, 2007 9:07 am
5316
New server New Environment :-> as such one simple guess can be the Execution environment is not behaving properly at New Server. Well this question is a...
dear all, I have one question. can we open a cursor in a trigger. the situation is like this. I have a table named marks having fields: rollno subject marks...
Thanks for the response vijay. Is there any other way to find out the triggers that belongs to the a particular database. Thanks again for your response in...