Hi -

Yes the user account has privileges and also tried the SA account

-

SSMS is 2008 R2 - Sql Server is running SQL 2005 !

Here's a question on that topic...

Hi,

It is SQL2005 SP2 ( without Hotfix! )

I have been reading that there is a problem reported from a windows update - I know that I was able to do...

I have now tested this issue on the Test Server that is running SQL 2008 R2 -

Modify is still in bold - but it does allow me to modify...

Totally amazing when you read a piece of code so many times and blind by your own perfections.

Have a sandwich .... have a drink .... come back ....

Only to discover...

Unfortunately I cannot upgrade our production server for another 6 months - so am stuck with 2005.

But my main issue - is the fact that it is workign fine under...

Phil Parkin (5/7/2013)

---

Why not avoid the datatype conversions completely?

declare @Today date

declare @NowTime time

select @Today = getdate()

,@NowTime = getdate()

select @Today

...

I am trying to acheive two fields, one with a DATE in and the second with a TIME in, for an audit log.

You always can login using windows authentication and reset the password in SQL management studio. if your SQL installs are installed in mixed mode with both SQL and Windows authentication....

There are some password reset utilities out there - Advanced Password Recovery - which can reset things. Not sure the costs - but worth a look as a last...

Hi - yes the software is fully compatible with 2008 and 2012 - there are no changes out the box as it runs on 2005 ->

I have checked my scrips...

After running the advisor all looks well.

Have run the upgrade on the test envoironment and again that has worked well - so planning on doing the Production server.

A very easy...

Brilliant - thanks for the advice.

It is used for Crystal Reports printing - whereby it links the qty to print on the total - so returns the numbers of sheets/labels...

Thanks again - I keep looking past the obvious and think its more complicated that it should be.

I have now created a stored procedures for this and using the output...

Brilliant - thats worked a treat -

One last question - can I incorporate the OUTPUT functionality to get the result set returned ?

Okay - I have now found another little problem...

The Production Server where I want to install this is on SQL 2005 - rather than 2008 ( which my Test area...