Search results for query: *

also you can check from the command prompt by typing isql -v

Hi all, I need help inorder to find out the maximum number of connections to particular database under a sybase instance is this value saved some where as for auditing reason we have to find out how many users access the particular database in one month or any time duration. we are running...

Hi I fighting with a strange problem with a DTS package, we had a DTS package under a name of user who left the company and his account was deactivated, i openned that DTS package and saved it under my name and my user is part of sysadmin role, when i am trying to execute the DTS i gets the...

Hi I fighting with a strange problem with a DTS package, we had a DTS package under a name of user who left the company and his account was deactivated, i openned that DTS package and saved it under my name and my user is part of sysadmin role, when i am trying to execute the DTS i gets the...

Thanks Mutley for your reply, i have checked both data and transaction logs are set to auto grow so i dont think it is problem also the same job some time runs fine and some time gives the above error message and fails. i tried but didnt found any clue so far, any help in this regards is...

Hi, I tried to manually start a job from Enterprise Manager and got ' Error 22022: Unable to post notification to SQL ServerAgent (reason: MapViewOfFile() returned error 8, 'Not enough storage is available to process this command') This happens quite often. Every time I have to re-start the...

Thanks for you prompt reply, i am wondering is there any known problems associated with the sp4 upgrade because so far all the databases on sql server with sp3 are running fine as it is going out of support so i have to upgrade it to current version but you know some issues/problem associated...

Hi i am trying to upgrade the service pack sp3 to sp4 on my sql server 2000 database and i have downloaded the sp4 files from microsoft which are as follows SQL2000-KB884525-SP4-x86-ENU.EXE SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE SQL2000.AS-KB884525-SP4-x86-ENU.EXE i stoped the SQL services and...

Thanks George for your help, actually i am bit hesitant at this stage to run this script as the database is in production and also i dont understand one thing still if the user owns the database and when u are accessing the database why u need to specify the schema/username with the table name...

Thanks bill for your quick reply, to answere your question does "abc" own the database , yes thats true user "abc" owns the database as well as the particular table to which i am running a select statement the query returns the results when ever i user the username.tablename together it gives...

Hi All I want to know how to remove the schema username from a table name while using that table in a query for example currently i am logged in with username abc in sql server 2000 when i select a table in database test123 i have to attach the username with table name i.e abc.table name in...

I need help as yesterday i created a new dts package which is a copy of old DTS package because it was under some other users name so i saved it under mine there is was job associated with this DTS package and now it is failing and giving following error messeges DTSRun: Loading... DTSRun...

I need help as yesterday i created a new dts package which is a copy of old DTS package because it was under some other users name so i saved it under mine there is was job associated with this DTS package and now it is failing and giving following error messeges DTSRun: Loading... DTSRun...

Thanks Geroge it worked i just ignore the database creation portion of the script and the rest of the portion created the scripts fine on the production box thanks alot for ur help K

when i ran the copied script on the production database it tried to drop the existing database and tried to create a new one, i just want to copy the user define fuctions from test box to production never did it before so thats why need help from you guys, george if u are online please guide me...

Thank you so much George, i copied the script should i paste it in the query Analyzer on the production box and execute it? in that way they will be copied to new box ? thanks for ur quick response Khalid

I need help as i want to move user define function from one SQL server 2000 (test box) to another (production) box any help will be highly appreciated Thanks Khalid