Search results for query: *

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...

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...

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...

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...

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

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

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)

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...

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

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

Sorry i got the SQL version 7 sp4 wakey wakey Rishi

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)

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?

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

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

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...

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)

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)

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...

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)...