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...
5753
Shyam Sunder
shyam_k25
Oct 1, 2007 1:37 pm
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...
5754
Roji P Thomas
roji_pt
Oct 1, 2007 1:56 pm
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:...
5755
satyaskj
Oct 1, 2007 5:25 pm
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...
5756
Anjana
anjana_r21
Oct 2, 2007 7:49 am
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...
5757
Anjana
anjana_r21
Oct 2, 2007 9:28 am
*Microsoft SQL Server Community <http://www.sqlcommunity.com/>** * World Wide Community for SQL Server Professionals *WWW.SQLCOMMUNITY.COM...
5758
Shashi Kumar Singh
shashi_120
Oct 3, 2007 3:57 am
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'...
5759
Dba Gurus
dbagurus
Oct 3, 2007 5:30 am
Hot Jobs – HCL - Database Administrators - Urgent HCL, One of the largest IT Company of India requires Database Administrators for following locations. ...
5760
Ajay
ajayn_delhi
Oct 3, 2007 5:51 am
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...
5761
$ha$hi
vardhan_shashi
Oct 3, 2007 6:41 am
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...
5762
s manikanth
s_manikanth
Oct 3, 2007 2:32 pm
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: ...
5763
Shashi Kumar Singh
shashi_120
Oct 4, 2007 3:49 am
Go to Enterprise Manager and expand your database then expand your Security and change your password for sa. Thanks! ... -- Shashi Kumar Singh Systems...
5764
hisatya
Oct 4, 2007 4:51 am
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...
5765
Bineesh Thomas(GMAIL)
bineeshthomas
Oct 4, 2007 5:22 am
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...
5766
prema tiwari
mailprematiwari
Oct 4, 2007 6:02 am
Try using type conversion task and convert the datatypes appropriately. "Bineesh Thomas(GMAIL)" <bineeshthomas@...> wrote: Are you sure that your...
5767
ram babu
singh_rambabu
Oct 4, 2007 8:26 am
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...
5768
bhavesh prajapati
bhavesh2984g...
Oct 4, 2007 2:02 pm
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...
5769
s manikanth
s_manikanth
Oct 4, 2007 3:08 pm
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...
5770
kishore
kvkishore79
Oct 4, 2007 3:19 pm
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...
5771
kishore
kvkishore79
Oct 4, 2007 3:26 pm
Hi, If the downtime window is more and number of transactional replication publications are more then due to heavy transactions on active active publisher...
5772
koushik roy
koushikroy_2001
Oct 5, 2007 10:16 am
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...
5773
mohd rizwan
mo2riz
Oct 7, 2007 8:50 am
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...
5774
Veer Ji Wangoo
vwangoo
Oct 10, 2007 3:58 am
Error! Filename not specified. <http://go.microsoft.com/?linkid=7539309> Webcast Schedule - October 2007 Attend a series of LIVE Webcasts this October by...
5775
mohd rizwan
mo2riz
Oct 10, 2007 7:20 am
Hi All, I have a query of bulk insert... ... SELECT IB_PROJECT_MAP.Region2, IB_SPARES_ITEMS.ITEM_NUMBER, IB_PROJECT_MAP.bucket_id, ...
5776
nitin kumar
tanu_22781
Oct 10, 2007 3:13 pm
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...
5777
nitin kumar
tanu_22781
Oct 10, 2007 3:16 pm
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...
5778
vardhan_shashi
Oct 11, 2007 9:52 am
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...
5779
Kuldeep Chauhan
mrkuldeepcha...
Oct 11, 2007 2:38 pm
FYI: Plan to attend these webcasts by Microsoft SQL experts....! Webcast Schedule - October 2007 Attend a series of LIVE Webcasts this October by Microsoft...
5780
hisatya
Oct 12, 2007 1:25 am
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...
5781
vijayasekar shanmugha...
vjsekars
Oct 12, 2007 9:33 am
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...