Wildcat (10/14/2010)

When you say this is the Production Support team, what exactly do you mean? Are they DBA's or System Admins? If they are only system admins and shouldn't be...

Well, its complicated... they are supposed to be DBA's (and have that title) but we can't just say things like go add a new user with these permissions we have...

so with the sp_create_trace ... after reading a little... its basically a programmatic way to tell sql server to start a profiler trace? And I can stop it and...

Well, they are production support...they are supposed to have access to everything. However, just because they have access to do anything and everything doesn't mean I don't want to...

Hi there, thanks for the link. I believe we figured out the problem with it and its just because I'm trying to execute the sdk from a remote path...

I wish I could check... I'm a developer, so I don't have permission on production to start and stop services.

Today however, there were no logins from yesterday. ...

Awesome glad you got it sorted! 🙂 It really is a handy reporting tool.

GilaMonster (9/7/2010)

Then check the user processes. The system processes should not be running often and, if they are running a lot and taking up resources better spent on user's queries,...

Ok thanks, I hadn't noticed it really before and we're having a lot of network contention and I/O issues with a slow server connection so I wanted to be sure...

If you run this query in the database that you are trying to get info from:

select object_id, name, create_date from sys.objects where type_desc = 'USER_TABLE'

You will get a list...

If you're using the delivered SQL Report Dashboard the http address would be something like: http://ServerNameHere/Reports

Assuming you have deployed the reports to that location, you can...

Thanks guys, I did try using a hint but SQL decided it still wanted to use the clustered index. 🙂

I did manage to fix the problem by running the query...

Well, I dunno if its a different story my post was referring to the error I got while trying to drop the file that I added to the filegroup for...

Dropping the table does not get rid of the files and filegroups that I have created for the table.

Oh Duh... I thought it was saying I had to list them in the select statement... haha... brain fart for the day is over... hopefully. 😉