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...
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...
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.