Search results for query: *

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

I need to find different drives and information in remote/Network Computer. I am working with Eight SERVERs and i need to findout their drives and also FreeSpace in those Drives. Thanks.

ToddR, thanks for your help. FileSystemObject did the job thanks again

Alt255, thanks for your help. filesystem object did the job. Thanks again.

I have code that will find the FreeSpace of a drive but i need help with modification of this code to fet the TOTALSPACE of the drive. Here is the Code: Private Type ULong ' Unsigned Long Byte1 As Byte Byte2 As Byte Byte3 As Byte Byte4 As Byte End Type Private Type LargeInt...

I have code to find FreeSpace of a drive but i need to modify it and get the TotalSpace of the drive. I need help with modification. Here is the code for FreeSpace: '************************************** 'Windows API/Global Declarations for :Ge ' tDiskFreeSpaceEx...