Viewing 15 posts - 10,591 through 10,605 (of 14,953 total)
So, if one of the results is 123 and the other is 456, you want to end up with the number 123456?
Can you multiply the first one by the appropriate...
March 9, 2009 at 9:08 am
Is the bit removed always a zero, or will it sometimes be something else?
March 9, 2009 at 9:06 am
I've upgraded a few servers (maybe 10). The only problem I've run into was having to re-register the DTS dll in Windows, and I'm not even sure that was...
March 9, 2009 at 9:04 am
You're welcome.
March 9, 2009 at 9:03 am
Databases that are offline won't display any of the objects under them. That's normal.
March 9, 2009 at 8:55 am
Where MyZipColumn like '[0-9][0-9][0-9][0-9][0-9]%'
Will find anything that is five numbers, followed by anything or nothing.
Where MyZipColumn like '[0-9][0-9][0-9][0-9][0-9]'
or MyZipColumn like '[0-9][0-9][0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]'
or MyZipColumn like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'
Will find anything that's five numbers and...
March 9, 2009 at 8:27 am
Insert, update and delete triggers are placed on specific tables, not on a whole database or server. You have to add them to each table.
March 9, 2009 at 8:23 am
First, are the databases still attached to the server, but offline, or have you detached them? Detaching them should fix what you're running into.
March 9, 2009 at 8:20 am
Create another database and move some of the data to that.
March 9, 2009 at 8:17 am
Check the properties on the primary filegroup. It may be set to have a limit of some sort.
March 9, 2009 at 8:16 am
Is rownum a column in one of the tables? If so, what's the range on it?
March 9, 2009 at 8:12 am
You can't run a tran log backup at the same time as a full backup. Won't let you.
When you say the tran log isn't being truncated/shrunk, I'm assuming you...
March 9, 2009 at 8:10 am
Start by making sure the database is being accessed by logins other than sa. Then make sure the logins being used have the minimum rights necessary in order to...
March 9, 2009 at 8:08 am
The idea of a pre-publication spot for article preview is good. I've usually sent my rough drafts around to a few folks for the few articles I've written, and...
March 9, 2009 at 7:41 am
Steve Jones - Editor (3/6/2009)
On the experts exchange, I've resisted that, but I think there might be...
March 9, 2009 at 7:29 am
Viewing 15 posts - 10,591 through 10,605 (of 14,953 total)