Temporary Tables

Technical Article

RE: truncate log after differential bkup

  • Reply

Not much other than failure error as shown below. I won't be back in my office til Monday so I'm not being rude by not replying... I really do appreciated your help on this. 2003-11-20 12:30:08.15 backup Database differential changes backed up: Database: TCPrd, creation date(time): 2003/06/24(07:38:28), pages dumped: 14395, first LSN: 16318:876:5, last LSN: […]

You rated this post out of 5. Change rating

2003-11-20

1 reads

Technical Article

RE: Database suspect status~

  • Reply

It appears your database is truly corrupted and attempts to reset the status will not be successful (as you've found out). Do you have a recent full backup to restore from? Were there any actions undertaken (eg. detach/attach) leading up to the suspect status occurring? Cheers, - Mark

You rated this post out of 5. Change rating

2003-08-16

Technical Article

RE: Refresh primary key

  • Reply

Hi Khalidhussain, quote: hi Could someone help me in following: I have a system data table where I add system data, e.g. Title table have Mr, Miss, Mrs, Dr etc. the table has column called ID and its set to primary key. if i want to add new data 'Ms' between e.g. 'Mr' and 'Miss' […]

You rated this post out of 5. Change rating

2003-08-14

1 reads

Technical Article

RE: Cache

  • Reply

The proc really runs a dbcc flushprocindb Here's the code.. create procedure sp_flush_db_procs @dbname sysname=NULL -- -- Flush the Procedure cache for a database. -- -- If no database name is supplied then flush -- the current database. -- -- WARNING: This SP uses an undocumented MS SQL -- DBCC command to do its business. […]

You rated this post out of 5. Change rating

2003-08-07

Technical Article

RE: Replacing BCP with SQLBulkLoad

  • Reply

This article could have been much better if it was edited and proof-read before posting. I gave up trying to decipher the spelling mistakes and errors, but I think the idea for the article was good. I didn't know SQLXML had this functionality, but I wouldn't trust the code samples given in the article because […]

You rated this post out of 5. Change rating

2003-07-21

Technical Article

RE: How much do you earn?

  • Reply

I thought Italy was uspposed to be a low taxed country in the EU, but it seems now that I was quite mistaken by that information. 17% in the USA and around 20% in the UK, what was people thinking when they settled Italy and Sweden? 😉 I will definitly look into these 'umbrella' companies […]

You rated this post out of 5. Change rating

2003-06-19

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers