Viewing 15 posts - 121 through 135 (of 306 total)
Just a quick followup - this problem went away after the client was rebooted. Still have no idea what caused it, and would definitley be intersted in hearing from anyone...
June 11, 2003 at 11:23 am
Tough one. I worked in placed where we rebooted monthly using scheduler. Occasionally especially on the older servers we'd have a hangup but OPS just went and hit the reset...
June 11, 2003 at 9:59 am
One note on all this - any statement that contains a #table that appears before the #table gets created, will cause the SPROC to recompile on each run. It is...
June 11, 2003 at 9:13 am
I guess I should just stick to Admin work eh, It took a little bit, but I figure it out yesterday. BOL doesn't exactly give you those type of examples....
June 11, 2003 at 9:09 am
yeah, I saw that too.
I was just looking for the same inherited right that sa has to execute.
Thanks for the thought.
John Zacharkan
June 10, 2003 at 3:10 pm
yeah, I saw that too.
I was just looking for the same inherited right that sa has to execute.
Thanks for the thought.
John Zacharkan
June 10, 2003 at 3:10 pm
It works without the INTO, you don't need to specify the fields. You just need the number of fields and data types match.
June 10, 2003 at 12:31 pm
Can anyone on SQL 7 sp2 to sp4, without hotfixes, detach model? Can you show me how you do this.
My MS rep recommends opening up a technical support case to...
May 27, 2003 at 2:15 pm
Great article, should be included in any disaster recovery. What do you use to pick up the transaction log files and at what frequency?
Cheers
John Zacharkan
May 27, 2003 at 1:55 pm
You mean something like this?
select author, count(*)
from profile inner join
matter on profile.System_id = matter.system_id
where client_id = '3999' and matter_id = '1'
group by author
John Zacharkan
May 20, 2003 at 10:35 am
Think that's an MS internal directorys, sounds awfully familiar. Check this out http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20307973=.html
John Zacharkan
May 19, 2003 at 2:23 pm
This I believe is was written at Microsoft, author unknown.
SQL Server Task Scheduling
Microsoft® SQL Server™ uses Microsoft Windows® threads, and sometimes fibers, to execute several concurrent tasks efficiently. SQL Server...
May 19, 2003 at 11:38 am
If this is a job you can also make the drop file as a seperate job task run xp_cmdshell 'del yourfilename.xls'
John Zacharkan
May 19, 2003 at 10:12 am
If you can send me the code I'll try it here on sp4 without hotfix
Seperate issue since you're on 1077 can you verify my post reply here
John...
May 19, 2003 at 9:49 am
Did you have a chance to see if it worked with SP4 before hotfix ?
quote:
Quite recently we have applied SP4 and Update...
May 19, 2003 at 9:31 am
Viewing 15 posts - 121 through 135 (of 306 total)