Viewing 15 posts - 56,221 through 56,235 (of 59,067 total)
Just another way...
SELECT REPLACE(STR(somecol,6),' ','0')
June 4, 2007 at 5:19 pm
You know what they say... "Tuning makes perfect"
Keeps getting better and better...
June 4, 2007 at 6:12 am
Nicely done, Ian... didn't know the OP was doing the kind of stuff he said in a later post.
June 4, 2007 at 6:05 am
Heh... could be... the correct answer is "don't sort in a view".
June 4, 2007 at 6:03 am
Thanks Jesemine...
Heh... yeah... the only reason I don't upgrade the client tools right away is because we still use 2k at work and I need to be able to answer...
June 3, 2007 at 9:57 am
Scheduled Backups become "Jobs"... Find the [Management] folder for the database and expand it... find the [SQL Server Agent] folder under that and expand it... find the [Jobs] folder under...
June 3, 2007 at 9:53 am
--===== Order by with NULL last... -- Sort/Select all non-null... will be first in list SELECT * FROM YourTable WHERE YourColumn IS NOT NULL ORDER BY YourColumn UNION ALL ----------------------- --...
June 3, 2007 at 8:57 am
Understood... I don't think there's a trick to do this or monitor this in 2k... if they can view the data, they can copy the data.
June 2, 2007 at 3:53 pm
Heh... I've really got to get 2k5... Just for grins, Jezemine, can you post the code as in your example for us 2k guys??? Would be interesting for me to...
June 2, 2007 at 3:50 pm
Removing the "owner" privs is the only way... unless you encrypt everything.
June 2, 2007 at 1:57 pm
Ok, Chris... but the OP did post some SQL Server 2k5 code.
{Edit}... sorry misread that... YOU have SQL Server 2k... I get it... ![]()
June 1, 2007 at 9:49 pm
Curious... Why do you have 3 email tables?
June 1, 2007 at 9:42 pm
Heh.... I'm in the telephone business... case you haven't noticed, we round everything UP ![]()
June 1, 2007 at 9:28 pm
Obviously, you'll need "SA" privs to do this...
--===== Declare local variables
DECLARE @DefaultDataPath SYSNAME
DECLARE @DefaultLogPath SYSNAME
DECLARE @InstanceName SYSNAME
DECLARE @KeyPath SYSNAME
DECLARE @RootKey SYSNAME
DECLARE @ServerName SYSNAME
--===== Presets
SET...
June 1, 2007 at 9:07 pm
Viewing 15 posts - 56,221 through 56,235 (of 59,067 total)