Search results for query: *

Dear All, I was reading the SQL Online help and doing practical work also as written Restorign a database to a prior state title i did all the steps as per Online SQL Server books Online..but I Failed to achive the result Pl. look what i did I took the database backup and log file backup at 1...

Dear all, I hv table like this no name 1 aa 1 bb 1 cc 2 dd 2 ee 3 ff 3 gg Now I like to write query to get result in this way no name 1 aa,bb,cc...

I welcome the Suggestions given by Andrzejek and Golom . Both solutions are same ... It solves my purpose but I hv little problem in the First file Two fields are seprated either by tab (Andrzejek Case) or by space (Golom case) . it should not be like this i like to maintain the same length e.g...

Dear All I have SQL Server Database Table say Address. I like to Export this file into Text File through VB Coding i.e. User just enter the name of the text file to be created and press OK I know its very easy through SQL Servr using Import/Export Method.. But I Don't know how through VB...

I am unable to uninstall this from control panel beca's it was not properly installed . infact i have deleted. This was trend micro's PC Clean internet security ... But still problem is there.

My system was runnin perfectly then I installed Antivirus from trend Micro but that was not completely installed and when i restartd my system this became very very slow (almost hangs) takes 5-6 minutes for every action... then i ran my system in safe mode with nwtworking this is working very...

I had accidently updated table as update table set name='somevalue', phone='somevalue' So all the 700 records updated with this.. Can Anybody suggest how to get the previous data.(I have not taken backup for a long time) thanks Inder

Dear all, Can anybody tell me how to secure the VB appliation code. e.g. My computer has vb application code and I update it from time to time. My system's password is known to my fellows. So how can I secure my VB application code. I.S.

Dear All gurus I have WIN 2000 server and as many as 20 clients (With Win XP). All system r running fine except one. i am facing prb of ODBC Connection when i make connection with NT authentication it gives error Cannot generate SSPI Context. and connection fails all system are under...

Dear All, I have installed SQL Server 2000 on Win 2000 Server. Intially administrative password was blank. Now When I change the Administrator password of teh server then SQL doesn't runs. What is the solution? Pl. Suggest (One solution is to uninstall SQl and then keep password of admini...

Dear All I have Win 2000 Server and 10 clinets are attached with this . All clients have XP O.S. Can Anybody tell me how to give message to all clients from this Server machine. e.g. message : Pl. Close your programs Its time for backup Similarly How Can i give message to a particular...

Dear All Guru's of SQL Yesterday when I tried to take the backup of my SQL Database I saw suspect written in its name and there was no item in the database I tried to copy mydatabase.mdf file on another server but it was not recovered i also checked event log error there was long messgae like...

Dear All, Can Anybody help in solving this problem. I like to know how a user(Not Administrator)can take the SQL backup without seeing the SQL Server tables More clearly I have win 2000 server and SQL 2000 installed on it. Data is stored in SQL We have given Sa password to SQL Server.As I am...

Dear All, Can Anybody help is solving this problem. I like to know how a user(Not Administrator)can take the SQL backup without seeing the SQL Server tables More clearly I have win 2000 server and SQL 2000 installed on it. Data is stored in SQL We have given Sa password to SQL Server.As I am...

Dear ALL on logging to win server 2003 when i make new user and give password it asked message somthing like policy doesn't allow.. what is this.. so it doesb;t accpet password Simple fresh win 2003 installed. Pl. guide regards Inder

Dear All I have little prb . I have Win 2000 Server insttaled on the server and server has made as domain. I am logging as administrator now i hv created user a/c say "jam" but when i log on using this a/c system displays the messgae user policy doesn't allow you to log on interactively. (I...

i tried the same but actually access has DATE/TIME fields while through VB coding it goes DATE only that's why error comes.. error in record selection formula A date time s required here so please suggest..

Dear All Pl. help me on this ;; I had made data report but i was unable to put sr no. in the report..pl. suggest how to do that then i tried to make this report in Crystal report. Serial no probelm was solved but then problem came of filtering the records. i like to filter records based on...

Dear All. Can anybody tell me how to put serial numbers in the data report e.g.my output is name class aa 4 bb 6 cc 5 dd 10 ee 2 now myreport should be as Sr. nO. name class 1 aa 4 2 bb 6 3...

Please tell me how combo box be enabled to get desired item like if i press a then cursor will go to item starting from a if press an then cursor will move to items starting from an like and etc.. Pl. suggest.. regards Inder