trying to drop a trigger on a table, but it just hangs, for hours...where do I begin looking as the cause of this issue? entire database is less than 1gb, table is maybe 300mb (varies), I am not sure where to begin?
trying to drop a trigger, but it just hangs, for hours...where do I begin looking as the cause of this issue? entire database is less than a gig, table is maybe 300mb, I am not sure where to begin
I didn't realize that these other two procedures were affected the same way:
sp_OACreate
sp_OAMethod
both of which are required prior to following Exapmle 5:
SQL RESULTS
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_OACreate'. The...
Example 5 deals with the adding of the xp_cmdshell extended proc. This I have done, but now the sp_addextendedproc is missing, sp_addextendedproc is used to add the extended proc xp_cmdshell.
I was hit with some spyware/malware/trojans. one of these executed procedures on sql server 2000 sp4 that drop xp_cmdshell. i cleaned the servers, or so i thought, and also created a little job that would run every 5 mins to verify that xp_cmdshell still exists, recreate if not using...
I currently use the GPO on a Windows 2000 domain and I have configured the Client's Active Desktop settings to use a single wallpaper (.bmp file) located on another server for all client machines to use as their wallpaper. The downside is that the users that run XP get an Icon with a solid...
I will do that. I suppose MAS 500 locks the table while running a process and never released it, I am not sure, but I will be more than willing to do anything to trace the cause.
thanks.
by stopping and starting the service, everthing returned to normal, possibly something was allocated and wouldn't release...blah blah blah, I will look into why.
Thanks.
DBCC CHECKTABLE('timInvtBinList')
----------------------------------
DBCC results for 'timInvtBinList'.
There are 19216 rows in 84 pages for object 'timInvtBinList'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
----------------------------------
no...
There is approximately 19000 records, I know this by viewing the properties of the table. There is one Index.
I have not run checkdb on the database, should I do this as well as DBCC CHECKTABLE?
I have never used the checkdb before.
We run MAS 500, a table now times out whenever it is called upon. This is the only table in the entire database that does this. When I open the table to view it, I recieve an ODBC time-out error. We have been using the database for over a few years now without this problem.
Any ideas?
Thanks
yeah, thats one of my proposals that will never come through...CFO is tight ass, thinks i spend to much money. thanks for your help.
John
PS, sorry, i wont rate the post since it wasnt much :P
i have configured DHCP on my firewall and configured my first two DNSs as DNS on my network (domain controllers), then a third entry that is my ISP DNS. Seems to work ok, as it should.
it was a test, but just to save time so i didnt have to reformat. working on it today, it seems that it connected to my existing "live" domain due to an improper configuration; so i just added it to the domain tree if only to get rid of the head-ache, it runs an email server so i figured what...
I have a Windows 2000 Server that I had created a "test" domain on just so I could play around. I have now Demoted the server and Un-Installed AD from the server. However, it seems that some of the components are still running and fill up the event log with AD errors. I have listed a couple...
How to connect to a shared folder using different user accounts
As administrator, you may want to access to a administrative shared folder from a client computer. You can do this by using net use h: \\servername\c$ /user:domain/administrator.
i.e (maps h: to the unc path specified)
net use...
got it, either a windows update/auto-update or someone thinking they are funny removed the c$ share from the servers....should have been the first thing i checked, but what they hay.
Windows 2000 servers running Active Directory, PDC is DNS
*******************************************
If i try to browse "\\servername\sharename" it will actually connect to that share, however, i try "\\servername\c$" and it gives me an error "The network name cannot be found".
I can browse...
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.