Viewing 15 posts - 8,296 through 8,310 (of 9,720 total)
jocampo (6/19/2009)
Why I'm going to code or fix code? 😎 ... I'm not getting paid for that!
Not necessarily true. It depends on what type of shop you're in. In my...
June 19, 2009 at 11:07 am
Oh, this is FUNNY. On a whim, to verify I knew the answer to Gail's question, I opened up BOL on my desktop. I wanted to check both the new...
June 19, 2009 at 7:06 am
I'm thinking you have a Dev version of one software and a regular "production" version of the other software and that's why you're having problems. So Dugi would be correct...
June 19, 2009 at 6:44 am
Check your paging file values. It could be tied up with that.
June 19, 2009 at 6:43 am
sivark1 (6/18/2009)
first i installed sqlserver 2005 dev edition ((default instance) and later i install lserver2000(named instance)
Is this your personal box or a production machine?
Are all your SQL instances...
June 19, 2009 at 6:29 am
You need to check your Server properties and see if SQL has priority for memory or not. Also, remember that just because the memory is available, if SQL doesn't need...
June 19, 2009 at 6:27 am
As of others have mentioned, you can put the table on a separate file or filegroup for backing up.
Of course, if you're trying to restore this table to a...
June 19, 2009 at 6:23 am
The only way I know how to do this is plan in advance.
We have a "user" database that we SELECT...INTO all data from the tables we are updating prior to...
June 19, 2009 at 6:20 am
alidahope (6/18/2009)
The steps that usually fail are step 8 and 9 with the following error:Unable to connect to SQL Server '(local)'. The step failed.
This sounds to me as if...
June 19, 2009 at 6:17 am
You could also use OpenRowSet without creating a linked server, I believe. Or SSIS.
There are plenty of methods available. The question is, what tools does your workplace have available for...
June 19, 2009 at 6:13 am
It could be also that the drive containing your TempDB is full. That error comes up for me when that happens. TempDB in our place is on a different drive...
June 19, 2009 at 6:11 am
My favorite interview question to ask interviewees is "How to you do a point in time restore for a database in Simple Recovery Mode?"
Simple question, right? Yet, it stumps so...
June 19, 2009 at 6:09 am
Nevermind. I finally figured out how to make the stupid Conditional Operator work correctly. It kept complaining that I couldn't use a LEN() function in conjunction with a string. a...
June 10, 2009 at 6:44 am
My thought on this issue is that the server still thinks something's wrong.
Announce to your users that you'll be taking the server down for maintenance on X date at...
June 8, 2009 at 12:26 pm
Viewing 15 posts - 8,296 through 8,310 (of 9,720 total)