Viewing 15 posts - 571 through 585 (of 643 total)
GilaMonster (12/5/2011)
Divine Flame (12/4/2011)
December 5, 2011 at 3:57 am
Dev (12/4/2011)
If you don't want the client to know about the tables & schemas names even, then possibly you can change the tables name to something generic like...
December 5, 2011 at 12:12 am
hitechimp (12/4/2011)
but cant we encrypt it the way we do it for data, thru certiificates and passwords?
For Backups I have...
December 4, 2011 at 10:03 pm
MasterDB (12/2/2011)
the wait_type and last_wait_type are BROKER_RECEIVE_WAITFOR
Then probably you need to adjust the DatabaseMail property 'Database Mail Executable Minimum Lifetime (seconds)" to some acceptable value as per your requirement.
Go through...
December 2, 2011 at 5:56 am
ruchikakkar2005 (12/2/2011)
I didn't getting ur point Please clearify ur Question
No problem, what I mean to say is:
1. Go to your client machine (the machine from where you are trying to...
December 2, 2011 at 4:01 am
Evil Kraig F (12/2/2011)
Divine Flame (12/2/2011)
Not able to view the plan attached. May be you need to attach it again.Sorry, had to comment. L, awesome avatar. 🙂
Thanks Kraig...
December 2, 2011 at 2:50 am
Dev (12/2/2011)
@ananda: Do you have any plans to upgrade your SS2K server anytime soon? I think you should consider it as well.
lol :-D, I think this is the...
December 2, 2011 at 2:12 am
ruchikakkar2005 (12/2/2011)
TCP Provider: No Connection could be made because the target machine...
December 2, 2011 at 2:08 am
Not able to view the plan attached. May be you need to attach it again.
December 2, 2011 at 1:55 am
Yes Log Shipping is possible between SQL Server 2000 (Primary) & SQL Server 2008 (Secondary). However, secondary server would be in "NoRecovery" mode only. If we use same versions for...
December 2, 2011 at 1:45 am
Log shipping was available in SQL Server 2000 whereas Mirroring was introduced in SQL Server 2005 only.
December 2, 2011 at 12:49 am
adlakha.22 (12/2/2011)
@flameI want to know how much time each procedure is taking to execute,
for this i have to make entry in .txt file, to track them..
You can track that also...
December 2, 2011 at 12:45 am
ananda.murugesan (12/1/2011)
Hi, i am going for high availability option not for report purpose,Mirroring option- It is not possible for configure for different version because primary database is SQL 2000.
Yes,...
December 2, 2011 at 12:31 am
adlakha.22 (12/1/2011)
I am executing a job in Sql server 2005,
which is executing 5 Stored Procedures together,
Is there is any way by which i can write any message/notification in log,after completing...
December 1, 2011 at 11:49 pm
ananda.murugesan (12/1/2011)
Dev (12/1/2011)
All published tables in transactional replication must contain a declared primary key.Considerations for Transactional Replication
http://msdn.microsoft.com/en-us/library/ms151254(v=SQL.100).aspx
Ok..All published tables in transactional replication must contain a declared primary key.
In...
December 1, 2011 at 11:38 pm
Viewing 15 posts - 571 through 585 (of 643 total)