Hi Shaik Find attached the script for the same Sunil kak ________________________________ From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On...
5529
Veer Ji Wangoo
vwangoo
Jul 26, 2007 1:47 pm
Oh it problem of Double hopping.. Do one thing on the security tab Linked server change and authenticate your credentials w.r.t to the one which are on the...
5530
Veer Ji Wangoo
vwangoo
Jul 26, 2007 1:49 pm
Oops attachments not allowed.. please copy paste it neatly in NON -HTM page in your email.. From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On...
5531
Sunil Kak
buntykak
Jul 26, 2007 2:22 pm
Below is the script ****** DECLARE @table_name VARCHAR(500) DECLARE @schema_name VARCHAR(500) DECLARE @tab1 TABLE( tablename VARCHAR (500) collate...
5532
Veer Ji Wangoo
vwangoo
Jul 26, 2007 2:34 pm
http://sqlservercentral.com/columnists/bkelley/qa2k_1.asp This will also help you ... From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On Behalf Of...
5533
Veer Ji Wangoo
vwangoo
Jul 26, 2007 5:51 pm
Hi, I am having a peculiar situation here .. My banking Auditors want me to generate a report from every SQL server which will get the history of all service...
5534
Manish Sharma
connect_manish
Jul 26, 2007 11:09 pm
Hi All How can we restore tail of transaction, e.g i have last full backup but after that i dont have any backup, but database is in full recovery mode.Can i...
5535
Babu
babupp_in
Jul 27, 2007 5:20 am
Hi Friends, Can any of you can explain, what exactly the "Reads" column in Profiler mean ? I'm not comfortable with the explanation given in BOL. "The number...
5536
kumanan archunan
dkumans_a2000
Jul 27, 2007 7:02 am
Hi veer You can write a program in an application(like vb) that will be running automatically when system starts. This program to check sql server setup log...
5537
Ved Prakash Agrawal
ved_17in
Jul 27, 2007 3:44 pm
Veer, Here is link for some stuff , Just look one time may help you. ...
5538
Lalit Kumar
lalit_khatter
Jul 27, 2007 10:36 pm
CNN has profiled Blue Chip a little differently: http://money.cnn.com/magazines/business2/business2_archive/2006/10/01/8387089/index.htm?postversion=2006101707...
5539
Madhu K Nair
madhuotp
Jul 28, 2007 4:34 am
i have already answered this in MSDN forum... hope this will help others ... From the below mentioned Link The I/O from an instance of SQL Server is divided...
5540
Venkataramana Rao Nott
venkathk
Jul 28, 2007 8:50 am
Vinculum Group is looking for solid top notch SQL Server DBAs to be based initially in Mumbai. Boutique company. Interesting work, Good package...... Please...
5541
Manish Sharma
connect_manish
Jul 29, 2007 11:14 pm
Hi All, My client whats to see some jobs related to his database. Since his user is not a member of sysadmin, so he is not able to see any job. When i add his...
5542
Madhu K Nair
madhuotp
Jul 30, 2007 2:49 am
you have not specified the version... if its 2005 yes you can.. New Roles in the msdb Database SQL Server Agent in SQL Server 2005 adds three new roles to the...
5543
sunil john
suniljk7
Jul 30, 2007 8:29 am
Dear all, we are using sqlserver 2000 enterprise on windows server 2000 adv. for that last two days on the server the cpu is running around 90% CPU. the...
5544
Babu
babupp_in
Jul 30, 2007 12:28 pm
If you are having only 6 active connections at a time, it could be quite easier to locate the connection causing problem. Keep watching these active connection...
5545
sunil john
suniljk7
Jul 30, 2007 1:34 pm
Dear babu, thanks for the mail, now then i mean there is only 10 active process that means these active process are changing all are not active all the time....
5546
Babu
babupp_in
Jul 30, 2007 2:08 pm
With sp_who2, CPU Time column is showing the cumulative time (in ms) consumed by that connection till from beginning of its connection, not the current running...
5547
s manikanth
s_manikanth
Jul 30, 2007 2:13 pm
http://blogs.techrepublic.com.com/10things/?p=193 //M ... Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo!...
5548
sunil john
suniljk7
Jul 30, 2007 2:50 pm
Dear babu, hmm thatz a good knowledge for me, i though its the present cpu its using.. i tried to find the Query which some of the process using but am seeing...
5549
JeeLani bASHa
basha_21_99
Jul 30, 2007 4:24 pm
Hi folks, I need a help in db user auditing. i have to retrive a list of db users and there permission to tables for each database. i wrote a script but the...
5550
Manish Sharma
connect_manish
Jul 30, 2007 10:49 pm
thanks for your reply. But its sql server 2000 Madhu K Nair <madhuotp@...> wrote: you have not specified the version... if its 2005 yes you...
5551
Veer Ji Wangoo
vwangoo
Jul 31, 2007 12:32 am
Few Questions before I give you the right script... 1. Do u want client to view only or modify his jobs as well.? 2. or Do you want them to see the status of...
5552
nic_santosh
Jul 31, 2007 6:23 am
Hi All one of table A containing 4,00,00,000. while giving a select statement it is taking some thing around 10 min... What Should be the Possibility to Make...
5553
Babu
babupp_in
Jul 31, 2007 7:06 am
I think your front-end application is passing queries directly, than using stored procedures. If the situation is like that, it could be difficult to tune...
5554
Babu
babupp_in
Jul 31, 2007 7:10 am
"select * from ..." may do a Table Scan or Clustered Index Scan. This is a really time consuming task. Consider the following, 1. Is there a primary key...
5555
jeelani basha
basha_21_99
Jul 31, 2007 12:34 pm
That was a typo... I wrote a Query but the output is not correct. let me know anybody can help me in this JeeLani bASHa <basha_21_99@...> wrote: Hi...
5556
Vidhya Sagar
kvs1983
Jul 31, 2007 1:18 pm
HI Jeelani, Refer the below link and go to script section, i think the script overthere may help you. Sqlarticles.com...
5557
arsalan
arsalanayub
Jul 31, 2007 6:05 pm
Multiple Job openings at DevASP Inc. Please do not hit the reply button right away; any CV submitted to an address other them jobs@......
