I Agree with Vinay Kumar..

There are sometimes a scenario comes where we just need the data and there are lots other things to complete in a row.. in that case...

Thank you so much for the help.

As the restore was done through job, from where will I be able to know the data, I mean how much restore is done?

Also...

Even I tried with invalid names and it is returning 0. I am still confused whats the usefulness of sp_validname

Thank you...

Hi All,

I have a problem which everybody is discussing.

I need to find the duplicate record in the table. Its not a matter of just 1 column.

create table #temp

(ddatetime datetime ,

...

🙂 Thank You.

thanks..:)

yes!!!

I want to delete records from table but do not want any entry in the log file ..

is it possible..

or

while deleting only can i truncate the log file???

Hi,

I anybody have any dml statments that while deleting the records it does not goes into the log or the moment 1 delete is complete it should truncate the log...

you can try this..

USE database_name

GO

DBCC SHRINKFILE (database_log,55)

GO

backup LOG database_name with truncate_only

GO

DBCC SHRINKFILE (database_log,50)

GO

USE master

DBCC SHRINKDATABASE (database_name, 2)

GO

SELECT CASE WHEN PATINDEX('%'+@Delimiter+'%', SUBSTRING(@String, number+1, 12)) > 0

THEN SUBSTRING(@String, CASE number WHEN 1 THEN...

Hi Chris,

I am having problerm as to what have you done in the code.

I am not able to understand properly step by step how and what is happeneing..

can you please...

Yep,

But Thank you so much..:)

Thanks a million..

It works..

Thank you so much..

🙂

It really works..:w00t:

Thank you soooooooooooooooooooooooooooo much.. :w00t::w00t::w00t:

Thank you so much..

:):laugh: