HI Gaurav, Thanks a lot friend. Regards Pankaj gaurav Pandey <gauravpandey2000@...> wrote: Hi Don't worry .you can download that book. Please download...
5290
shaik mansoor
shaik_mhmansoor
Jun 1, 2007 10:47 am
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...
5291
bhavesh prajapati
bhavesh2984g...
Jun 1, 2007 3:24 pm
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...
5292
sob
steffibev
Jun 2, 2007 5:50 am
Hi, Is there any option I can replace NULL to a blank in Query Analyzer Result Set ? I mean I don't want to use isnull or coalesce function....
5293
bhavesh prajapati
bhavesh2984g...
Jun 2, 2007 9:33 am
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. ...
5294
sunil john
suniljk7
Jun 2, 2007 11:43 am
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...
5295
Anitha Sagar
anitha.vsagar
Jun 2, 2007 12:38 pm
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,...
5296
Ajay
ajayn_delhi
Jun 4, 2007 6:55 am
Hi, I dropped and recreated the linked server, but the problem is still exists. Thanks & Regards, Ajay Jain ram babu <singh_rambabu@...> wrote: IT...
5297
Anitha Sagar
anitha.vsagar
Jun 4, 2007 10:40 am
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...
5298
Anitha Sagar
anitha.vsagar
Jun 4, 2007 11:11 am
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...
5299
nic_santosh
Jun 4, 2007 12:43 pm
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...
5300
kishore
kvkishore79
Jun 4, 2007 3:08 pm
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...
5301
krishna kishore
sv_39
Jun 6, 2007 8:11 am
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...
5302
shaik mansoor
shaik_mhmansoor
Jun 6, 2007 2:59 pm
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...
5303
shaik mansoor
shaik_mhmansoor
Jun 6, 2007 3:04 pm
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...
5304
indu teja
induteja
Jun 6, 2007 4:06 pm
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...
5305
kishore
kvkishore79
Jun 6, 2007 5:40 pm
Hi Mansoor, Tables,Views, Sps etc., are all logical one. Physically what actully backed up in full backup... Regards, Kishore. ... From: shaik mansoor...
5306
sunil john
suniljk7
Jun 7, 2007 7:05 am
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...
5307
vijayasekar shanmugha...
vjsekars
Jun 7, 2007 2:50 pm
sp_helptrigger 'object_name' will give you triggers on a table. Thanks Vijayasekar ... [Non-text portions of this message have been removed]...
5308
nitin kumar
nitinm_525
Jun 7, 2007 7:49 pm
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:...
5309
Santhosh
san_spy
Jun 8, 2007 2:30 am
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...
5310
Ajay
ajayn_delhi
Jun 8, 2007 8:06 am
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...
5311
Anitha Sagar
anitha.vsagar
Jun 8, 2007 11:41 am
Hello All, *What skills employers seek from candidates? How to write an effective resume?* And many more job hunting related resources. *Click here *...
5312
Mubarak Sha Mustaq Ah...
mubaraksha
Jun 9, 2007 6:44 am
Hello.. I Just visited this site. Very useful content. I will try to read it all. I am .net and SQL Server developer. Thanks Mubarak Sha ... ...
5313
oraclerojak
Jun 9, 2007 2:38 pm
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]...
5314
indu teja
induteja
Jun 9, 2007 3:36 pm
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...
5315
sqlcon@yahoogroups.com
Jun 11, 2007 9:07 am
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 :...
5316
Veer Ji Wangoo
vwangoo
Jun 11, 2007 9:40 am
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...
5317
RAJAN SHARMA
rajans22in
Jun 11, 2007 10:46 am
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...
5318
shaik mansoor
shaik_mhmansoor
Jun 11, 2007 3:15 pm
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...
