Viewing 15 posts - 2,041 through 2,055 (of 9,641 total)
Thanks George. That's what I thought, but I needed to get some confirmation. Sometimes what I think is logical and reasonable result is not right.
October 26, 2011 at 2:04 pm
Of course the issue is that you'd then have to have a step on Success that makes sure the job is updated again to send an email for the next...
October 26, 2011 at 10:47 am
Your issue is with the encryption setting for your package. Open your package in BIDS and go to Properties -> Protection Level. Odds are you have it set...
October 26, 2011 at 10:39 am
Loner (10/26/2011)
I thought it supposed to be 300.What number is good and what number is bad?
I don't understand the number meant. Can you explain?
Thanks
If you haven't read the blog post,...
October 26, 2011 at 10:32 am
I'm not sure if this helps, but have you tried using the Filtering functionality in SSMS to find what you are looking for? It isn't the same, but it...
October 26, 2011 at 10:21 am
Couldn't you change your Where clause to exclude databases that are owned by the generic accounts that it is okay to have as a database owner? Then ALTER AUTHORIZATION...
October 26, 2011 at 10:17 am
I've been "lurking" on this thread to see some different opinions. I have to say I agree with Elliot so far. If I'm using SSIS I'd avoid...
October 25, 2011 at 2:19 pm
Jeff Moden (10/24/2011)
Jack Corbett (10/24/2011)
I have a question. Why the TABLOCKX hint on the temp table? What does it give you that the QP/QO wouldn't do anyway?
It's a...
October 24, 2011 at 11:41 am
I'd just use a call to sp_testlinkedserver @servername. I think this is lighter weight than the script below. Then I'd also use sp_send_dbmail to send the email.
October 24, 2011 at 10:44 am
I have a question. Why the TABLOCKX hint on the temp table? What does it give you that the QP/QO wouldn't do anyway?
October 24, 2011 at 10:29 am
Can you post your .NET code? What does your query/command look like that is filling the dataset? If your query is using best practices and does not return...
October 22, 2011 at 9:04 am
If you google/bing SQL Server Max Memory Setting you'll find plenty of resources that talk about that setting being for the buffer pool. Here's just one, http://msdn.microsoft.com/en-us/library/ms180797.aspx
Edit: Changed the...
October 21, 2011 at 3:55 pm
I'll defer to Gail on this, but CXPacket is the top wait type so I'd definitely look at what is getting parallelized and perhaps modify the Threshold for Parallelism setting....
October 21, 2011 at 2:26 pm
Are you backing up to a local drive or a network location? Sometimes this happens when backing up across a network you can get these issues.
October 21, 2011 at 1:30 pm
Can you post the .NET code or at least a similar example? I'm really not sure what you mean.
I'm not sure what you mean by a .NET database. ...
October 21, 2011 at 1:26 pm
Viewing 15 posts - 2,041 through 2,055 (of 9,641 total)