permissions are not cross checked the way you are thinking.

this is working by design...an example might be you do not want "smith" to touch the tables directly, and only thru...

Sorry, it's not possible with a view.

in SQL Server, only a procedure can be created where the objects it uses do not exist yet;

everything else...tables with foreign keys, views and...

halifaxdal (6/2/2010)

---

One thing missing here: is it possible to find out the last modified user? who made the last change? It seems not included in the sys.objects table. I do...

adding to what Gail said, here's screenshots of where in SSMS to see how much you could release by shrinking the database.

you might want to move any existing backups off...

halifaxdal (6/2/2010)

---

Hi folks,

I am just wondering if there is a way to track the usage of stored procedures and functions in SQL 2005? I want to know how many times...

awesome Aaron;

sometimes just a shove in the right direction gets you rolling;

i had a brain block exactly like that last week, where i knew how to do something, but it...

here you go Aaron;

teh trick you want is to use hte ROW_NUMBER() function; that can give you "partitioned" results per PatientID, for example.

if you can in the future, if...

take a look at this thread: someone was running into a similar situation:

http://www.sqlservercentral.com/Forums/Topic930970-149-1.aspx

without seeing your specific query against the linked server, i bet it is the same issue:

i know...

ok i know linked server queries are slow because if you join a local table to a remote table, the entire remote table is downloaded into local temp, and then...

CREATE TABLE [Test] (col1 bit)

DECLARE @endDate datetime

SET @endDate = DATEADD(hh,8,GETDATE()) -- 8 hours from now

WHILE GETDATE() < @endDate

BEGIN

INSERT INTO [Test] VALUES...

the procedure sp_spaceused takes an optional parameter, tablename, which would give you some info like this:

sp_spaceused CLIENTREQHIST

--results:

name rows...

i just changed it on my dev machine, and can find it in both the SQL logs and the Event Viewers "Security" Windows logs, but it's not obvious what the...

do you host the email server? if you are talking about emails you SENT, you cannot, you can only check the status of emails that exist on your mail server,...

Paul White NZ (5/5/2010)

---

I've had a much better idea. Create an XML format file like so:

<snip>

And use the BULK OPENROWSET provider to allow you to pre-process the raw data...

well this compiles correctly, but it depends on the other procedure GetFileSpaceStats , which was not posted so far;

if the procedure...