Recent content by Hpatel

There are about 350 stored procedures that need to be changed and there are some Stored procedures are as long as 1000 lines. Your suggestion works but it would require each stored procedure to be touched and modified. Also, the amount of time it will take to change. I appreciate your help...

If you defined a variable as decimal and assigned it a value of 12.5 and you attempted to compare this value to an integer column, SQL Server converted the decimal variable to integer (essentially truncating the number to 12) before carrying out the operation. This no longer is the case in SQL...

Hi, I need to find out size of all the used defined stored procedures in the database. If this information is stored in a system table that would be great. Thank you for your help. Hpatel

I need to get information on All the user Logged in the SQL Server and what time they gotin in specific Time period. EX: Login info fot All the user from 8 AM to 1 PM that login to SQL SERVER. Need this ASAP. ANY help would be appreciated. THX,

Hi, I need help with what does this following script do. I am not familiar with scripts. I am trying to decide if i need this script that someone else wrote. If you can figure it out please let me know. Here is the script: Down Up "s" Esc Menu {Scripts} Esc Esc Esc {Tools}...

Hi, i used to use ADODC to look at the data from ACCESS database table. Now that table has been moved to SQL SERVER 2000. I dont know how to LOOK at the data from SQL SERVER. Any HELP would be appreciated. Thank you, HPATEL

Thanks Joe, I am going to try this out and see where we go from here? Thanks, HPATEL

Hi Joe, What does deleting the Pdoxusrs.net file does? Also, i am not familiar with the TUtility that does data corruption check? Is these a program? and where can i find it? -I am going to provide you with the info that you asked for. *PARADOX 4.5 on NOVELL *Users accesing the tables using...

Users cannot log out of the database and after that if new user logs in, they cannot get out. Only way they can log out is if they reboot the system. Thanks, HPATEL

HI, Do you have any knowledge of the problem with PARADOX DATABASE Trapping users that are loged into the database? Thank you, HPatel

Hi, I am not experienced to PARADOX. Is there any schedule maintainance needed for PARADOX 4.5 Database? If it does, is there a script? Any help would be appreciated. Thank you, Hpatel

need help with finding more information reguarding real-time replication. Also, need to get detailed infromation reguarding pros and cons about multiple vs. onetime load replication. Thank you for you help. HPATEL

Thank you guys for you help. I am going to try this out.

I am having trouble finding where did the error occured in the prodecure. I modifying a previously written procedure which inserts and updates. But if there is error at insert block it make @@error=1 and if there is no error then @@error=0. Now in the next block of the code, if there is error...

I need help with finding what different drives as in different SERVERs. I am currently working with eight servers and i need to find out their different drives. I have code for fileSystemObject but it gives me information for my Computer drives. I am posting the code below and see if you can...