Well, I was expecting another sproc, turns out this functions does it, I guess (have not tried it)

SELECT * FROM :: fn_trace_getinfo(default)

I think I like it better as in...

TheSQLGuru (10/11/2007)

---

Easiest way to get rid of the 9gb log (assuming the database has only one file) is to take the database offline drop it and then reattach it using...

Paul Randal (10/9/2007)

---

ok - so you can either take (and continue to take) log backups and stay in full recovery mode, or you can change modes and run a dbcc...

Your article is fine, but I am running SQL 2000. On the other hand, I checked for long running transaction and there is none. It seems is just a big...

I forgot to mention, empty column will be filled sequentially after user submits a...

devteamlead...I think I know what you mean about avoiding cursors. In fact, I found out in BOL and also in experience. After I posted I managed to create a procedure...

try starting a new project again on your local server. first time, it might be reporting nothing int he log.try updating some rows in a table, and then re-open the...

I tried on both local and remote. I even tried from local, via VPN to remote and added the required xp.

I am afraid the cause is this instruccion being run...

It is set to FULL. After restoring backup locally I got two files, one MDF 2.2GB and one LDF 3.3GB big.

I ran one popular script I found here from Rodrigo...

I created one MS Access version. But my goal is to make something to run under Linux.

Discussions in my team are around the subject of C# using Mono, or making...

I have SQL 2000.

I had to create one cube for each data source, then a virtual cube with dimensions from existing cubes.

Thanks for the tip. Enlightening.

But if actually when SET ANSI_NULLS is ON, all comparisons against a null value evaluate to UNKNOWN why is the correct answer FALSE? At least that is what I got.

(Also,...

Those Logs I am referring to keep track of user, sessionid, session start and end date, visited page and/or page group...that kind of stuff.

I intend to use them in Analisys...