Viewing 15 posts - 3,631 through 3,645 (of 5,685 total)
It's griping because of the single-user mode.
ALTER DATABASE [BTData] SET MULTI_USER WITH NO_WAIT
March 19, 2011 at 4:53 pm
Henry, Gail's right (as usual) about the necessity for backups, but it seems like you're an accidental DBA. A little background to why what you're doing didn't work.
There are...
March 19, 2011 at 4:51 pm
At a guess you'll get a better idea of what's going on from the lightspeed forums. It sounds like it's looking to use an existing bak file and put...
March 19, 2011 at 3:14 pm
Thanks folks, nice to have someone care what I actually type... 😉 Still getting a feel for how it's currently used across the boards. Looks like a cross...
March 19, 2011 at 1:18 pm
GilaMonster (3/19/2011)
Craig Farrell (3/18/2011)
Somewhere, the gods are laughing at me... I've started a twitter account.And your twitter handle is????
Was a bit nervous about throwing it out there, but ah, what...
March 19, 2011 at 2:33 am
Butterfly, I saw someone mention this earlier in the thread but your way out of this is probably Full Text Indexing. It's a bloat on the data layer but...
March 19, 2011 at 12:37 am
Somewhere, the gods are laughing at me... I've started a twitter account.
Now, my one saving grace is I won't be able to get there from work and my phone is...
March 18, 2011 at 4:20 pm
I'd need to see the DDL and the execution plans to really tell you what was happening here, but I don't see any bitwise operators occuring there, so you're just...
March 18, 2011 at 1:44 pm
Koen Verbeeck (3/18/2011)
ProKelly (3/18/2011)
March 18, 2011 at 4:33 am
ProKelly (3/18/2011)
My only concern with moving to SSIS is my experience performing tasks such as lookups from OLE DB sources operations are SLOW, really slow compared to SQL code.
I've found...
March 18, 2011 at 4:31 am
kirubamca09 (3/18/2011)
'm not clear 'm just generate the script
Then I'll help you find the point of the beginning of your investigation, we can't help you fix this, you MUST understand...
March 18, 2011 at 4:27 am
Kiruba, please don't double post.
Please direct all answers and comments to this thread:
http://www.sqlservercentral.com/Forums/Topic1080227-357-1.aspx
March 18, 2011 at 4:23 am
Eric Mamet (3/18/2011)
It was running fast on my laptop with either 2005...
March 18, 2011 at 4:21 am
Recently dealing with this error in another thread. You found a key via a nonclustered index lookup, and when it went back to the clustered index via keylookup, the...
March 18, 2011 at 4:19 am
leon.booij (3/18/2011)
yes a want to see that, is that possible
Not from decimal, no.
You are in varchar, and need to stay in varchar. You're looking at this the wrong way...
March 18, 2011 at 4:16 am
Viewing 15 posts - 3,631 through 3,645 (of 5,685 total)