This is what first came to mind, I was trying to find more...

There are also trusted logins, that were deleted from the domain a week ago. Can I delete them without caution?

2Jeremy Kemp:

The procedure I call from the job does a number of backups in a cycle:

set @backup_command = 'BACKUP DATABASE ' + @db_name + ' TO DISK=''' + @full_backup_path +...

I just wanted to fetch a single column at one place of the procedure and take the others at another. So "partial" fetching is not possible.

Thanks all...

Another one:

The properties listed in the Active Directory may not always be exactly the same as they are in SQL Server. If there is discrepancy between the publication and attributes...

Just found it: BOL (keywords: Active Directory Services)

Typically, if a user wants to subscribe to a publication, they must know the name of the instance of Microsoft SQL Server™ and...

Not quite understand, but what is the practical use of such publications?

Suppose I use a stored procedure. How can place data (few records) it returns into a cursor or a temporary table. I need something like:

select * from [exec...

This works fine for DBs like Northwind, but does not work for my working DBs (returns nothing) This is the second time I face such situation. This procedure...

Well, wrote a code, that works fine, can count number of records and size of all tables, even system (just change the type of the object):

print GetDate()

print '------------------------------------------------'

DECLARE @table_name varchar(100)

DECLARE...

Thanks a lot, I managed to do this in QA

I am doing it in EM and this is the only log backup and I have SP3 for mai SQL2000.

So should I do this in query analyzer?

Maintenance plan does not allow me to choose all databases on all servers but a list of DBs that are not to backup. Maintenance plan does not allow me to...

Big thanks! It worked!

restore database ACCPAC2

from disk = '\\Saturn\sql_backup\ACCPAC_BACKUP.BAK'

WITH REPLACE,

MOVE 'accpac_data' TO 'd:\sql_data\ACCPAC2_Data.mdf',

MOVE 'accpac_log' TO 'd:\sql_log\ACCPAC2_Log.ldf'

So, can I do the task (saving the number of the string of table, where the time of procedure start is recorded) any other way?

The structure of the table where...