which option "locate the Distributor on a non-clustered SQL Server" or "locate the Distributor on a clustered SQL Server' affect the performance...
yes. i checked the Demo alert. it doesn't work. that is why we set up another one and want to see if non-demo alert works.
here is the script of alert: IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'ALERT_DB_TEMPDB')) ---- Delete the alert with the same...
data files and tran_log files are set up "automatically grow by 10%; maximum file size is unrestricted file growth". the error message we got "The...
SQLAgent is running. how to check the limit alert of tempdb? please advise. actually i did troubleshooting follow the BOL. it didn't work.
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...
it works. i got what i needed. thank you very much.
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...
yes. we have primary key(one col) in current table. can i do that? 1. alter table to drop PK 2. add two cols. 3. import data into new cols because...
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...
30% data of all tables.
does it means that i have to work on one by one table? i wish i could import 30% data of whole database in one step. anyone has any script to do it?...
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...
but i couldn't see the arrow sign that means the SQL Agent running on some servers which are not in clustering. does the service account affect it?
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...
thanks, Haywood yes, i'm still confused with how the second node on active/active cluster comes from. i did active/passive clustering. it's exactly...
thanks for your reply. i know the name for node 1. how about the second node? it should be machine_namesecond-instance_name on active/active...
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...
thank you, All actually the following is the answer i'm looking for: How are Windows NT-authenticated Connections Made? Sometimes a DTS package...
Separate names with a comma.
