In our company we have cluster Sql server 2000 with SP3, if we want to upgrade to SQL server 2005 should i first install with sql2000 SP4 or not...
<br />Where can i found a full documents for <img src='/community/emoticons/emotion-7.gif' alt=':s' />teps required to install cluster sql server...
when i double click nothing come, when i try to run the msseach.exe with RUN AS this error appear : This application has failed to start because...
Thanks Satya I checked the documents it is not include how to installed the FULL-TEXTSEARH with a server SQL SERVER INSTALLED already on it?? i tried...
I installed SQL Server 2000 without installing Full-Text Search. Now I want to add Full-Text Search IN ONE DATABASE OF THE SERVER WHICH HAS 20...
if i want to update the data in the column include in the partion is these will cause expensive operation?? example: if i define the partion create...
Thanks MohammedU but i tried these one u send it , it was not working, did u try it ? the error appear with this code : sql ="SELECT name FROM...
HI How do I export MS SQL SERVER database TO MS Access database??????
Greetings the SQL Server data and log files on same physical drive ,how can i move the log files to another physical drive there is any script will...
Hi , How can i prohibit Non-administrators can log on locally on database servers in other words how can i check Non-administrators how log in...
HI, If i have cluser server and The nodes that belong to this Cluster node (hardware/firmware )does not match . how can i check Cluster Node...
Hi, if the transaction log file every day when i monitored i saw that it is almost full , what should i check? there is any roles should i depend on...
Thanks Mohd, Please did anybody has chapter from this book as pdf , or any alternative way
Hi . If i have application and i got the the following details about the database from the copmany : The database schema along with each column size...
Hi, how can i define DTS using "Microsoft OLE DB Provider for SQL Server" to bring data from server on diffrent(another) domain :example DTS...
HI inhttp://www.sql-server-performance.com/nn_monitor_with_dts_06.asp#a2 the batch file name : Db_space_monitor.Bat from where should run ? i...
hi bslashw, i tried your script and this error message appear to me: Server: Msg 8134, Level 16, State 1, Line 28 Divide by zero error encountered....
Thanks Chappy,<br /><br />I modified the script as you told me:<br /><br /><font color="red">set nocount on <br />use dbamaint<br /><br /> <br...
Hi ,<br />How can i send the result of this sql statement through e-mail sould i put this statment in the job?? or there is other way??<br /><br />...
I seraech about the same throght Satya's wrote but i could't find the same article ? i want to be know excatly what should i monitor every day,week...
Separate names with a comma.
