I have to disagree with Greg on this one. Create a role that has the necessary permissions and assign the user to the role. The db_datareader and db_datawriter...

Is it an embedded sub-report or a link to another report?

Well, since you are setting the stop time to 5 minutes I would venture to say that you are only collecting 128KB of data and would never fill a 5MB...

Great article Bill. As with most good articles you read it and say "Yeah, that makes sense", but then you realize how many times you leave out some of...

Lack of understanding the SQL Server security model. Using sa or putting everyone in the dbo or datareader and datawriter roles. SQL in the application not in stored...

Check out this article[/url] by Brian Kelley.

No offense to MS but Brian's solution is better than the MS one. sys.dm_exec_sessions can be spoofed by the Workstation ID and EventData...

You have to be wary of the logon trigger approach because client host can be set in the connection string of the application. So a "smart" person could spoof...

Lynn Pettis (5/7/2009)

---

Has anyone else noticed that EVERY TIME a new version of SQL Server is released there are many questions asking if you can restore a database from the...

Okay, I used RedGate SQLGenerator to put 100,000 rows in the table and ran these 3 queries which all returned the same results:

DBCC FREEPROCCACHE()

DBCC DROPCLEANBUFFERS()

SET STATISTICS IO...

I don't know of any way to do this within SQL Server. You could do it with a rule in a firewall.

Declare @filename nvarchar(245),

@rc Int,

@TraceID Int,

...

Wouldn't this return the same thing?

Select

max(id) as id

From

tbl_logs

Where

date between '2009-05-06 00:00:00' and '2009-05-06 23:59:00'

Group By

fk_tbl_visits_id

Please take a look at the first article linked in my signature and post...

John,

I'm glad the code I provided was helpful, but I did ask for more information the same as Lynn

The...

"Here I go again on my own"

Well ACCESS does support OUTER JOIN's so you could use a LEFT OUTER JOIN. The LEFT OUTER JOIN would work in SQL Server too, but EXCEPT is easier.