Viewing 15 posts - 7,936 through 7,950 (of 9,244 total)
your welcome!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 9:01 am
hamidi 97216 (5/21/2010)
is this what u mean?:
No
you may also want to check my tutorial for installing SQL Server 2008 in a clustered configuration at this
link, it may help quite...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 7:42 am
saimonkhan15 (5/21/2010)
I have always thought this was a bit strange, since truncate is so much
faster. You can grant...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 7:39 am
Alex Webber (5/21/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 7:32 am
before removing any files check their contents. Can you post the results of the following queries?
USE yourdb
select name from sys.filegroups
USE yourdb
select a.name as 'Index name', b.name as 'Filegroup',
c.name as 'Table...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 2:05 am
check this link for more info
the following info is relevant
A log backup is required to move the head of the log forward (full or bulk-logged recovery models only).
Note:
Log backups...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 1:49 am
shew (5/20/2010)
We are running Microsoft Failover Clustering on Windows Server 2008 R1 with SQL Server 2008 R1. We have one named instance installed and need to add a second...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 1:29 am
In most cases Standard edition is suitable for what most people require. Unless you plan to have multi node clusters, require IA64 support, get heavily into partitioning, require compression and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 1:14 am
TRUNCATE requires ALTER permission on the table which you will also need for adding the constraint. You will probably also require ALTER on the schema too!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 1:08 am
no its nothing like Office. Pick your self up a copy of the SQL Server 2008 training kit you can get it reasonably priced from Amazon, this is your best...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 21, 2010 at 12:53 am
hamidi 97216 (5/11/2010)
since i didn't know which ones to select, i selected all of the features.
OK this slightly worries me. How can you expect a stable installation if you do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2010 at 10:03 am
Franco
transferring logins to SQL Server 2008 uses the same script that you have for 7\2000 to 2005
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 20, 2010 at 6:11 am
Scott Hedrick-378512 (5/19/2010)
Perry, what don't you like about DPM backups of SQL Server? We are considering using it and would appreciate some real world feedback. Thanks.
Hi Scott
i didnt...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 19, 2010 at 11:06 am
Oracle_91 (5/17/2010)
Thanks Perry!Those are too good.:-)
Thank you, glad they are able to help you
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2010 at 10:30 am
hamidi 97216 (5/11/2010)
where is it located?
on the failure notification it gives you the log location?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 18, 2010 at 10:29 am
Viewing 15 posts - 7,936 through 7,950 (of 9,244 total)