kenstevenson (3/14/2012)

---

Is there a way to quickly search some freetext in all sp/fn within the database? I often need to search for a sp but just couldn't find it, I...

Or, if all things being equal:

DECLARE @DatetimeasVC VARCHAR(30);

set @DatetimeasVC = '10/28/2011 11:47:55.686455 AM';

select convert(datetime,

substring(@DatetimeasVC, 7, 4) + substring(@DatetimeasVC, 1, 2) + substring(@DatetimeasVC, 4,...

Based on the forum this...

A little busy right now, but it looks like you are going to have to do some reformating of your dates to convert. The format code 100 expects the...

saidapurs (2/8/2012)

---

Hi Perry,

All are under same domain...

I tried from 1st it self....

I logged in in Primary server & logging primary Database than connect Mirror &...

Well, if you really want a solution you need to do a few things first.

One, read the first article I reference below in my signature block regarding asking for help....

GilaMonster (3/14/2012)

---

Not in any of the...

Hey, I missed it too and I was looking for a missing comma. :blush:

derekr 43208 (3/14/2012)

---

GilaMonster (3/14/2012)

---

Fragmentation will never cause SQL to not find a value where it's supposed to be (according to the index tree). If a value is not where it's...

Has to be both of us. I count 19 columns in the defintion of the cursor and 19 variables.

One question, why are you using a cursor?

Gianluca Sartori (3/14/2012)

---

Correct. MySQL uses "IN" to...

Could you post the DDL for the tables? Looking at it I can't see a problem.

I am assuming that the IN is to indicate that the parameter that follows is an input parameter, drop it.

Also, may I suggest that you look up CREATE PROCEDURE in...

You may also want to review the jobs that run at night. Did any maintenance plans run that may have rebuilt indexes?

jcrawf02 (3/14/2012)

---

IT'S A BOY!!!

I won't get to meet him for a few months still, but very excited!

So now the important question is, do we let him watch Star...