Viewing 15 posts - 16,816 through 16,830 (of 39,831 total)
why did you begin a transaction in you second try? you're already within a transaction.
February 2, 2011 at 11:17 am
ALZDBA (2/2/2011)
Steve Jones - SSC Editor (2/1/2011)
February 2, 2011 at 11:07 am
Tom Brown (2/2/2011)
February 2, 2011 at 11:06 am
WayneS (2/1/2011)
Steve Jones - SSC Editor (2/1/2011)
February 2, 2011 at 11:04 am
Dan,
I'm not necessarily saying that hybrids need to be in IT, but rather that we need these hybrids, and the IT guys could fill some of these roles, if they...
February 2, 2011 at 9:43 am
If you upgrade to SQL 7, you can move to 2005.
http://msdn.microsoft.com/en-US/library/ms143393%28v=SQL.90%29.aspx
However, DTS was better in SQL 2000. You ought to be able to restore the database from v6.5 backup to...
February 2, 2011 at 8:49 am
I Tend to agree with Craig, and I'd like to see more information about what the entities are, what you are tracking, and what it means in relation to other...
February 1, 2011 at 5:50 pm
Here's some licensing information from Robert Pearl, who researched a bit of what is out there for 2008
February 1, 2011 at 5:41 pm
I did it a few times.
I was the basic DBA, got offered the IT manager position at a small company. That meant I managed the network guy/programmer/contractor, and myself. Not...
February 1, 2011 at 4:48 pm
Well, had a nice adventure today. Water cut off mid-morning, took my daughter to the doctor so they could diagnose flu, and while thawing a pipe this afternoon with a...
February 1, 2011 at 4:41 pm
You have distinct, but that applies to the entire row, not just the display name. The account differences are resulting in the extra rows. If you removed a row, how...
February 1, 2011 at 4:39 pm
Malcolm Daughtree (2/1/2011)
Are you accessing the data for any purpose then NOT passive.
I can snapshot the mirror and run dbcc. Is that passive?
I talked with MS licensing and they considered...
February 1, 2011 at 4:26 pm
Thanks, we've suspended development here while working on a few other things, but we'll be looking to add more info to this app, or another one, in the future.
February 1, 2011 at 4:22 pm
I don't know quite how a passive server is defined, but all the MS documents seem to say that you get at least one passive server for your HA options....
February 1, 2011 at 2:14 pm
GSquared is correct. The order of operations has the insert tested and you have a type conversion, without data being moved.
February 1, 2011 at 11:36 am
Viewing 15 posts - 16,816 through 16,830 (of 39,831 total)