It seems that you should close the conn, but also try to restart all services on the Instance where you are working!

:w00t:

Nice article and rich stuff here ...thnx Steve!

:w00t:

Hi Sudarram,

Full Recovery Model fully logs all transactions so the Bulk-Logged Recovery Model minimally logs bulk operations! Bulk-Logged Recovery Model works almost in same manner as Full Recovery Model but...

Interesting ... lot of stuff here and very rich article

thnx and no comment!

Ok as I can see at the varchar parameter is incorrect you should write like this ''%' + @parameter(varchar)+'%''

CREATE proc usp_strsrchtemp

@userstr varchar(100),...

Very intereseting ....

So if you compare one MVP(SQL - and we have some infos how to become MVP) with one Software Engineer (SQL or Oracle Database) Graduate Master or Doctorature...

For the moment I'm not front of Oracle DB I will try tomorow! - thnx!

Dugi

I try it with TO_CHAR but still not working ... because the same function I used on another view and it works very fine... here to create pivot not working!

I'm...

...Hmmm... Not working and I do not have any idea what is wrong!!??

Jason Selburg (6/19/2008)

---

Or you could take advantage of the fact that an IP address just happens to have four parts just like a fully qualified SQL object name and use...

Yep we are here to help you just post the specific info what you are trying to do, of course that there are many ways how to do that, but...

hmmm I forget ah ..... Happy Independence of USA ....!!!!

Regards from Republic of Kosova the newest state in the World

thnx USA!

Dugi

Hi, can you provide us what experience you have with databases or more specific with SQL server:

1. How many years you have experience!

2. How are you familar with SQL Server...

Congratz! - Jeff and Michael

The correct way is:

Set the recovery mode to Simple then shrink log...