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...

http://www.sqlservercentral.com/scripts/DateTime/61691/

This returns just the date, although time is still present as 00:00:00. See the discussion for that article for further examples.

BrainDonor.