Do I have SP3 or SP3a? If you issue a command select @@version and If you visit following microsoft page it will say for both SP3 and SP3a the version is same...
Hi All, Please let me know the best way of error handling in Stored Procedures in Sql server 2000. Best Regards Shyam Sunder .K Database Administrator. 98851...
Have a look at http://www.sommarskog.se/error-handling-I.html http://www.sommarskog.se/error-handling-II.html Regards Roji ... From: Shyam Sunder To:...
Intial Sp3 was bugged and it has been corrected, from the download link it should be SP3a. --Satya http://www.sqlserver-qa.net ... following microsoft page it...
Hi Bineesh, There is a Trivandrum MUG (http://www.t-mug.org/), but it doesn't have a seperate SQL chapter. We can connect you to the T-MUG UG leads, and they...
Hi, Always use small block in sp and after each block check for if query is doing any DML operation:- BEGIN TRAN IF @@ERROR!=0 BEGIN ROLLBACK TRAN SELECT 'MSG'...
Hot Jobs – HCL - Database Administrators - Urgent HCL, One of the largest IT Company of India requires Database Administrators for following locations. ...
Hi All, I am getting the below mentioned error in SQL Server 2000:- Login failed for user 'sa'. [CLIENT: <local machine>] I am using the Mixed authentication...
Hi Ajay, Try to login to windows authenication once .if it works then it is problem with sa user account either the password entered is wrong or may be with...
If its sql 2005, once you login with windows id, check if sa account is locked becuase of any password policy. //Mani $ha$hi <vardhan_shashi@...> wrote: ...
Go to Enterprise Manager and expand your database then expand your Security and change your password for sa. Thanks! ... -- Shashi Kumar Singh Systems...
Hi group - I am trying to migrate/ convert SQL 2000 DTS pkgs into SQL 2005 SSIS pkgs. Here are the errors w.r.t the couple of pkgs: 1. Source: DB2 table to...
Are you sure that your collation are same for both SQL’s? _____ From: sqlcon@yahoogroups.com [mailto:sqlcon@yahoogroups.com] On Behalf Of hisatya Sent: 04...
try to open enterprise manager using run as administrator ... Travelling to a new city? Search for ATMs in that city. Go to http://in.maps.yahoo.com...
Hi, I have SERVER-A and SERVER-B. There is a transactional replication set-up from A to B. I am just an owner of A and on B i have no access, The permissions...
Stop the log reader agent before you restart server A, and once its up i think it should automatically sync or you can start manually. thks, Mani bhavesh...
Hi, Proper procedure to restart publisher or subscriber servers is synchronize the data manually making sure that there is no delta in the queue, then stop sql...
Hi, If the downtime window is more and number of transactional replication publications are more then due to heavy transactions on active active publisher...
Hi Team, I have one production database on SQL server 2000. When user trying to access the database from his local SQL server 2000 system , he can able to see...
Hi friends, I am in big trouble this time....can anyone please help me in this....the scanerio is like this........ I have got a already setup active/passive...
Error! Filename not specified. <http://go.microsoft.com/?linkid=7539309> Webcast Schedule - October 2007 Attend a series of LIVE Webcasts this October by...
Check your backup with following command Restore verifyonly from disk='backupfile with full path'. If its not a valid backup then take a backup again and try...
I like SQL Server 2000 EE. But I listen 2K is a really good RDBMS. ... http://groups.yahoo.com/group/sqlcon/surveys?id=2270737 ... Now you can chat without...
Hi, So yur are trying restore a backup of 2000's server to2005 server and getting an error. The best way is Register 2000 server in 2005 instance, I mean...
FYI: Plan to attend these webcasts by Microsoft SQL experts....! Webcast Schedule - October 2007 Attend a series of LIVE Webcasts this October by Microsoft...
Hi friendz, I have the folowing scenario and I am stuck up to find the solution on how to migrate (not upgrade) or move database diagrams from SQL Server 2000...
Hi, We are using sql 2005 instance with SP2.Sometimes users were are not able to connect to instance and it gets solved only after instance is recycled.We get...
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.
