gradpks ,

You can view any of the character codes in charmap. To view charmap click --> start --> run --> charmap and get the proper key strokes or code...

You must first create the textfile with the column headers in it. Below is an example of openrowset.

Use AdventureWorks

go

INSERT OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Text;Database=C:\',test#txt)

--query goes here

SELECT FirstName

FROM Person.Contact

Where ContactID < 50

Have you tried to switch the database out of recovery mode?

restore database databasename with recovery

Just for some good reading material this link has some good arguement about the different recovery models and their performance.

http://www.sqlservercentral.com/Forums/Topic426078-146-1.aspx

I am glad everything worked out! 😀

It seems like ApexSQL will not even consider looking into the tran. log of a database, if it is set to the simple recovery...

I really do not think there is much you can do, in this situation. The biggest problem you are faced with is the recovery model is set to SIMPLE...

Edmund,

I have modified your query to meet your expected results. You should note that one of your expected results is incorrect. For 500260 Recoverable you are expecting 1634.73;...

Sample data and expected results would allow me to get a better understanding of what you are trying to accomplish :D. I would start with joining the tables in the...

No. You have the ability to do a point in time restore with all versions of SQL server (not sure about compact edition), but the database must be set...

You have a few options to choose from:

1. Restore from a known good backup

2. Try restoring the page from a good backup as such:

RESTORE DATABASE TEST PAGE = '1:82799' FROM...

If you cannot get your hands on a 3rd party tool, I would just script each set of objects. This way you will have a file for Tables, Schemas,...

Day,

ALZDBA was stating that the application only has to make one stored procedure call to retrieve both sets of information. The count is stored in output variable that the...

The database is in a read only state. Did you restore the database and use the norecovery or standby options, or you backup the tail of the transaction log...

You could probably do a sub query to reference back to the main table like such:

Select c.[ConsultantID]

,c.[FirstName]

,c.[LastName]

,c.[SponsorID]

,(SELECT [FirstName] + ' ' + [LastName] FROM Consultant WHERE ConsultantID = c.SponsorID)

from...

Lalit,

The only method I can think of is to use a cursor to store the pervious calldetailid and compare it to the current. If they are the same, give...