boy these read just like homework questions.

what do you think the answers are?

you can create a...

well it really depends on your application.

if your application is a client-server kind of app, then changing the connection string would be once-at-startup, and then an on-demand situation, where...

omg that extended proc with no...

Andrew i have this saved in my snippets; it's creating a linked server to Active directory, and querying for some stuff;

when i tried it on my own network, i didn't...

this is outside my area of experience, but my Google-Fu skills are strong! I searched "ssas star or snowflake" and found some stuff.

i found this article about why snowflake is...

i believe the DDL statement DROP index would be captured in the default trace;

you can use the GUI filtered version and find out whodunnit if not too much time has...

just because a table has no rows does not mean that table has not been referenced by a view/stored proc / function or external application; it is perfectly normal to...

are you confusing DBCC TRACEON with a system trace? (select * from sys.traces)

every DBCC TRACEON command does a different thing...some turn on something to be visible in performance counters, others...

this clearly identifies the issue, and it's outside of SQL server:

The server response was: 5.7.1 Unable to relay for aangie@ibmcore.org). )

that is one of the standard SMTP error messages.

that means...

wouldn't this just be a min( date), and count(*) grouped by customerid ,year(min(date))?? so you can calculate counts per year or some other period?

nite re-download the project one more time;

i tested it found some bugs and missing code, this versions much better.

something like this is what you want;

the permissions is VIEW ANY DEFINITION, which is what you were asking for: let them see the text of any view/proc/function.

CREATE ROLE [ReallyReadOnly]

--give reader...

the recommended way is to take your script, which you already know works, and use SQL Agent to create a job from within SSMS, which runs on a regular basis.

while...

as Chirag alluded to, you can use the procedure sp_procoption to run a procedure when SQL server starts, but SQL Agent might not be running.

here's an article wher ethey discuss...

maybe i'm mis reading the request, but it seems to be "show SSMS reports in our application instead of SSRS web pages". I had thought it was different.

I'm assuming the...