Viewing 15 posts - 5,851 through 5,865 (of 9,712 total)
There's a difference between package variables and the variables declared within an Execute SQL Task. Could you post details on exactly how you set up and populated this variable? It...
June 10, 2011 at 6:13 am
Tom.Thomson (6/10/2011)
SQLRNNR (6/9/2011)
...Whether with formal attire or beach attire, people can't discern where flip flops belong.Surely everyone can discern that they belong on the feet? 😛
In Florida?
Don't be so sure....
June 10, 2011 at 5:40 am
Also, what have you tried so far?
This sounds like a programming class question.
June 10, 2011 at 4:18 am
Look at your SQL Agent jobs. Make sure SA doesn't own any of them. If it does, that might be why things are running under the SA context.
June 10, 2011 at 3:29 am
Don't forget to "fix" SQL Server after your OS defrag. Check your indexes to see if they need to be defragged (because a hard drive defrag will move your SQL...
June 10, 2011 at 3:21 am
Gail already told you what was happening. Restores will clear the plan cache. The fact that this is a secondary log shipping server means that every time a log is...
June 10, 2011 at 3:16 am
A couple of things. You can get this error if the drive that TempDB is on happens to be full or if its Primary filegroup is at its max growth...
June 10, 2011 at 3:13 am
Have you verified that there are no page restores currently happening on the database?
What version of SQL 2k5 are you running? (SP3 or above?) Because if you're running a service...
June 10, 2011 at 3:11 am
I'm confused as well. I'm assuming "they" is your client. But the fact that they don't like big numbers and you are generating a random 50 character number that you...
June 10, 2011 at 3:00 am
Bhuvnesh (6/10/2011)
thanks it has been resolved it happened due to some network issues.
That's usually what that error means. Glad you got it resolved.
June 10, 2011 at 2:46 am
It occurs to me to wonder if the SQL users even have permissions to run your proc. If they don't, then EXECUTE AS won't do you any good.
If this is...
June 10, 2011 at 2:45 am
Salary.com posted an interesting click-thru article about 14 job hunting mistakes. Though y'all would be interested.
Upper left, under the banners:
http://www.salary.com/Articles/ArticleDetail.asp?part=par4104
EDIT:
Found another one. This one about bad habits.
June 9, 2011 at 12:11 pm
Steve Jones - SSC Editor (6/9/2011)
Brandie Tarvin (6/9/2011)
Toyota says a problem with electric power...
June 9, 2011 at 12:06 pm
Steve Jones - SSC Editor (6/9/2011)
Brandie Tarvin (6/9/2011)
June 9, 2011 at 12:04 pm
No, but only because I don't use DB Mirroring at the moment. But it sounds like a resource issue since you're mirroring 6 dbs on that one instance.
Have you run...
June 9, 2011 at 11:48 am
Viewing 15 posts - 5,851 through 5,865 (of 9,712 total)