Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Udayk100
-
move and upgrade SQL server 7.0 to 2K
Are you gonna have a new sql server machine.. If so..May be you can backup and restore on the new 200 machine... The minutes you apply the last transaction log will be the time users will be down... Are there users 24 hours...- Udayk100
- Post #2
- Forum: Microsoft SQL Server: Programming
-
SIMPLE SQL QUERY'S TIMING OUT
If its a select....try with (nolock) hint... Look at the execution plan on the sql server 7.0.. That might help you... May be drop and recreate y'r non clustered index...- Udayk100
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Replication Issues
exec mater..sp_replicationdboption @dbname = <database name>, @optname = 'Publish', @value = 'false' replcae = <database name> with the dbname of the one with the shared hands... This will remove the shared hand from the dbname.... which version of SQL server are we talking about here...- Udayk100
- Post #2
- Forum: Microsoft SQL Server: Programming
-
xp_sendmail
I have a quesry which uses linked server calls to another server forretrive information, and send it as an attachment to recepients using xp_sendmail. After service pack 3, the query doesn't send the info to recepients anymore. The error says something like"the setuse doesn't have access...- Udayk100
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
