Viewing 15 posts - 1,156 through 1,170 (of 1,179 total)
Microsoft has introduced DDL Trigger in SQL Server 2005. You can use DDL Trigger to fulfill your requirement.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 21, 2008 at 2:59 am
I guess there are no setting from SQL Server side. You need to configure the threshold in the 3rd party monitoring tool. Also you have not mention which monitoring tool...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 18, 2008 at 5:32 am
This topic is really v.good and debatable and having lots of variety of answers 🙂
Depend on your interest you do have 3 options.
1. Pure Technical
2. Pure Managerial
3. Techno-Managerial
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 14, 2008 at 10:21 pm
Check following link:
http://msdn2.microsoft.com/en-us/library/ms174269.aspx
--USE THIS TO CHANGE DATABASE COLLATION
http://msdn2.microsoft.com/en-us/library/aa197950(SQL.80).aspx
--USE THIS TO CHANGE INSTANCE COLLATION
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 14, 2008 at 5:25 am
Check following link:
http://msdn2.microsoft.com/en-us/library/ms189794.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 14, 2008 at 5:13 am
As data on Production and Test enviroment is different. You need to reconfigure replication after the restore. If you are sure that there are no change in database design. You...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 14, 2008 at 3:35 am
You would like to map AD login i.e. you would like to use window login alongwith sql server login. The only option for this is use Mix mode security.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 14, 2008 at 1:21 am
Thank you Minaz for your quick reply.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 14, 2008 at 1:06 am
Pl. refer the following microsoft link:
http://support.microsoft.com/kb/307487
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 13, 2008 at 11:08 pm
For some of your monitoring you can set SQL Mail to send you alert in jobs and for others you can find the SQL scripts to monitor it. Search in...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 10, 2008 at 9:41 pm
Have you recorded the growth of the database anywhere? If no you won't get it except check the size of the database backup on Jan 07 and Dec 07 and...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 10, 2008 at 5:01 am
This is happening because you do not have stored procedure sp_msForEachTable in your database nav_sepia to check this execute following query to your database nav_sepia.
select * from sysobjects where name...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 10, 2008 at 4:56 am
Refer following link of SQL Server Central.
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31929/
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 10, 2008 at 4:14 am
In addition to this if you would like to keep your Tlog size smaller i.e less than 2 gb than while doing DTS and transfering the data commit your transaction...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 10, 2008 at 2:21 am
Hello Raymond,
Here is the simple command which will give you desired result.
xp_fixeddrives
Hope this is what are you looking for.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 9, 2008 at 11:27 pm
Viewing 15 posts - 1,156 through 1,170 (of 1,179 total)