Spotlight = on the fly, bird's eye view of a system

Foglight = same as above, but collects the data longer to be able to trend on it

Depending on exactly what...

I think we need some more info ... what do you mean you're installing a reporting services database by restoring it?

Are you migrating a reporting services database from one...

SQL ORACLE (2/26/2008)

---

Here is the scenario.

A user is a database owner, but has no access at all to master database. Now, the user would like to execute one stored procedure...

Forgot about this topic ...

I found what I was looking for in xp_sqlagent_enum_jobs

Thanks though

Think I found my issue: http://support.microsoft.com/kb/q238477/

If I run the query from the server, it works (wasn't before, I changed something).

Anyways, I enabled named pipes without restart SQL and it worked...

Whoops, someone else posted the same topic title before me ... my apologies. It won't let me edit it ...

Perfect, thanks guys.

Oh wow, I didn't realize you could specify the SID on a login create ... that's news to me.

So for NT groups, I don't need to worry about this eh?

Check out the view, you can query it to accomplishes that.

GilaMonster (2/23/2008)

---

Drop the snapshot and create a new one?

Perhaps I'm misunderstanding you, but after you've created a snapshot, neither new data nor new objects created after that time will be...

That is SQLMail, which requires outlook on the SQL Server, aka it sucks.

My advice, steer clear of SQLMail ... even Microsoft doesn't like it.

CDOSYSMail is a fantastic alternative that I'd recommend looking into:

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=46350&enterthread=y

HotFixes and Cumulative Updates (to my knowledge) are always rolled up in the service pack releases.

If anyone is interested, I did some reworking ... I still have a small problem on a join where I'm missing out on nulls and dynamic SQL, but I have...

Well, if anyone is interested, MS came back and said that there is in fact no true alternative to DBCC INPUTBUFFER (There is no replacement or alternative for DBCC INPUTBUFFER...