Viewing 15 posts - 9,121 through 9,135 (of 9,241 total)
hey, happy to help 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 1:06 pm
Jack Corbett (7/22/2008)
Perry Whittle (7/22/2008)
datareader only applies to user tables so should be safe
Sure, but it applies to ALL user tables in the database. Using the datareader role is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 12:26 pm
FreeHansje (7/22/2008)
Did not link the Client Config Tool with this problem as a solution.
Now to find how to restore my Admin privilege on my pc, which also seems to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 12:17 pm
are the file paths exactly the same on the new server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 12:15 pm
what steps did you take to move the databases and what commands did you use?
what errors are you getting?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 12:12 pm
datareader only applies to user tables so should be safe
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 12:09 pm
as wildcat mentioned above, to move a table create a clustered index on that table into the new filegroup with drop existing on the tablename. Logically when you create the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 11:47 am
the datareader role should grant select on tables.
of course you could modify the public role but i wouldnt recommend that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 11:40 am
depending on your disk subsystem set up really, extra filegroups are only worth it if they will be placed on separate disks\arrays.
you create the filegroup using the alter database. Add...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 11:36 am
psmith (7/22/2008)
What is the technical reason for leaving the Windows disk as Basic, if you have a raid disk system running your other data files?
dynamic disks are designed to support...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 11:24 am
set the database offline and move the disk file(s) to the new location(s) then run
alter database dbname modify file
(name = logical filename,
filename = driveletter\path\filename.extension)
for each file you move.
Bring the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 10:40 am
you cant just copy master and msdb, what if the collations are different between servers?
do you have any SSIS packages?
do you have any custom jobs running against the db?
are you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 3:26 pm
avipenina (7/21/2008)
so i write this syntax and i get an error.why?THX
this should do it
if not exists (select name from sys.configurations where name = 'xp_cmdshell' and value_in_use = 1)
begin
EXEC sp_configure 'show...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 3:05 pm
follow these steps
move the MASTER DB first. Stop the sql instance and agent and copy the database files
(master, model, tempdb, msdb, mssqlsystemresource and dist DB files) to their new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 12:59 pm
check the NTFS file permissions on the data files
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 21, 2008 at 12:52 pm
Viewing 15 posts - 9,121 through 9,135 (of 9,241 total)