Viewing 13 posts - 16 through 28 (of 28 total)
Generally I setup a single account on the database server and use table(s) for user logins. I always encrypt the passwords, if nothing else with md5.
November 21, 2005 at 1:02 pm
Thanks for the info. I think I'l have to check out their products. Sounds like what we just might need.
November 18, 2005 at 1:52 pm
That's right. It's normal to have unused space in the log file. So having a 2 gig file doesn't necessarily mean that 2 gigs of the file are used. When...
November 17, 2005 at 10:23 am
I also hardly ever shrink a log file unless it grows out of control for some reason.
November 16, 2005 at 2:57 pm
ALTER TABLE [dbo].[Test]
ADD CONSTRAINT [DF_dbo_Test_amount] DEFAULT 0 FOR [amount]
November 16, 2005 at 1:45 pm
I missed the part about the TRUNCATE_ONLY. Your right...that could cause problems.
November 16, 2005 at 1:26 pm
It shouldn’t hurt anything to shrink the database down since it only truncates off data that has already been written to the database. However, if...
November 16, 2005 at 1:22 pm
From what I've been told 2005 has many similarities to 2000 as far as administering it. I'm sure there are some differences; I know DTS is now SSIS.
As far...
November 15, 2005 at 11:46 am
Take this for whatever you feel its worth; I’m not an Oracle DBA nor have I been, just MS…
Maybe it's just me, but I look at things...
November 14, 2005 at 8:05 am
Let me add to that...some of the items are touched on in the first course you list. But don't go into detail. That might be ok for you. Depends if...
October 27, 2005 at 10:36 am
I just finished the 2072 course. It was very good and informative. I had read many books before hand. Books are good because you always have them. I'd say if...
October 27, 2005 at 10:34 am
That did it. Thanks so much for your help!
-Chris
October 18, 2005 at 9:52 am
Thanks for your help. I've never used sp_executeSql. I no longer receive errors, but my variable comes back null. This is what I have:
DECLARE @SQLStatement2 NVARCHAR(255)
DECLARE @Myvar int
select @SQLStatement2 =...
October 18, 2005 at 9:26 am
Viewing 13 posts - 16 through 28 (of 28 total)