Is there not a clause in Backup Log that avoids breaking the LSN chain?

Lowell (10/26/2012)

---

blacklabellover2003 (10/26/2012)

---

Hi all,

I have an orphaned .mdf + .ldf fileset on our production box, I know how to attach them.

But I also need to find out who the last...

WayneS (10/11/2010)

---

Example - if user 1 has a value in the Text column of 'Att20451', and user 2's is 'Att40451', if we pass in @attendance = '30452', then the Sproc...

Well, the consensus is that the final check isn't necessary, my remainings concern are error-handling, emailing that rowcount automatically, and possibly lifting the phone numbers using OpenRowset.

But otherwise, you think...

Hi Wayne,

That solves the repeating phone number issue, but do you think some sort of "If, Then.." control flow is needed?

Hi Vinod,

I can't use OpenRowset as our servers are 64 bit. Is there a workaround for this, or another command?

Thanks,

Jim.

Possible, but there are òther servers still on SP2 that don't exhibit the issue.

Can anyone help with this? This is the code I've got so far, but it's for Excel, whereas I need to point it to a tab delimited Notepadfile

SELECT * into...

To search the data, in a database, for the existence of a string of data.

Got it. Also, is this backup being made over the network?

EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [Outnow] TO DISK = ''\\dbsrvr1a\outnow\Outnow.sqb'' WITH COMPRESSION = 2, MAXTRANSFERSIZE = 1048576"', @exitcode OUT,...

Looks great Alex! Would I be able to export the results out to a csv/xls for reporting?

AlexSQLForums (9/20/2010)

---

I would create a stored procedure which starts with getting data into sql server from excel:

SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

then add the rest...

Did you publish...