Viewing 15 posts - 9,121 through 9,135 (of 9,244 total)
use
CREATE LOGIN prova WITH PASSWORD = 'prova123prova'
my guess is the password is not being recognised
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 1:48 pm
you could use a trusted connection or a file DSN
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 1:37 pm
we have a few SQL VM's in our enterprise, personally unless there was a drastic need i would prefer to do a fresh build of the SQL server and migrate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2008 at 1:15 pm
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
Viewing 15 posts - 9,121 through 9,135 (of 9,244 total)