Viewing 15 posts - 4,171 through 4,185 (of 9,244 total)
You could also use
SELECT *
FROM sys.objects
WHERE is_ms_shipped<>1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2013 at 8:05 am
vishalsurya50 (4/19/2013)
In sql server 2012 creating a cluster , i had added servers and the next step is Access point for administering the cluster which i need to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 20, 2013 at 7:48 am
Have you checked the maintenance plan history?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2013 at 10:09 am
prettsons (3/26/2013)
Simple recovery model allows restore database only up to the last full backup
Up to the last differential backup actually, as long as you're taking diff backups of course 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 19, 2013 at 10:06 am
TheSQLGuru (4/18/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2013 at 8:45 am
The whole point of AlwaysOn is that you don't have shared storage. There's nothing to say that the disks cant be SAN based but they're not shared across the windows...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2013 at 6:56 am
gamit124 (3/28/2013)
hiwhen i am taking full backup and i am restoring full back up
i am getting error like "the database is not accessible"
please help me
regards,
gamit
Are you getting this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 18, 2013 at 12:15 am
Markus (4/17/2013)
Throwing hardware at an issue sometimes is just not the answer.
It's something you see time and time again and you're right it's a futile\costly exercise.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 11:19 am
dan-572483 (4/17/2013)
Does pausing the passive node you're installing on have the same effect and is an equally valid action?
This was only really necessary under Windows 2003 clusters. Windows\sql 2008 have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 7:47 am
the reason for removing the passive node as a possible owner on the networkname resource is to avoid the situation where you're patching the passive node and half way through...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 7:12 am
has the user been added as an explicit server login on the sql server.
What are the resultsd of the following query
select name, SID
from sys.server_principals
where type = 'U'
and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 7:08 am
uninstall the cu and reboot then try re applying
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 7:03 am
In that case you use CREATE INDEX specifying the new file group with the DROP_EXISTING = ON clause
See here for more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 12:16 am
No problem, don't forget to check the pre reqs and restrictions carefully, it can save you a whole lot of time later on.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 17, 2013 at 12:13 am
Google??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 16, 2013 at 10:44 pm
Viewing 15 posts - 4,171 through 4,185 (of 9,244 total)