Viewing 15 posts - 1,786 through 1,800 (of 9,641 total)
Simple answer is defragmenting indexes does not require downtime, but unless you are on enterprise edition and use the ONLINE option rebuilding an index is blocking. In addition to blocking...
February 1, 2012 at 2:13 pm
Evil Kraig F (1/31/2012)
A robot DBA may not injure data or, through inaction, allow data to come to harm.
A robot DBA must obey the orders given to it...
February 1, 2012 at 9:46 am
Brandie Tarvin (1/31/2012)
Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list. Agree? Disagree?
I agree especially when...
February 1, 2012 at 9:38 am
I mentioned the computed column because I wasn't sure if it needed to be writable.
I'll have to play around a bit with the sample code to see how...
January 31, 2012 at 3:36 pm
Have you seen this article, http://support.microsoft.com/kb/811889?
Based on what you have described it doesn't sound like a double-hop problem because the user is connecting directly from their PC to the SQL...
January 30, 2012 at 10:22 am
Is SQL Agent running? I've seen this get shut down or not set to auto start.
January 30, 2012 at 10:17 am
Sound like they want a model of the database. You can use the database diagram ability in SSMS, but then you'd need to either create an image of the...
January 30, 2012 at 10:15 am
A couple of things.
First, Paul, why an INSTEAD OF TRIGGER? I'm assuming that will have some performance benefit over an AFTER trigger.
Secondly, since the CBM2 column is...
January 30, 2012 at 10:05 am
It looks to me like this is a byproduct of running it in BIDS. When you open the package in BIDS it creates the first log file and then...
January 30, 2012 at 9:59 am
Off the top of my head I'd handle this in the .NET application by having a connection for the membershipDB and then a connection for the application DB. The...
January 30, 2012 at 9:36 am
GSquared (1/30/2012)
ramadesai108 (1/27/2012)
Besides triggers, I can also use function. right?I don't think so. How would you use a function for this?
As I said earlier you can't use a function...
January 30, 2012 at 6:49 am
Wish I could be of more help, but I don't see anything out of the ordinary in the package and have never experienced this problem.
January 27, 2012 at 11:56 am
If it is still set with EncryptSensitiveWIthPassword then that would be why I can't open it. You mention that in your first post.
January 27, 2012 at 10:53 am
What is the error you are getting?
How about somehting like this (may not be logically equivalent, but is close):
UPDATE a
SET a.Value = ?
WHERE
...
January 27, 2012 at 10:04 am
YOu can't use a function as a FK. You could use a function in a CHECK constraint.
I'd recommend against a cross-server constraint like this. I'd verify the data...
January 27, 2012 at 9:58 am
Viewing 15 posts - 1,786 through 1,800 (of 9,641 total)