Viewing 15 posts - 9,076 through 9,090 (of 9,208 total)
Max Databases per instance of SQL Server = 32,767
July 23, 2008 at 8:55 am
what are the preceding errors?
open up the plan and double check it
July 23, 2008 at 5:27 am
you do need to assign the user account sql runs as to the local policy "lock pages in memory"
July 23, 2008 at 5:23 am
did you format using the 64k switch?
was it successful?
July 23, 2008 at 1:50 am
what version ESX server are you using out of interest?
July 22, 2008 at 2:52 pm
how many disks are in the array that the file sits on?
also what is the set up of sql server, where are the data and log files stored?
July 22, 2008 at 2:39 pm
in linked table manager when the login box appears use trusted connection
July 22, 2008 at 2:38 pm
use
CREATE LOGIN prova WITH PASSWORD = 'prova123prova'
my guess is the password is not being recognised
July 22, 2008 at 1:48 pm
you could use a trusted connection or a file DSN
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...
July 22, 2008 at 1:15 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...
July 22, 2008 at 12:26 pm
Viewing 15 posts - 9,076 through 9,090 (of 9,208 total)