Viewing 15 posts - 46 through 60 (of 69 total)
Unfortunately they most def wont give a new server, would it be better to do the side by side upgrade, once this is done can i uninstall sql 2000.
Assuming side...
July 22, 2009 at 3:23 am
But the database on SQL 2008 will be used in the production enviroment, SQL 2000 will be un-installed.
Is their a difference by keeping it along-side and upgrading (sorry but just...
July 22, 2009 at 2:41 am
I'd tried using the activity monitor, under the processes tab it shows what is currently running. I cant see much their How can I extend those columns because I can't...
June 1, 2009 at 6:14 am
Aha thanx that seems to do the trick, Changed the recovery model to simple then shrunk the logfile using the shrink tool in Server Management Studio. Thanks alot for all...
February 9, 2009 at 3:29 am
Result after executing your statemet
Original Size of ServerAdmin LOG is 358648 8K pages or 2801MB
Cannot shrink log file 2 (ServerAdmin_Log) because the logical log file located at the end...
February 9, 2009 at 2:49 am
dbcc opentran (ServerAdmin)
go
dbcc shrinkfile (ServerAdmin_log, truncateonly)
dbcc shrinkfile (ServerAdmin_log, 0)
Results:
No active open transactions.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Cannot shrink log file 2 (ServerAdmin_Log) because the...
February 9, 2009 at 1:50 am
The sysxlogins table returns the same example
CORPORATE\FER06137
CORPORATE\HEI01720
corporate\hib05552
CORPORATE\hla06441
CORPORATE\Hot Products Group
CORPORATE\jac06909
CORPORATE\jag06779
CORPORATE\jor23611
It picks up 8 Users on the database, but what if their are 10 users in the CORPORATE\Hot Products Group. This will...
July 25, 2008 at 3:46 am
Thanks so much for your reply, yes the sysusers has all the users but it shows the Windows NT group name as 1 User.Not the users that are part of...
July 25, 2008 at 3:23 am
Thanks alot for your assistance, I found the solution though, the actual database file permissions were set to read_only as well, I noticed this when i went to the properties...
June 9, 2008 at 1:41 am
recieving the same error:
Server: Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name 'F:\LEVEL2HISTORY\20071126\Level2Backup_sys.mdf' may be incorrect.
Server: Msg 5105, Level 16, State 1, Line 1
Device...
June 8, 2008 at 11:48 pm
yes the file does exist, no its not a network drive
June 6, 2008 at 8:11 am
To SQLDBA
Executed this command it returns null values EXEC sp_change_users_login 'Report'
Steve
Thanks Steve under database->users: User Name = dba_developer Login Name= <UNKNOWN>
It is UNKNOWN because it does not exist under SECURITY->LOGIN...
August 30, 2007 at 12:53 am
On my developement machine results are
corporate\dba_developer |group user| corporate\dba_developer |NULL
which i agree because the user exists on both DATABASE->USER folder as well as the SECURITY->LOGIN folder
but on the production machine there is no such...
August 29, 2007 at 6:09 am
Thanks John for the reply I do know that please check the question.
I'm confused how does the developer have write access to the database, because the only logon which has the...
August 29, 2007 at 3:48 am
Viewing 15 posts - 46 through 60 (of 69 total)