Viewing 15 posts - 61 through 75 (of 134 total)
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 9, 2013 at 11:48 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 8, 2013 at 12:50 pm
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 8, 2013 at 3:01 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 7, 2013 at 5:46 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 7, 2013 at 5:30 am
Phil Parkin (5/7/2013)
declare @Today date
declare @NowTime time
select @Today = getdate()
,@NowTime = getdate()
select @Today
...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 7, 2013 at 5:28 am
I am trying to acheive two fields, one with a DATE in and the second with a TIME in, for an audit log.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 7, 2013 at 5:22 am
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....
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 3, 2013 at 7:45 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 3, 2013 at 7:43 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 3, 2013 at 7:37 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 3, 2013 at 6:38 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 30, 2013 at 6:24 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 24, 2013 at 11:45 am
Brilliant - thats worked a treat -
One last question - can I incorporate the OUTPUT functionality to get the result set returned ?
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 24, 2013 at 9:11 am
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...
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
April 24, 2013 at 7:52 am
Viewing 15 posts - 61 through 75 (of 134 total)