Viewing 15 posts - 6,901 through 6,915 (of 9,241 total)
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:20 pm
Link here 😉
😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:17 pm
This should get you started
SET NOCOUNT ON
--Check if the temp table exists, if it does cleanup!
IF (object_id('tempdb..#sysdbs')) IS NOT NULL
BEGIN
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:10 pm
perfectly ok for the 2 to co exist
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 2:01 pm
SQL7 databases may be directly attached\restored to SQL Server 2005 with no step between. When upgrading to SQL Server 2008 you would need to go through either SQL Server 2000...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 1:48 pm
logicinside22 (7/14/2011)
created clusterdc , node1,node2 virtual machine names on VMware.
Allocated 15GB hard drive...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 1:41 pm
If mirroring in a workgroup use this article to help you set it up
http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 1:27 pm
You asked
yoffes (7/14/2011)
What are the least set of permissions that will allow this?
Granting at the table object level is least permission, granting at schema is greater scope!
This looks neater
yoffes (7/14/2011)
GRANT...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 1:15 pm
validate and cleanse the column data in the source table
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 12:51 pm
Grant select, insert, update, delete on object::dbo.test2 to testrole
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 11:01 am
to configure mirroring for a workgroup see the following blog post
http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 6:54 am
GilaMonster (7/13/2011)
Honestly, I'd be taking backups and mirroring the backups.
I'm with Gail here, I think this would be the best solution
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 3:56 am
subbkarth (7/14/2011)
suddenly i'm getting this error:
Here is the error
Executing the query "ALTER INDEX [work_package_calendar_work_package_IDX] ON...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 3:52 am
GilaMonster (7/14/2011)
so no point in time recovery until, you take another full backup.
or a differential 😉
If the 2 hourly backups are not managing the log sufficiently increase it to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 3:48 am
not something i have ever seen before, the databases will synchronise when they both restart.
Build yourself a couple of virtual machines and try it 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2011 at 3:08 am
Viewing 15 posts - 6,901 through 6,915 (of 9,241 total)