Viewing 15 posts - 106 through 120 (of 605 total)
Lynn Pettis (6/10/2009)
I have a suggestion, please make Books Online your friend.Let me help you with this one, just click here.
:laugh:
June 11, 2009 at 2:20 am
What exactly did you do? I just ran a quick test using a temp table and had no problem.
What result does this query yield in your environment?
SELECT CAST(967.69 AS...
June 10, 2009 at 10:52 am
Robert klimes (6/10/2009)
The money type has four decimal places, so to ensure no data loss numeric(10,4) would be more appropriate.
Good catch! Missed that 🙂
June 10, 2009 at 9:26 am
Not if you specify the correct precision and scale. For example, numeric(10,2).
June 10, 2009 at 9:01 am
GilaMonster (6/5/2009)
Loner (6/5/2009)
So if the page count is less than 100, even the fragment in percent is high, I don't have to worry about it?
1000 pages. Not 100.
1000 pages is...
June 6, 2009 at 6:22 am
I agree with Grant.
Also, get yourself a copy of Express and play about with that as well. Can't beat hands on learning!
June 6, 2009 at 3:48 am
I wrote a small script to see who was online at various points in the day. Nothing too crazy - I just ran the sp_who2 command and saved the...
June 6, 2009 at 3:28 am
A good day off for me would be a round of golf (hopefully not playing too bad) and a bit of lunch with the wife (to keep myself in the...
May 22, 2009 at 9:30 am
Also, as a side point, you should not really be using sa to run any queries etc. The sa login should be left well alone. You should logins...
May 21, 2009 at 5:06 am
As Gail said, the sa login has full privaleges within the instance. You do not need to explicitly grant any permissions to this login.
May 21, 2009 at 5:04 am
What do you mean by universal permissions?
May 21, 2009 at 3:10 am
Hi,
This link may be of interest to you.
May 21, 2009 at 3:08 am
Agreed - if you change it at the server you also need to change the connection strings!
That said, once you do resolve your sa password issues, I would recommend that...
May 21, 2009 at 2:59 am
You can't find the DLL on the server?
Do you have the client tools on your desktop? If so, do a search on your desktop and save it in the...
May 7, 2009 at 5:01 am
Viewing 15 posts - 106 through 120 (of 605 total)