You could maybe install a printer driver that prints to a JPEG. Neevia Technology claims to have one.

Cheers,

- Mark

You could try something like:

 

declare @theNums varchar(1000) set @theNums = '3,4,6,9'

update tempSalesDetail

set SET BTI = 1

where ',' + @theNums + ',' like '%,' +...

Just check for a non-zero value for @@ERROR. 3013 is returned for "not a valid backup set"

Cheers,

- Mark

Use SQL Profiler. Trace the object:deleted event and possibly some filtering so you can just isolate this one login.

Cheers,

- Mark

Some problems often come up with FT Indexing because builtin/administrators has been removed, or removed from the sysadmin role.

Cheers,

- Mark

I'm afraid your strategy won't work. The receiving logshipped database must remain in "loading" or "standby" state. Any changes will break the log shipping chain.

Archiving will need to...

If you have a database set to AUTOCLOSE (the default for SQL Personal Edition, but needing to be explicitly set for other editions) then yes, when the last user has...

Here's a crude (no error checking) bit of code to demonstrate a loop to do it:

 



set rowcount 5000

declare @rows int

while 1 = 1

 ...

Dinesh,

I'm not sure you tried inserting data directly into the cell of the "Open Table" panel as Kokyan has done.

Yes, if you run the INSERT (as you have posted) in...

If you want to avoid the requirement for batch separators, you could create the IDENTITY field in the SELECT INTO statement. EG:

SELECT IDENTITY(INT, 1,1) AS AUTOID, MSG INTO #TMPTBL...

Oops. Was that QOD 26/11 was it? And there's already a thread discussing it? And it's already been adequately explained?

I'll just crawl back under my rock and...

The trace does write straight to the file, but only in chunks of 128k or so (or maybe depends on how your disk is formatted). Whether SQL explicitly buffers it...

Aaaargh!

OK, who else has got a defect BOL?

Cheers,

- Mark

In 95% of cases I research it first, whether that's looking in BOL, testing, or using sqlservercentral's new-fangled google search.

My brain's storage is reserved for important stuff, like my wife's...

Definitely.

This is easiest to set up with the Import/Export Wizard, choosing an Excel destination and, in the "transformations" dialog, chossing to drop and recreate destination table.

Cheers,

- Mark