Hi All<br /> we have an Alert that monitor the tempdb size. if the tempdb is full, then it executes a job that takes some actions. we got several...
Hi All i am not good at SQL coding. could anyone help me to modify this query? i need it to return only the one recip_ID, prov_Num, lated...
Hi All i need to add two new columns to a table in our production database and make them part of primary key (need to build a composit key). could...
Hi All i want to import 30% of data from the database on current production server to database on development server. could anyone tell me how to...
Hi Guru what the "DRI" means in permission of database role? there are SELECT, INSERT, DELETE, UPDATE, EXEC, DRI" permission. what situation we need...
Hi Guru i have a question: why i can't tell if the SQL Server Agent is running or not under management on some servers on my client desktop EM? we...
Hi All i want to know when the node name of SQL Server clustering is created? especially for active/active cluster? there are two node names on the...
Hi All we have a lot of DTS packages in our production SQL server. some use windows authentication to connect to the server. i'm thinking if the...
Hi All could anyone give me some ideas regarding how to install active/active sql server clustering? i need a step-by-step doc for it. what is the...
Hi All if anyone knows how to get the DTS package information, like connection string, password etc, without opening the DTS package in Design...
Hi All i ran the sp_spaceused against one of our database. the following is the output. is there any defragmentation on DB? database size:...
Hi Guru i want to know if we can restore all backup devices created on the production server when we restore all database on our test box from...
Hi Guru i need to know which login need to be restored after i refresh the database on the test box from backup on the production box. we have...
Hi i need to restore the production DB on our test server--both are clustered. someone just installed the clustered server for testing . i'm new...
Hi All we got the this error message when we tried to manually uninstall the sql server 2000 on clustered "The log file 'c:program filesmicrosoft...
Hi All if anyone knows how to use net send to send a message to DBA if an alert fired? for example: hardware fails with severity level 24. we want...
Hi All if anyone knows what is wrong with this syntax: i im in domain abcd computer name long-1 login id is newlong i tried to send out the...
Hi Guru i need to do some ODBC Encryption SQL Server work. what it means? Long
Separate names with a comma.
