Thanks for posting the link Lutz. Looks like I only wasted a little time on this thread.

Brent Ozar has series of blog posts on How to Get Junior DBA job that is pretty good found here[/url]. You probably aren't looking for a junior position, but...

I've been involved in a similar project where we used an EAV method. We had category and type tables and then defined the EAV values base don category and...

I'm going to ask some questions to clarify the problem. All of the questions would be answered if you had posted the question using th emethod suggested in the...

Nice and article and an interesting concept. I'd also be concerned about overhead and space issues. Although space issues could easily be dealt with by purging the table...

Wouldn't part of processing the file be moving/renaming/deleting it?

I recommend against doing something like creating a file from a trigger. Why? Because the trigger is part of the transaction and if your trigger fails for any...

So maybe the despite should be because. 😛

No doubt as it took me a minute to figure...

Barry,

Yes your examples are actually the "safer" version of using select. The issue I have, and I use both Set and Select is that

Select @i = object_from sys.all_objects

Will work...

JuanBob (5/8/2009)

---

Well, the server processes many records a second. 5 minutes should fill up a 5mb file no problem so a roll_over would probably be expected. The problem...

Why not just schedule a job to run hourly and if the file exists process it.

Then the code in one job is:

If file exists THen

run job...

I am a firm believer in defining all foreign keys in the database. Yes, there is a small performance hit in verifying the key, but you have to verify...

Are you setting it up using the properties of the textbox using Jump to Report on the navigation tab? Once you pick the report you can set the parameters...

Check out this MS Support Article, http://support.microsoft.com/kb/842014. It is not about Profiler, but addresses similar issue with Outlook connecting to the BCM database in SQL Server. The dll is...