Viewing 10 posts - 46 through 56 (of 56 total)
ghanshyam.kundu (10/5/2011)
hi folks,can anybody tell me about sql logging and how can i retrieved the deleted data from that.
You need to elaborate on your requirements. Do you mean point in...
October 5, 2011 at 10:01 pm
A table is a heap when data is unorganized. When you create a clustered index, it organizes the data based on a key (or keys). Non-clustered indexes are created outside...
October 5, 2011 at 10:09 am
We have mirroring with Clusters for some of our databases and it works fine.
may be you can have active/active cluster on both sites. One node will be for production...
October 5, 2011 at 10:04 am
If the package is scheduled to run through SQL Agent, then this will be executed under the security context of the service account used for SQL Agent.
October 4, 2011 at 10:56 am
this this link
http://msdn.microsoft.com/en-us/library/ms175941.aspx
What i wanted to say that you could create a DDL trigger so that whenever a user performs any structure/schema change, you can either prevent it or...
October 2, 2011 at 11:52 pm
Active/Active cluster is no different from active/passive.
It's just that in Active/active, one instance (say instance 1) runs on one node(say node a) and the other one (say instance 2) runs...
October 2, 2011 at 11:49 pm
waseem.shahzad 45937 (10/2/2011)
We are working in .Net and database in SQL Server. I want to...
October 2, 2011 at 11:36 pm
There has to be a mechanism to initiate both transactions at the same time. May be via a scheduled job. Even then no one can guarantee that both transactions will...
October 2, 2011 at 11:31 pm
you dont seem to have much options. Generally it's not the best ides to put database files on the drive used by OS. But in this scenario, you may keep...
October 2, 2011 at 11:15 pm
May be you can elaborate more on your requirements?
the simplest way is to execute queries in multiple query windows.
October 2, 2011 at 11:07 pm
Viewing 10 posts - 46 through 56 (of 56 total)