Can you post the results for

select @@version

or

Select Serverproperty( 'BuildClrVersion' ) as BuildClrVersion

, Serverproperty( 'Collation' ) as Collation

, Serverproperty( 'CollationID' ) as CollationID

,...

What's the effect if you alter the sproc using the

With recompile parameter ?

Seems to me cardinallity may be very different when using criteria 1 or 2.

Can you compare (or even post) the execution plans for both queries ?

Can you find anyting related in sqlserver errorlog or sqlagent sqlagent.out ?

Can you post the full dbmail setup ddl ?

(don't post the actual email address, but put in a dummy one)

kiranmca24 (2/3/2009)

---

i have a database called Link.The data file is 443 mb and log file size is 104GB.so that restoring is not done.so i want to reduce my log size...

Are you fetching XML data to a grid ?

I've experienced SSMS with results to grid generating our client antivirus to interfere (not with every select, but every time with the...

Is there a VPN in between you and your sqlserver ?

- did you grant the operatorid usage for the mail profile ?

- if you RDC (remote desktop connection) the server, are you able to send a testmail ? (so server...

did you check the various fn_split solutions posted at SSC ?

e.g.

http://www.sqlservercentral.com/articles/T-SQL/63003/

once a connection is established, communication performance may depend on the protocol it uses.

The sql performance for equal queries will be the same.

Also keep in min what kind of...

Jeff Moden (2/1/2009)

---

And THAT is what I'm really getting at... it doesn't matter if it's an undocumented feature or not! If you don't do any regression testing before you...

Jeff Moden (1/31/2009)

---

That little privs change on sp_MakeWebTask killed a lot of people's code because it now requires "SA" privs and a lot of smart DBA's won't allow users...

I'm glad you resolved the issue.

As you've experienced, on a cluster, you need to use the correct tool (indeed: Cluster administrator) for a clustered service to be available !

Been...

keep in mind SAC should not be used on a clustered instance!

You should use cluster manager to configure (stop/start) parts of this sqlserver instance.