Dear Frineds, Basavaraj Here, Actually at one of our site we have SQL server 2000 running with windows based authentication . The problem here is they have the...
if it is windows authentication why cant u reset the windows password ... tell u r network administrator to reset the passowrd... in windows authentication,...
Dear Madhu, However i can ask the client to reset the passoword, but this problem will repeat again as the password will expire again in 3 months according to...
You can ask the Administrators to set "Password Never Expires" option for this specific user account. Thanks, Neeraj ... From: Basavaraj mailar To:...
Neeraj Malik
nrajmalik@...
Mar 6, 2007 1:37 pm
5057
You should be able to reset the password through network admin as said by Nair. User with local admininstrator rights will be able to login into the box.Ifyou...
If you know the new password, go to the services and select the sql server and its relevant services and change the password of the accounts and restart, it...
There is a bug in the maintenance plan clean up schedule, which does the clean up a bit earlier than expected. Seems they have fixed the bug in the latest sp2...
Dear Mubarak, This fix is only if you have downlaoded the SP2 from the Microsoft prior to March 5th. The latest SP2 in their website, includes the fix build in...
Hi All, Is there any standard naming convention for sql server db objects? could you please let me know if you know any. Any information regarding this will be...
Hi, suspect for a variety of reasons: database files are unavailable, files are corrupted, or a database resource by be denied by the operating system....
Hello: Firstly thanks for excellent response. We have few more opportunities in BizTalk and Sharepoint Server developers for one of client in Southern...
Hi Balesh, All the replication tables are present int msdb. Go ahead and clear all the entries. Let me know if this doesn't help. Thanks, ahoo.com> wrote: Hi...
if your database not recover from suspect mode. you set the database into emergency mode and then run the checkdb command to findout the problem if tables...
I have a requirement to Import/Export the data between SQL Server 2000 and SQL Server 2005. I am facing some problems when importing data to SQL Server 2005...
Munavvar_Shaik
Munavvar_Shaik@...
Mar 15, 2007 1:13 pm
5070
What is the error you gets? what is the tool u used for import/export... Pse post the full error Madhu ... 2000 ... from ... use of the intended recipient/s...
You need to rebuild indexes if your Index is corrupt or if there is high fragmentation. You can use DBCC SHOWCONTIG with index name to view fragmentation...
HCL HIRING DATABASE ADMINISTRATORS - URGENT HCL, One of the largest IT Company of India requires DATABASE ADMINISTRATORS for following locations.. Team Lead...
Hi group - I have some 350+ databases to be migrated to SQL Server 2005 and that also includes few Oracle databases and lots of DTS packages. Is anyone have...
Hi Satya, Most important point to be considered before moving to SQL 2005 is SQL 2005 will only suppport ANSI compliance code where as SQL 2000 will also...
Also refer to the links: http://www.sql-server-performance.com/sj_detect_fragmentation.asp http://www.sql-server-performance.com/rd_index_fragmentation.asp ...
Thanks for sharing valid info, Kishore. Group - Is there any other post migration issues that I need to plan for? What is the best method for side-by-side...
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.
