Viewing 15 posts - 31 through 45 (of 70 total)
Here is the updated script.
I have also updated the online script, Just waiting for it to be published.
/**
Script: list all Usernames, Roles for all the databases.
Author: Shiva Challa...
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 8, 2008 at 7:57 am
This issue did not reoccur yet. but my concern is that it might and i dont have any explaination of what happened.
Do any of you good folks at sqlservercentralville...
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 8, 2008 at 7:49 am
Thanks Cathy !!
Do you mind if I add this to the online script?
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 2, 2008 at 2:44 pm
steveb (9/29/2008)
This is the code i use to get the current running sql queries
SELECT st.text, r.session_id, r.status, r.command, r.cpu_time, r.total_elapsed_time
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS st
For 2000, you...
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 29, 2008 at 1:19 pm
KDASQL (8/28/2008)
Is there anyway we can make this work in SQL 2000. I need to run this on a SQL 2000 box.Please advise.
Thank you.
You can't run this script on SQL...
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 25, 2008 at 9:14 am
Key DBA (8/28/2008)
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '-'.
(260 row(s) affected)
(260 row(s) affected)
......
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 25, 2008 at 8:40 am
Hi Jeffrey
You just made my day!!!
Thanks a lot for this info.
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 22, 2008 at 1:38 pm
My hunch is that its an authentication issue.
You can test it in two says.
(1) Try using "Be made using this security context" and enter the remote Login and password....
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 22, 2008 at 1:25 pm
When using "Be made using login's current security context", SS2005 will use your logged in userid and password. If this is working on your server, where is it failing?
by using...
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 22, 2008 at 1:05 pm
There were some miscellaneous characters in the below statement that was causing that issue.
I have attached the image highlighting the code that have those characters in it.
Also, I have...
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2008 at 11:26 pm
You should install Oracle 10 64bit client.
You have to install a 64 bit client (or any app for that matter) on a 64 bit machine. It doesnt matter which...
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 29, 2008 at 8:46 am
Thanks for your help GSquared!
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 29, 2008 at 8:17 am
Thanks GSquared!!
so, its like a copy of the existing index is created on tempdb while the original index is being reindexed in online mode?
thats why you see the tempdb...
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 28, 2008 at 2:36 pm
Thank you Ola Hallengren...
I will check it out.
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 25, 2008 at 3:20 pm
Hi GSquared, thanks for the response.
This happens during an idle time, 3:00 am.
But I cant change the script for this alone, its automatically generated as a part of Rebuild...
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 25, 2008 at 12:54 pm
Viewing 15 posts - 31 through 45 (of 70 total)