Viewing 15 posts - 5,386 through 5,400 (of 9,241 total)
webrunner (7/2/2012)
From a security perspective, is it advised or discouraged for non-DBA users to have owner (db_owner or equivalent permissions) to some or all databases on a SQL Server?...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 11:50 am
i'm a dinosaur and prefer good old T-SQL 🙂
USE [SomeDB]
GO
SELECT 'The database owner is: ' + QUOTENAME(SUSER_SNAME(dp.sid))
FROM sys.database_principals dp
WHERE dp.name = 'dbo'
GO
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 11:45 am
failback is a windows cluster feature to enable a clustered resource (not just SQL Server) to move back to its preferred location after a failover has occurred. On resources such...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 11:30 am
only in 2008 set up onwards can you specify a userdb data, log and a backup directory.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 11:24 am
Codezilla-292868 (6/29/2012)
Named Pipes Provider: Could not open a connection to SQL Server
the job could not connect...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 11:05 am
anthony.green (7/2/2012)
Perry Whittle (7/2/2012)
anthony.green (7/2/2012)
add another file to the filegroup that way SQL will stripe the data across both files in an equal proportion
No, it won't, as the remaining files...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 10:46 am
looks like disk issues.
Which nodes does the instance come online on?
Have you checked that all required storage has been presented to all the nodes that are participating in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 8:37 am
surma.sql (7/2/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 8:32 am
anthony.green (7/2/2012)
add another file to the filegroup that way SQL will stripe the data across both files in an equal proportion
No, it won't, as the remaining files in the group...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 2, 2012 at 8:30 am
Mindy Hreczuck (6/25/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2012 at 2:33 am
To add further, the IP and port number must be a unique combination for the installed instances, the following would be valid
Instance1 ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2012 at 2:26 am
gantavasu (6/29/2012)
We are having 28gb ram in that after installing the sql server it is occupying 10 gb Ram.here i want to set this to 2gb.
Wow, what other application do...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 1, 2012 at 2:15 am
muthyala_51 (6/29/2012)
I am new to clustering.Do we need to create linked server on both the nodes ? and how about the jobs?
No, they are created at the instance level, when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2012 at 7:14 am
This all depends entirely on how you will present the storage to the servers. Is this a new cluster or adding a virtual to an existing cluster.
Which virtualisation platform are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2012 at 3:55 am
Codezilla-292868 (6/28/2012)
We have one instance instance 1 running on node A. And I have an instance 2 running on node B.
If you only have 2 nodes in the cluster this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 29, 2012 at 3:52 am
Viewing 15 posts - 5,386 through 5,400 (of 9,241 total)