Search the web
Sign In
New User? Sign Up
sqlcon
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

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

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help