What Data Type are the variables? If FeedType is not able to store string values or pNeedPorSessions is not configured for numeric values then you will get this error.

If they...

Are you sure that your log-shipping is actually working? The message implies that it has been a little over two years since the databases were last in sync.

There is an...

Jayanth_Kurup (10/13/2011)

---

Would you believe it If I told you we have all this in place , code travels thru 5 environments before it reaches LIVE ( not always tested :-)...

If some form of source control is in place then that must be the only source used for code. When someone sends a version of code via email, no matter...

I know a few users I'd like to send into space.

Within SSMS right-click on the database name and select Tasks/Generate Scripts.

Is this what you need?

Have a close look at your '%Growth' - the ',2' is in the wrong place.

96% of answers incorrect - you'll be popular! No cheap points here.

We have a similair setup here, where a software package upgrades a database to the latest version but occassionaly alterations have to be made before and after this for a...

Have a look at String Functions in MSDN http://msdn.microsoft.com/en-us/library/aa258891(v=sql.80).aspx.

I would probably use PATINDEX to locate the first '/', you know the date starts 2 characters before this and then locate...

Thanks for the reply. Now that I know that, I've worked out what to search for: http://msdn.microsoft.com/en-us/library/cc835497.aspx and http://stackoverflow.com/questions/1128597/is-there-a-64-bit-version-of-ssms-and-bids-with-sql-server-2008-64-bit.

Thanks for your time.

Dave Ballantyne (9/14/2011)

BTW Anyone going to SQLBits or SQLRally Nordic this year ??

And if you are in the UK ( or will be in the UK) dont forget to...

Rush hour in Calgary...

I normally don't comment on QOD articles, but the explanation and screen-shot of the execution plan deserves merit.

Grant Fritchey (8/12/2011)

---

Hey guys, want a free little toy from Red Gate? It's called Tab Magic and remembers what tabs you had open when you close SSMS. Kinda cool. A...