I'm pretty sure you can't limit the forwarding, but I'm pretty sure you can limit the number of alerts or emails that are sent from the email enabled sql server....

So from the sound of it, you have dbcreator rights, but not securityadmin. Without at least that, you can't restore a database and give permissions to access it.

Can you post the actual execution plan? Just save it as a .sqlplan file, zip it and attach it.

I see that your TVF is also calling another function. Just so...

But even then, you can only add users if you have the security admin privileges to do that.

You don't need error handling or transactions for the SELECT part of the query. There's nothing going on there that requires it.

As to the rest, here's an article I wrote...

You can't. That's a hard limit built into the system. That's a lot of data to be sorting on. Do you have any options there? What are you trying to...

If it's eliminating NULL values you might see an increase in performance, but I'm not sure. Can you post the execution plans along with the queries?

If you're the admin on the server you should be able to connect to it. What specifically is the error message.

If you have security admin privileges on the server, you...

As the last post showed, @@ServerName gets you the name of the server, DB_NAME() gets you the current database. If you pass it a database ID, it will get any...

There's nothing all that special about a view. It's just a query that sort of behaves like it was a table. If you need to move data out of the...

The index is bigger. That means more disk space will be needed to maintain. It's possible that it will have more levels because of the extra size which will add...

pandeharsh (3/31/2009)

Suppose i write a general proc like this.

Create proc Example

@empid int,

@Mode varchar (1),

@fname varchar (100),

@lname varchar(100)

As

If (@Mode='S'

Begin

Select fname,lname from emp where empid=@empid

End

If (@Mode='I'

Begin

Insert into...

If the procedures are still in the cache you can query sys.dm_exec_query_stats to see exactly how long the procedure ran, how many resources it used, etc. You can even combine...

You may need to filter the data. Include a WHERE clause to limit the amount of information you're getting back.

I guess the question is, do you want grow your own monitors or do you want to go & purchase some of the more sophisticated monitors?

If you want to grow...