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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Rishi146
  • Order by date
  1. Rishi146

    VB.net Component, Use in ASP

    I have been learning VB.net asp.net and C# by Learnkey training and Keystone also APP dev using VB6 Dll object to Vb.net or ASP.net is FIne as .net has an intermediate process that translates the code to IL when u reference the oject IM not 100% sure on this but i think you can not call .net...
  2. Rishi146

    sa login

    if you are getting error "trying to access the properties of my server." then register the server using NT LOGIn then do what i said Goto Enterprise manager Right click on YOUR SERVER Name --.goto properties You will see menu with 9 tabs Choose SECURITY MAKE SURE it says SQL SERVER AND...
  3. Rishi146

    sa login

    i think you are using Nt authentication when you installed SQL try this Goto Enterprise manager Right click on YOUR SERVER Name --.goto properties You will see menu with 9 tabs Choose SECURITY MAKE SURE it says SQL SERVER AND WINDOWS (option is checked) REstart the MSSQL service and try login...
  4. Rishi146

    Will VB.net do what I want?

    ps YOU DO NOT NEED Visual.STUDIO JUST VB.NET ALONE Will do VB.STUDIO just gives you a variety of languages to program in. If you want to learn j#, c#,visual C++, etc then buy the studio you'll need it. but if your only goal is to master vb.net and build robust quality apps vb.net will do...
  5. Rishi146

    Will VB.net do what I want?

    Yes you can do this in VB6 or VB.net not a prob if you need the code holler again scheduling is not a problem either a good resource is www.planet-source-code.com they have good examples there
  6. Rishi146

    MSDAORA error with oracle linked server

    If you have CS2 Working as linked server are you connecting using Micrososft OLE DB Provider For Oracle have you got Logins for oracle? READ THIS http://www.microsoft.com/sql/techinfo/tips/administration/addingoracle.asp
  7. Rishi146

    Database says Loading

    I have had this happen what should happen is the Grey datbase will say restore how long has this problem occured for. Rishi(MCSD,MSDBA,MCP)
  8. Rishi146

    Lost ability to connect after SP4

    OK lets break this down First you need to Check if that service pack You installed works correctly on NT 4.0 SP 6a Check microsoft site This error is either the network card(i dont think it is) BUT IT IS AN OPERATING SYSTEM PROBLEM. THE SERVER NAME is not Resolving by NAME A workaround is YOU...
  9. Rishi146

    Lost ability to connect after SP4

    From your Desktop can you ping the server by Name you didnt state that or does it time out
  10. Rishi146

    Lost ability to connect after SP4

    From your Desktop can you ping the server by Name you didnt state that
  11. Rishi146

    Lost ability to connect after SP4

    Sorry i got the SQL version 7 sp4 wakey wakey Rishi
  12. Rishi146

    Database says Loading

    What did you last do to it what version of SQL Have you takin the database offline? How big is or are the datbases Rishi(MCSD,MSDBA,MCP)
  13. Rishi146

    Lost ability to connect after SP4

    Yes restart the service and then RESTART the server is that Ok to do If its a Production server restart it later. What operating system are you using? what SQL version?
  14. Rishi146

    Lost ability to connect after SP4

    can you ping to the server by name and IP PS I AM OK LETS SOLVE THIS
  15. Rishi146

    Stored procedures runs well. But job does n't. why?

    I dont think you will able to do this without setting up a LINKED SERVER.This would be the easiest way to do this Rishi
  16. Rishi146

    Blocking Problems

    Are you running everything under one procedure If so Why is there any special need lke variables etc DOES it need to be under a single procedure(if you are using one) Personally i always split long,aggresive procedures up For now though you are right you will have to use optomistic locking or...
  17. Rishi146

    timeout errors

    This question is to do with ADO mostly and SQL 1.Check your code for CONNECTION OBJECTS, have you CLOSED the recordset are you using CURSORS in your code, if not by default its static i would change this to FORWARD ONLY and lock to optimistic try this this should help Rishi(MCSD,MCDBA,MCP)
  18. Rishi146

    point-in-time recovery good? bad?

    im not going to write an essay :) but i persoanlly get a business descsion around this as i personallyback the tranasctions ever 25 mins Rishi (MCSD,MCDBA,MCP)
  19. Rishi146

    Stored procedures runs well. But job does n't. why?

    how are you running it in a job please give more details is it in a DTS package or just a job if just a job 1.Make sure SQL server agent is running 2.MAke sure the Agent has right authentication if running accross domains 3.In the job if you click on it and goto the tab steps and open the...
  20. Rishi146

    Maintenance Plan Reporting Problem

    if i understand correctly when you say "to delete files older than 1 day" it ONLY deletes the database .BAK file each day ONLY in that directory Is it doing that? And you have reports but they are not deleteing if so where is the path (what im getting at are you using mapped drives)...

Part and Inventory Search

Back
Top