do not copy the master database. Look up script sp_help revlogin and use that to copy logins or use the dts transfer logins task as servers on same network. Check...

so anyway, can I have my point for saying write performance is worse please.

are the default database file locations in EM defined with a \ at the end? if so , remove it

if the server name and ip address is the same you should be fine moving system database as long as SQL versions and directory strucures are identical. Just bring SQL...

had something simialar (but not identical) and it was down to permissions service account had on the registry, in particular HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib

there is a...

david, that's great, thanks. I knew it would be embaressingly easy

try this:

set quoted_identifier off

declare @statement nvarchar(255)

select @statement = 'BACKUP database [dbname] to disk = '+"'" +

'\\servername\E$\fullpath\dbname_db_' +

CONVERT(varchar(4), datepart(yy, getdate()))+

right('0' + CONVERT(varchar(2), datepart(mm, getdate())),2)+

right('0' + CONVERT(varchar(2), datepart(dd, getdate())),2)+

right('0'...

David,

I am trying to produce the sp_dropuser and sp_grantdbaccess commands for all users in the database, with the quotes required for windows authenticated users, i.e.

exec sp_dropuser 'username'

exec sp_grantdbaccess 'domain\name','name'

Its getting...

reindexing actions are stored in the tran log so yes the effects are seen on the standby. If it goes in the log it happens on the other side.

If the...

sp_help_revlogin works great and is possibly the most useful script I have used.

However remember it does not set default database, default language or asign any server roles so you may...

if you are restoring via QA also include the stats parameter which will record progress for you in percentage terms

greg, thanks for that. The script also pointed me towards sp_drop_dtspackage in msdb which can beused to drop specific versions of a package, but you have to give it versionid.

george

I believe this happens when the ID is not explicitly defined as a user but gets its access via group membership, sql agent is not able to determine if user...

if you are sure you're tran log only is corrupt and you have no backups, you can try detaching the database then reattach with sp_attach_single_file_db, specifying .mdf only (see BOL)

restore...

you probably have an open transaction that is preventing the log being truncated. in the database run command 'dbcc opentran' , this will tell you oldest open command (with its...