Viewing 15 posts - 5,476 through 5,490 (of 9,253 total)
freecoder (6/12/2012)
I want a script to copy the data from abcd to efg table. As you can see Fid is and identity column.
If you want to capture all data...
June 12, 2012 at 3:34 am
SQLSACT (6/11/2012)
We have 3 Clustered servers namely: Server1, Server2 & Server3
Are all servers in the same domain?
June 11, 2012 at 1:03 pm
Each computername must be unique within the domain. Why is changing the node name so important?
What you're asking involves destroying the current server1 and removing server2 from the cluster. Bit...
June 11, 2012 at 12:58 am
Doing it the way you did has produced errors as you can see.
You now need to reinstall all clustered apps.
Best thing is to revert back to the original name...
June 10, 2012 at 2:52 pm
Thomas Stringer (6/10/2012)
Is that port (5024) blocked?
On the same server, no.
But it could be in use by either the principal or mirror instance.
June 10, 2012 at 2:49 pm
Jai-SQL DBA (6/10/2012)
Gila lets take a Scenerio :There are 3 file groups for My db
Primary
Secondary
Log
are all talking scenario here or the actual configuration of your database?
As Gail...
June 10, 2012 at 9:16 am
can you provide a little more detail on your setup?
June 10, 2012 at 9:14 am
to change the actual node name uninstall any clustered instances from that node then remove the node from the cluster.
Rename and reboot and then re join to the cluster, then...
June 10, 2012 at 8:59 am
great, you can also slipstream during setup, see my tutorial at this link[/url] for info on how to do this
June 7, 2012 at 6:47 am
cfradenburg (6/7/2012)
-- Clear Wait Stats
-- DBCC...
June 7, 2012 at 6:05 am
Jpotucek (6/7/2012)
Sharepoint really should be in it's own Named Instance and I have another application that requires it's own instance because of a special SQL Server collation that it requires.
That's...
June 7, 2012 at 4:44 am
Hi
Run the following against your secondary database and check the column value for "restore_mode".
exec sp_help_log_shipping_secondary_database
@secondary_database = 'secondary_database_name'
To change the secondary database config use
EXEC master.dbo.sp_change_log_shipping_secondary_database
@secondary_database = 'secondary_database_name'
,...
June 6, 2012 at 5:51 pm
Yes, SQL 2000 doesn't support mount points anyway so that's fine. You'll need to use xp_fixeddrives to get the free space and disk name
June 6, 2012 at 3:52 pm
Viewing 15 posts - 5,476 through 5,490 (of 9,253 total)