Viewing 15 posts - 646 through 660 (of 1,069 total)
I would recommend writing CLR stored procedure instead of extended stored procedure.
August 31, 2010 at 11:51 pm
Can anyone please let me know that can we turn on and off the TDE fundtion in sql 2008 if we want to.
Yes. TDE can be turned on and...
August 30, 2010 at 11:18 pm
Rohit Chitre-274613 (8/17/2010)
I am not aware how to configure the port so that the server will listen to it.
You need to create TCP endpoints. TCP endpoints will have port...
August 17, 2010 at 5:11 am
August 15, 2010 at 10:47 pm
Stop the SQL Server 2005 related services and keep them disabled for a month or so.
Also preserve the backup of all the system and user databases of 2005 version.
August 13, 2010 at 3:21 am
(In India) There are actors above 40 years age who play the role of a college students in the movies.
There are cricket players above 40 years age in the national...
August 5, 2010 at 10:27 pm
sanketahir1985 (8/4/2010)
Where are they used?
You need to create a Credential firstly to create a Proxy (under SQL Server Agent).
August 5, 2010 at 4:56 am
Database snapshot always reside on the same server instance as the database.
Replication snapshot can be replicated to several different servers.
August 4, 2010 at 10:54 pm
handkot (8/4/2010)
Yes.DB Recovery model is Full, Sql Server 2000
in this case you have to make backup db and after backup log wtih TRUNCATE_ONLY options
I don't agree with this solution.
August 4, 2010 at 3:15 am
vamshi.sql (8/4/2010)
that is ok.i enabled auto shrink option,but why that is not happening once the log file is grown extremely..please let me know...
Is log backup happening regularly?
AutoShrink does not remove...
August 4, 2010 at 3:07 am
vamshi.sql (8/4/2010)
Yes.DB Recovery model is Full.Even Auto Srink option is also enabled.the database is in Sql Server 2000.
Disable Auto Shrink.
August 4, 2010 at 2:51 am
You should create a maintenance plan to take log backup regularly.
If log backup is not taken, log entries remain in the file and file grows continuously.
Hope this helps you.
August 4, 2010 at 2:47 am
Try this (quote from BOL):
SQL Server Integration Services includes the three fixed database-level roles, db_ssisadmin, db_ssisltduser, and db_ssisoperator, for controlling access to packages. Roles can be implemented only on packages...
August 2, 2010 at 5:35 am
manoj.ks (7/28/2010)
Once enabled, i tested row-versioning option. It didnt work for me.?
How did you test it?
July 30, 2010 at 4:27 am
Viewing 15 posts - 646 through 660 (of 1,069 total)