Viewing 15 posts - 76 through 90 (of 114 total)
The first thing you should do is download and run the Microsoft SQL Server 2008 Upgrade Advisor. Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2000 and...
Sagar Sonawane
** Every DBA has his day!!:cool:
October 13, 2011 at 1:16 am
Sample script for Database mirroring
Video for Db Mirroring
Sagar Sonawane
** Every DBA has his day!!:cool:
October 13, 2011 at 1:09 am
You can use Database mirroring or Replication....
Sagar Sonawane
** Every DBA has his day!!:cool:
October 13, 2011 at 12:50 am
matt.newman (10/12/2011)
Sagar Sonawane
** Every DBA has his day!!:cool:
October 12, 2011 at 11:23 pm
By default the 32 bit Operating System (the Kernel) can only use up to 2 GB of Virtual address space (VAS) leave 2 GB of Virtual address space for...
Sagar Sonawane
** Every DBA has his day!!:cool:
October 12, 2011 at 9:37 pm
As I said there wasnt any problem with code itself.... the problem was at Linked Server Server Options...
Please find attachement....
Sagar Sonawane
** Every DBA has his day!!:cool:
October 12, 2011 at 9:32 pm
Perry Whittle (10/12/2011)
Saga... (10/12/2011)
Yes You will need 2 ip's (Heartbeat IP, Private IP) for each node & 1 Ip for SQL server.
Heartbeat and private are the same!
I assume you...
Sagar Sonawane
** Every DBA has his day!!:cool:
October 12, 2011 at 9:25 pm
I was using this code to list all Indexes from linked servers..... but IT shows only system defined indexes...
I am using SQL Server 2008 R2
IF EXISTS(SELECT * FROM
SYSOBJECTS WHERE...
Sagar Sonawane
** Every DBA has his day!!:cool:
October 12, 2011 at 1:10 am
You can use
select * from sys.syslogins
exec XP_logininfo
Sagar Sonawane
** Every DBA has his day!!:cool:
October 12, 2011 at 1:07 am
My perspective for using cursor is.... In one query it should give all indexes information for all linked servers.... hence i m not using Instance name....
Sagar Sonawane
** Every DBA has his day!!:cool:
October 12, 2011 at 12:57 am
Yes You will need 2 ip's (Heartbeat IP, Private IP) for each node & 1 Ip for SQL server.
Sagar Sonawane
** Every DBA has his day!!:cool:
October 12, 2011 at 12:47 am
first of all thank you for your reply....
I am creating an Inventory Application for all Linked servers... for that I have scripted rest all things like DB info, logins, Drive...
Sagar Sonawane
** Every DBA has his day!!:cool:
October 12, 2011 at 12:28 am
Is there any negative scoring for the wrong answers.... ???
Sagar Sonawane
** Every DBA has his day!!:cool:
September 14, 2011 at 4:10 am
Christi Wilson (8/25/2011)
Saga... (8/25/2011)
Christi Wilson (8/18/2011)
I was a database programmer for 6 years and due to illness I had to...
Sagar Sonawane
** Every DBA has his day!!:cool:
August 25, 2011 at 1:33 am
Christi Wilson (8/18/2011)
I was a database programmer for 6 years and due to illness I had to take about 6...
Sagar Sonawane
** Every DBA has his day!!:cool:
August 25, 2011 at 1:01 am
Viewing 15 posts - 76 through 90 (of 114 total)