Viewing 15 posts - 8,161 through 8,175 (of 9,253 total)
Ratheesh.K.Nair (3/24/2010)
Hi Experts,Is it possible to take a table level backup?
TIA
Hi
if you want just data and structure then use the following for a quick and dirty
select * into newtable from...
March 24, 2010 at 11:44 am
if you run the root SETUP.exe it will detect your architecture and launch the appropriate installer. You can also see the architecture by clicking options on the left menu in...
March 24, 2010 at 11:37 am
is this a windows 2003 or windows 2008 cluster?
March 22, 2010 at 3:06 pm
Jeff Moden (3/22/2010)
It's a real shame that we have to try to rewrite that which works so well...[font="Arial Black"]Dir c:\*.* /s /b[/font]
Good old DOS Jeff, you can't beat it can...
March 22, 2010 at 11:56 am
Scott Wise (3/22/2010)
Perry,I really appreciate the follow up. Isn't what you are saying to do just creating a new cluster?
No, it is creating a new clustered instance 😉
there is...
March 22, 2010 at 10:40 am
newbie2sql (3/19/2010)
Solution you had given me is correct for my solution. Currently I am checking the permissions and...
March 20, 2010 at 4:19 am
yes, that goes without saying!
March 20, 2010 at 4:16 am
OK, i made this real easy. The screenshots below shows the registry entries created when installing SQL Server and the instance configuration in the installer. Notice the default instance (MSSQLSERVER)...
March 19, 2010 at 6:45 pm
i dont see whats wrong with my script?? :ermm:
March 19, 2010 at 6:31 pm
As Gail says "no commit, no dice" 😉
it's also worth noting if the database is in simple or bulk-logged recovery the create\alter index is not fully logged!
March 19, 2010 at 6:27 pm
GTR (3/18/2010)
Perry, are sure that will work on cluster?Scott, i think if you need two instances on cluster then you should go for Active\Active clustering with two named instances.
you...
March 19, 2010 at 7:18 am
try this
--uncomment the where clause and specify a database user
--to get permissions for a single account
USE yourdbhere
SELECT
'Permission "' + CONVERT(NVARCHAR(10), permission_name) COLLATE Latin1_General_CI_AS + '" "' +
case CONVERT(NVARCHAR(10),...
March 18, 2010 at 4:24 pm
the index which is being rebuilt is stored in a temporary area and brought in when the rebuild has finished to replace the existing index. An outage shouldnt really have...
March 18, 2010 at 4:07 pm
Scott Wise (3/4/2010)
March 18, 2010 at 3:44 pm
totally agree Thor.
the revoke thing is a little ambiguous i agree. I understand it as
if you take the user account out of the ACL you have neither allowed or...
February 8, 2010 at 10:35 am
Viewing 15 posts - 8,161 through 8,175 (of 9,253 total)