You won't find them on your disk, but you can download them from here. You can read more about them here

Just as Chiraq said you can do something like this using triggers but not with a stored procedure. But you must be aware that a trigger will be fired...

kumar99ms (12/10/2008)

---

Hi,

I am planning to install ms sql server 2005 trailer edition in my system

i want SSIS SSAS SSRS & (Standard Edition or Enterprise Edition)

can you please send me currect...

You cannot use sp_changedbowner on system databases. The only way of changing the ownerback to sa is reattach the msdb while being logged on as sa. Unfortuantely it's not a...

Unfortunately you can't edit the automatically created index for a PK.

But it might still be usefull to keep your current unique index with the included columns. The index for...

I've seen similar errors using an iSCSI cabinet. Every time a lot of IO activity occured like when doing index rebuilds we got intermittent IO errors. You should see some...

Did it really say file 'G:\.mdf' ??? Anyhow OS error 21 usually means that SQL server cannot access the disk. Check eventlog for any disk errors.

Instead of granting exec permissions on sp_adduser you can better use the fixed database role db_accessadmin to allow them to add new users. Eventually you also need db_securityadmin because...

The surface area configuration tool has been removed from SQL 2008 as a separate utility. You can now manage these things by using Policies. There's a facet called surface area...

Are you trying to install the dashboard on the server itself or from your workstation via SSMS.

In the second case check the version of SSMS. See under Help>About which...

CrazyMan (12/3/2008)

---

you can use msdb.dbo.sp_send_DBMail ro send mail from your SP, what exactly is that you want to do, if you can explain a bit more then we can give...

Did you have a look in Books online? It explains all these things in some detail.

When you create a new datasource you can select ODBC data.

Not sure if I understand your requirement correctly. If you want to restrict connections coming from other clients like your IIS server, you could create a DDL LOGON Trigger, which...

If you want to give read\write permissions on all tables add the user to the roles db_datareader and db_datawriter. But remember that this will not give them permission to execute...