Viewing 15 posts - 42,856 through 42,870 (of 49,571 total)
Please don't create new threads for existing problem. All you're doing is wasting people's time as they answer questions that have already been answered elsewhere.
No moer replies to this thread...
November 28, 2008 at 4:51 am
The string for the IN needs quotes around all the values
(user1,user2,user3,user4,user5)
Not going to work as those are strings. You're also duplicating the brackets.
Pass the user list as ''user1'',''user2'',''user3'',''user4'',''user5''
Two final words:...
November 28, 2008 at 4:50 am
LiteSpeed does have the ability to do object restores from a full backup. I don't recall exactly how, it's been a while since I used the product. I seem to...
November 28, 2008 at 4:41 am
Ninja's_RGR'us (11/28/2008)
Not really, but it doesn't matter since any one can use google to find this thread again, so any new info is still usefull to post!
My comments was more...
November 28, 2008 at 4:35 am
As a wild guess, parameter sniffing, but it's impossible to say anything for sure without seeing the code.
November 28, 2008 at 4:28 am
bhuvnesh.dogra (11/28/2008)
or you have any alternative to do database shrinking ?
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in...
November 28, 2008 at 4:26 am
Why do you want to shrink? Databases tend to grow as more data gets put in them.
Shrinking causes massive fragmentation and will just result in the data file growing...
November 28, 2008 at 4:25 am
The line SELECT BuildID AS [@BuildID] is actually naming the return column @BuildID, not assigning the value to the variable. To do the assignment, you need to do it like...
November 28, 2008 at 4:23 am
As a wild guess, you're trying to insert a duplicate primary key value. ie, you're trying to insert a value for ClientID that's already there. Primary key must be unique.
November 28, 2008 at 4:17 am
You should only restore the log backups that were taken after the full backup. Not before.
Why bulk-logged? Are you doing lots of bulk operations?
If you create a DB in simple...
November 28, 2008 at 4:01 am
Truncation can occur any time you're inserting from a wider column into a narrower column. In the insert statement you posted, you're doing that 4 times.
You're inserting a varchar(255) (Client)...
November 28, 2008 at 3:57 am
I read your first post just fine, thank you.
Is the 2-column key just because of that, or is there another reason you can't have a 2-column unique key (with...
November 28, 2008 at 12:54 am
skyw (11/27/2008)
Is taking the database offline and then deleting it an option at all? (rather than bringing it to the single-user mode and then deleting it.)
Sure.
ALTER DATABASE SomeDB SET OFFLINE...
November 28, 2008 at 12:38 am
v.reddy (11/27/2008)
November 28, 2008 at 12:35 am
I'm not sure there's a good way in SQL 2005.
Why can't you make the combination of the two columns unique?
November 28, 2008 at 12:32 am
Viewing 15 posts - 42,856 through 42,870 (of 49,571 total)