Viewing 15 posts - 331 through 345 (of 411 total)
Ensure tcpip port 1433 is only on the firewall.
Start the SQL Browser service using the Configuration Manager (and ensure 1434 is open).
If this doesn't help, please post the error...
March 14, 2011 at 8:28 am
Gail - Thanks! In older versions of SQL Server, when a minimally logged action occurred (bcp, etc.) in bulk-logged recovery mode, TLog backups thereafter FAILED with an error noting...
March 11, 2011 at 9:36 am
I also have 16G in my lappy. HP envy model. Nice lappy but terrible secondary battery design.
As for servers, largest are 32G RAM; two of them. Most others only...
March 11, 2011 at 7:19 am
GilaMonster (3/11/2011)
March 11, 2011 at 6:53 am
GilaMonster (3/10/2011)
There's just ... so much misinformation on the log, I don't want any more starting because someone read something and drew an incorrect conclusion.
I couldn't agree more. That's one...
March 10, 2011 at 1:21 pm
Eric,
Sweet. That's why I wasn't condeming your actions, just warning about some of the consequences. There is always an exception to a rule and I'm glad you know the benefits...
March 10, 2011 at 12:45 pm
GilaMonster (3/10/2011)
[Jim].[dba].[Murphy] (3/10/2011)
A log truncation could have bad side effects if any part of that database is used by others; rows being modified in some way.
A log truncation...
March 10, 2011 at 11:52 am
mmmm. Not sure about that. A log truncation could have bad side effects if any part of that database is used by others; rows being modified in some...
March 10, 2011 at 11:19 am
Just for the record, I'll take this one too, along with the other two SQL Azure articles unless there are any objections.
Jim
March 10, 2011 at 10:03 am
That's good to know Jeff. Thanks!
Jim
March 10, 2011 at 10:01 am
Chazman - nice work. The min select should be aliased as NextID instead. Minor typo.
I agree with Chazman - although this will work, it is not a nice, cheap...
March 10, 2011 at 7:32 am
AH! I remember the days, but I was using DBase III+, Alpha4 and Clipper.
A colleague of mine showed me his first SELECT statement in SQL 4.2 (SQL NT) and...
March 8, 2011 at 2:31 pm
To fix the problem at hand, the Set Transaction... Statements need to be inside the Alter Procedure statement. Only items below the Alter relate to running the stored proc. Statements...
March 8, 2011 at 2:01 pm
clausm73 (3/8/2011)
Gail, I like your point ajour having the field explicitly added to the composite index. This will be my "Best Practise" recommendation to my colleagues going forward.
I agree....
March 8, 2011 at 1:53 pm
Generally, you can use INSERT INTO.... SELECT (col1, col2) FROM syntax. See Books Online (BOL) for the detailed syntax and requirements for the columns to specify and their values.
As...
March 8, 2011 at 11:58 am
Viewing 15 posts - 331 through 345 (of 411 total)