Viewing 15 posts - 42,856 through 42,870 (of 49,566 total)
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
rbarryyoung (11/27/2008)
Actually, Plan Guides might be able to do this. Unfortunately, I missed that session at PASS.
Only if a hint will help the query, and only if its one...
November 28, 2008 at 12:23 am
lrams99 (11/27/2008)
Hi GuysIf you have any idea in this issue, Please give some tips onthis..and detailed process
Please post a new thread with your question and don't hijack a completely unrelated...
November 28, 2008 at 12:18 am
v.g.mujumdar (11/27/2008)
Please tell me why this message occured? is this error? How can I understand that my replication is running normally?
It's not an error. In transactional replication the snapshot's...
November 27, 2008 at 2:27 pm
Yup, because a proc doesn't have a defined output. It's possible to have a procedure that returns various different resultsets (or none at all) depending on parameters passed.
November 27, 2008 at 2:14 pm
Um... Did anyone notice that this thread is 4 and a half years old, and was answered accurately 10 days after it was posted?
November 27, 2008 at 12:17 pm
Viewing 15 posts - 42,856 through 42,870 (of 49,566 total)