And this brings us to the BUSINESS REQUIREMENTS

What is it that you are trying to do? Do you need just one value from the second table and in this case...

You have to test how much time transaction log backup takes when backing up log every hour. Then you will decide how often. if the backup takes 20 min to...

Gail,

Yes, of course. There is a few conditions including that the DB has to be read-write. Also CREATE DATABASE article says

FOR ATTACH_REBUILD_LOG requires the following:

...

If this issue has not been resolved yet, ask the user how he/she connects to SQL Server and compare this login to other logins who don't have this problem

Yelena

Well, but you can specify a new empty log file. In the past we did it with sp_attach_single_file_db, in this case a new log file is generated. Now you ...

Hi,

How much actual data is in the database? How fast the data is changing? What are your recovery requirements? How much space in the log your long tansaction take? Are...

[/quote]

Hi Mark,

One can schedule SQL Server job in Windows Task Schedule using OSQL or SQLCMD....

Hi All,

I think the worst security thread relvant to passwords is integrated authentication (within the network). One hacked or written down password can lead to a hacker getting access to...

Thank you Steve!!!!

The insert statement for events will be helpful.

Do you happen to know what rights in SQL Server 2008 do you need in order to run server traces if...

Wendy,

most of the stuff in Reporting Services is stored in the reporting services databases. Database backups assure that report definitions, data sources etc are backed up. I have never specifically...

Have you tried usig Performance counters? Make good graphs if the log is open in Excel.

Also for the queries you can use Profiler.

In case only SSRS are installed on the server you can use Windows scheduler with any command like batch job or VBscript job to delete older files.

Is there anything special with the character #40?

In this case you can copy and paste the content to Microsoft Word or Outlook and do a Replace replacing this character with...

If the tab names have to be dynamic in the Lili's script before the line

objWorkbook.Sheets(1).Name = "TransactionDetails"

define a variable that will hold current sheet name and use this variable instead...

You may want to try to follow a manual uninstall procedure described in

http://support.microsoft.com/kb/955404

this procedure is for the cases when the previous installation fails, but it probably may help...