what was the statement that you used before you got this message.

i hope you should have used

sp_configure 'user options',0

sql server treats this to be a configuration change and asks you...

I hope the statement should read like this

no transactions are kept in the log file. i hope this would mean the exact sense of the phrase used.

Sure i shall check for your requirement i hope there is a easy solution that can be done.

yes clark u r right. i apologize. i dint read this phrase in the last post.

we want to carry out some other transaction on the second server and same...

i hope u r running the stopred procedure as a job. u can output the results of the stored procedure to the excel file in the step properties of the jobitself...

i think ur data type is datetime try using this

date >= '2006-06-13 00:00:00.000' and date <= '2006-06-14 00:00:00.000'.

between omits the starting and ending days including in the query.

give us the column names and the data types. so that query can be written for ur req.

restore a full backup and then periodically resotre ur diff backup. but why can't u try replication for ur requirement if u r using sql server 2005 u can also...

please be more specific.

by default the inner sub query is executed first and then the outer query.

ODBC is OPEN DATABASE CONNECTIVITY which uses drivers to connect to any datasource. the drivers can be any OLE DB providers or ODBC drivers or any other drivers which can...

i thik u r getting this stmt at sql startup or r u geting this often. if at startup then i hope sql server is initialising some parameters for its...

this was a script written by me to get the list of DB and object permissions for all users check if this script helps u.

http://www.sqlservercentral.com/memberservices/updatescript.asp?Approve=y&scriptid=1777

Hi Imke,

have u solved this problem. whats was done to solve this one. Please let us know.

with sql server 2005 the memory management is dynamic until u set a fixed memory configuration the internal processes in managing the memory has been improved too much in such...

remember that even if u have ur log shipped database to read only mode u will not be able to read the data always. users cant access the database when...