Viewing 15 posts - 3,061 through 3,075 (of 9,244 total)
can you provide a little more detail on your setup, did you get any other erros during the earlier steps of the wizard.
What account type are you using for the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 6:25 am
It's all detailed in Books Online. Basically, the below query is aliasing a source table for the deletes and is designed to avoid a subquery.
DELETE FROM dbo.DutyRosterShift
FROM dbo.DutyRosterShift...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 6:23 am
Instead of rebuilding the clustered index, I would create the clustered index with DROP_EXISTING = ON
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 4:49 am
Can you post results of this query please
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
GO
SELECTs.name
, OBJECT_NAME(o.object_id)AS TableName
, ISNULL(i.name, 'HEAP')AS IndexName
, i.index_idAS IndexID
, i.is_disabledAS IsDisabled
, CASE
WHEN i.data_space_id > 65600 THEN ps.name
ELSE f.name
ENDAS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 4:28 am
Lempster (8/15/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2014 at 4:05 am
Mr. Kapsicum (8/14/2014)
Anyone with the Answer.?
Patience is a virtue my friend, as well as an opera 😉
This very same topic is covered here
To explain briefly
The WITH CHECK or NOCHECK applies...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2014 at 3:21 am
greg 69516 (8/13/2014)
I would've thought that manager would come with original package.
It does, SQL Server Express with Advanced Services 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2014 at 2:36 am
naresh.talla (8/13/2014)
I want to downgrade SQL server 2008 enterprise edition to SQL server 2008 r2 standard edition, it will allow to work ? can you please help me on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2014 at 2:33 am
SQLRNNR (8/13/2014)
I think you mean the OP created the user as FredBloggs.
yes, sorry my bad.
In the end it's just a database user and doesn't really matter what it's called....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2014 at 12:15 pm
The Microsoft recommendation removes any unpatched nodes from the possible owners of the VNN resource to prevent a failover causing a downgrade.
In most scenarios not all nodes are patched in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2014 at 12:07 pm
Steve Jones - SSC Editor (8/13/2014)
Don't automatically fix this. Catch...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2014 at 12:01 pm
The use database is required for the creation of the DEK, the ALTER DATABASE ... SET ENCRYPTION ON is not a database specific command, in fact focus should probably be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2014 at 10:21 am
SQLRNNR (8/13/2014)
It sounds to me like you created database users as loginless accounts when you created the database users.
No, the vendor has simply create the database user as FredBloggs instead...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2014 at 9:48 am
its only a database user name, if you really wanty to enforce your standard then just inform the vendor
Rename a user with the following
alter user dbusername with name = [newdbusername]...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2014 at 9:22 am
at 4 or 8 GB increments your going to experience excessive waits while the log grows.
What size does the log need to be?
Find this out and then leave it there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2014 at 6:58 am
Viewing 15 posts - 3,061 through 3,075 (of 9,244 total)