Viewing 15 posts - 3,061 through 3,075 (of 9,241 total)
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
You're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 13, 2014 at 12:31 am
I wouldn't recommend running SQL Server 2005 on Windows 2008 either, it's frought with issues :w00t:
If you really want to though this is what i'd do (and assuming the hardware...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2014 at 9:25 am
vsamantha35 (8/12/2014)
Since I don't have a testing environment, I am seeking help on this.
In a 2-node SQL Cluster, if Node-1 is on SQL 2008 SP3 and Node-2 is running on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2014 at 6:22 am
Viewing 15 posts - 3,061 through 3,075 (of 9,241 total)