Viewing 15 posts - 16 through 30 (of 135 total)
ksatpute123 (10/30/2014)
This trace flag has existed for some time but was documented only in SQL 2008.It works for SQL 2008, 2005 and 2000 SP4 (not tested) update.
Yes, an excellent QOTD....
October 31, 2014 at 9:56 am
Harlan Ellison has a tremendous number of short stories that would adapt well, though most of them would be pretty depressing.
His story "A Boy and His Dog" was made into...
February 28, 2014 at 12:01 pm
For many years the only books I've longed, really longed, for someone to make movies of, are:
Isaac Asimov's "Foundation" trilogy
Robert Heinlein's "The Door Into Summer"
The latter is not as well...
February 28, 2014 at 7:34 am
OK, I've now had something of a breakthrough. After my last post, I went back to the problem and managed to alter my thinking. Key #1 is, I guess a...
February 14, 2014 at 10:43 am
Gary Gwyn (2/13/2014)
You can use UNC paths in the BACKUP DATABASE command.
Yes, I know, but the problems are the same.
Just backup directly to the destination server
That's not always possible, due...
February 13, 2014 at 3:19 pm
One more thing -- it turns out Microsoft suggests disabling UAC in situations such as this, where the only activity on the console is server admin tasks.
http://support.microsoft.com/kb/2526083
I had...
October 9, 2012 at 2:13 pm
mister.magoo (10/8/2012)
This seems similar to a known bug
Hmmm, yes, it certainly does. It's not exactly the same situation, because I'm using a different browse window, but it's close. I'm not...
October 9, 2012 at 12:56 pm
AmarettoSlim (10/5/2012)
Hmm, as for not being able to see remote instances or the local instance
No, that's not right. As I said in my first post, I CAN browse to and...
October 8, 2012 at 3:43 pm
OK, I have disabled UAC on the new test server. In fact when I run programs like SQL Server Configuration Manager, they no longer ask for administrator confirmation, which is...
October 5, 2012 at 10:04 am
AmarettoSlim (9/28/2012)
October 2, 2012 at 3:29 pm
AmarettoSlim (9/26/2012)
What is the exact error SSMS is throwing? Do you see anything corresponding to these failed login attempts in Event Viewer?
Well of course there is currently no error when...
September 27, 2012 at 11:35 am
Something seems contradictory in the answer to this question. First it says the answer is 2012/04/05 11:00:00 +05:00. Then in the explanation it says the GMT time of the result...
April 6, 2012 at 7:46 am
When putting code on the site, it would be easier to handle if it had simple double-quote characaters instead of those "smart quotes" which have to be fixed with a...
February 14, 2012 at 11:26 am
Am I the only one who noticed this error in the original article?
> with right section of the decimal point representing
> number of dates since 01-Jan-1900
"right section of the decimal...
September 1, 2011 at 8:25 am
It turns out there was already an install of SQL 2000 on TestWeb, and I ran its Client Config, and sure enough, that old version has aliases too. So now...
May 4, 2011 at 7:58 am
Viewing 15 posts - 16 through 30 (of 135 total)