Viewing 15 posts - 13,381 through 13,395 (of 14,953 total)
I know what the error means (it's a server transfering authority to another server, that transfers it yet again), but what would cause it to be intermittent, I haven't a...
June 10, 2008 at 11:38 am
fmuntean (6/9/2008)
I just want to point you to a free tool for monitoring the SQL Log files.
It is Log Parser currently in v2.2 form Microsoft.
It is using a query engine...
June 10, 2008 at 11:28 am
Yes, a list of databases happens.
As far as English classes, I'd gladly take one, but I actually find my state of complete illiteracy provides me with more opportunities to actualize...
June 10, 2008 at 11:20 am
Mia: Yep. Calculated risk (actually, I first learned that concept in game theory and military studies, but it most certainly applies to businesses as well). The trick is...
June 10, 2008 at 11:11 am
You're welcome. Glad it worked.
June 10, 2008 at 11:04 am
"...in my personal opinion, express should be used for nothing but development work." - AH
Actually, I'd use Dev Edition for development.
Express edition should be used for personal databases. It's...
June 10, 2008 at 10:48 am
I've actually had arguments with managers over the idea of killing a project part-way through. I thought the business case for the projects had been proven untenable, based on...
June 10, 2008 at 9:33 am
DCPeterson, on the subject of a "server side trace". I'm not clear on what you mean by that. Are you talking about something outside the database, or some...
June 10, 2008 at 9:19 am
Lee Forst (6/10/2008)
June 10, 2008 at 9:15 am
Anirban Paul (6/10/2008)
Nice one... I didn't expect the part II to come so quickly. How you people write so quick.....:)
I actually wrote the whole thing as one long article about...
June 10, 2008 at 6:27 am
As already mentioned, don't use the view wizard. Write the queries yourself.
I've actually seen the view wizard break queries that were already working.
June 9, 2008 at 3:44 pm
Is there anything in the SSIS package that might stop at a certain point?
Or does the job itself have a "stop if running for more than X minutes" setting on...
June 9, 2008 at 3:40 pm
Can't say I know how to do this in Sybase, if it's different from SQL Server, but how you'd do it in SQL Server is generally with a stored procedure:
create...
June 9, 2008 at 3:37 pm
Are you using the GUI to design views or something? I'm asking because the "right-click, Edit" option for procs/views/etc., doesn't do any reformatting that I'm aware of.
June 9, 2008 at 3:08 pm
Creating a new table with the right settings is the only way I know of.
June 9, 2008 at 2:34 pm
Viewing 15 posts - 13,381 through 13,395 (of 14,953 total)