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...
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...
HI How do I export MS SQL SERVER database TO MS Access database??????
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...
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, 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...
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 ,<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 used : Monitor Your Database Servers with DTS, Part 3: Space Monitoring of SQL Servers i have 2 qustions : 1- log file from where can i reun it?...
Hi, To track the file gorwth in SQL SERVER, I found the script in this site: http://vyaskn.tripod.com/track_sql_database_file_growth.htm now i want...
Greetings, there is any recommendation or best practice regarding “DBA Daily, Weekly and Monthly Roles “, If you have like this document with...
Greetings, there is any recommendation or best practice include all DBCC commands should be used in “DBA Daily, Weekly and Monthly tasks “, If...
I have a large database with more than 100 users , how can i know by one command for each login excatly his details privilege? I am looking in the...
there is any command or procedure to get the privilege for each user in the sql server i want the details privileges (database owner, server role)per...
there is any command or procedure to get the privilege for each user in the sql server, i want the details privileges (database owner, server role)
Separate names with a comma.
